讲信息录入录入界面的建立ppt课件

1、第十九讲第十九讲 信息录入信息录入_ _ 录入界面的建立录入界面的建立19.1 添加记录19.2 删除记录19.3 修正记录 本章要点本章要点l掌握JAVA中添加记录的方法l掌握JAVA中删除记录的方法l掌握JAVA中修正记录的方法19.1 添加记录添加记录(1) 本数据库为Access数据库，所以可选用JDBCODBC衔接数据库。(2) 设计窗体，在窗体中参与控件，显示用户输入界面。(3) 为控件参与监听者及事件处置代码段。添加记录窗体图示添加记录窗体图示添加记录代码段添加记录代码段 void jButton1_actionPerformed(ActionEvent e) try Class

2、.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:stu01; Connection conn = DriverManager.getConnection(url); Statement stat = conn.createStatement();String sql = insert into students values(+xhjTextField.getText()+,+xmjTextField.getText()+,+xbjComboBox.getSelectedItem()+,+nljTextField.g

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

4、olTipText(); dhjTextField.setText(); zzjTextField.setText(); conn.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 = co

5、nn2.createStatement(); String sql2 = select * from classes 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(错误!); xhjTextFie

6、ld.requestFocus(); 添加记录代码段续二添加记录代码段续二19.2 删除记录删除记录设计分析(1) 选用JDBCODBC衔接数据库。(2) 设计窗体，在窗体中参与控件，显示用户输入界面。(3) 为控件参与监听者及事件处置代码段。删除记录窗体图示删除记录窗体图示删除记录代码段删除记录代码段public void jButton1_actionPerformed(ActionEvent e) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:stu01; Connection conn =

7、 DriverManager.getConnection(url); Statement stat = conn.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.setTex

8、t(删除错误!); xmjTextField.setText(); xmjTextField.setText(); xbjComboBox.setSelectedIndex(0); nljTextField.setText(); dhjTextField.setText(); zzjTextField.setText(); bjjComboBox.setSelectedIndex(newbjjComboBox.getSelectedIndex(); try 删除记录代码段续一删除记录代码段续一Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String

9、 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(); whi

10、le (rSet2.next() xhjComboBox.addItem(rSet2.getString(1); conn2.close(); catch(java.lang.Exception exec) jbjg.setText(错误!); newbjjComboBox.requestFocus(); 删除记录代码段续二删除记录代码段续二19.3 修正记录修正记录设计分析(1) 选用JDBCODBC衔接数据库。(2) 设计窗体，在窗体中参与控件，显示用户输入界面。(3) 为控件参与监听者及事件处置代码段。修正记录窗体图示修正记录窗体图示修正记录代码段修正记录代码段public void j

11、Button2_actionPerformed(ActionEvent e) try Class.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()+,xingmi

12、ng=+xmjTextField.getText()+,xingbie=+xbjComboBox.getSelectedItem().toString()+,nianling=+nljTextField.getText()+,banji=+bjjComboBox.getSelectedItem().toString()+,dianhua=+dhjTextField.getText()+,zhuzhi=+zzjTextField.getText()+ where xuehao=+xhjComboBox.getSelectedItem().toString()+;int rowCount =sta

13、t.executeUpdate(sql); if (rowCount0 ) jbjg.setText(修正正确!); conn.close(); catch(java.lang.Exception exec) jbjg.setText(修正错误!); xmjTextField.setText(); xmjTextField.setText(); xbjComboBox.setSelectedIndex(0); nljTextField.setText(); dhjTextField.setText(); zzjTextField.setText(); bjjComboBox.setSelect

14、edIndex(newbjjComboBox.getSelectedIndex(); try 修正记录代码段续一修正记录代码段续一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.e