frmveg2.java~13~

在学校时做的第一个项目

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;

/**
 * <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 btndelet = new JButton();
    JButton btnadd = new JButton();
    JButton btnback = new JButton();

    public Frmveg2() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(600,560);
        this.setLocation(200,15);
        this.setTitle("后台管理查询界面");
        jScrollPane1.setBounds(new Rectangle(32, 86, 533, 407));
        btncheck.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btncheck.addActionListener(new Frmveg2_btncheck_actionAdapter(this));
        btndelet.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btndelet.addActionListener(new Frmveg2_btndelet_actionAdapter(this));
        btnadd.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnadd.addActionListener(new Frmveg2_btnadd_actionAdapter(this));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnback.addActionListener(new Frmveg2_btnback_actionAdapter(this));
        btnback.setBounds(new Rectangle(441, 508, 95, 29));
        btnback.setText("返回");
        btnadd.setBounds(new Rectangle(435, 34, 84, 30));
        btnadd.setText("增加");
        btndelet.setBounds(new Rectangle(258, 32, 92, 32));
        btndelet.setText("删除");
        this.getContentPane().add(btncheck);
        this.getContentPane().add(btndelet);
        this.getContentPane().add(btnadd);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnback);
        jScrollPane1.getViewport().add(jTable1);
        btncheck.setBounds(new Rectangle(71, 32, 91, 33));
        btncheck.setText("查询");
    }

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

    public void btncheck_actionPerformed(ActionEvent e) {
        //建立JDBC——ODBC桥连接
        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("进货时间");
            Vector vb=new Vector();
            ResultSet rs=s.executeQuery("select *from vegtable");
            //循环录入列值
            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));
                vb.addElement(v);
            }
            javax.swing.table.DefaultTableModel model=new DefaultTableModel(vb,vh);//vb代表行,vh代表列
            this.jTable1.setModel(model);
            //关闭所有连接
            con.close();
            s.close();
            rs.close();
        } catch (SQLException ex1) {
        }
    }
    //单击返回弹出后台管理窗体
    public void btnback_actionPerformed(ActionEvent e) {
        Frmveg3 frmveg3=new Frmveg3();
        frmveg3.setVisible(true);
        this.setVisible(false);
    }
    //单击增加按钮弹出后台管理窗体
    public void btnadd_actionPerformed(ActionEvent e) {
        Frmveg3 frmveg3=new Frmveg3();
        frmveg3.setVisible(true);
        this.setVisible(false);
    }
    //单击删除按钮弹出后台管理窗体
    public void btndelet_actionPerformed(ActionEvent e) {
        Frmveg3 frmveg3=new Frmveg3();
        frmveg3.setVisible(true);
        this.setVisible(false);
    }
}


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

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


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

    public void actionPerformed(ActionEvent e) {
        adaptee.btnadd_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);
    }
}