private java.sql.Statement sql; private TextArea show; private Connection con;
@Override public void mouseClicked(MouseEvent arg0) { String s0,s1,s2,s3,s4,s5,s6,s7,s8,s9,s10,s11,recode,insert1 ; s0 = textField_1.getText(); s1 = textField_1.getText(); s2 = textField_2.getText(); s3 = textField_3.getText(); s4 = textField_4.getText(); s5 = textField_5.getText(); s6 = textField_6.getText(); s7 = textField_7.getText(); s8 = textField_8.getText(); s9 = textField_9.getText(); s10 = textField_10.getText(); s11 = textField_11.getText(); sql = null; show = null; try { Class.forName("com.ibm.db2.jcc.DB2Driver"); } catch (ClassNotFoundException eee) { System.out.println("" + eee); } try { con = DriverManager.getConnection("jdbc:db2://localhost:50000/sample","jiongjun","881342"); sql = con.createStatement(); recode = "(" + s0 + "," + s9 + "," + s1 + "," + s2 + "," + s3 + ","+ s4 +","+ s5+ ","+ s6 + ","+s7+","+s8+","+s10+","+s11+")"; insert1="INSERT INTO JIONGJUN.CHENGJIBIAO (xuehao,xingming,yuwen,shuxue,yingyu,wuli,huaxue,shengwu,dili,lishi,zongfen,mingci) VALUES"+recode; sql.executeUpdate(insert1);