frmjinhuo.java~22~

在学校时做的第一个项目

package vegtable;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.BorderFactory;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;

/**
 * <p>Title: vegtable</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frmjinhuo extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JLabel lblname = new JLabel();
    JTextField txtname = new JTextField();
    JLabel lblprice = new JLabel();
    JTextField txtprice = new JTextField();
    JLabel lbldw = new JLabel();
    JComboBox cbodw = new JComboBox();
    JLabel lblnum = new JLabel();
    JTextField txtnum = new JTextField();
    JLabel lblgonghuoshang = new JLabel();
    JComboBox cbogonghuoshang = new JComboBox();
    JLabel lbltime = new JLabel();
    JTextField txttime = new JTextField();
    JLabel lbldanwei = new JLabel();
    JButton btnadd = new JButton();
    JButton btndelete = new JButton();
    JButton btncheck = new JButton();
    JButton btnback = new JButton();
    JOptionPane jOptionPane1 = new JOptionPane();
    JPanel jPanel1 = new JPanel();
    public Frmjinhuo() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(650,500);
        this.setLocation(200,10);
        lblname.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblname.setText("商品名称");
        lblname.setBounds(new Rectangle(66, 48, 87, 32));
        cbodw.setBackground(Color.orange);
        cbodw.setBounds(new Rectangle(422, 121, 124, 29));
        lblnum.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblnum.setText("数量");
        lblnum.setBounds(new Rectangle(358, 49, 61, 29));
        txtnum.setBounds(new Rectangle(422, 48, 124, 29));
        lblgonghuoshang.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblgonghuoshang.setText("供货商");
        lblgonghuoshang.setBounds(new Rectangle(358, 194, 69, 30));
        cbogonghuoshang.setBackground(Color.orange);
        cbogonghuoshang.setBounds(new Rectangle(422, 194, 124, 29));
        lbltime.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbltime.setText("进货时间");
        lbltime.setBounds(new Rectangle(66, 195, 78, 29));
        txttime.setBounds(new Rectangle(146, 196, 124, 28));
        lblprice.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbldanwei.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbldanwei.setText("元/斤");
        lbldanwei.setBounds(new Rectangle(278, 121, 59, 29));
        lbldw.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbldw.setText("单位");
        lbldw.setBounds(new Rectangle(358, 123, 53, 30));
        txtprice.setBounds(new Rectangle(147, 120, 124, 30));
        lblprice.setText("价格");
        lblprice.setBounds(new Rectangle(66, 120, 71, 30));
        btnadd.setBounds(new Rectangle(125, 287, 123, 36));
        btnadd.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnadd.setText("录入商品信息");
        btnadd.addActionListener(new Frmjinhuo_btnadd_actionAdapter(this));
        btndelete.setBounds(new Rectangle(126, 363, 123, 35));
        btndelete.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btndelete.setText("删除商品信息");
        btndelete.addActionListener(new Frmjinhuo_btndelete_actionAdapter(this));
        btncheck.setBounds(new Rectangle(352, 286, 142, 35));
        btncheck.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btncheck.setText("录入下一条信息");
        btncheck.addActionListener(new Frmjinhuo_btncheck_actionAdapter(this));
        btnback.setBounds(new Rectangle(352, 363, 142, 34));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnback.setText("返回前一台界面");
        btnback.addActionListener(new Frmjinhuo_btnback_actionAdapter(this));
        jOptionPane1.setBounds(new Rectangle(83, 253, 18, 25));
        this.cbodw.addItem("--请选择单位--");
        this.cbodw.addItem("筐");
        this.cbodw.addItem("公斤");
        this.cbodw.addItem("斤");
        this.cbogonghuoshang.addItem("--请选择供货商--");
        this.cbogonghuoshang.addItem("张三");
        this.cbogonghuoshang.addItem("李四");
        this.cbogonghuoshang.addItem("赵武");
        this.cbogonghuoshang.addItem("李阳");
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(24, 27, 575, 415));
        this.getContentPane().add(jOptionPane1);
        this.getContentPane().add(txtnum);
        this.getContentPane().add(lblnum);
        this.getContentPane().add(cbodw);
        this.getContentPane().add(lbldw);
        this.getContentPane().add(lbldanwei);
        this.getContentPane().add(txtprice);
        this.getContentPane().add(lblprice);
        this.getContentPane().add(txtname);
        this.getContentPane().add(lblname);
        this.getContentPane().add(cbogonghuoshang);
        this.getContentPane().add(lblgonghuoshang);
        this.getContentPane().add(txttime);
        this.getContentPane().add(lbltime);
        this.getContentPane().add(btnadd);
        this.getContentPane().add(btndelete);
        this.getContentPane().add(btnback);
        this.getContentPane().add(btncheck);
        this.getContentPane().add(jPanel1);
        txtname.setBounds(new Rectangle(147, 47, 124, 31));
    }

    public static void main(String[] args) {
        Frmjinhuo frmjinhuo = new Frmjinhuo();
        frmjinhuo.setVisible(true);
    }

    public void btnadd_actionPerformed(ActionEvent e) {
        String i=null;
        if(this.cbodw.getSelectedItem().equals("筐"))
        {
            i="筐";
        }
        else if(this.cbodw.getSelectedItem().equals("公斤"))
        {
            i="公斤";
        }
        else
        {
            i="斤";
        }
        String u=null;
        if(this.cbogonghuoshang.getSelectedItem().equals("张三"))
        {
            u="张三";
        }
        else if(this.cbogonghuoshang.getSelectedItem().equals("李四"))
        {
            u="李四";
        }
        else if(this.cbogonghuoshang.getSelectedItem().equals("赵武"))
        {
            u="赵武";
        }
        else
        {
            u="李阳";
        }
        if(this.txtname.getText().equals(""))
        {
            this.jOptionPane1.showMessageDialog(this,"商品名不能为空，请输入！");
        }else{
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
        }
        try {
            Connection con = java.sql.DriverManager.getConnection(
                    "jdbc:odbc:veg");
            Statement s=con.createStatement();
            int num=s.executeUpdate("insert into 入库表 values('"+this.txtname.getText()+"','"+this.txtnum.getText()+"','"+i+"','"+this.txtprice.getText()+"','"+u+"','"+this.txttime.getText()+"')");
            if(num>0)
            {
                this.jOptionPane1.showMessageDialog(this,"商品信息录入成功！");
            }
            con.close();
            s.close();
        } catch (SQLException ex1) {
        }
      }
    }

    public void btncheck_actionPerformed(ActionEvent e) {
       this.txtname.setText("");
       this.txtnum.setText("");
       this.txtprice.setText("");
       this.txttime.setText("");
    }

    public void btndelete_actionPerformed(ActionEvent e) {
        //建立桥连接
        try {
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         } catch (ClassNotFoundException ex) {
         }
         //连接数据源
         try {
             Connection con = java.sql.DriverManager.getConnection(
                     "jdbc:odbc:veg");
             Statement s=con.createStatement();
             int num=s.executeUpdate("delete from 入库表 where 商品名称='"+this.txtname.getText()+"'");
             if(num>0)
             {
                 this.jOptionPane1.showMessageDialog(this,"商品信息删除成功！");
             }
             //关闭所有连接
             con.close();
             s.close();
         } catch (SQLException ex1) {
         }

    }

    public void btnback_actionPerformed(ActionEvent e) {
        Frmveg frmveg = new Frmveg();
        frmveg.setVisible(true);
        this.setVisible(false);
    }
}


class Frmjinhuo_btnback_actionAdapter implements ActionListener {
    private Frmjinhuo adaptee;
    Frmjinhuo_btnback_actionAdapter(Frmjinhuo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnback_actionPerformed(e);
    }
}


class Frmjinhuo_btndelete_actionAdapter implements ActionListener {
    private Frmjinhuo adaptee;
    Frmjinhuo_btndelete_actionAdapter(Frmjinhuo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btndelete_actionPerformed(e);
    }
}


class Frmjinhuo_btncheck_actionAdapter implements ActionListener {
    private Frmjinhuo adaptee;
    Frmjinhuo_btncheck_actionAdapter(Frmjinhuo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btncheck_actionPerformed(e);
    }
}


class Frmjinhuo_btnadd_actionAdapter implements ActionListener {
    private Frmjinhuo adaptee;
    Frmjinhuo_btnadd_actionAdapter(Frmjinhuo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnadd_actionPerformed(e);
    }
}