frmcheck1.java

在学校时做的第一个项目

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 javax.swing.table.DefaultTableModel;
import java.util.Vector;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;

/**
 * <p>Title: vegtable</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frmcheck1 extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JButton btncheck1 = new JButton();
    JButton btnback = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(520,500);
        this.setLocation(200,100);
        btncheck1.setBounds(new Rectangle(78, 423, 143, 33));
        btncheck1.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btncheck1.setText("销售表查询");
        btncheck1.addActionListener(new Frmcheck1_btncheck1_actionAdapter(this));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnback.addActionListener(new Frmcheck1_btnback_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(31, 38, 452, 353));
        this.getContentPane().add(btncheck1);
        this.getContentPane().add(btnback);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        btnback.setBounds(new Rectangle(290, 423, 138, 32));
        btnback.setText("返回主窗口");
    }

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

    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("单位");
           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));
               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);
    }
}


class Frmcheck1_btnback_actionAdapter implements ActionListener {
    private Frmcheck1 adaptee;
    Frmcheck1_btnback_actionAdapter(Frmcheck1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmcheck1_btncheck1_actionAdapter implements ActionListener {
    private Frmcheck1 adaptee;
    Frmcheck1_btncheck1_actionAdapter(Frmcheck1 adaptee) {
        this.adaptee = adaptee;
    }

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