yh.java

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

/*
 * 创建日期 2008-4-5
 *
 * 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.JLabel;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import java.awt.GridLayout;
import java.awt.BorderLayout;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.ImageIcon;
import javax.swing.table.DefaultTableModel;

import appsm.model.Obj_user;
import appsm.util.JdbcAdapter;
import appsm.util.RetrieveObject;
/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class YH extends JInternalFrame {

	private javax.swing.JPanel jContentPane = null;
	private JSplitPane jSplitPane = null;
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JPanel jPanel1 = null;
	private JPanel jPanel2 = null;
	private JLabel jLabel = null;
	private JTextField jTextField = null;
	private JLabel jLabel1 = null;
	private JTextField jTextField1 = null;
	private JLabel jLabel2 = null;
	private JComboBox jComboBox = null;
	private JPanel jPanel = null;
	private JButton jButton = null;
	private JButton jButton1 = null;
	private JButton jButton2 = null;
	private JPanel jPanel3 = null;
	private JLabel jLabel3 = null;
	private JTextField jTextField2 = null;
	/**
	 * This is the default constructor
	 */
	public YH() {
		super();
		initialize();
		buildTable();
		
	}
	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setFrameIcon(new ImageIcon("./images/\u6dfb\u52a0\u5b66\u751f.GIF"));  // Generated
		this.setSize(652, 485);
		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
			jContentPane.add(getJPanel3(), java.awt.BorderLayout.SOUTH);  // Generated
		}
		return jContentPane;
	}
	/**
	 * This method initializes jSplitPane	
	 * 	
	 * @return javax.swing.JSplitPane	
	 */    
	private JSplitPane getJSplitPane() {
		if (jSplitPane == null) {
			try {
				jSplitPane = new JSplitPane();
				jSplitPane.setLeftComponent(getJScrollPane());  // Generated
				jSplitPane.setRightComponent(getJPanel1());  // Generated
				jSplitPane.setDividerLocation(550);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jSplitPane;
	}
	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */    
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			try {
				jScrollPane = new JScrollPane();
				jScrollPane.setViewportView(getJTable());  // Generated
				jScrollPane.setPreferredSize(new java.awt.Dimension(500,421));  // 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) {    
						String id=null;
						String sql=null;
						int selectrow=0;
						selectrow=jTable.getSelectedRow();
						if(selectrow<0)
							return;
						id=jTable.getValueAt(selectrow,0).toString();
						sql="select * from tb_user where userID='"+id+"'";
						Vector vdata=null;
						RetrieveObject retrive=new RetrieveObject();
						vdata=retrive.getObjectRow(sql);
						jTextField.setText(vdata.get(0).toString());
						jTextField2.setText(vdata.get(1).toString());
						jTextField1.setText(vdata.get(2).toString());
						jComboBox.setSelectedItem(vdata.get(3).toString());
				
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTable;
	}
	/**
	 * This method initializes jPanel1	
	 * 	
	 * @return javax.swing.JPanel	
	 */    
	private JPanel getJPanel1() {
		if (jPanel1 == null) {
			try {
				jPanel1 = new JPanel();
				jPanel1.setLayout(new BorderLayout());  // Generated
				jPanel1.add(getJPanel2(), java.awt.BorderLayout.NORTH);  // Generated
				jPanel1.add(getJPanel(), java.awt.BorderLayout.CENTER);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jPanel1;
	}
	/**
	 * This method initializes jPanel2	
	 * 	
	 * @return javax.swing.JPanel	
	 */    
	private JPanel getJPanel2() {
		if (jPanel2 == null) {
			try {
				jLabel3 = new JLabel();
				jLabel2 = new JLabel();
				jLabel1 = new JLabel();
				jLabel = new JLabel();
				GridLayout gridLayout4 = new GridLayout();
				jPanel2 = new JPanel();
				jPanel2.setLayout(gridLayout4);  // Generated
				jLabel.setText("用户ID");  // Generated
				jLabel1.setText("密码");  // Generated
				jLabel2.setText("类型");  // Generated
				gridLayout4.setRows(4);  // Generated
				jLabel3.setText("用户名");  // Generated
				jPanel2.add(jLabel, null);  // Generated
				jPanel2.add(getJTextField(), null);  // Generated
				jPanel2.add(jLabel3, null);  // Generated
				jPanel2.add(getJTextField2(), null);  // Generated
				jPanel2.add(jLabel1, null);  // Generated
				jPanel2.add(getJTextField1(), null);  // Generated
				jPanel2.add(jLabel2, null);  // Generated
				jPanel2.add(getJComboBox(), null);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jPanel2;
	}
	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */    
	private JTextField getJTextField() {
		if (jTextField == null) {
			try {
				jTextField = new JTextField();
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jTextField;
	}
	/**
	 * 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 jComboBox	
	 * 	
	 * @return javax.swing.JComboBox	
	 */    
	private JComboBox getJComboBox() {
		if (jComboBox == null) {
			try {
				jComboBox = new JComboBox();
				jComboBox.addItem("管理员");
				jComboBox.addItem("销售员");
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jComboBox;
	}
	/**
	 * This method initializes jPanel	
	 * 	
	 * @return javax.swing.JPanel	
	 */    
	private JPanel getJPanel() {
		if (jPanel == null) {
			try {
				jPanel = new JPanel();
				jPanel.setLayout(null);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jPanel;
	}
	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */    
	private JButton getJButton() {
		if (jButton == null) {
			try {
				jButton = new JButton();
				jButton.setIcon(new ImageIcon("./images/btn_add.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) {  
						if(jTextField.getText().trim().equals(""))return;
						Obj_user objuser=new Obj_user();
						objuser.setuserID(jTextField.getText().trim());
						objuser.setuserName(jTextField2.getText().trim());
						objuser.setuserPass(jTextField1.getText().trim());
						objuser.setuserqx(String.valueOf(jComboBox.getSelectedItem()));
						JdbcAdapter jdbcadapter=new JdbcAdapter();
						if(jdbcadapter.InsertYH(objuser))
							{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.setIcon(new ImageIcon("./images/btn_del.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) {    
						if(jTextField.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_user where userID='"+jTextField.getText().trim()+"'";
						JdbcAdapter jdbcadapter=new JdbcAdapter();
						if(jdbcadapter.Delet(sql)){
							jTextField.setText("");
							jTextField1.setText("");
							jTextField2.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.setIcon(new ImageIcon("./images/btn_edit.jpg"));  // Generated
				jButton2.setPreferredSize(new java.awt.Dimension(68,30));  // Generated
				jButton2.addActionListener(new java.awt.event.ActionListener() { 
					public void actionPerformed(java.awt.event.ActionEvent e) {    
						if(jTextField.getText().trim().equals(""))return;
						Obj_user objuser=new Obj_user();
						objuser.setuserID(jTextField.getText().trim());
						objuser.setuserName(jTextField2.getText().trim());
						objuser.setuserPass(jTextField1.getText().trim());
						objuser.setuserqx(String.valueOf(jComboBox.getSelectedItem()));
						JdbcAdapter jdbcadapter=new JdbcAdapter();
						if(jdbcadapter.UpdataYH(objuser))
							{buildTable();}
					}
				});
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jButton2;
	}
	/**
	 * This method initializes jPanel3	
	 * 	
	 * @return javax.swing.JPanel	
	 */    
	private JPanel getJPanel3() {
		if (jPanel3 == null) {
			try {
				jPanel3 = new JPanel();
				jPanel3.add(getJButton(), null);  // Generated
				jPanel3.add(getJButton1(), null);  // Generated
				jPanel3.add(getJButton2(), null);  // Generated
			}
			catch (java.lang.Throwable e) {
				// TODO: Something
			}
		}
		return jPanel3;
	}
	public void buildTable(){
		DefaultTableModel tablemodel=null;
		String[] name={"用户ID","用户名","用户密码","用户权限"};
		String sql="select * from tb_user ";
		RetrieveObject bdt=new RetrieveObject();
		tablemodel=bdt.getTM(name,sql);
		jTable.setModel(tablemodel);
		
		}
	/**
	 * 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;
	}
           }  //  @jve:decl-index=0:visual-constraint="10,10"