}
public void actionPerformed(ActionEvent ee) {
String s1, s2, s3, s4, s5, insert1, recode, name, date, number;
int m1, m2, math, english;
s1 = input1.getText();
s2 = input2.getText();
s3 = input3.getText();
s4 = input4.getText();
s5 = input5.getText();
number = s1;
name = s2;
date = s3;
m1 = Integer.parseInt(s4);
math = m1;
m2 = Integer.parseInt(s5);
english = m2;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException eee) {
System.out.println("" + eee);
}
try {
con = DriverManager.getConnection("jdbc:odbc:sun", "gxy", "123"); sql = con.createStatement();
recode = "(" + "'" + number + "'" + "," + "'" + name + "'" + ","
+ "'" + date + "'" + "," + math + "," + english + ")";
insert1 = "INSERT INTO chengjibiao VALUES " + recode;
sql.executeUpdate(insert1);
show.setText("你插入了:");
show.append("学号：" + number + " 姓名：" + name + " 出生：" + date + " 数学 " + math + " 英语 " + english);
show.append("\n");
} catch (SQLException e) {
System.out.println(e);
JOptionPane.showMessageDialog(this, "你输入的学号已存在，请核对重新输入！");
}
}
}
7