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

"

} }

sql = con.createStatement(); rs = sql.executeQuery("SELECT * FROM chengjibiao "); while (rs.next()) { String number = rs.getString("number"); String name = rs.getString("name"); String date = rs.getString("date"); int math = rs.getInt("math"); int english = rs.getInt("english"); if (number.equals(s)) { boo = false; show.setText(null); show.append("学号：" + number + " 姓名：" + name + " 出生： + date + " 数学 " + math + " 英语 " + english); show.append("\n"); } } con.close(); if (boo) { JOptionPane.showMessageDialog(this, "你输入的学号不存在"); } } catch (SQLException eee) { System.out.println(eee); }

6.5 删除模块

用删除学生信息

主要代码：class shanchu extends JFrame implements ActionListener {

JFrame frame = new JFrame("删除记录");

JPanel imagePanel;

ImageIcon bg;

Button xunzhao;

TextField input;

TextArea show;

String s;

int k, s1, j;

Connection con;

Statement sql;

int sum = 0;

ResultSet rs;

15