xiaoshouls.java

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

/*
 * 创建日期 2008-3-18
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package appsm.view;

import javax.swing.JInternalFrame;
import javax.swing.JOptionPane;
import javax.swing.JSplitPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JButton;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import javax.swing.ImageIcon;
import javax.swing.table.DefaultTableModel;
import appsm.util.JdbcAdapter;
import appsm.util.RetrieveObject;
import javax.swing.JTextField;
import javax.swing.JLabel;
/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class XiaoshouLS extends JInternalFrame {

	private javax.swing.JPanel jContentPane = null;
	private JSplitPane jSplitPane = null;
	private JPanel jPanel = null;
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JButton jButton = null;
	private JButton jButton1 = null;
	private  String tm;
	private JTextField jTextField = null;
	private JLabel jLabel1 = null;
	private JButton jButton2 = null;
	private String string=null;
	private JLabel jLabel = null;
	/**
	 * This is the default constructor
	 */
	public XiaoshouLS() {
		super();
		initialize();
		buildTable();
	}
	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setFrameIcon(new ImageIcon("./images/ImageBar33.jpg"));  // Generated
		this.setTitle("");  // Generated
		this.setSize(609, 402);
		this.setContentPane(getJContentPane());
	}
	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private javax.swing.JPanel getJContentPane() {
		if(jContentPane == null) {
			jContentPane = new javax.swing.JPanel();
			jContentPane.setLayout(new java.awt.BorderLayout());
			jContentPane.add(getJSplitPane(), java.awt.BorderLayout.CENTER);  // Generated
		}
		return jContentPane;
	}
	/**
	 * This method initializes jSplitPane	
	 * 	
	 * @return javax.swing.JSplitPane	
	 */    
	private JSplitPane getJSplitPane() {
		if (jSplitPane == null) {
			try {
				jSplitPane = new JSplitPane();
				jSplitPane.setOrientation(javax.swing.JSplitPane.VERTICAL_SPLIT);  // Generated
				jSplitPane.setTopComponent(getJPanel());  // Generated
				jSplitPane.setBottomComponent(getJScrollPane());  // Generated
				jSplitPane.setDividerSize(3);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jSplitPane;
	}
	/**
	 * This method initializes jPanel	
	 * 	
	 * @return javax.swing.JPanel	
	 */    
	private JPanel getJPanel() {
		if (jPanel == null) {
			try {
				jLabel = new JLabel();
				jLabel1 = new JLabel();
				jPanel = new JPanel();
				jPanel.setLayout(new FlowLayout());  // Generated
				jPanel.setBackground(java.awt.SystemColor.inactiveCaptionText);  // Generated
				jPanel.setPreferredSize(new java.awt.Dimension(100,40));  // Generated
				jLabel1.setText("关键字");  // Generated
				jLabel1.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 12));  // Generated
				jLabel.setText("显示所有商品");  // Generated
				jLabel.setFont(new java.awt.Font("Dialog", java.awt.Font.PLAIN, 12));  // Generated
				jLabel.setForeground(java.awt.Color.blue);  // Generated
				jPanel.add(jLabel, null);  // Generated
				jPanel.add(jLabel1, null);  // Generated
				jPanel.add(getJTextField(), null);  // Generated
				jPanel.add(getJButton2(), null);  // Generated
				jPanel.add(getJButton(), null);  // Generated
				jPanel.add(getJButton1(), null);  // Generated
				jLabel.addMouseListener(new java.awt.event.MouseAdapter() { 
					public void mouseClicked(java.awt.event.MouseEvent e) {    
						buildTable();
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jPanel;
	}
	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */    
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			try {
				jScrollPane = new JScrollPane();
				jScrollPane.setViewportView(getJTable());  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jScrollPane;
	}
	/**
	 * This method initializes jTable	
	 * 	
	 * @return javax.swing.JTable	
	 */    
	private JTable getJTable() {
		if (jTable == null) {
			try {
				jTable = new JTable();
				jTable.addMouseListener(new java.awt.event.MouseAdapter() { 
					public void mouseClicked(java.awt.event.MouseEvent e) {    
						
						
						int selectrow=0;
						selectrow=jTable.getSelectedRow();
						if(selectrow<0)
							return;
						tm=jTable.getValueAt(selectrow,4).toString();
						/*sql="select goodsID from tb_sellHistory where goodsID='"+id+"'";
						Vector vdata=null;
						RetrieveObject retrive=new RetrieveObject();
						vdata=retrive.getObjectRow(sql);*/
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTable;
	}
	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */    
	private JButton getJButton() {
		if (jButton == null) {
			try {
				jButton = new JButton();
				jButton.setText("");  // Generated
				jButton.setIcon(new ImageIcon("./images/btn_del.jpg"));  // Generated
				jButton.setPreferredSize(new java.awt.Dimension(68,30));  // Generated
				jButton.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {    
						String sql="delete from tb_sellHistory where goodsTime='"+tm+"'";
						JdbcAdapter jd=new JdbcAdapter();
						if(jd.Clear(sql)){
							buildTable();
							}
					}
				});
			}
			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_empty.jpg"));  // Generated
				jButton1.setPreferredSize(new java.awt.Dimension(68,30));  // Generated
				jButton1.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {    
						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_sellHistory ";
						JdbcAdapter jd=new JdbcAdapter();
						if(jd.Clear(sql)){
							buildTable();
							}
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton1;
	}
	public void buildTable(){
		DefaultTableModel tablemodel=null;
		String[] name={"商品编号","商品名称","商品单价(元)","商品数量","销售时间","销售员"};
		String sql="select * from tb_sellHistory ";
		RetrieveObject bdt=new RetrieveObject();
		tablemodel=bdt.getTM(name,sql);
		jTable.setModel(tablemodel);
		
		}
	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField() {
		if (jTextField == null) {
			try {
				jTextField = new JTextField();
				jTextField.setPreferredSize(new java.awt.Dimension(100,22));  // Generated
				jTextField.addKeyListener(new java.awt.event.KeyAdapter() { 
					public void keyPressed(java.awt.event.KeyEvent e) {    
						if(e.getKeyCode()==KeyEvent.VK_ENTER)
						{
							ActionEvent	login=new ActionEvent(jButton2,0,null);
						    jButton2_actionPerformed(login);
						}
					}
				});
				jTextField.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {
						
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField;
	}
	/**
	 * This method initializes jButton2	
	 * 	
	 * @return javax.swing.JButton	
	 */    
	private JButton getJButton2() {
		if (jButton2 == null) {
			try {
				jButton2 = new JButton();
				jButton2.setIcon(new ImageIcon("./images/btn_select.jpg"));  // Generated
				jButton2.setPreferredSize(new java.awt.Dimension(50,20));  // Generated
				jButton2.addActionListener(new JButton2class(this)); 
					
				
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton2;
	}
	public void jButton2_actionPerformed(java.awt.event.ActionEvent e) {    
		String input=jTextField.getText().trim();
		if(input.matches("\\d*"))
	        string="select * from tb_sellHistory where  goodsID='"+input+"'";
		else
		     string="select * from tb_sellHistory where  goodsName like '%"+input+"%' or selluser like '%"+input+"%'";
		DefaultTableModel tablemodel=null;
		String[] name={"商品编号","商品名称","商品单价(元)","商品数量","销售时间","销售员"};
		RetrieveObject bdt=new RetrieveObject();
		tablemodel=bdt.getTM(name,string);
		jTable.setModel(tablemodel);	
	}
        }
class JButton2class implements ActionListener
{
	private XiaoshouLS xsls;
	JButton2class(XiaoshouLS xsls)
	{
		this.xsls=xsls;
	}
	public void actionPerformed(ActionEvent e) {
		xsls.jButton2_actionPerformed(e);
	}
	
}