?? updaterecordframe.java
字號:
package updaterecord;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;import java.lang.*;import java.lang.Object.*;import java.sql.*;import java.util.*;import javax.swing.*;import javax.swing.event.*;import javax.swing.table.*;/** * Title: 更新數據記錄程序 * Description: 教學示范 * Copyright: Copyright (c) 2003 * Company: 北京師范大學計算機系 * @author 孫一林 * @version 1.0 */public class UpdateRecordFrame extends JFrame { private JPanel contentPane; private XYLayout xYLayout1 = new XYLayout(); // 構造XYLayout布局管理器 // 創建顯示信息使用的組件 private Label label1 = new Label(); private Label label2 = new Label(); private Label label3 = new Label(); private Label label4 = new Label(); private Label label5 = new Label(); private TextField stunumField = new TextField(); private TextField nameField = new TextField(); private TextField ageField = new TextField(); private TextField sexField = new TextField(); private TextField departnameField = new TextField(); private Button updateButton = new Button(); private Button refreshButton = new Button(); Vector vector; // 聲明一個向量對象 String title[] = {"學號","姓名","年齡","性別","系名"}; // 二維表列名 Connection connection = null; // 聲明Connection接口對象connection ResultSet rs = null; // 定義數據庫查詢的結果集 Statement statement = null; // 定義查詢數據庫的Statement對象 AbstractTableModel tm; // 聲明一個AbstractTableModel類對象tm public UpdateRecordFrame() { enableEvents(AWTEvent.WINDOW_EVENT_MASK); try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } private void jbInit() throws Exception { contentPane = (JPanel) this.getContentPane(); // 初始化組件 label1.setText("學號"); contentPane.setLayout(xYLayout1); this.setSize(new Dimension(431, 436)); this.setTitle("更新數據記錄"); label2.setText("姓名"); label3.setText("年齡"); label4.setText("性別"); label5.setText("系名"); updateButton.setLabel("更新記錄"); refreshButton.setLabel("刷新記錄"); updateButton.addActionListener(new java.awt.event.ActionListener() { // 設置updateButton按鈕監聽器 public void actionPerformed(ActionEvent e) { updateButton_actionPerformed(e); } }); refreshButton.addActionListener(new java.awt.event.ActionListener() { // 設置refreshButton按鈕監聽器 public void actionPerformed(ActionEvent e) { refreshButton_actionPerformed(e); } }); contentPane.add(ageField, new XYConstraints(185, 289, 63, 27)); contentPane.add(label1, new XYConstraints(47, 249, 46, 31)); contentPane.add(label2, new XYConstraints(119, 249, 46, 31)); contentPane.add(label3, new XYConstraints(192, 249, 46, 31)); contentPane.add(label4, new XYConstraints(264, 249, 46, 31)); contentPane.add(label5, new XYConstraints(336, 249, 46, 31)); contentPane.add(stunumField, new XYConstraints(31, 289, 63, 27)); contentPane.add(nameField, new XYConstraints(108, 289, 63, 27)); contentPane.add(sexField, new XYConstraints(261, 289, 63, 27)); contentPane.add(departnameField, new XYConstraints(338, 289, 63, 27)); contentPane.add(updateButton, new XYConstraints(102, 331, 87, 32)); contentPane.add(refreshButton, new XYConstraints(241, 331, 83, 32)); createtable(); // 在初始化函數中調用createtable()函數顯示表格 } void createtable() { // 定義createtable()函數 JTable table; // 聲明一個JTable類對象table JScrollPane scroll; // 聲明一個滾動杠對象scroll vector = new Vector(); // 創建向量對象 tm = new AbstractTableModel() { // 創建AbstractTableModel類對象tm public int getColumnCount() { // 取得表格列數 return title.length; } public int getRowCount() { // 取得表格行數 return vector.size(); } public Object getValueAt(int row, int column) { // 取得單元格中的屬性值 if(!vector.isEmpty()) { return ((Vector)vector.elementAt(row)).elementAt(column); } else { return null; } } public void setValueAt(Object value, int row, int column) { // 數據模型不可編輯，該方法設置為空 } public String getColumnName(int column) { // 取得表格列名 return title[column]; } public Class getColumnClass(int c) { // 取得列所屬對象類 return getValueAt(0,c).getClass(); } public boolean isCellEditable(int row, int column) {// 設置單元格不可編輯，為缺省實現 return false; } }; table = new JTable(tm); // 生成自己的數據模型 table.setToolTipText("Display Query Result"); // 設置幫助提示 table.setAutoResizeMode(table.AUTO_RESIZE_OFF); // 設置表格調整尺寸模式 table.setCellSelectionEnabled(false); // 設置單元格選擇方式 table.setShowHorizontalLines(true); // 設置是否顯示單元格之間的分割線 table.setShowVerticalLines(true); scroll = new JScrollPane(table); // 給表格加上滾動杠 scroll.setBounds(6,20,540,250); contentPane.add(scroll,new XYConstraints(16, 20, 395, 200)); } protected void processWindowEvent(WindowEvent e) { super.processWindowEvent(e); if (e.getID() == WindowEvent.WINDOW_CLOSING) { System.exit(0); } } void updateButton_actionPerformed(ActionEvent e) { // 處理updateButton的ActionEvent try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動 String url = "jdbc:odbc:TestDbStu"; // 設置連接字符串 connection = DriverManager.getConnection(url); // 連接數據庫 // 創建Statement接口對象 statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from studentbase where 學號="+Integer.parseInt(stunumField.getText()) ; rs = statement.executeQuery(sql); // 執行學號為輸入學號的查詢語句 if (rs.next()==false) { // 判斷數據庫中是否有要更新的記錄，如沒有則顯示提示框 JOptionPane msg = new JOptionPane(); JOptionPane.showMessageDialog(UpdateRecordFrame.this, "數據庫中沒有您要更新的學號", "數據庫中沒有您要更新的學號！", 1); } else { sql="update studentbase set 姓名='"+nameField.getText()+"', 年齡="+Integer.parseInt(ageField.getText())+" ,性別='"+sexField.getText()+"',系名='"+departnameField.getText()+"' where 學號="+Integer.parseInt(stunumField.getText()); statement.executeUpdate(sql); // 執行更新數據記錄語句 // 清空信息框 stunumField.setText(""); nameField.setText(""); ageField.setText(""); sexField.setText(""); departnameField.setText(""); } } catch(SQLException ex){ // 捕捉異常 System.out.println("\nERROR:----- SQLException -----\n"); while (ex != null) { System.out.println("Message: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("ErrorCode: " + ex.getErrorCode()); ex = ex.getNextException(); } } catch(Exception ex ) { ex.printStackTrace(); } finally { try { if(statement != null) { statement.close(); // 關閉Statement接口實例 } if(connection != null) { connection.close(); // 關閉Connection接口實例 } } catch (SQLException ex) { System.out.println("\nERROR:----- SQLException -----\n"); System.out.println("Message: " + ex.getMessage( )); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("ErrorCode: " + ex.getErrorCode()); } } } void refreshButton_actionPerformed(ActionEvent e) { // 處理refreshButton的ActionEvent try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動 String url = "jdbc:odbc:TestDbStu"; connection = DriverManager.getConnection(url); // 連接數據庫 statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from studentbase"; rs = statement.executeQuery(sql); // 執行查詢語句 vector.removeAllElements(); // 初始化向量對象 tm.fireTableStructureChanged(); // 更新表格內容 while(rs.next()) { Vector rec_vector = new Vector(); // 從結果集中取數據放入向量rec_vector中 rec_vector.addElement(String.valueOf(rs.getInt("學號"))); rec_vector.addElement(rs.getString("姓名")); rec_vector.addElement(String.valueOf(rs.getInt("年齡"))); rec_vector.addElement(rs.getString("性別")); rec_vector.addElement(rs.getString("系名")); vector.addElement(rec_vector); // 向量rec_vector加入向量vector中 } tm.fireTableStructureChanged(); // 更新表格，顯示向量vector的內容 rs.close(); // 關閉結果集 } catch(SQLException ex){ // 捕捉異常 System.out.println("\nERROR:----- SQLException -----\n"); while (ex != null) { System.out.println("Message: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("ErrorCode: " + ex.getErrorCode()); ex = ex.getNextException(); } } catch(Exception ex ) { ex.printStackTrace(); } finally { try { if(statement != null) { statement.close(); // 關閉Statement接口實例 } if(connection != null) { connection.close(); // 關閉Connection接口實例 } } catch (SQLException ex) { System.out.println("\nERROR:----- SQLException -----\n"); System.out.println("Message: " + ex.getMessage( )); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("ErrorCode: " + ex.getErrorCode()); } } }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -