?? frameproductin.java
字號:
package Manager;
import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
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 FrameProductIn extends JFrame {
// 定義臨時結果的結果集
ResultSet rs;
//dbmanager
private DBManager db =new DBManager();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
XYLayout xYLayout1 = new XYLayout();
JPanel jPanel1 = new JPanel();
XYLayout xYLayout2 = new XYLayout();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jText37ee = new JLabel();
JLabel jLabel8 = new JLabel();
JLabel jLabel9 = new JLabel();
JLabel jLabel10 = new JLabel();
JLabel jLabel11 = new JLabel();
JLabel jLabel12 = new JLabel();
JLabel jLabel13 = new JLabel();
JLabel jLabel14 = new JLabel();
JTextField jText36 = new JTextField();
JTextField jText37 = new JTextField();
JTextField jText38 = new JTextField();
JTextField jText39 = new JTextField();
JTextField jText40 = new JTextField();
JTextField jText41 = new JTextField();
JTextField jText42 = new JTextField();
JTextField jText43 = new JTextField();
JTextField jText44 = new JTextField();
JTextField jTextkuanxing = new JTextField();
JTextField jTextdate = new JTextField();
JComboBox jCombocolor = new JComboBox();
JButton jButtonReset = new JButton();
JButton jButtonCancel = new JButton();
JLabel jLabel7 = new JLabel();
JLabel jLabel15 = new JLabel();
JTextField jTextoperator = new JTextField();
JTextField jTextcomment = new JTextField();
private JButton jButtonAdd = new JButton();
public FrameProductIn() {
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
FrameProductIn frameProductIn = new FrameProductIn();
}
private void jbInit() throws Exception {
jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel1.setText("款型");
this.setTitle("產品入庫");
this.getContentPane().setLayout(xYLayout1);
jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel2.setVerifyInputWhenFocusTarget(true);
jLabel2.setText("入庫日期");
jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel3.setText("顏色");
xYLayout1.setWidth(648);
xYLayout1.setHeight(427);
jPanel1.setBorder(BorderFactory.createLineBorder(Color.black));
jPanel1.setToolTipText("");
jPanel1.setLayout(xYLayout2);
jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel5.setText("信息明細");
jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel6.setText("36");
jText37ee.setFont(new java.awt.Font("Dialog", 0, 16));
jText37ee.setText("37");
jLabel8.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel8.setText("38");
jLabel9.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel9.setText("40");
jLabel10.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel10.setText("41");
jLabel11.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel11.setText("39");
jLabel12.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel12.setText("42");
jLabel13.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel13.setText("43");
jLabel14.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel14.setText("44");
jTextkuanxing.setText("");
jTextdate.setText("");
jText42.setText("0");
jText44.setText("0");
jText41.setText("0");
jText40.setText("0");
jText39.setText("0");
jText36.setText("0");
jText37.setText("0");
jText38.setText("0");
jButtonReset.setFont(new java.awt.Font("Dialog", 0, 16));
jButtonReset.setText("清空");
jButtonReset.addMouseListener(new FrameProductIn_jButtonReset_mouseAdapter(this));
jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16));
jButtonCancel.setText("取消");
jButtonCancel.addMouseListener(new FrameProductIn_jButtonCancel_mouseAdapter(this));
jLabel7.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel7.setText("操作員");
jLabel15.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel15.setText("備注");
jTextoperator.setText("");
jTextcomment.setText("");
jButtonAdd.setFont(new java.awt.Font("Dialog", 0, 16));
jButtonAdd.setText("添加");
jButtonAdd.addMouseListener(new FrameProductIn_jButtonAdd_mouseAdapter(this));
//jCombocolor中加入顏色的值
jCombocolor.addItem("");
jCombocolor.addItem("red");
jCombocolor.addItem("black");
jCombocolor.addItem("blue");
jText43.setText("0");
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(jLabel5, new XYConstraints(13, 178, 86, 22));
this.getContentPane().add(jPanel1, new XYConstraints(13, 206, 613, 161));
this.getContentPane().add(jButtonReset, new XYConstraints(168, 387, 94, 26));
this.getContentPane().add(jButtonCancel, new XYConstraints(405, 387, 100, 29));
this.getContentPane().add(jCombocolor, new XYConstraints(121, 78, 82, 24));
this.getContentPane().add(jTextdate, new XYConstraints(438, 28, 89, -1));
this.getContentPane().add(jLabel2, new XYConstraints(348, 24, 90, 31));
this.getContentPane().add(jTextcomment, new XYConstraints(120, 126, 490, 28));
this.getContentPane().add(jButtonAdd, new XYConstraints(282, 388, 96, 27));
this.getContentPane().add(jTextkuanxing, new XYConstraints(122, 33, 77, -1));
this.getContentPane().add(jLabel15, new XYConstraints(37, 124, 67, 32));
this.getContentPane().add(jLabel1, new XYConstraints(37, 24, 66, 32));
this.getContentPane().add(jLabel3, new XYConstraints(38, 76, 50, 27));
this.getContentPane().add(jLabel7, new XYConstraints(346, 74, 90, 26));
this.getContentPane().add(jTextoperator, new XYConstraints(439, 78, 89, 25));
}
void jButtonCancel_mouseClicked(MouseEvent e) {
this.dispose() ;
}
//可調用的清空文本框過程
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");
}
//在jButtonReset的mouseClicked事件中調用清空過程
void jButtonReset_mouseClicked(MouseEvent e) {
reSetAllTextbox();
}
void jButtonAdd_mouseClicked(MouseEvent e) {
//判斷款型和顏色是否為空，若有為空的彈出警告信息
if(jTextkuanxing.getText().trim().equals("")&&jTextkuanxing.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(null," 款型和顏色不許為空!");
return;
}
String sql;
//生成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 {
sql = "insert into ProductStore(Model,Color,Number36,Number37,Number38,Number39,Number40,Number41,Number42,Number43,Number44)values( ";
sql = sql + "'" + jTextkuanxing.getText() + "',";
sql = sql + "'" + jCombocolor.getSelectedItem().toString() + "',";
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 + ")";
}
}
catch (SQLException ex) {
}
//使用DBManager對象執行操作 ，并返回成功或失敗信息
if(db.executeSql(sql)){
JOptionPane.showMessageDialog(null,"操作成功！");
}
else
{
JOptionPane.showMessageDialog(null,"操作失敗 !");
}
//當然對于產品入庫信息表始終是插入新值
sql = "insert into ProductIn (Model,Color,Datein,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,"操作失敗 !");
}
}
}
class FrameProductIn_jButtonCancel_mouseAdapter extends java.awt.event.MouseAdapter {
FrameProductIn adaptee;
FrameProductIn_jButtonCancel_mouseAdapter(FrameProductIn adaptee) {
this.adaptee = adaptee;
}
public void mouseClicked(MouseEvent e) {
adaptee.jButtonCancel_mouseClicked(e);
}
}
class FrameProductIn_jButtonReset_mouseAdapter extends java.awt.event.MouseAdapter {
FrameProductIn adaptee;
FrameProductIn_jButtonReset_mouseAdapter(FrameProductIn adaptee) {
this.adaptee = adaptee;
}
public void mouseClicked(MouseEvent e) {
adaptee.jButtonReset_mouseClicked(e);
}
}
class FrameProductIn_jButtonAdd_mouseAdapter extends java.awt.event.MouseAdapter {
FrameProductIn adaptee;
FrameProductIn_jButtonAdd_mouseAdapter(FrameProductIn adaptee) {
this.adaptee = adaptee;
}
public void mouseClicked(MouseEvent e) {
adaptee.jButtonAdd_mouseClicked(e);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -