第十九讲信息录入录入界面建立

1、本章要本章要点点l掌握JAVA中添加记录的方法l掌握JAVA中删除记录的方法l掌握JAVA中修改记录的方法19.1 添加记录添加记录(1) 本数据库为Access数据库，所以可选用JDBCODBC连接数据库。(2) 设计窗体，在窗体中加入控件，显示用户输入界面。(3) 为控件加入监听者及事件处理代码段。添加记录窗体图示添加记录窗体图示添加记录代码段添加记录代码段 void jButton1_actionPerformed(ActionEvent e) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:

2、stu01; Connection conn = DriverManager.getConnection(url); Statement stat = conn.createStatement();String sql = insert into students values(+xhjTextField.getText()+,+xmjTextField.getText()+,+xbjComboBox.getSelectedItem()+,+nljTextField.getText()+,+bjjComboBox.getSelectedItem().toString()+,+dhjTextFi

3、eld.getText()+,+zzjTextField.getText()+);int rowCount =stat.executeUpdate(sql);if (rowCount0 ) jbjg.setText(录入正确!);xhjTextField.setText(); xmjTextField.setText(); xbjComboBox.setSelectedIndex(0); nljTextField.setText(); bjjComboBox.setToolTipText(); dhjTextField.setText(); zzjTextField.setText(); co

4、nn.close(); catch(java.lang.Exception exec) jbjg.setText(录入错误!); try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url2 = jdbc:odbc:stu01; 添加记录代码段（续一）添加记录代码段（续一）Connection conn2 = DriverManager.getConnection(url2); Statement stat2 = conn2.createStatement(); String sql2 = select * from classes

5、where mingcheng=+bjjComboBox.getSelectedItem().toString()+; ResultSet rSet2 = stat2.executeQuery(sql2); while (rSet2.next() xhjTextField.setText(rSet2.getString(1); conn2.close(); catch(java.lang.Exception exec) jbjg.setText(错误!); xhjTextField.requestFocus(); 添加记录代码段（续二）添加记录代码段（续二）19.2 删除记录删除记录设计分析(

6、1) 选用JDBCODBC连接数据库。(2) 设计窗体，在窗体中加入控件，显示用户输入界面。(3) 为控件加入监听者及事件处理代码段。删除记录窗体图示删除记录窗体图示删除记录代码段删除记录代码段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

7、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(

8、); 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

9、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

10、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

11、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

12、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

13、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

14、修改记录代码段（续一）修改记录代码段（续一）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.execute