信息录入录入界面的建立.ppt

第十九讲 信息录入_ 录入界面的建立,19.1 添加记录 19.2 删除记录 19.3 修改记录,本章要点,掌握JAVA中添加记录的方法 掌握JAVA中删除记录的方法 掌握JAVA中修改记录的方法,19.1 添加记录,(1) 本数据库为Access数据库，所以可选用JDBCODBC连接数据库。 (2) 设计窗体，在窗体中加入控件，显示用户输入界面。 (3) 为控件加入监听者及事件处理代码段。,添加记录窗体图示,添加记录代码段,void jButton1_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 = “insert into students values(“+xhjTextField.getText()+“,“+xmjTextField.getText()+“,“+xbjComboBox.getSelectedItem()+“,“+nljTextField.getText()+“,“+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.setToolTipText(“); 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 = conn2.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(“错误!“); xhjTextField.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 = 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.setText(“删除错误!“); 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 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(); ,删除记录代码段（续二）,19.3 修改记录,设计分析 (1) 选用JDBCODBC连接数据库。 (2) 设计窗体，在窗体中加入控件，显示用户输入界面。 (3) 为控件加入监听者及事件处理代码段。,修改记录窗体图示,修改记录代码段,public void jButton2_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()+“,xingming=“+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 =stat.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.setSelectedIndex(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 = st