userview.java

代码是自己我的代码不是网上down的。是自己写的。里面有很多值得学习的知识点。还有一些javabean组件。不算自己写的JAR文件

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class UserView extends JFrame
{
	ResultSet rs;
	private DBManager db=new DBManager();
	private JPanel centerpanel;
	private JPanel southpanel;
	private JLabel username;
	private JLabel password;
	private JLabel qrpassword;
	private JLabel power;
	private JTextField myusername;
	private JTextField mypassword;
	private JTextField myqrpassword;
	private JComboBox mypower;
	JButton ok;
	JButton edit;
	JButton del;
	JButton cancel;
    
	public UserView()
	{
	centerpanel=new JPanel(new GridLayout(4,2));
	southpanel=new JPanel(new GridLayout(1,1));
	username=new JLabel("用户名");
	password=new JLabel("密码");
	qrpassword=new JLabel("确认密码");
	power=new JLabel("登陆权限");
	myusername=new JTextField(16);
	mypassword=new JTextField(16);
	myqrpassword=new JTextField(16);
    String[] comboboxcontent={"管理员","普通用户"};
	mypower=new JComboBox(comboboxcontent);
	ok=new JButton("添加");
	edit=new JButton("修改");
	del=new JButton("删除");
	cancel=new JButton("查询");
	centerpanel.add(username);
	centerpanel.add(myusername);
	centerpanel.add(password);
	centerpanel.add(mypassword);
	centerpanel.add(qrpassword);
	centerpanel.add(myqrpassword);
	centerpanel.add(power);
	centerpanel.add(mypower);
	southpanel.add(ok);
	southpanel.add(edit);
	southpanel.add(del);
	southpanel.add(cancel);
	getContentPane().add(centerpanel,"Center");
	getContentPane().add(southpanel,"South");
//	setTitle("用户管理");
	setSize(300,160);
	Dimension screen=getToolkit().getScreenSize();
	setLocation((screen.width-getSize().width)/2,(screen.height-getSize().height)/2);
		addWindowListener(
			new WindowAdapter()
			{
				public void windowClosing(WindowEvent e)
				{
					System.exit(0);
				}
			}
			);
		cancel.addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					userSearch();
				}
			}
			);
		ok.addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					userAdd();
				}
			}
			);
		del.addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					userDel();
				}
			}
			);	
			edit.addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					userEdit();
				}
			}
			);	
		show();
	}
	public void userAdd()
	{
		if(myusername.getText().trim().equals(""))
		{
			JOptionPane.showMessageDialog(this,"用户名不能为空！");
			return;
		}
		else if(mypassword.getText().trim().equals(""))
		{
			JOptionPane.showMessageDialog(this,"密码不能为空！");
			return;
		}
		else if(myqrpassword.getText().trim().equals(""))
		{
			JOptionPane.showMessageDialog(this,"确认密码不能为空！");
			return;
		}
		else if (!myqrpassword.getText().trim().equals(mypassword.getText().trim()))
		{
			JOptionPane.showMessageDialog(this,"两次输入密码不一致！");
			return;
		}
		
		UserBean bean=new UserBean();
		bean.setUsername(myusername.getText().trim());
		bean.setPwd(mypassword.getText().trim());
		bean.setPower(mypower.getSelectedItem().toString().trim());
	   if(bean.isnull())
	   {
	   	    if (bean.insert()) {
            JOptionPane.showMessageDialog(this, "插入成功！");
        } else {
            JOptionPane.showMessageDialog(this, "插入失败！");
        }
	   }
	   else
    	{
    		JOptionPane.showMessageDialog(this, "此用户已经存在！");
    	}
		
	}
	public void userDel()
	{
		UserBean bean=new UserBean();
		bean.setUsername(myusername.getText().trim());
		if(bean.isnull())
		{
			JOptionPane.showMessageDialog(this, "没有此记录！");
            return;
		}
		 if (bean.delete()) {
            JOptionPane.showMessageDialog(this, "删除成功！");
        } else {
            JOptionPane.showMessageDialog(this, "删除失败！");
        }
	}
	public void userEdit()
	{
		UserBean bean=new UserBean();
		bean.setUsername(myusername.getText().trim());
		bean.setPwd(mypassword.getText().trim());
		bean.setPower(mypower.getSelectedItem().toString().trim());
		 if (bean.isnull()) {
            JOptionPane.showMessageDialog(this, "没有此记录！");
            return;
        }

        if (bean.modify()) {
            JOptionPane.showMessageDialog(this, "修改成功！");
        } else {
            JOptionPane.showMessageDialog(this, "修改失败！");
        }
	}
	public void userSearch()
	{
		ResultSet rs=null;
		rs=new DBManager().execute("select * from 用户表 where username='"+myusername.getText()+"'");
		try
		{
		if(rs.next())
	    {
	    	myusername.setText(rs.getString("username"));
	    	mypassword.setText(rs.getString("password"));
	    	mypower.setSelectedItem(rs.getString("power"));
	    }
	    else
	    {
	       JOptionPane.showMessageDialog(this, "没有此记录！");
	    }	
		}
		catch(Exception ex)
		{
			System.out.println(ex.toString());
		}
	    
	}
}