frmgengxin.java~30~

在学校时做的第一个项目

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 java.sql.*;
import java.net.URL;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.util.Calendar;

/**
 * <p>Title: vegtable</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frmgengxin extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JLabel lblname = new JLabel();
    JTextField txtname = new JTextField();
    JLabel lblnum = new JLabel();
    JTextField txtnum = new JTextField();
    JLabel lblprice = new JLabel();
    JTextField txtprice = new JTextField();
    JLabel lbldw = new JLabel();
    JComboBox cbodw = new JComboBox();
    JLabel lblgonghuoshang = new JLabel();
    JComboBox cbogonghuoshang = new JComboBox();
    JLabel lbltime = new JLabel();
    JTextField txttime = new JTextField();
    JButton btngengxin = new JButton();
    JButton btnagain = new JButton();
    JButton btnback = new JButton();
    JOptionPane jOptionPane1 = new JOptionPane();
    JLabel lbldanw = new JLabel();
    JLabel lblimg = new JLabel();

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(650,600);
        this.setLocation(200,10);
        this.setTitle("商品更新管理");
        lblname.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblname.setText("商品名称");
        lblname.setBounds(new Rectangle(65, 210, 87, 32));
        txtnum.setBounds(new Rectangle(478, 215, 109, 29));
        lblnum.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblnum.setText("数量");
        lblnum.setBounds(new Rectangle(374, 215, 71, 29));
        lblprice.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbldw.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lblgonghuoshang.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        lbltime.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btngengxin.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btngengxin.addActionListener(new Frmgengxin_btngengxin_actionAdapter(this));
        btnagain.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnagain.addActionListener(new Frmgengxin_btnagain_actionAdapter(this));
        btnback.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        btnback.addActionListener(new Frmgengxin_btnback_actionAdapter(this));
        jOptionPane1.setBounds(new Rectangle(290, 241, 21, 17));
        btnback.setBounds(new Rectangle(435, 449, 141, 44));
        btnback.setText("返回到前一窗体");
        btnagain.setBounds(new Rectangle(253, 450, 156, 44));
        btnagain.setText("更新下一商品信息");
        btngengxin.setBounds(new Rectangle(71, 449, 155, 44));
        btngengxin.setText("更新商品数量");
        txttime.setBounds(new Rectangle(478, 355, 110, 30));
        txttime.addMouseListener(new Frmgengxin_txttime_mouseAdapter(this));
        txttime.addActionListener(new Frmgengxin_txttime_actionAdapter(this));
        lbltime.setText("进货时间");
        lbltime.setBounds(new Rectangle(381, 354, 81, 30));
        cbogonghuoshang.setBackground(Color.orange);
        cbogonghuoshang.setBounds(new Rectangle(164, 358, 135, 31));
        this.additemcbo();
        lblgonghuoshang.setText("供货商");
        lblgonghuoshang.setBounds(new Rectangle(65, 357, 85, 35));
        cbodw.setBackground(Color.orange);
        cbodw.setBounds(new Rectangle(478, 287, 109, 31));
        lbldw.setText("单位");
        lbldw.setBounds(new Rectangle(381, 286, 80, 32));
        txtprice.setBounds(new Rectangle(165, 285, 120, 33));
        txtprice.addMouseListener(new Frmgengxin_txtprice_mouseAdapter(this));
        lblprice.setText("价格");
        lblprice.setBounds(new Rectangle(65, 287, 85, 31));
        this.cbodw.addItem("--请选择单位--");
        this.cbodw.addItem("筐");
        this.cbodw.addItem("公斤");
        this.cbodw.addItem("斤");
        lbldanw.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        lbldanw.setText("元/斤");
        lbldanw.setBounds(new Rectangle(288, 287, 51, 29));
        lblimg.setBounds(new Rectangle(85, 42, 476, 93));

        this.getContentPane().add(jOptionPane1);
        this.getContentPane().add(txttime);
        this.getContentPane().add(lbltime);
        this.getContentPane().add(cbodw);
        this.getContentPane().add(lbldw);
        this.getContentPane().add(txtnum);
        this.getContentPane().add(lblnum);
        this.getContentPane().add(cbogonghuoshang);
        this.getContentPane().add(txtprice);
        this.getContentPane().add(txtname);
        this.getContentPane().add(lbldanw);
        this.getContentPane().add(lblimg);
        this.getContentPane().add(btnback);
        this.getContentPane().add(btnagain);
        this.getContentPane().add(btngengxin);
        this.getContentPane().add(lblprice);
        this.getContentPane().add(lblname);
        this.getContentPane().add(lblgonghuoshang);
        txtname.setBounds(new Rectangle(165, 212, 121, 32));
        URL u=this.getClass().getResource("条幅1.jpg");
        this.lblimg.setIcon(new ImageIcon(u));
    }

    public void additemcbo()
   {
   try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   } catch (ClassNotFoundException ex) {
   }
  try {
      Connection con = java.sql.DriverManager.getConnection("jdbc:odbc:veg");
      Statement s=con.createStatement();
      ResultSet rs=s.executeQuery("select 联系人 from 客户信息表");
      while(rs.next())
      {
         this.cbogonghuoshang.addItem(rs.getString(1));
      }
  } catch (SQLException ex1) {
  }

   }

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

    public void btnagain_actionPerformed(ActionEvent e) {
        this.txtname.setText("");
        this.txtnum.setText("");
        this.txtprice.setText("");
        this.txttime.setText("");
    }

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

    public void btngengxin_actionPerformed(ActionEvent e) {
        //判断下拉列表框中的信息是否选中
        String i=null;
        if(this.cbodw.getSelectedItem().equals("筐"))
        {
            i="筐";
        }
        else if(this.cbodw.getSelectedItem().equals("公斤"))
        {
            i="公斤";
        }
        else
        {
            i="斤";
        }
        String u=null;
        if(this.cbogonghuoshang.getSelectedItem().equals("张三"))
        {
            u="张三";
        }
        else if(this.cbogonghuoshang.getSelectedItem().equals("李四"))
        {
            u="李四";
        }
        else if(this.cbogonghuoshang.getSelectedItem().equals("赵武"))
        {
            u="赵武";
        }
        else
        {
            u="李阳";
        }
        if(this.txtname.getText().equals(""))
        {
            this.jOptionPane1.showMessageDialog(this,"商品名不能为空，请输入！");
        }else
        {
            //建立桥连接
        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("update 入库表 set 数量=数量+'"+this.txtnum.getText()+"',价格='"+this.txtprice.getText()+"',单位='"+i+"',供货商='"+u+"',进货时间='"+this.txttime.getText()+"' where 商品名称='"+this.txtname.getText()+"' " );
            if(num>0)
            {
                this.jOptionPane1.showMessageDialog(this,"更新信息成功！");
            }
            //关闭所有连接
            con.close();
            s.close();
        } catch (SQLException ex1) {
        }
       }
    }

    public void txttime_actionPerformed(ActionEvent e) {

    }

    public void txttime_mouseClicked(MouseEvent e) {
        Calendar cal;
        cal=Calendar.getInstance();
        txttime.setText(cal.get(Calendar.YEAR)+"-"+(cal.get(Calendar.MONTH)+1)+"-"+cal.get(Calendar.DATE));

    }

    public void txtprice_mouseClicked(MouseEvent 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();
                ResultSet rs=s.executeQuery("select 价格 from 入库表 where 商品名称='"+this.txtname.getText()+"'");
                if(rs.next())
                {
                 String  u= rs.getString(1);
                 this.txtprice.setText(u);
                }
            } catch (SQLException ex1) {
            }

    }
}


class Frmgengxin_txtprice_mouseAdapter extends MouseAdapter {
    private Frmgengxin adaptee;
    Frmgengxin_txtprice_mouseAdapter(Frmgengxin adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.txtprice_mouseClicked(e);
    }
}


class Frmgengxin_txttime_mouseAdapter extends MouseAdapter {
    private Frmgengxin adaptee;
    Frmgengxin_txttime_mouseAdapter(Frmgengxin adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.txttime_mouseClicked(e);
    }
}


class Frmgengxin_txttime_actionAdapter implements ActionListener {
    private Frmgengxin adaptee;
    Frmgengxin_txttime_actionAdapter(Frmgengxin adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmgengxin_btngengxin_actionAdapter implements ActionListener {
    private Frmgengxin adaptee;
    Frmgengxin_btngengxin_actionAdapter(Frmgengxin adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmgengxin_btnback_actionAdapter implements ActionListener {
    private Frmgengxin adaptee;
    Frmgengxin_btnback_actionAdapter(Frmgengxin adaptee) {
        this.adaptee = adaptee;
    }

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


class Frmgengxin_btnagain_actionAdapter implements ActionListener {
    private Frmgengxin adaptee;
    Frmgengxin_btnagain_actionAdapter(Frmgengxin adaptee) {
        this.adaptee = adaptee;
    }

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