?? productupdate.java
字號:
package Manager;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 productUpdate extends JFrame { ResultSet rs; //定義結果集 private DBManager db =new DBManager(); XYLayout xYLayout1 = new XYLayout(); JLabel jLabel4 = new JLabel(); JTextField jTextFielddanwei = new JTextField(); JLabel jLabel2 = new JLabel(); JTextField jTextFieldperson = new JTextField(); JLabel jLabel6 = new JLabel(); JTextField jTextFieldname = new JTextField(); JTextField jTextFieldcomment = new JTextField(); JLabel jLabel1 = new JLabel(); JLabel jLabel3 = new JLabel(); JTextField jTextFieldprice = new JTextField(); JButton jButtonExit = new JButton(); JTextField jTextFielddep = new JTextField(); JButton jButtonClear = new JButton(); JButton jButtonOk = new JButton(); JLabel jLabel5 = new JLabel(); JButton jButtonDeside = new JButton(); JLabel jLabel7 = new JLabel(); JButton jButtonDelete = new JButton(); public productUpdate() { try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } public static void main(String[] args) { productUpdate productUpdate = new productUpdate(); } private void jbInit() throws Exception { jLabel5.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel5.setText("單價"); jButtonOk.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonOk.setText("更新"); jButtonOk.addMouseListener(new productUpdate_jButtonOk_mouseAdapter(this)); jButtonClear.setText("清空"); jButtonClear.addMouseListener(new productUpdate_jButtonClear_mouseAdapter(this)); jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFielddep.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFielddep.setText(""); jButtonExit.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonExit.setText("取消"); jButtonExit.addMouseListener(new productUpdate_jButtonExit_mouseAdapter(this)); jTextFieldprice.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldprice.setText(""); jLabel3.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel3.setText("所屬部門"); jLabel1.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel1.setText("名稱"); jTextFieldcomment.setText(""); jTextFieldcomment.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldname.setText(""); jLabel6.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel6.setText("描述"); jTextFieldperson.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldperson.setText(""); jLabel2.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel2.setText("負責人"); jTextFielddanwei.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFielddanwei.setText(""); jLabel4.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel4.setText("單位"); this.getContentPane().setLayout(xYLayout1); jButtonDeside.setText("確定"); jButtonDeside.addMouseListener(new productUpdate_jButtonDeside_mouseAdapter(this)); jButtonDeside.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel7.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel7.setText("填入產品名稱點擊確定將調出此產品相關信息："); xYLayout1.setWidth(546); xYLayout1.setHeight(402); jButtonDelete.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonDelete.setText("刪除"); jButtonDelete.addMouseListener(new productUpdate_jButtonDelete_mouseAdapter(this)); this.setTitle("更新產品信息"); this.getContentPane().add(jTextFieldname, new XYConstraints(309, 41, 111, 28)); this.getContentPane().add(jLabel4, new XYConstraints(155, 173, 105, 34)); this.getContentPane().add(jTextFielddanwei, new XYConstraints(310, 171, 111, 27)); this.getContentPane().add(jLabel2, new XYConstraints(155, 86, 80, 34)); this.getContentPane().add(jTextFieldperson, new XYConstraints(308, 85, 111, 26)); this.getContentPane().add(jLabel6, new XYConstraints(152, 260, 105, 34)); this.getContentPane().add(jTextFieldcomment, new XYConstraints(311, 256, 111, 28)); this.getContentPane().add(jLabel1, new XYConstraints(158, 42, 99, 34)); this.getContentPane().add(jLabel3, new XYConstraints(154, 127, 110, 36)); this.getContentPane().add(jTextFieldprice, new XYConstraints(310, 214, 111, 28)); this.getContentPane().add(jTextFielddep, new XYConstraints(310, 127, 111, 27)); this.getContentPane().add(jLabel5, new XYConstraints(153, 215, 105, 34)); this.getContentPane().add(jLabel7, new XYConstraints(11, 7, 359, 29)); this.getContentPane().add(jButtonDeside, new XYConstraints(153, 326, 91, 31)); this.getContentPane().add(jButtonOk, new XYConstraints(244, 326, 91, 31)); this.getContentPane().add(jButtonDelete, new XYConstraints(336, 326, 90, 31)); this.getContentPane().add(jButtonClear, new XYConstraints(58, 325, 95, 31)); this.getContentPane().add(jButtonExit, new XYConstraints(429, 327, 94, 30)); }//退出次窗體 void jButtonExit_mouseClicked(MouseEvent e) { this.dispose(); }//清空文本框 void jButtonClear_mouseClicked(MouseEvent e) { jTextFieldname.setText(""); jTextFieldperson.setText(""); jTextFielddep.setText(""); jTextFielddanwei.setText(""); jTextFieldprice.setText(""); jTextFieldcomment.setText(""); } void jButtonOk_mouseClicked(MouseEvent e) { //定義字符串對象,代表sql語句 String strSQL ; //生成sql語句 strSQL="update productinfo set Principal='"+jTextFieldperson.getText().trim() +"',"; strSQL= strSQL+" Department='"+jTextFielddep.getText().trim() +"',"; strSQL= strSQL+" Units='"+jTextFielddanwei.getText().trim() +"',"; strSQL= strSQL+" Unitprice='"+jTextFieldprice.getText().trim() +"',"; strSQL= strSQL+" Comment='"+jTextFieldcomment.getText().trim() +"'"; strSQL= strSQL+"where Name='"+jTextFieldname.getText().trim() +"' " ; //由DBManager對象執行過程，若成功返回成功信息，若失敗返回失敗提示 if(db.executeSql(strSQL)) {JOptionPane.showMessageDialog(null,"成功更新！"); } else { JOptionPane.showMessageDialog(null," 更新失敗，請重新操作！"); } }//調出產品相關信息 void jButtonDeside_mouseClicked(MouseEvent e) { //定義字符串對象,代表sql語句 String strSQL ; //生成sql語句 strSQL="select * from productinfo where Name='"+jTextFieldname.getText().trim() +"' " ; //由DBManager對象執行過程，若成功返回成功信息，若失敗返回失敗提示 rs=db.getResult(strSQL) ; //判斷結果集是否為空 boolean isexist=false; try { isexist = rs.first(); } catch (SQLException ex1) { } //若為空，則說明產品不存在，彈出警告信息 if(!isexist) {JOptionPane.showMessageDialog(null,"此產品不存在！"); } //若不為空，則說明產品存在 else { try { //將數據集中的數據顯示在對應文本框中 rs.first(); jTextFieldperson.setText(rs.getString("Principal") ); jTextFielddep.setText(rs.getString("Department")); jTextFielddanwei.setText(rs.getString("Units")); jTextFieldprice.setText(rs.getString("Unitprice")); jTextFieldcomment.setText(rs.getString("Comment")); } catch (SQLException ex) { } } } //刪除此信息 void jButtonDelete_mouseClicked(MouseEvent e) { //定義字符串對象,代表sql語句 String strSQL ; //生成sql語句 strSQL="delete from productinfo where Name='"+jTextFieldname.getText().trim() +"' " ; //由DBManager對象執行過程，若成功返回成功信息，若失敗返回失敗提示 if(db.executeSql(strSQL)) {JOptionPane.showMessageDialog(null,"成功刪除！"); } else { JOptionPane.showMessageDialog(null," 刪除失敗，請重新操作！"); } }}class productUpdate_jButtonExit_mouseAdapter extends java.awt.event.MouseAdapter { productUpdate adaptee; productUpdate_jButtonExit_mouseAdapter(productUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonExit_mouseClicked(e); }}class productUpdate_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter { productUpdate adaptee; productUpdate_jButtonClear_mouseAdapter(productUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonClear_mouseClicked(e); }}class productUpdate_jButtonOk_mouseAdapter extends java.awt.event.MouseAdapter { productUpdate adaptee; productUpdate_jButtonOk_mouseAdapter(productUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonOk_mouseClicked(e); }}class productUpdate_jButtonDeside_mouseAdapter extends java.awt.event.MouseAdapter { productUpdate adaptee; productUpdate_jButtonDeside_mouseAdapter(productUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonDeside_mouseClicked(e); }}class productUpdate_jButtonDelete_mouseAdapter extends java.awt.event.MouseAdapter { productUpdate adaptee; productUpdate_jButtonDelete_mouseAdapter(productUpdate adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonDelete_mouseClicked(e); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -