frmjinhuo.java~13~

在学校时做的第一个项目

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();
    JScrollPane jScrollPane1 = new JScrollPane();
    JButton btnadd = new JButton();
    JButton btndelete = new JButton();
    JButton btncheck = new JButton();
    JButton btnback = new JButton();
    JTable jTable1 = new JTable();
    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(880,600);
        this.setLocation(200,10);
        lblname.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblname.setText("商品名称");
        lblname.setBounds(new Rectangle(32, 44, 87, 32));
        cbodw.setBounds(new Rectangle(110, 160, 124, 29));
        lblnum.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblnum.setText("数量");
        lblnum.setBounds(new Rectangle(32, 104, 70, 29));
        txtnum.setBounds(new Rectangle(110, 104, 124, 29));
        lblgonghuoshang.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblgonghuoshang.setText("供货商");
        lblgonghuoshang.setBounds(new Rectangle(31, 271, 69, 30));
        cbogonghuoshang.setBounds(new Rectangle(110, 272, 124, 29));
        lbltime.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbltime.setText("进货时间");
        lbltime.setBounds(new Rectangle(32, 332, 78, 29));
        txttime.setBounds(new Rectangle(110, 333, 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(233, 214, 59, 29));
        lbldw.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbldw.setText("单位");
        lbldw.setBounds(new Rectangle(31, 160, 86, 30));
        txtprice.setBounds(new Rectangle(110, 213, 124, 30));
        lblprice.setText("价格");
        lblprice.setBounds(new Rectangle(32, 214, 71, 30));
        jScrollPane1.setBounds(new Rectangle(296, 27, 544, 520));
        btnadd.setBounds(new Rectangle(23, 386, 123, 36));
        btnadd.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnadd.setText("录入商品信息");
        btnadd.addActionListener(new Frmjinhuo_btnadd_actionAdapter(this));
        btndelete.setBounds(new Rectangle(23, 457, 123, 35));
        btndelete.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btndelete.setText("删除商品信息");
        btndelete.addActionListener(new Frmjinhuo_btndelete_actionAdapter(this));
        btncheck.setBounds(new Rectangle(161, 385, 128, 35));
        btncheck.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btncheck.setText("查询商品信息");
        btncheck.addActionListener(new Frmjinhuo_btncheck_actionAdapter(this));
        btnback.setBounds(new Rectangle(161, 457, 130, 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));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(15, 25, 279, 482));
        this.getContentPane().add(cbodw);
        this.cbodw.addItem("--请选择单位--");
        this.cbodw.addItem("筐");
        this.cbodw.addItem("公斤");
        this.cbodw.addItem("斤");
        this.getContentPane().add(txtnum);
        this.getContentPane().add(txtname);
        this.getContentPane().add(lbltime);
        this.getContentPane().add(lblnum);
        this.getContentPane().add(lblname);
        this.getContentPane().add(txttime);
        this.getContentPane().add(txtprice);
        this.getContentPane().add(cbogonghuoshang);
        this.cbogonghuoshang.addItem("--请选择供货商--");
        this.cbogonghuoshang.addItem("张三");
        this.cbogonghuoshang.addItem("李四");
        this.cbogonghuoshang.addItem("赵武");
        this.cbogonghuoshang.addItem("李阳");
        this.getContentPane().add(lblgonghuoshang);
        this.getContentPane().add(lblprice);
        this.getContentPane().add(lbldw);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        this.getContentPane().add(btncheck);
        this.getContentPane().add(btnadd);
        this.getContentPane().add(btndelete);
        this.getContentPane().add(btnback);
        this.getContentPane().add(lbldanwei);
        this.getContentPane().add(jOptionPane1);
        this.getContentPane().add(jPanel1);
        txtname.setBounds(new Rectangle(110, 44, 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()+"','"+this.txttime.getText()+"','"+u+"')");
            if(num>0)
            {
                this.jOptionPane1.showMessageDialog(this,"商品信息录入成功！");
            }
            con.close();
            s.close();
        } catch (SQLException ex1) {
        }
      }
    }

    public void btncheck_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();
            Vector vh=new Vector();
            vh.addElement("编号");
            vh.addElement("商品名称");
            vh.addElement("数量");
            vh.addElement("单位");
            vh.addElement("价格");
            vh.addElement("供货商");
            vh.addElement("进货时间");
            Vector vb=new Vector();
            ResultSet rs=s.executeQuery("select *from 入库表");
            if(rs.next())
            {
                Vector v=new Vector();
                v.addElement(rs.getInt(1));
                v.addElement(rs.getString(2));
                v.addElement(rs.getString(3));
                v.addElement(rs.getString(4));
                v.addElement(rs.getString(5));
                v.addElement(rs.getString(6));
                v.addElement(rs.getString(7));
                vb.addElement(v);
            }
            javax.swing.table.DefaultTableModel model=new DefaultTableModel(vb,vh);
            this.jTable1.setModel(model);
            con.close();
            s.close();
            rs.close();
        } catch (SQLException ex1) {
        }
    }

    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);
    }
}