《最新十九讲信息录入录入界面的建立PPT课件》由会员分享,可在线阅读,更多相关《最新十九讲信息录入录入界面的建立PPT课件(18页珍藏版)》请在金锄头文库上搜索。
1、十九讲信息录入录入界面的建立本章要本章要点点l掌握JAVA中添加记录的方法l掌握JAVA中删除记录的方法l掌握JAVA中修改记录的方法删除记录窗体图示删除记录窗体图示删除记录代码段删除记录代码段public void jButton1_actionPerformed(ActionEvent e) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:stu01; Connection conn = DriverManager.getConnection(url); Statement stat = con
2、n.createStatement(); String sql = delete from students where xuehao=+xhjComboBox.getSelectedItem().toString()+; int rowCount =stat.executeUpdate(sql); if (rowCount0 ) jbjg.setText(删除正确!); conn.close(); catch(java.lang.Exception exec) jbjg.setText(删除错误!); xmjTextField.setText(); xmjTextField.setText(
3、); xbjComboBox.setSelectedIndex(0); nljTextField.setText(); dhjTextField.setText(); zzjTextField.setText(); bjjComboBox.setSelectedIndex(newbjjComboBox.getSelectedIndex(); try 删除记录代码段(续一)删除记录代码段(续一)Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url2 = jdbc:odbc:stu01; Connection conn2 = DriverM
4、anager.getConnection(url2); Statement stat2 = conn2.createStatement(); String sql2 = select xuehao from students where banji=+newbjjComboBox.getSelectedItem().toString()+; ResultSet rSet2 = stat2.executeQuery(sql2); xhjComboBox.removeAllItems(); while (rSet2.next() xhjComboBox.addItem(rSet2.getStrin
5、g(1); conn2.close(); catch(java.lang.Exception exec) jbjg.setText(错误!); newbjjComboBox.requestFocus(); 删除记录代码段(续二)删除记录代码段(续二)19.3 修改记录修改记录设计分析(1) 选用JDBCODBC连接数据库。(2) 设计窗体,在窗体中加入控件,显示用户输入界面。(3) 为控件加入监听者及事件处理代码段。修改记录窗体图示修改记录窗体图示修改记录代码段修改记录代码段public void jButton2_actionPerformed(ActionEvent e) try Clas
6、s.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:stu01; Connection conn = DriverManager.getConnection(url); Statement stat = conn.createStatement(); String sql = update students set xuehao=+xhjComboBox.getSelectedItem().toString()+,xingming=+xmjTextField.getText()+,xingbie=+xbjComboBo
7、x.getSelectedItem().toString()+,nianling=+nljTextField.getText()+,banji=+bjjComboBox.getSelectedItem().toString()+,dianhua=+dhjTextField.getText()+,zhuzhi=+zzjTextField.getText()+ where xuehao=+xhjComboBox.getSelectedItem().toString()+;int rowCount =stat.executeUpdate(sql); if (rowCount0 ) jbjg.setT
8、ext(修改正确!); conn.close(); catch(java.lang.Exception exec) jbjg.setText(修改错误!); xmjTextField.setText(); xmjTextField.setText(); xbjComboBox.setSelectedIndex(0); nljTextField.setText(); dhjTextField.setText(); zzjTextField.setText(); bjjComboBox.setSelectedIndex(newbjjComboBox.getSelectedIndex(); try
9、修改记录代码段(续一)修改记录代码段(续一)Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url2 = jdbc:odbc:stu01; Connection conn2 = DriverManager.getConnection(url2); Statement stat2 = conn2.createStatement(); String sql2 = select xuehao from students where banji=+newbjjComboBox.getSelectedItem().toString()+; ResultSet rSet2 = stat2.executeQuery(sql2); xhjComboBox.removeAllItems(); while (rSet2.next() xhjComboBox.addItem(rSet2.getString(1); conn2.close(); catch(java.lang.Exception exec) jbjg.setText(错误!); newbjjComboBox.requestFocus(); 修改记录代码段(续二)修改记录代码段(续二)结束语结束语谢谢大家聆听!谢谢大家聆听!18