frmkehu.java

在学校时做的第一个项目

package vegtable;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.BorderFactory;
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 not attributable
 * @version 1.0
 */
public class Frmkehu extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JLabel lbllixiren = new JLabel();
    JTextField txtlianxiren = new JTextField();
    JLabel lblghname = new JLabel();
    JTextField txtghname = new JTextField();
    JLabel lbltel = new JLabel();
    JTextField txttel = new JTextField();
    JLabel lbltype = new JLabel();
    JComboBox cbotype = new JComboBox();
    JButton btnadd = new JButton();
    JButton btndelete = new JButton();
    JOptionPane jOptionPane1 = new JOptionPane();
    JButton btnnew = new JButton();
    JButton btnback = new JButton();
    JPanel jPanel1 = new JPanel();
    JTextField txtname = new JTextField();
    JLabel lbllxr = new JLabel();
    public Frmkehu() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(650,330);
        this.setLocation(200,10);
        this.setTitle("客户信息管理");
        lbllixiren.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbllixiren.setText("联系人");
        lbllixiren.setBounds(new Rectangle(72, 47, 83, 33));
        lbltype.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbltype.setText("类型");
        lbltype.setBounds(new Rectangle(72, 216, 79, 31));
        txttel.setBounds(new Rectangle(170, 160, 128, 31));
        lbltel.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbltel.setText("联系电话");
        lbltel.setBounds(new Rectangle(72, 157, 78, 32));
        txtghname.setBounds(new Rectangle(171, 103, 128, 31));
        lblghname.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblghname.setText("供货商名称");
        lblghname.setBounds(new Rectangle(72, 103, 80, 31));
        cbotype.setBackground(Color.orange);
        cbotype.setBounds(new Rectangle(169, 217, 128, 31));
        btnadd.setBounds(new Rectangle(414, 41, 143, 38));
        btnadd.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnadd.setText("提交客户信息");
        btnadd.addActionListener(new Frmkehu_btnadd_actionAdapter(this));
        btndelete.setBounds(new Rectangle(415, 173, 143, 37));
        btndelete.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btndelete.setText("删除客户信息");
        btndelete.addActionListener(new Frmkehu_btndelete_actionAdapter(this));
        this.cbotype.addItem("--请选择类型--");
        this.cbotype.addItem("普通客户");
        this.cbotype.addItem("供货商");
        this.cbotype.addItem("供货商或普通客户");
        jOptionPane1.setBounds(new Rectangle(318, 131, 12, 16));
        btnnew.setBounds(new Rectangle(416, 93, 142, 37));
        btnnew.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnnew.setText("重新填写信息");
        btnnew.addActionListener(new Frmkehu_btnnew_actionAdapter(this));
        btnback.setBounds(new Rectangle(414, 216, 143, 34));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnback.setText("返回到前一窗体");
        btnback.addActionListener(new Frmkehu_btnback_actionAdapter(this));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(42, 26, 559, 243));
        txtname.setBounds(new Rectangle(415, 135, 142, 30));
        lbllxr.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lbllxr.setForeground(Color.red);
        lbllxr.setText("请输入姓名");
        lbllxr.setBounds(new Rectangle(336, 135, 77, 30));
        this.getContentPane().add(lbllixiren);
        this.getContentPane().add(lblghname);
        this.getContentPane().add(lbltel);
        this.getContentPane().add(lbltype);
        this.getContentPane().add(cbotype);
        this.getContentPane().add(txttel);
        this.getContentPane().add(txtghname);
        this.getContentPane().add(txtlianxiren);
        this.getContentPane().add(jOptionPane1);
        this.getContentPane().add(btnadd);
        this.getContentPane().add(txtname);
        this.getContentPane().add(btndelete);
        this.getContentPane().add(btnback);
        this.getContentPane().add(btnnew);
        this.getContentPane().add(lbllxr);
        this.getContentPane().add(jPanel1);
        txtlianxiren.setBounds(new Rectangle(171, 48, 128, 32));
    }

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

    public void btnadd_actionPerformed(ActionEvent e) {
        String i=null;
        if(this.cbotype.getSelectedItem().equals("普通客户"))
        {
            i="普通用户";
        }
        else if(this.cbotype.getSelectedItem().equals("供货商"))
        {
            i="供货商";
        }
        else
        {
            i="供货商或普通客户";
        }
        //建立桥连接
        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.txtlianxiren.getText()+"','"+this.txtghname.getText()+"','"+i+"','"+this.txttel.getText()+"')");
            if(num>0)
            {
                this.jOptionPane1.showMessageDialog(this,"提交信息成功！");
            }
            //关闭所有连接
            con.close();
            s.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 btncheck_actionPerformed(ActionEvent e) {

    }

    public void btnnew_actionPerformed(ActionEvent e) {
        this.txtlianxiren.setText("");
        this.txtghname.setText("");
        this.txttel.setText("");
    }

    public void btnback_actionPerformed(ActionEvent e) {
        Frmveg frmveg=new Frmveg();
        frmveg.setVisible(true);
        this.setVisible(false);
    }
}


class Frmkehu_btnback_actionAdapter implements ActionListener {
    private Frmkehu adaptee;
    Frmkehu_btnback_actionAdapter(Frmkehu adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmkehu_btnnew_actionAdapter implements ActionListener {
    private Frmkehu adaptee;
    Frmkehu_btnnew_actionAdapter(Frmkehu adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmkehu_btndelete_actionAdapter implements ActionListener {
    private Frmkehu adaptee;
    Frmkehu_btndelete_actionAdapter(Frmkehu adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmkehu_btnadd_actionAdapter implements ActionListener {
    private Frmkehu adaptee;
    Frmkehu_btnadd_actionAdapter(Frmkehu adaptee) {
        this.adaptee = adaptee;
    }

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