frmveg3.java~16~

在学校时做的第一个项目

package vegtable;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
//导入所需包
import java.sql.*;
import javax.swing.JOptionPane;

/**
 * <p>Title: vegtable</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author 任炳林
 * @version 1.0
 */
public class Frmveg3 extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JLabel lblname = new JLabel();
    JTextField txtname = new JTextField();
    JLabel lblprice = new JLabel();
    JTextField txtprice = new JTextField();
    JLabel lblnum = new JLabel();
    JTextField txtnum = new JTextField();
    JLabel lblpfprice = new JLabel();
    JTextField txtpfprice = new JTextField();
    JLabel lbltime = new JLabel();
    JTextField txttime = new JTextField();
    JButton btnadd = new JButton();
    JButton btndelete = new JButton();
    JButton btnback = new JButton();
    JOptionPane jOptionPane1 = new JOptionPane();
    JLabel lblnum1 = new JLabel();
    JLabel lblprice1 = new JLabel();
    JLabel lblpfprice1 = new JLabel();
    JButton btnback1 = new JButton();

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(500,450);
        this.setLocation(200,150);
        this.setTitle("后台管理信息处理界面");
        lblname.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblname.setText("蔬菜名称");
        lblname.setBounds(new Rectangle(24, 55, 74, 33));
        txttime.setBounds(new Rectangle(97, 159, 90, 34));
        lbltime.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbltime.setText("进货时间");
        lbltime.setBounds(new Rectangle(24, 161, 72, 35));
        txtpfprice.setBounds(new Rectangle(300, 138, 103, 29));
        lblpfprice.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblpfprice.setText("批发价");
        lblpfprice.setBounds(new Rectangle(241, 142, 69, 30));
        txtnum.setBounds(new Rectangle(97, 112, 91, 30));
        lblnum.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblnum.setText("数量");
        lblnum.setBounds(new Rectangle(24, 111, 73, 31));
        txtprice.setBounds(new Rectangle(300, 81, 104, 32));
        lblprice.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblprice.setText("售价");
        lblprice.setBounds(new Rectangle(251, 85, 70, 31));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnback.addActionListener(new Frmveg3_btnback_actionAdapter(this));
        btndelete.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btndelete.addActionListener(new Frmveg3_btndelete_actionAdapter(this));
        btnadd.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnadd.addActionListener(new Frmveg3_btnadd_actionAdapter(this));
        jOptionPane1.setBounds(new Rectangle(239, 284, 11, 13));
        btnback.setBounds(new Rectangle(78, 309, 93, 28));
        btnback.setText("返回");
        btndelete.setBounds(new Rectangle(286, 249, 99, 30));
        btndelete.setText("删除");
        btnadd.setBounds(new Rectangle(77, 248, 93, 31));
        btnadd.setText("增加");
        lblnum1.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblnum1.setText("公斤");
        lblnum1.setBounds(new Rectangle(197, 113, 53, 29));
        lblprice1.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblprice1.setText("元/斤");
        lblprice1.setBounds(new Rectangle(416, 81, 62, 31));
        lblpfprice1.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblpfprice1.setText("元/斤");
        lblpfprice1.setBounds(new Rectangle(408, 236, 65, 29));
        btnback1.setBounds(new Rectangle(286, 308, 99, 27));
        btnback1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnback1.setText("返回前台");
        btnback1.addActionListener(new Frmveg3_btnback1_actionAdapter(this));
        this.getContentPane().add(jOptionPane1);
        this.getContentPane().add(lblpfprice1);
        this.getContentPane().add(txtname);
        this.getContentPane().add(lblname);
        this.getContentPane().add(txtnum);
        this.getContentPane().add(lblnum);
        this.getContentPane().add(lblnum1);
        this.getContentPane().add(lbltime);
        this.getContentPane().add(txttime);
        this.getContentPane().add(lblprice);
        this.getContentPane().add(txtprice);
        this.getContentPane().add(lblprice1);
        this.getContentPane().add(lblpfprice);
        this.getContentPane().add(txtpfprice);
        this.getContentPane().add(btnadd);
        this.getContentPane().add(btndelete);
        this.getContentPane().add(btnback);
        this.getContentPane().add(btnback1);
        txtname.setBounds(new Rectangle(97, 55, 92, 32));
    }

    public static void main(String[] args) {
        Frmveg3 frmveg3 = new Frmveg3();
        frmveg3.setVisible(true);
    }
    //单击返回按钮来弹出另一窗体
    public void btnback_actionPerformed(ActionEvent e) {
        Frmveg2 frmveg2=new Frmveg2();
        frmveg2.setVisible(true);
        this.setVisible(false);
    }

    public void btnadd_actionPerformed(ActionEvent e) {
        if(this.txtname.getText().equals(""))
        {
            this.jOptionPane1.showMessageDialog(this,"菜名不能为空！");
        }
        else{
        //建立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();
            int num=s.executeUpdate("insert into vegtable values('"+this.txtname.getText()+"','"+this.txtnum.getText()+"','"+this.txtprice.getText()+"','"+this.txtpfprice.getText()+"','"+this.txttime.getText()+"')");
            if(num>0)
            {
                this.jOptionPane1.showMessageDialog(this,"增加成功！");
            }
            //关闭所有连接
            con.close();
            s.close();
        } catch (SQLException ex1) {
        }
        }
    }

    public void btndelete_actionPerformed(ActionEvent e) {
        if(this.txtname.getText().equals(""))
        {
            this.jOptionPane1.showMessageDialog(this,"菜名不能为空！");
        }
        else{
        //建立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();
            int num=s.executeUpdate("delete from vegtable where vegname='"+this.txtname.getText()+"'");
            if(num>0)
            {
                this.jOptionPane1.showMessageDialog(this,"删除成功！");
            }
            con.close();
            s.close();
        } catch (SQLException ex1) {
        }
        }
    }
    //单击返回前台按钮弹出前台管理界面
    public void btnback1_actionPerformed(ActionEvent e) {
        Frmveg frmveg=new Frmveg();
        frmveg.setVisible(true);
        this.setVisible(false);
    }
}


class Frmveg3_btnback1_actionAdapter implements ActionListener {
    private Frmveg3 adaptee;
    Frmveg3_btnback1_actionAdapter(Frmveg3 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmveg3_btndelete_actionAdapter implements ActionListener {
    private Frmveg3 adaptee;
    Frmveg3_btndelete_actionAdapter(Frmveg3 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmveg3_btnadd_actionAdapter implements ActionListener {
    private Frmveg3 adaptee;
    Frmveg3_btnadd_actionAdapter(Frmveg3 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmveg3_btnback_actionAdapter implements ActionListener {
    private Frmveg3 adaptee;
    Frmveg3_btnback_actionAdapter(Frmveg3 adaptee) {
        this.adaptee = adaptee;
    }

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