package electronicbook;

import javax.swing.*;  

import java.sql.*;  
 
 
public class Insert extends JFrame{
	  String tableName;  
	    JTextField field[]=null;  
	    String a[]=null;  
	    Update update;  
	    public void setTableName(String s){  
	        tableName=s.trim();  
	    }  
	    public void setField(JTextField s[]){  
	        field=s;  
	    }  
	    public void setA(String e[]){  
	        a=e;  
	    }  
	    public Insert(){  
	          
	    }  
	    public void  Execute_Insert(int mark){  
	        String SQL;  
	        Connection con;  
	        Statement sql;  
	        try{  
	            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");  
	        }  
	        catch(ClassNotFoundException exp){  
	            System.out.println(exp);  
	        }  
	        try{  
	            String url,userName,userPwd;  
	            url="jdbc:sqlserver://localhost:1433;DatabaseName=电子书订阅";  
	            userName="sa";  
	            userPwd="123456";  
	            SQL="insert "+"书籍详情"+"("+a[mark]+") values ('"+field[mark].getText().toString()+"')";  
	            con=DriverManager.getConnection(url,userName,userPwd);  
	            sql=con.createStatement();  
	            sql.execute(SQL);  
	            con.close();  
	            update =new Update();  
	            update.setTableName(tableName);  
	            update.setField(field);  
	            update.setA(a);  
	            update.Execute_Update(mark);  
	            JOptionPane.showMessageDialog(this, "添加成功！！！","消息对话框",JOptionPane.WARNING_MESSAGE);  
	            for(int i=0;i<field.length;i++)  
	                field[i].setText(null);;  
	        }  
	        catch(SQLException ex){  
	            System.out.println(ex);  
	        }  
	    }  
}