学生成绩管理系统-数据库课程设计(9)

}

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

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库学生成绩管理系统-数据库课程设计(9)在线全文阅读。