shangpingl.java

小中型超市的管理系统！ JAVA完整的源码！

	 */    
	private JButton getJButton() {
		if (jButton == null) {
			try {
				jButton = new JButton();
				jButton.setText("");  // Generated
				jButton.setPreferredSize(new java.awt.Dimension(50,20));  // Generated
				jButton.setIcon(new ImageIcon("./images/btn_select.jpg"));  // Generated
				jButton.addActionListener(new ShangpinGL_jButton(this));
					

					
				
				
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton;
	}
	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */    
	private JButton getJButton1() {
		if (jButton1 == null) {
			try {
				jButton1 = new JButton();
				jButton1.setText("");  // Generated
				jButton1.setIcon(new ImageIcon("./images/btn_del.jpg"));  // Generated
				jButton1.setPreferredSize(new java.awt.Dimension(65,28));  // Generated
				jButton1.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {  
						
						if(jTextField1.getText().trim().equals(""))return;
						int result=JOptionPane.showOptionDialog(null,"是否删除数据","系统提示",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE, null,new String[] {"是","否"},"否");
						
						if(result==JOptionPane.NO_OPTION||result==JOptionPane.CLOSED_OPTION)
							return;
						String sql="delete from tb_Shangpin where goodsID='"+jTextField1.getText().trim()+"'";
						JdbcAdapter jdbcadapter=new JdbcAdapter();
						if(jdbcadapter.Delet(sql)){
							jTextField1.setText("");
							jTextField2.setText("");
							jTextField3.setText("");
							jTextField4.setText("");
							jTextField5.setText("");
							jTextField6.setText("");
							buildTable();
							}
					   
				}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton1;
	}
	/**
	 * This method initializes jButton2	
	 * 	
	 * @return javax.swing.JButton	
	 */    
	private JButton getJButton2() {
		if (jButton2 == null) {
			try {
				jButton2 = new JButton();
				jButton2.setText("");  // Generated
				jButton2.setPreferredSize(new java.awt.Dimension(65,28));  // Generated
				jButton2.setIcon(new ImageIcon("./images/btn_add.jpg"));  // Generated
				jButton2.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {  
						if(jTextField1.getText().trim().equals(""))return;
						Obj_shangpin objshangpin=new Obj_shangpin();
						objshangpin.setgoodsID(jTextField1.getText().trim());
						objshangpin.setgoodsName(jTextField2.getText().trim());
						objshangpin.setgoodsPrice(jTextField3.getText().trim());
						objshangpin.setgoodsDanwei(jTextField4.getText().trim());
						objshangpin.setgoodsNumber(jTextField5.getText().trim());
						objshangpin.setgoodsKucun(jTextField6.getText().trim());
						JdbcAdapter jdbcadapter=new JdbcAdapter();
						if(jdbcadapter.InsertSP(objshangpin))
							{buildTable();}
						jTextField1.setText("");
						jTextField2.setText("");
						jTextField3.setText("");
						jTextField4.setText("");
						jTextField5.setText("");
						jTextField6.setText("");
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton2;
	}
	/**
	 * This method initializes jButton3	
	 * 	
	 * @return javax.swing.JButton	
	 */    
	private JButton getJButton3() {
		if (jButton3 == null) {
			try {
				jButton3 = new JButton();
				jButton3.setText("");  // Generated
				jButton3.setPreferredSize(new java.awt.Dimension(65,28));  // Generated
				jButton3.setIcon(new ImageIcon("./images/btn_edit.jpg"));  // Generated
				jButton3.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {   
						if(jTextField1.getText().trim().equals(""))return;
						Obj_shangpin objshangpin=new Obj_shangpin();
						objshangpin.setgoodsID(jTextField1.getText().trim());
						objshangpin.setgoodsName(jTextField2.getText().trim());
						objshangpin.setgoodsPrice(jTextField3.getText().trim());
						objshangpin.setgoodsDanwei(jTextField4.getText().trim());
						objshangpin.setgoodsNumber(jTextField5.getText().trim());
						objshangpin.setgoodsKucun(jTextField6.getText().trim());
						JdbcAdapter jdbcadapter=new JdbcAdapter();
						if(jdbcadapter.UpdateSP(objshangpin))
							{buildTable();}	
						jTextField1.setText("");
						jTextField2.setText("");
						jTextField3.setText("");
						jTextField4.setText("");
						jTextField5.setText("");
						jTextField6.setText("");
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton3;
	}
	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			try {
				jTextField1 = new JTextField();
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField1;
	}
	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			try {
				jTextField2 = new JTextField();
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField2;
	}
	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			try {
				jTextField3 = new JTextField();
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField3;
	}
	/**
	 * This method initializes jTextField4	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			try {
				jTextField4 = new JTextField();
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField4;
	}
	/**
	 * This method initializes jTextField5	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField5() {
		if (jTextField5 == null) {
			try {
				jTextField5 = new JTextField();
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField5;
	}
	/**
	 * This method initializes jTextField6	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField6() {
		if (jTextField6 == null) {
			try {
				jTextField6 = new JTextField();
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField6;
	}
	public void buildTable(){
		DefaultTableModel tablemodel=null;
		String[] name={"编号","名称","单价(元)","单位","货架号","库存","销量"};
		String sql="select * from tb_Shangpin order by goodsID asc";
		RetrieveObject bdt=new RetrieveObject();
		tablemodel=bdt.getTM(name,sql);
		jTable.setModel(tablemodel);
		
		}
	public void jButton_actionPerformed(java.awt.event.ActionEvent e) { 
	  
	  String   number=jTextField.getText().trim();   
	 if(number.equals(""))return;
	 if(number.matches("\\d*"))
     
	{
	 	string="select * from tb_Shangpin where goodsID='"+number+"'" ;
	}else
	{
		string="select * from tb_Shangpin where goodsName like '%"+number+"%'" ;
	}
	DefaultTableModel tablemodel=null;
	String[] name={"编号","名称","单价(元)","单位","货架号","库存","销量"};
	RetrieveObject bdt=new RetrieveObject();
	tablemodel=bdt.getTM(name,string);
	jTable.setModel(tablemodel);
	Vector vdata=null;
	RetrieveObject retrive=new RetrieveObject();
	vdata=retrive.getObjectRow(string);
	jTextField1.setText(vdata.get(0).toString());
	jTextField2.setText(vdata.get(1).toString());
	jTextField3.setText(vdata.get(2).toString());
	jTextField4.setText(vdata.get(3).toString());
	jTextField5.setText(vdata.get(4).toString());
	jTextField6.setText(vdata.get(5).toString());
	
}
                }
class ShangpinGL_jButton implements ActionListener{
	private ShangpinGL spgl;
	ShangpinGL_jButton(ShangpinGL spgl)
	{this.spgl=spgl;}
	public void actionPerformed(ActionEvent e) {
		spgl.jButton_actionPerformed(e);
	}
	}