stocking.java

小型零售商店管理数据库管理

package retail;
import java.awt.GridLayout;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.sql.ResultSet;

import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;

  class Stocking extends JPanel implements MouseListener{
	
	JLabel lWare_ID=null;JLabel lware_Name=null;
	JLabel l_amount=null; JLabel l_price=null;
	JLabel l_unit=null; JLabel l_date=null;
	JLabel l_null1=null; JLabel l_null2=null;
	JLabel l_null3=null; JTextField wareID=null;
	JTextField wareName=null; JTextField i_amount=null;
	JTextField i_price=null;  JTextField i_unit=null;
	JTextField i_date=null; JButton b_query=null;
	JButton b_del=null; JButton b_update=null;
	JButton b_add=null; JButton b_next=null;
	ResultSet rst=null;
	
	Stocking(){
		lWare_ID=new JLabel("商品代码"); lware_Name=new JLabel("商品名称");
		l_amount=new JLabel("进货数量");l_price=new JLabel("进货价格");
		l_unit=new JLabel("包装单位");l_date=new JLabel("进货日期");
		l_null1=new JLabel(""); l_null2=new JLabel("");
		l_null3=new JLabel("");wareID=new JTextField(10);
		wareName=new JTextField(10);i_amount=new JTextField(6);
    	 i_price=new JTextField(6);i_unit=new JTextField(4);
    	 i_date=new JTextField(10);b_query=new JButton("查询");
    	 b_add=new JButton("增加"); b_del=new JButton("删除");
    	 b_update=new JButton("修改"); b_next=new JButton("下一条");
    	 setLayout(new GridLayout(4,5));
    	 add(lWare_ID);add(wareID);add(lware_Name);add(wareName);
    	 add(b_next); add(l_amount);add(i_amount);add(l_price);
    	 add(i_price); add(l_null1);add(l_unit);add(i_unit);
    	 add(l_date);add(i_date);add(l_null2);add(b_add);    	 
    	 add(b_query);add(b_del);add(b_update);
    	 
    	 b_query.addMouseListener(this);b_del.addMouseListener(this);
    	 b_update.addMouseListener(this);b_add.addMouseListener(this);
    	 b_next.addMouseListener(this);
     }
			
		
	 public void mouseClicked(MouseEvent e){
		 if(e.getSource()==b_query){
			 try{
				 rst=SqlDB.execQuery("select*from stocking_table where wares_ID='"
						 +wareID.getText().trim()+"'");
			 }catch(Exception ex){
				 
			 }
		 }
		 if(e.getSource()==b_add){
			 try{
				 SqlDB.execUpdate("insert into stocking_table values('"+
				wareID.getText().trim()+"','"+wareName.getText()+"','"+
				 Integer.parseInt(i_amount.getText().trim())+","+
				 Float.parseFloat(i_price.getText().trim())+",'"+
				 i_unit.getText().trim()+"','"+i_date.getText().trim()+"')");
			 }catch(Exception ex){
				 System.out.println(ex.getMessage());
			 }
		 }
		 else if(e.getSource()==b_update){
			 try{
				SqlDB.execUpdate("Update stocking_table Set i_amount='"
						+Integer.parseInt(i_amount.getText().trim())+
						"',i_price="+Float.parseFloat(i_price.getText().trim())
						+","
						+"units='"+i_unit.getText()+"',i_date='"+i_date.getText()
						+"where wares_ID='"+wareID.getText().trim()+"'") ;
			 }catch(Exception ex){
				 System.out.println(ex.getMessage());
			 }
		 }
		 else if(e.getSource()==b_del){
			 SqlDB.execUpdate("delete stocking_table"+"where wares_id='"
					 +wareID.getText().trim()+"'");
		 }
		 else if(e.getSource()==b_next){
			 try{
				 if(rst.next()){
					wareName.setText(rst.getString(2)) ;
					i_amount.setText(rst.getString(3));
					i_price.setText(rst.getString(4));
					i_unit.setText(rst.getString(5));
					i_date.setText(rst.getString(6));
				 }
			 }catch(Exception ex){
				 System.out.println(ex.getMessage());
			 }
			 finally{
				 SqlDB.closeDB();
			 }
		 }
	 }
	 public void mouseReleased(MouseEvent e){}
     public void mouseEntered(MouseEvent e){ }	    
     public void mousePressed(MouseEvent e){ }
     public void mouseExited(MouseEvent e){ }
}