frmveg2.java

在学校时做的第一个项目

package vegtable;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JScrollPane;
import java.awt.Rectangle;
import javax.swing.JTable;
import javax.swing.JButton;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
//导入所需的包
import java.sql.*;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import javax.swing.JTextField;
import javax.swing.JLabel;
import java.awt.Color;

/**
 * <p>Title: vegtable</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author 任炳林
 * @version 1.0
 */
public class Frmveg2 extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    JButton btncheck = new JButton();
    JButton btnback = new JButton();
    JTextField txtname = new JTextField();
    JButton btncheck1 = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel lblname = new JLabel();
    public Frmveg2() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(600,600);
        this.setLocation(200,15);
        this.setTitle("库存查询管理");
        jScrollPane1.setBounds(new Rectangle(32, 107, 533, 386));
        btncheck.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btncheck.addActionListener(new Frmveg2_btncheck_actionAdapter(this));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnback.addActionListener(new Frmveg2_btnback_actionAdapter(this));
        btnback.setBounds(new Rectangle(391, 508, 145, 33));
        btnback.setText("返回到主窗口");
        txtname.setBounds(new Rectangle(269, 64, 112, 36));
        btncheck1.setBounds(new Rectangle(70, 64, 149, 36));
        btncheck1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btncheck1.setText("查询单个商品信息");
        btncheck1.addActionListener(new Frmveg2_btncheck1_actionAdapter(this));
        jLabel1.setText("jLabel1");
        jLabel1.setBounds(new Rectangle( -56, 199, 42, 15));
        lblname.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblname.setForeground(Color.red);
        lblname.setText("请输入商品名");
        lblname.setBounds(new Rectangle(390, 65, 88, 35));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnback);
        this.getContentPane().add(btncheck);
        this.getContentPane().add(txtname);
        this.getContentPane().add(btncheck1);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(lblname);
        jScrollPane1.getViewport().add(jTable1);
        btncheck.setBounds(new Rectangle(70, 22, 148, 33));
        btncheck.setText("商品库存查询");
    }

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

    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 入库表");
           while(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 btnback_actionPerformed(ActionEvent e) {
         Frmveg frmveg=new Frmveg();
        frmveg.setVisible(true);
        this.setVisible(false);
    }

    public void btnadd_actionPerformed(ActionEvent e) {

    }

    public void btndelet_actionPerformed(ActionEvent e) {

    }

    public void jButton1_actionPerformed(ActionEvent e) {
       Frmgengxin frmgengxin=new Frmgengxin();
       frmgengxin.setVisible(true);
       this.setVisible(false);
    }

    public void btncheck1_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 入库表 where 商品名称='"+this.txtname.getText()+"'");
           while(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) {
        }

    }
}


class Frmveg2_btncheck1_actionAdapter implements ActionListener {
    private Frmveg2 adaptee;
    Frmveg2_btncheck1_actionAdapter(Frmveg2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmveg2_btnback_actionAdapter implements ActionListener {
    private Frmveg2 adaptee;
    Frmveg2_btnback_actionAdapter(Frmveg2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmveg2_btncheck_actionAdapter implements ActionListener {
    private Frmveg2 adaptee;
    Frmveg2_btncheck_actionAdapter(Frmveg2 adaptee) {
        this.adaptee = adaptee;
    }

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