?? addrecordframe.java~14~
字號:
package addrecord;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;import java.sql.*;import java.util.*;import javax.swing.*;import javax.swing.event.*;import javax.swing.table.*;/** * Title: 數(shù)據(jù)庫增加新的數(shù)據(jù)記錄程序 * Description: 教學(xué)示范 * Copyright: Copyright (c) 2003 * Company: 北京師范大學(xué)計算機系 * @author 孫一林 * @version 1.0 */public class AddRecordFrame extends JFrame { private JPanel contentPane; private XYLayout xYLayout1 = new XYLayout(); // 構(gòu)造XYLayout布局管理器 private Label label1 = new Label(); // 創(chuàng)建顯示信息使用的組件 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 addrecordButton = new Button(); private Button refreshButton = new Button(); Vector vector; // 聲明一個向量對象 String title[] = {"CUST_ID","CUST_NAME","CUST_ADD","CUST_PHONE","CUST_ACCOUNT"}; // 二維表列名 Connection connection = null; // 聲明Connection接口對象connection ResultSet rs = null; // 定義數(shù)據(jù)庫查詢的結(jié)果集 Statement statement = null; // 定義查詢數(shù)據(jù)庫的Statement對象 AbstractTableModel tm; // 聲明一個AbstractTableModel類對象tm public AddRecordFrame() { enableEvents(AWTEvent.WINDOW_EVENT_MASK); try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } private void jbInit() throws Exception { contentPane = (JPanel) this.getContentPane(); label1.setText("學(xué)號"); // 初始化組件 contentPane.setLayout(xYLayout1); this.setSize(new Dimension(439, 420)); this.setTitle("增加新的數(shù)據(jù)記錄"); label2.setText("姓名"); label3.setText("年齡"); label4.setText("性別"); label5.setText("系名"); addrecordButton.setLabel("添加記錄"); refreshButton.setLabel("刷新"); addrecordButton.addActionListener(new java.awt.event.ActionListener() { // 設(shè)置addrecordButton按鈕監(jiān)聽器 public void actionPerformed(ActionEvent e) { addrecordButton_actionPerformed(e); } }); refreshButton.addActionListener(new java.awt.event.ActionListener() { // 設(shè)置refreshButton按鈕監(jiān)聽器 public void actionPerformed(ActionEvent e) { refreshButton_actionPerformed(e); } }); contentPane.add(label4, new XYConstraints(273, 235, 46, 30)); contentPane.add(label1, new XYConstraints(31, 235, 46, 30)); contentPane.add(label2, new XYConstraints(112, 235, 46, 30)); contentPane.add(label3, new XYConstraints(193, 235, 46, 30)); contentPane.add(label5, new XYConstraints(354, 235, 46, 30)); contentPane.add(sexField, new XYConstraints(271, 270, 63, 28)); contentPane.add(stunumField, new XYConstraints(28, 270, 63, 28)); contentPane.add(nameField, new XYConstraints(109, 270, 63, 28)); contentPane.add(ageField, new XYConstraints(190, 270, 63, 28)); contentPane.add(departnameField, new XYConstraints(352, 270, 63, 28)); contentPane.add(addrecordButton, new XYConstraints(88, 316, 82, 32)); contentPane.add(refreshButton, new XYConstraints(276, 316, 82, 32)); createtable(); // 在初始化函數(shù)中調(diào)用createtable()函數(shù)顯示表格 } void createtable() { // 定義createtable()函數(shù) JTable table; // 聲明一個JTable類對象table JScrollPane scroll; // 聲明一個滾動杠對象scroll vector = new Vector(); // 創(chuàng)建向量對象 tm = new AbstractTableModel() { // 創(chuàng)建AbstractTableModel類對象tm public int getColumnCount() { // 取得表格列數(shù) return title.length; } public int getRowCount() { // 取得表格行數(shù) 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) { // 數(shù)據(jù)模型不可編輯，該方法設(shè)置為空 } 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) {// 設(shè)置單元格不可編輯，為缺省實現(xiàn) return false; } }; table = new JTable(tm); // 生成自己的數(shù)據(jù)模型 table.setToolTipText("Display Query Result"); // 設(shè)置幫助提示 table.setAutoResizeMode(table.AUTO_RESIZE_OFF); // 設(shè)置表格調(diào)整尺寸模式 table.setCellSelectionEnabled(false); // 設(shè)置單元格選擇方式 table.setShowHorizontalLines(true); // 設(shè)置是否顯示單元格之間的分割線 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 addrecordButton_actionPerformed(ActionEvent e) { // 處理addrecordButton的ActionEvent try { String user="sysdba"; String password="masterkey"; String drivername="interbase.intercliect.Driver"; Class.forName(drivername); // 實例化JDBC-ODBC橋的驅(qū)動 System.out.println("成功interbase驅(qū)動"); String url = "jdbc:interbase://localhost/e:/jbuilder/shujk/student22.gdb"; // 設(shè)置連接字符串 connection = DriverManager.getConnection(url,user,password); // 連接數(shù)據(jù)庫 System.out.println("連接數(shù)據(jù)庫成功"); statement = connection.createStatement(); // 創(chuàng)建Statement接口對象 String sql = "insert into customers (學(xué)號,姓名,年齡,性別,系名) values (" + Integer.parseInt(stunumField.getText()) +", '" + nameField.getText()+"'," +Integer.parseInt(ageField.getText())+",'"+sexField.getText()+"',"+"'"+departnameField.getText()+ "')"; statement.executeUpdate(sql); // 執(zhí)行增加新的數(shù)據(jù)記錄語句 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(); // 關(guān)閉Statement接口實例 } if(connection != null) { connection.close(); // 關(guān)閉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 { String user="sysdba"; String password="masterkey"; String drivername="interbase.intercliect.Driver"; Class.forName(drivername); // 實例化JDBC-ODBC橋的驅(qū)動 System.out.println("成功interbase驅(qū)動"); String url = "jdbc:interbase://localhost/e:/jbuilder/shujk/student22.gdb"; // 設(shè)置連接字符串 connection = DriverManager.getConnection(url,user,password); // 連接數(shù)據(jù)庫 System.out.println("連接數(shù)據(jù)庫成功"); // 連接數(shù)據(jù)庫 statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from CUSTOMERS"; // 設(shè)置字符串sql的值 rs = statement.executeQuery(sql); // 執(zhí)行查詢語句 vector.removeAllElements(); // 初始化向量對象 tm.fireTableStructureChanged(); // 更新表格內(nèi)容 while(rs.next()) { Vector rec_vector = new Vector(); // 從結(jié)果集中取數(shù)據(jù)放入向量rec_vector中 rec_vector.addElement(String.valueOf(rs.getInt("CUST_ID"))); rec_vector.addElement(rs.getString("CUST_NAME")); rec_vector.addElement(String.valueOf(rs.getInt("CUST_ADD"))); rec_vector.addElement(rs.getString("CUST_PHONE")); rec_vector.addElement(rs.getString("CUST_ACCOUNT")); vector.addElement(rec_vector); // 向量rec_vector加入向量vector中 } tm.fireTableStructureChanged(); // 更新表格，顯示向量vector的內(nèi)容 rs.close(); // 關(guān)閉結(jié)果集 } 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(); // 關(guān)閉Statement接口實例 } if(connection != null) { connection.close(); // 關(guān)閉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()); } } }}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -