?? frameproductout.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 FrameProductOut extends JFrame { DBManager db =new DBManager(); //創建數據操作對象 ResultSet rs; //定義所用的結果集 XYLayout xYLayout1 = new XYLayout(); JLabel jLabel8 = new JLabel(); JTextField jText44 = new JTextField(); JTextField jText41 = new JTextField(); JLabel jLabel12 = new JLabel(); JButton jButtonCancel = new JButton(); JLabel jLabel1 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel13 = new JLabel(); JTextField jText43 = new JTextField(); JButton jButtonReset = new JButton(); JTextField jText37 = new JTextField(); JLabel jLabel2 = new JLabel(); JLabel jLabel14 = new JLabel(); JTextField jTextkuanxing = new JTextField(); JLabel jLabel9 = new JLabel(); JComboBox jCombocolor = new JComboBox(); JLabel jText37ee = new JLabel(); JTextField jText36 = new JTextField(); JLabel jLabel11 = new JLabel(); JLabel jLabel7 = new JLabel(); JTextField jText40 = new JTextField(); JButton jButtonAdd = new JButton(); JTextField jTextoperator = new JTextField(); JPanel jPanel1 = new JPanel(); JTextField jTextdate = new JTextField(); JTextField jText42 = new JTextField(); JTextField jText38 = new JTextField(); JLabel jLabel6 = new JLabel(); XYLayout xYLayout2 = new XYLayout(); JTextField jTextcomment = new JTextField(); JLabel jLabel15 = new JLabel(); JLabel jLabel10 = new JLabel(); JTextField jText39 = new JTextField(); JLabel jLabel5 = new JLabel(); public FrameProductOut() { try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } public static void main(String[] args) { FrameProductOut frameProductOut = new FrameProductOut(); } private void jbInit() throws Exception { jPanel1.setLayout(xYLayout2); jPanel1.setToolTipText(""); jPanel1.setBorder(BorderFactory.createLineBorder(Color.black)); jTextoperator.setText(""); jButtonAdd.setText("添加"); jButtonAdd.addMouseListener(new FrameProductOut_jButtonAdd_mouseAdapter(this)); jButtonAdd.setFont(new java.awt.Font("Dialog", 0, 16)); jText40.setText("0"); jLabel7.setText("操作員"); jLabel7.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel11.setText("39"); jLabel11.setFont(new java.awt.Font("Dialog", 0, 16)); jText36.setText("0"); jText37ee.setText("37"); jText37ee.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel9.setText("40"); jLabel9.setFont(new java.awt.Font("Dialog", 0, 16)); jTextkuanxing.setText(""); jLabel14.setText("44"); jLabel14.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel2.setText("出庫日期"); jLabel2.setVerifyInputWhenFocusTarget(true); jLabel2.setFont(new java.awt.Font("Dialog", 0, 16)); jText37.setText("0"); jButtonReset.setText("清空"); jButtonReset.addMouseListener(new FrameProductOut_jButtonReset_mouseAdapter(this)); jButtonReset.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel13.setText("43"); jLabel13.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel3.setText("顏色"); jLabel3.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel1.setText(" 款型"); jLabel1.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonCancel.setText("取消"); jButtonCancel.addMouseListener(new FrameProductOut_jButtonCancel_mouseAdapter(this)); jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel12.setText("42"); jLabel12.setFont(new java.awt.Font("Dialog", 0, 16)); jText41.setText("0"); jText44.setText("0"); jLabel8.setText("38"); jLabel8.setFont(new java.awt.Font("Dialog", 0, 16)); xYLayout1.setWidth(650); xYLayout1.setHeight(422); this.getContentPane().setLayout(xYLayout1); jCombocolor.addItem(""); jCombocolor.addItem("red"); jCombocolor.addItem("black"); jCombocolor.addItem("blue"); jTextdate.setText(""); jText42.setText("0"); jText38.setText("0"); jLabel6.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel6.setText("36"); jTextcomment.setText(""); jLabel15.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel15.setText("備注"); jLabel10.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel10.setText("41"); jText39.setText("0"); jLabel5.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel5.setText("信息明細"); jText43.setText("0"); this.setTitle("產品出庫"); jPanel1.add(jLabel11, new XYConstraints(187, 15, 40, 25)); jPanel1.add(jLabel13, new XYConstraints(407, 64, 35, 22)); jPanel1.add(jLabel12, new XYConstraints(410, 20, 35, 21)); jPanel1.add(jLabel14, new XYConstraints(406, 113, 41, 20)); jPanel1.add(jLabel6, new XYConstraints(14, 18, 34, 20)); jPanel1.add(jText37ee, new XYConstraints(13, 61, 41, 22)); jPanel1.add(jLabel8, new XYConstraints(13, 120, 36, 26)); jPanel1.add(jLabel9, new XYConstraints(183, 70, 35, -1)); jPanel1.add(jLabel10, new XYConstraints(185, 122, 34, 21)); jPanel1.add(jText36, new XYConstraints(62, 17, 90, 27)); jPanel1.add(jText37, new XYConstraints(63, 62, 87, 26)); jPanel1.add(jText38, new XYConstraints(64, 120, 85, -1)); jPanel1.add(jText39, new XYConstraints(251, 20, 104, 23)); jPanel1.add(jText40, new XYConstraints(251, 67, 108, 25)); jPanel1.add(jText41, new XYConstraints(252, 122, 109, 23)); jPanel1.add(jText42, new XYConstraints(462, 23, 104, 25)); jPanel1.add(jText43, new XYConstraints(462, 66, 106, 24)); jPanel1.add(jText44, new XYConstraints(462, 112, 108, 21)); this.getContentPane().add(jLabel1, new XYConstraints(25, 13, 66, 32)); this.getContentPane().add(jTextdate, new XYConstraints(425, 13, 87, 28)); this.getContentPane().add(jLabel5, new XYConstraints(17, 164, 86, 22)); this.getContentPane().add(jPanel1, new XYConstraints(17, 192, 613, 161)); this.getContentPane().add(jButtonCancel, new XYConstraints(392, 373, 100, 28)); this.getContentPane().add(jLabel3, new XYConstraints(27, 61, 50, 27)); this.getContentPane().add(jButtonReset, new XYConstraints(155, 372, 94, 26)); this.getContentPane().add(jTextkuanxing, new XYConstraints(109, 18, 77, -1)); this.getContentPane().add(jButtonAdd, new XYConstraints(278, 373, 92, 29)); this.getContentPane().add(jLabel15, new XYConstraints(26, 114, 82, 32)); this.getContentPane().add(jTextcomment, new XYConstraints(107, 114, 452, 28)); this.getContentPane().add(jCombocolor, new XYConstraints(106, 63, 78, 27)); this.getContentPane().add(jLabel2, new XYConstraints(328, 12, 91, 25)); this.getContentPane().add(jLabel7, new XYConstraints(327, 59, 90, 26)); this.getContentPane().add(jTextoperator, new XYConstraints(426, 62, 89, 25)); }void reSetAllTextbox(){ jTextkuanxing.setText(""); jTextdate.setText(""); jTextcomment.setText(""); jCombocolor.setSelectedIndex(0); jTextoperator.setText(""); jText42.setText("0"); jText43.setText("0"); jText44.setText("0"); jText41.setText("0"); jText40.setText("0"); jText39.setText("0"); jText36.setText("0"); jText37.setText("0"); jText38.setText("0"); } void jButtonCancel_mouseClicked(MouseEvent e) { dispose(); }//添加操作 void jButtonAdd_mouseClicked(MouseEvent e) { //判斷款型和顏色是否全部為空，若為空的彈出警告信息 if(jTextkuanxing.getText().trim().equals("")&&jTextkuanxing.getText().trim().equals("")) { JOptionPane.showMessageDialog(null," 款型和顏色不許全部為空!"); return; } String sql; sql="select * from ProductStore "; sql=sql+" where Model='"+jTextkuanxing.getText().trim()+"'"; sql=sql+" and Color='"+jCombocolor.getSelectedItem().toString().trim() +"'"; rs =db.getResult(sql); try { //如果已存在，則將原數據庫中的數目減去新減去的數目并執行更新操作 if (rs.first() ) { sql = "update ProductStore set Number36= Number36-" +jText36.getText().trim()+","; sql = sql + " Number37=Number37-" + jText37.getText().trim() + ","; sql = sql + " Number38=Number38-" + jText38.getText().trim() + ","; sql = sql + " Number39=Number39-" + jText39.getText().trim() + ","; sql = sql + " Number40=Number40-" + jText40.getText().trim() +","; sql = sql + " Number41=Number41-" + jText41.getText().trim() +","; sql = sql + " Number42=Number42-" + jText42.getText().trim() +","; sql = sql + " Number43=Number43-" + jText43.getText().trim() +","; sql = sql + " Number44=Number44-" + jText44.getText().trim() +""; sql = sql + " where Model='" + jTextkuanxing.getText().trim() + "'"; sql = sql + " and Color ='" + jCombocolor.getSelectedItem().toString().trim() + "'"; } //若不存在返回 else { JOptionPane.showMessageDialog(null,"產品數據庫中無此商品信息！"); return; } } catch (SQLException ex) { JOptionPane.showMessageDialog(null,"操作失敗！"); }//執行數據操作 if(db.executeSql(sql)) {//若成功則清空文本框 //reSetAllTextbox(); JOptionPane.showMessageDialog(null,"操作成功！");} else { JOptionPane.showMessageDialog(null,"操作失敗！");} //當然對于產品出庫信息表始終是插入新值 sql = "insert into ProductOut (Model,Color,Dateout,Operator, Comment,Number36,Number37,Number38,Number39,Number40,Number41,Number42,Number43,Number44)values( "; sql = sql + "'" + jTextkuanxing.getText() + "',"; sql = sql + "'" + jCombocolor.getSelectedItem().toString() + "',"; sql = sql + "'" + jTextdate.getText() + "',"; //date sql = sql + "'" + jTextoperator.getText() + "',"; sql = sql + "'" + jTextcomment.getText() + "',"; sql = sql + "" + jText36.getText() + ","; sql = sql + "" + jText37.getText() + ","; sql = sql + "" + jText38.getText() + ","; sql = sql + "" + jText39.getText() + ","; sql = sql + "" + jText40.getText() + ","; sql = sql + "" + jText41.getText() + ","; sql = sql + "" + jText42.getText() + ","; sql = sql + "" + jText43.getText() + ","; sql = sql + "" + jText44.getText() + ""; sql = sql + ")"; //使用DBManager對象執行操作 ，并返回成功或失敗信息 if(db.executeSql(sql)){ //執行操作后清空文本框 reSetAllTextbox(); JOptionPane.showMessageDialog(null,"操作成功！"); } else { JOptionPane.showMessageDialog(null,"操作失敗 !"); } }//清空按鈕，清空文本框 void jButtonReset_mouseClicked(MouseEvent e) { reSetAllTextbox(); }}class FrameProductOut_jButtonCancel_mouseAdapter extends java.awt.event.MouseAdapter { FrameProductOut adaptee; FrameProductOut_jButtonCancel_mouseAdapter(FrameProductOut adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonCancel_mouseClicked(e); }}class FrameProductOut_jButtonAdd_mouseAdapter extends java.awt.event.MouseAdapter { FrameProductOut adaptee; FrameProductOut_jButtonAdd_mouseAdapter(FrameProductOut adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonAdd_mouseClicked(e); }}class FrameProductOut_jButtonReset_mouseAdapter extends java.awt.event.MouseAdapter { FrameProductOut adaptee; FrameProductOut_jButtonReset_mouseAdapter(FrameProductOut adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonReset_mouseClicked(e); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -