usergui.java

连接数据库并实现一系列的增删改查等等

package gui;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.Box;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JScrollPane;
import javax.swing.JTabbedPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;

import entity.UserEntity;

import news.UserOperation;

public class UserGUI extends JFrame implements ActionListener
{
	//增加
	private JTabbedPane tabUser=new   JTabbedPane();
	private JPanel userPanelAdd=new JPanel();
	private JPanel userPanelDelete=new JPanel();
	private JPanel userPanelUpdate=new JPanel();
	private JPanel userPanelSelect=new JPanel();	
	private JLabel lblUserName=new JLabel("用户名");
	private JLabel lblUserPwd=new JLabel("密  码");
	private JTextField txtUserName=new JTextField(10);
	private JPasswordField userPwd=new JPasswordField(10);
	private JButton btnUserAdd=new JButton("增加");
	private JButton btnUserCancel=new JButton("取消");
	//删除
	JLabel lblDeleteUserId=new JLabel("用户编号");
	JTextField txtDeleteUuerId=new JTextField();
	JButton btnDeleteUserOk=new JButton("删除");
	JButton btnDeleteUserCancel=new JButton("取消");
	
	//修改
	private JLabel lblUpdateUserId=new JLabel("用户编号");
	private JTextField txtUpdateUserId=new JTextField();
	
	private JLabel lblUpdateUserName=new JLabel("用户名");
	private JLabel lblUpdateUserPwd=new JLabel("密  码");
	private JTextField txtUpdateUserName=new JTextField(10);
	private JPasswordField userUpdatePwd=new JPasswordField(10);
	private JButton btnUserUpdate=new JButton("修改");
	private JButton btnUserUpdateCancel=new JButton("取消");
	//查询
	private JButton btnUserSelect=new JButton("查询");
	private JTable table=new JTable();
	public UserGUI()
	{
		this.tabUser.add("增加用户信息",this.userPanelAdd);
		this.tabUser.add("删除用户信息",this.userPanelDelete);
		this.tabUser.add("修改用户信息",this.userPanelUpdate);
		this.tabUser.add("查询用户信息",this.userPanelSelect);
		//增加界面
		Box userAddUpBox=Box.createHorizontalBox();
		userAddUpBox.add(this.lblUserName);
		userAddUpBox.add(Box.createHorizontalStrut(10));
		userAddUpBox.add(this.txtUserName);
		
		Box userAddCenterBox=Box.createHorizontalBox();
		userAddCenterBox.add(this.lblUserPwd);
		userAddCenterBox.add(Box.createHorizontalStrut(10));
		userAddCenterBox.add(this.userPwd);
		
		Box userAddLowBox=Box.createHorizontalBox();
		userAddLowBox.add(this.btnUserAdd);
		userAddLowBox.add(Box.createHorizontalStrut(10));
		userAddLowBox.add(this.btnUserCancel);
		this.btnUserAdd.addActionListener(this);
		this.btnUserCancel.addActionListener(this);
		Box baseUserAdd=Box.createVerticalBox();
		baseUserAdd.add(userAddUpBox);
		baseUserAdd.add(Box.createVerticalStrut(10));
		baseUserAdd.add(userAddCenterBox);
		baseUserAdd.add(Box.createVerticalStrut(10));
		baseUserAdd.add(userAddLowBox);
		
		this.userPanelAdd.add(baseUserAdd);
		//删除界面
		Box boxUpDeleteUser=Box.createHorizontalBox();
		boxUpDeleteUser.add(this.lblDeleteUserId);
		boxUpDeleteUser.add(Box.createHorizontalStrut(10));
		boxUpDeleteUser.add(this.txtDeleteUuerId);
		
		Box boxLowDeleteUser=Box.createHorizontalBox();
		boxLowDeleteUser.add(this.btnDeleteUserOk);
		boxLowDeleteUser.add(Box.createHorizontalStrut(10));
		boxLowDeleteUser.add(this.btnDeleteUserCancel);
		
		Box baseUserDeleteBox=Box.createVerticalBox();
		baseUserDeleteBox.add(boxUpDeleteUser);
		baseUserDeleteBox.add(Box.createVerticalStrut(10));
		baseUserDeleteBox.add(boxLowDeleteUser);
		
		this.userPanelDelete.add(baseUserDeleteBox);
		
		this.btnDeleteUserOk.addActionListener(this);
		
		//修改界面

		Box userUpdateUpUpBox=Box.createHorizontalBox();
		userUpdateUpUpBox.add(this.lblUpdateUserId);
		userUpdateUpUpBox.add(Box.createHorizontalStrut(10));
		userUpdateUpUpBox.add(this.txtUpdateUserId);
		
		Box userUpdateUpBox=Box.createHorizontalBox();
		userUpdateUpBox.add(this.lblUpdateUserName);
		userUpdateUpBox.add(Box.createHorizontalStrut(10));
		userUpdateUpBox.add(this.txtUpdateUserName);
		
		Box userUpdateCenterBox=Box.createHorizontalBox();
		userUpdateCenterBox.add(this.lblUpdateUserPwd);
		userUpdateCenterBox.add(Box.createHorizontalStrut(10));
		userUpdateCenterBox.add(this.userUpdatePwd);
		
		Box userUpdateLowBox=Box.createHorizontalBox();
		userUpdateLowBox.add(this.btnUserUpdate);
		userUpdateLowBox.add(Box.createHorizontalStrut(10));
		userUpdateLowBox.add(this.btnUserUpdateCancel);
		this.btnUserUpdate.addActionListener(this);
		this.btnUserUpdateCancel.addActionListener(this);
		
		Box baseUserUpdate=Box.createVerticalBox();
		baseUserUpdate.add(userUpdateUpUpBox);
		baseUserUpdate.add(Box.createVerticalStrut(10));
		baseUserUpdate.add(userUpdateUpBox);
		baseUserUpdate.add(Box.createVerticalStrut(10));
		baseUserUpdate.add(userUpdateCenterBox);
		baseUserUpdate.add(Box.createVerticalStrut(10));
		baseUserUpdate.add(userUpdateLowBox);
		
		this.userPanelUpdate.add(baseUserUpdate);
		//查询
		this.userPanelSelect.add(this.btnUserSelect);
		this.userPanelSelect.add(new JScrollPane(this.table));
		this.btnUserSelect.addActionListener(this);
		this.getContentPane().add(this.tabUser);
//		int width=this.getToolkit().getScreenSize().width;
//		int height=this.getToolkit().getScreenSize().height;
//		this.setLocation(width/3,height/3);
		this.setSize(500,500);
		this.setVisible(true);
		
	}
	public static void main(String[] args) 
	{
		UserGUI userGUI=new UserGUI();
	}
	public void actionPerformed(ActionEvent e) 
	{
		System.out.println("aaaaaaaaaaaaaa");
		if(e.getSource()==this.btnUserAdd)
		{
			String name=this.txtUserName.getText();
			String pwd=new String(this.userPwd.getPassword());
			UserOperation userOper=new UserOperation();
			
			UserEntity entity=new UserEntity();
			entity.setUserName(name);
			entity.setUserPwd(pwd);
			
			boolean bool=userOper.addUser(entity);
			if(bool)
			{
				JOptionPane.showMessageDialog(this,"增加成功!");
			}
			else
			{
				JOptionPane.showMessageDialog(this,"增加失败!");
			}
			
		}
		if(e.getSource()==this.btnDeleteUserOk)
		{
			String id=this.txtDeleteUuerId.getText();
			UserOperation userOper=new UserOperation();
			boolean bool=userOper.deleteUser(id);
			if(bool)
			{
				JOptionPane.showMessageDialog(this,"删除成功!");
			}
			else
			{
				JOptionPane.showMessageDialog(this,"删除失败!");
			}
		}
		
		if(e.getActionCommand().equals("修改"))
		{
			System.out.println("oh,my god");
			String id=this.txtUpdateUserId.getText();
			String name=this.txtUpdateUserName.getText();			
			String pwd=new String(this.userUpdatePwd.getPassword());
			
			UserEntity entity=new UserEntity();
			entity.setId(Integer.parseInt(id));
			entity.setUserName(name);
			entity.setUserPwd(pwd);
			UserOperation userOper=new UserOperation();
			boolean bool=userOper.updateUser(entity);
			if(bool)
			{
				JOptionPane.showMessageDialog(this,"修改成功!");
			}
			else
			{
				JOptionPane.showMessageDialog(this,"修改失败!");
			}		
			
			
		}
		if(e.getSource()==this.btnUserSelect)
		{
			UserOperation userOper=new UserOperation();
			String content[][]=userOper.selectUser();
			String title[]={"编号","用户名","密码"};
			DefaultTableModel model=(DefaultTableModel)this.table.getModel();
		    model.setDataVector(content,title);
		}
		
	}
}