?? borrowinfoupdate.java~12~
字號:
package bookmanager;import javax.swing.*;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class borrowInfoUpdate extends JFrame { ResultSet rs; //定義結果集 private DBManager db =new DBManager();//定義數據庫操作對象 XYLayout xYLayout1 = new XYLayout(); JButton jButtonupdate = new JButton(); JButton jButtonexit = new JButton(); JButton jButtondeciside = new JButton(); JButton jButtonClear = new JButton(); JLabel jLabel8 = new JLabel(); JLabel jLabel4 = new JLabel(); JTextField jTextbookname = new JTextField(); JTextField jTextborrowdate = new JTextField(); JLabel jLabel1 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel2 = new JLabel(); JTextField jTextcomment = new JTextField(); JTextField jTextstudentname = new JTextField(); public borrowInfoUpdate() { try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } public static void main(String[] args) { borrowInfoUpdate borrowInfoUpdate = new borrowInfoUpdate(); } private void jbInit() throws Exception { jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonClear.setText("清空"); jButtonClear.addMouseListener(new borrowInfoUpdate_jButtonClear_mouseAdapter(this)); jButtondeciside.setFont(new java.awt.Font("Dialog", 0, 16)); jButtondeciside.setText("確定"); jButtondeciside.addMouseListener(new borrowInfoUpdate_jButtondeciside_mouseAdapter(this)); jButtonexit.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonexit.setText("退出"); jButtonexit.addMouseListener(new borrowInfoUpdate_jButtonexit_mouseAdapter(this)); jButtonupdate.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonupdate.setText("更新"); jButtonupdate.addMouseListener(new borrowInfoUpdate_jButtonupdate_mouseAdapter(this)); this.getContentPane().setLayout(xYLayout1); jLabel8.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel8.setText("輸入借閱者姓名或書名點擊確定，將調出此書相關信息"); jLabel4.setText("備注"); jLabel4.setFont(new java.awt.Font("Dialog", 0, 16)); jTextbookname.setText(""); jTextbookname.setFont(new java.awt.Font("Dialog", 0, 16)); jTextborrowdate.setText(""); jTextborrowdate.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel1.setText("借閱者姓名"); jLabel1.setRequestFocusEnabled(true); jLabel1.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel3.setText("借閱日期"); jLabel3.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel2.setText("書名"); jLabel2.setFont(new java.awt.Font("Dialog", 0, 16)); jTextcomment.setText(""); jTextcomment.setFont(new java.awt.Font("Dialog", 0, 16)); jTextstudentname.setText(""); jTextstudentname.setFont(new java.awt.Font("Dialog", 0, 16)); xYLayout1.setWidth(477); xYLayout1.setHeight(386); this.getContentPane().add(jTextstudentname, new XYConstraints(219, 90, 150, 26)); this.getContentPane().add(jLabel4, new XYConstraints(90, 247, 63, 29)); this.getContentPane().add(jTextbookname, new XYConstraints(218, 144, 154, 23)); this.getContentPane().add(jTextborrowdate, new XYConstraints(218, 187, 153, -1)); this.getContentPane().add(jLabel1, new XYConstraints(91, 86, 88, 33)); this.getContentPane().add(jLabel3, new XYConstraints(88, 200, 87, 29)); this.getContentPane().add(jLabel2, new XYConstraints(88, 144, 89, 35)); this.getContentPane().add(jTextcomment, new XYConstraints(219, 236, 154, -1)); this.getContentPane().add(jLabel8, new XYConstraints(17, 26, 435, 25)); this.getContentPane().add(jButtondeciside, new XYConstraints(166, 314, -1, 28)); this.getContentPane().add(jButtonupdate, new XYConstraints(232, 314, 74, 27)); this.getContentPane().add(jButtonexit, new XYConstraints(306, 314, 75, 28)); this.getContentPane().add(jButtonClear, new XYConstraints(99, 314, 66, 28)); } void jButtondeciside_mouseClicked(MouseEvent e) { String sql; //定義變量，用來判斷是否是第一個查詢條件 boolean isfirst =true; sql="select * from BookBorrow "; //如果款型的查詢條件不為空 if (jTextstudentname.getText().trim().length() ==0) {} else { sql=sql+" where studentname='"+jTextstudentname.getText().trim()+"'"; isfirst=false; } //如果顏色的查詢條件不為空 if (jTextbookname.getText().trim().length()==0) {} else { //如果是第一個查詢條件 if (isfirst) sql=sql+" where bookname='"+jTextbookname.getText().trim() +"'"; //如果是第二個查詢條件 else sql=sql+" and bookname='"+jTextbookname.getText().trim() +"'"; } //執行數據庫的查詢操作 rs =db.getResult(sql); try { //判斷返回的結果集是否為空，若不為空顯示第一條記錄 if(! rs.equals(null) ) { rs.first(); jTextstudentname.setText(rs.getString("studentname")); jTextbookname.setText(rs.getString("bookname")); jTextborrowdate.setText(rs.getString("borrowdate")); jTextcomment.setText(rs.getString("comment")); } else { JOptionPane.showMessageDialog(null,"無次紀錄!"); } }//若出現異常，彈出警告對話框 catch (SQLException ex) { JOptionPane.showMessageDialog(null,"發生錯誤!"); } } //清空文本框 void jButtonClear_mouseClicked(MouseEvent e) { jTextstudentname.setText(""); jTextbookname.setText(""); jTextborrowdate.setText(""); jTextcomment.setText(""); } void jButtonexit_mouseClicked(MouseEvent e) { this.dispose(); } void jButtonupdate_mouseClicked(MouseEvent e) { String strSQL ;strSQL="update BookBorrow set ";strSQL= strSQL+" borrowdate='"+jTextborrowdate.getText().trim()+"',";strSQL= strSQL+" comment='"+jTextcomment.getText().trim()+"'";strSQL= strSQL+ " where studentname='"+jTextstudentname.getText().trim() +"'";strSQL= strSQL+" and bookname='"+jTextbookname.getText().trim()+"'";if(db.executeSql(strSQL)) {JOptionPane.showMessageDialog(null,"成功更新！"); } else { JOptionPane.showMessageDialog(null," 更新失敗，請重新操作！"); } }}class borrowInfoUpdate_jButtondeciside_mouseAdapter extends java.awt.event.MouseAdapter { borrowInfoUpdate adaptee; borrowInfoUpdate_jButtondeciside_mouseAdapter(borrowInfoUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtondeciside_mouseClicked(e); }}class borrowInfoUpdate_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter { borrowInfoUpdate adaptee; borrowInfoUpdate_jButtonClear_mouseAdapter(borrowInfoUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonClear_mouseClicked(e); }}class borrowInfoUpdate_jButtonexit_mouseAdapter extends java.awt.event.MouseAdapter { borrowInfoUpdate adaptee; borrowInfoUpdate_jButtonexit_mouseAdapter(borrowInfoUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonexit_mouseClicked(e); }}class borrowInfoUpdate_jButtonupdate_mouseAdapter extends java.awt.event.MouseAdapter { borrowInfoUpdate adaptee; borrowInfoUpdate_jButtonupdate_mouseAdapter(borrowInfoUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonupdate_mouseClicked(e); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -