?? deleterecordframe.java
字號:
package deleterecord;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 DeleteRecordFrame extends JFrame { private JPanel contentPane; private XYLayout xYLayout1 = new XYLayout(); // 構造XYLayout布局管理器 private TextField delrecordnumField = new TextField(); // 創建顯示信息使用的組件 private Label label1 = new Label(); private Button deleteButton = new Button(); private Button refreshButton = new Button(); Vector vector; // 聲明一個向量對象 String title[] = {"學號","姓名","年齡","性別","系名"}; // 二維表列名 Connection connection = null; // 聲明Connection接口對象connection ResultSet rSet = null; // 定義數據庫查詢的結果集 Statement statement = null; // 定義查詢數據庫的Statement對象 AbstractTableModel tm; // 聲明一個AbstractTableModel類對象tm public DeleteRecordFrame() { 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(436, 420)); this.setTitle("刪除數據記錄"); deleteButton.setLabel("刪除記錄"); refreshButton.setLabel("刷新記錄"); deleteButton.addActionListener(new java.awt.event.ActionListener() { // 設置deleteButton按鈕監聽器 public void actionPerformed(ActionEvent e) { deleteButton_actionPerformed(e); } }); refreshButton.addActionListener(new java.awt.event.ActionListener() { // 設置refreshButton按鈕監聽器 public void actionPerformed(ActionEvent e) { refreshButton_actionPerformed(e); } }); contentPane.add(deleteButton, new XYConstraints(103, 311, 87, 31)); contentPane.add(refreshButton, new XYConstraints(242, 311, 87, 31)); contentPane.add(delrecordnumField, new XYConstraints(207, 251, 94, 35)); contentPane.add(label1, new XYConstraints(104, 257, 83, 31)); 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 deleteButton_actionPerformed(ActionEvent e) { // 處理deleteButton的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(delrecordnumField.getText()) ; rSet = statement.executeQuery(sql); // 執行學號為輸入學號的查詢語句 if (rSet.next()==false) { // 判斷數據庫中是否有要刪除的記錄，如沒有則顯示提示框 JOptionPane msg = new JOptionPane(); JOptionPane.showMessageDialog(DeleteRecordFrame.this, "數據庫中沒有您刪除的學號", "數據庫中沒有您刪除的學號！", 1); } else { sql="delete from studentbase where 學號="+Integer.parseInt(delrecordnumField.getText()); statement.executeUpdate(sql); // 執行刪除數據記錄語句 delrecordnumField.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()); } } 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"; rSet = statement.executeQuery(sql); // 執行查詢語句 vector.removeAllElements(); // 初始化向量對象 tm.fireTableStructureChanged(); // 更新表格內容 while(rSet.next()) { Vector rec_vector = new Vector(); // 從結果集中取數據放入向量rec_vector中 rec_vector.addElement(String.valueOf(rSet.getInt("學號"))); rec_vector.addElement(rSet.getString("姓名")); rec_vector.addElement(String.valueOf(rSet.getInt("年齡"))); rec_vector.addElement(rSet.getString("性別")); rec_vector.addElement(rSet.getString("系名")); vector.addElement(rec_vector); // 向量rec_vector加入向量vector中 } tm.fireTableStructureChanged(); // 更新表格，顯示向量vector的內容 rSet.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 + -