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

第十九講 信息錄入_ 錄入界面的建立,19.1 添加記錄 19.2 刪除記錄 19.3 修改記錄,本章要點,掌握J(rèn)AVA中添加記錄的方法 掌握J(rèn)AVA中刪除記錄的方法 掌握J(rèn)AVA中修改記錄的方法,19.1 添加記錄,(1) 本數(shù)據(jù)庫為Access數(shù)據(jù)庫，所以可選用JDBCODBC連接數(shù)據(jù)庫。 (2) 設(shè)計窗體，在窗體中加入控件，顯示用戶輸入界面。 (3) 為控件加入監(jiān)聽者及事件處理代碼段。,添加記錄窗體圖示,添加記錄代碼段,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“;,添加記錄代碼段（續(xù)一）,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(); ,添加記錄代碼段（續(xù)二）,19.2 刪除記錄,設(shè)計分析 (1) 選用JDBCODBC連接數(shù)據(jù)庫。 (2) 設(shè)計窗體，在窗體中加入控件，顯示用戶輸入界面。 (3) 為控件加入監(jiān)聽者及事件處理代碼段。,刪除記錄窗體圖示,刪除記錄代碼段,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 ,刪除記錄代碼段（續(xù)一）,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(); ,刪除記錄代碼段（續(xù)二）,19.3 修改記錄,設(shè)計分析 (1) 選用JDBCODBC連接數(shù)據(jù)庫。 (2) 設(shè)計窗體，在窗體中加入控件，顯示用戶輸入界面。 (3) 為控件加入監(jiān)聽者及事件處理代碼段。,修改記錄窗體圖示,修改記錄代碼段,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 ,修改記錄代碼段（續(xù)一）,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