sales.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 Sales 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;JTextField wareID=null;
	 JTextField wareName=null;JTextField o_amount=null;
	 JTextField o_price=null; JTextField o_unit=null;	
	 JTextField o_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;
	 Sales(){
		 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("");
		 wareID=new JTextField(10);wareName=new JTextField(10);
		 o_amount=new JTextField(6);o_price=new JTextField(8);
		 o_unit=new JTextField(8);o_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(o_amount);add(l_price);
		 add(o_price);add(l_null1);add(l_unit);add(o_unit);
		 add(l_date);add(o_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 sales_table where wares_ID='"
							+wareID.getText().trim()+"'");
			 }catch(Exception ex){
				 System.out.println(ex.getMessage());
			 }
		 }
		 else if(e.getSource()==b_add){
			 try{
				    SqlDB.execUpdate("insert into sales_table values('"+
			    	wareID.getText().trim()+"','"+wareName.getText()+"','"+
					Integer.parseInt(o_amount.getText().trim())+","+
					Float.parseFloat(o_price.getText().trim())+",'"+
					o_unit.getText().trim()+"','"+o_date.getText().trim()+"')");
			 }catch(Exception ex){
				 System.out.println(ex.getMessage());
			 }
		 }
		 else if(e.getSource()==b_update){
			 try{
				SqlDB.execUpdate("Update sales_table Set o_amount="
						+Integer.parseInt(o_amount.getText().trim())+
						",o_price="+Float.parseFloat(o_price.getText().trim())
						+",	units='"+o_unit.getText()+"',o_date='"+o_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 sales_table"+"where wares_id='"
					 +wareID.getText().trim()+"'");
		 }
		 else if(e.getSource()==b_next){
			 try{
				 if(rst.next()){
					wareName.setText(rst.getString(2)) ;
					o_amount.setText(rst.getString(3));
					o_price.setText(rst.getString(4));
					o_unit.setText(rst.getString(5));
					o_date.setText(rst.getString(6));
				 }
			 }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){}
}