frmcheck.java~8~

在学校时做的第一个项目

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;
import java.net.URL;

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

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(650,550);
        this.setLocation(100,10);
        btncheck.setBounds(new Rectangle(138, 93, 135, 38));
        btncheck.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btncheck.setText("查询客户信息");
        btncheck.addActionListener(new Frmcheck_btncheck_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(40, 150, 568, 327));
        btnback.setBounds(new Rectangle(377, 93, 143, 37));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnback.setText("返回主窗口");
        btnback.addActionListener(new Frmcheck_btnback_actionAdapter(this));
        lblimg.setBounds(new Rectangle( -2, 3, 651, 87));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btncheck);
        this.getContentPane().add(btnback);
        this.getContentPane().add(lblimg);

        jScrollPane1.getViewport().add(jTable1);
    }

    public static void main(String[] args) {
        Frmcheck frmcheck = new Frmcheck();
        frmcheck.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("联系电话");
            Vector vb=new Vector();
            ResultSet rs=s.executeQuery("select *from 客户信息表");
            while(rs.next())
            {
                Vector v=new Vector();
                v.addElement(rs.getString(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 Frmcheck_btnback_actionAdapter implements ActionListener {
    private Frmcheck adaptee;
    Frmcheck_btnback_actionAdapter(Frmcheck adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmcheck_btncheck_actionAdapter implements ActionListener {
    private Frmcheck adaptee;
    Frmcheck_btncheck_actionAdapter(Frmcheck adaptee) {
        this.adaptee = adaptee;
    }

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