?? stuaddquerysysframe.java
字號:
package stuaddquerysys;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 StuAddQuerySysFrame extends JFrame { private JPanel contentPane; private XYLayout xYLayout1 = new XYLayout(); // 構造XYLayout布局管理器 // 創建顯示信息使用的組件 private Label label1 = new Label(); private TextField stunumField = new TextField(); private TextField nameField = new TextField(); private Label label2 = new Label(); private TextField ageField = new TextField(); private Label label3 = new Label(); private TextField sexField = new TextField(); private Label label4 = new Label(); private TextField departmentField = new TextField(); private Label label5 = new Label(); private TextField teleField = new TextField(); private Label label6 = new Label(); private TextField emailField = new TextField(); private Label label7 = new Label(); private Button addrecordButton = new Button(); private Button deleteButton = new Button(); private Button refreshButton = new Button(); private Button stunumqueryButton = new Button(); private Button allrecordButton = new Button(); Vector vector; // 聲明一個向量對象 String title[] = {"學號","姓名","年齡","性別","系名","電話","EMAIL"}; // 二維表列名 Connection connection = null; // 聲明Connection接口對象connection ResultSet rSet = null; // 定義數據庫查詢的結果集 Statement statement = null; // 定義查詢數據庫的Statement對象 AbstractTableModel tm; // 聲明一個AbstractTableModel類對象tm public StuAddQuerySysFrame() { 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(571, 521)); this.setTitle("學生地址表查詢系統"); label2.setText("姓名"); label3.setText("年齡"); label4.setText("性別"); label5.setText("系名"); label6.setText("電話"); label7.setText("EMAIL地址"); addrecordButton.setLabel("添加"); deleteButton.setLabel("刪除"); refreshButton.setLabel("更新"); stunumqueryButton.setLabel("學號查詢"); allrecordButton.setLabel("全部記錄"); addrecordButton.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { addrecordButton_actionPerformed(e); } }); deleteButton.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { deleteButton_actionPerformed(e); } }); refreshButton.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { refreshButton_actionPerformed(e); } }); stunumqueryButton.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { stunumqueryButton_actionPerformed(e); } }); allrecordButton.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { allrecordButton_actionPerformed(e); } }); contentPane.add(teleField, new XYConstraints(211, 370, 70, 29)); contentPane.add(label1, new XYConstraints(44, 315, 41, 29)); contentPane.add(stunumField, new XYConstraints(88, 315, 70, 29)); contentPane.add(label2, new XYConstraints(163, 315, 48, 29)); contentPane.add(nameField, new XYConstraints(212, 315, 70, 29)); contentPane.add(label3, new XYConstraints(293, 315, 35, 29)); contentPane.add(ageField, new XYConstraints(329, 315, 70, 29)); contentPane.add(label4, new XYConstraints(405, 315, 31, 29)); contentPane.add(sexField, new XYConstraints(440, 315, 70, 29)); contentPane.add(label5, new XYConstraints(42, 370, 44, 29)); contentPane.add(departmentField, new XYConstraints(89, 370, 70, 29)); contentPane.add(label6, new XYConstraints(163, 372, 49, 29)); contentPane.add(label7, new XYConstraints(292, 371, 67, 29)); contentPane.add(emailField, new XYConstraints(361, 370, 102, 29)); contentPane.add(addrecordButton, new XYConstraints(52, 416, 85, 32)); contentPane.add(deleteButton, new XYConstraints(147, 416, 85, 32)); contentPane.add(refreshButton, new XYConstraints(241, 416, 85, 32)); contentPane.add(stunumqueryButton, new XYConstraints(336, 416, 85, 32)); contentPane.add(allrecordButton, new XYConstraints(430, 416, 85, 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(6, 20, 540, 250)); } 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 { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 實例化JDBC-ODBC橋的驅動 String url = "jdbc:odbc:TestDbStu"; // 設置連接字符串 connection = DriverManager.getConnection(url); // 連接數據庫 // 創建Statement接口對象 statement = connection.createStatement(); String sql1 = "insert into studentbase (學號,姓名,年齡,性別,系名) values (" + Integer.parseInt(stunumField.getText()) +", '" + nameField.getText()+"'," +Integer.parseInt(ageField.getText())+",'"+sexField.getText()+"',"+"'"+departmentField.getText()+ "')"; String sql2 = "insert into studentaddress (電話,Email地址,學號) values (" + "'" + teleField.getText()+"','" + emailField.getText()+"',"+Integer.parseInt(stunumField.getText())+")"; statement.executeUpdate(sql2); // 執行增加新的數據記錄語句，向studentaddress 表中添加記錄 statement.executeUpdate(sql1); // 執行增加新的數據記錄語句，向studentbase表中添加記錄 // 清空信息框 stunumField.setText(""); nameField.setText(""); ageField.setText(""); sexField.setText(""); departmentField.setText(""); teleField.setText(""); emailField.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()); } } }?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -