团员管理系统(10)

JAVA课程设计包括全部源代码

面向对象课程设计报告 第 10 页，共 19 页 setDefaultCloseOperation(DISPOSE_ON_CLOSE);// 设置关闭当前窗口 } public void actionPerformed(ActionEvent e) { try { Class.forName("tuanyuan.jdbc.odbc.JdbcOdbcDriver"); } catch (ClassNotFoundException e0) { System.out.println(e0); } if (e.getSource() == b1) { ta.setText(""); try { con = DriverManager.getConnection("jdbc:odbc:tuanyuan", "", ""); sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = sql.executeQuery("SELECT * FROM tuanyuanxinxi"); while (rs.next()) { 获取信息： } con.close(); sql.close(); } catch (SQLException e1) { System.out.println(e1); } } else if (e.getSource() == b2) { String s1 = ta2.getText(); String s2 = JOptionPane.showInputDialog("请输入班级"); try { con = DriverManager.getConnection("jdbc:odbc:tuanyuan", "", ""); sql = con.createStatement(); sql.executeUpdate("UPDATE tuanyuanxinxi SET 班级 = " + "'" + s2 + "'" + " WHERE 姓名 LIKE" + "'" + s1 + "'"); rs = sql .executeQuery("SELECT * FROM tuanyuanxinxi WHERE 姓 名 LIKE " + "'" + s1 + "'"); while (rs.next()) { 获取信息：姓名、班级、学号、性别、出生日期、入团时间、联系方式、家庭住址； 输出至文本区：姓名、班级、学号、性别、出生日期、入团时间、联系方式、家庭住址； } con.close(); sql.close(); } catch (SQLException e2) { System.out.println(e2); }