storing.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;

public class Storing extends JPanel implements MouseListener{
	JLabel lWare_ID=null;JLabel lware_Name=null;
	JLabel l_amount=null; 	JLabel l_unit=null; 
	JLabel l_date=null;	JLabel l_null1=null;
	JLabel l_null2=null; 	JLabel l_null3=null; 
	JLabel l_null4=null; JTextField wareID=null;
	JTextField wareName=null; JTextField s_amount=null;
	JTextField s_unit=null;	JTextField s_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;
	public Storing(){
		lWare_ID=new JLabel("商品代码"); lware_Name=new JLabel("商品名称");
		l_amount=new JLabel("库存数量");l_unit=new JLabel("包装单位");
		l_date=new JLabel("盘点日期");l_null1=new JLabel("");
		l_null2=new JLabel("");l_null3=new JLabel("");
		l_null4=new JLabel("");wareID=new JTextField(10);
		wareName=new JTextField(10);s_amount=new JTextField(6);
		s_unit=new JTextField(6);s_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,4));
		add(lWare_ID);add(wareID);add(lware_Name);add(wareName);
		add(b_next); add(l_amount);add(s_amount);add(l_unit);
		add(s_unit);add(l_null1);add(l_date);add(s_date);
		add(l_null2);add(l_null3);add(l_null4);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 storage_table where wares_ID='"
						+wareID.getText().trim()+"'");
			}catch(Exception ex){
				System.out.println(ex.getMessage());
			}
		}
		else if(e.getSource()==b_add){
			try{
				SqlDB.execQuery("insert into storage_table values ('"
						+wareID.getText().trim()+"','"+wareName.getText()+
						"',"+Integer.parseInt(s_amount.getText().trim())
						+",'"+s_unit.getText().trim()+"','"+
						s_date.getText().trim()+"')");
			}catch(Exception ex){
				System.out.println(ex.getMessage());
			}
		}
		else if(e.getSource()==b_update){
			 try{
					SqlDB.execUpdate("Update stocking_table Set s_amount='"
							+Integer.parseInt(s_amount.getText().trim())
							+", units='"+s_unit.getText()+"',s_date='"+s_date.getText().trim()
							+"'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)) ;
					s_amount.setText(rst.getString(3));					
					s_unit.setText(rst.getString(4));
					s_date.setText(rst.getString(5));
				 }
			 }catch(Exception ex){
				 System.out.println(ex.getMessage());
			 }
			 
		}
	}
	public void mouseReleased(MouseEvent e){}
	public void mouseEntered(MouseEvent e){}
	public void mousePressed(MouseEvent e){}
	public void mouseExited(MouseEvent e){}
}