useredit.java

实现图书借阅管理,运用access数据库

package bookmanager;
import javax.swing.*;
import java.awt.event.*;
import java.awt.GridLayout;
import java.sql.*;

public class userEdit extends JFrame implements ActionListener
{
	public userEdit()
	{
		setTitle("修改用户");
		setSize(200,200);
		gl=new GridLayout(5,2,20,20);
		JPanel panel=new JPanel();
		panel.setLayout(gl);
		userlbl=new JLabel("用户名");
		oldpasswordlbl=new JLabel("原密码");
		confirmlbl=new JLabel("确认新密码");
		newpasswordlbl=new JLabel("新密码");
		usertex=new JTextField("");
		oldpasswordtex=new JPasswordField("");
		newpasswordtex=new JPasswordField("");
		confirmtex=new JPasswordField("");
		addbtn=new JButton("确认");
		cancelbtn=new JButton("取消");
		panel.add(userlbl);
		panel.add(usertex);
		panel.add(oldpasswordlbl);
		panel.add(oldpasswordtex);
		panel.add(newpasswordlbl);
		panel.add(newpasswordtex);
		panel.add(confirmlbl);
		panel.add(confirmtex);
		panel.add(addbtn);
		panel.add(cancelbtn);
		getContentPane().add(panel);
		addbtn.addActionListener(this);
		cancelbtn.addActionListener(this);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==addbtn)
		{
			String username=usertex.getText().trim();
			if(username.equals(""))
			{
			JOptionPane.showMessageDialog(null,"用户名不能为空!");
			return;
		}
		String  oldpassword=new String(oldpasswordtex.getPassword()).trim();
		if(oldpassword.equals(""))
		{
			JOptionPane.showMessageDialog(null,"原密码名不能为空!");
			return;
		}
		String newpassword=new String(newpasswordtex.getPassword()).trim();
		if(newpassword.equals(""))
		{
			JOptionPane.showMessageDialog(null,"新密码名不能为空!");
			return;
		}
		String confrim=new String(confirmtex.getPassword()).trim();
		//查询密码与用户名匹配的一项
		if(confrim.equals("")||!(confrim.equals(newpassword)))
		{
			confirmtex.setText("");
			oldpasswordtex.setText("");
			newpasswordtex.setText("");
			JOptionPane.showMessageDialog(null,"密码不一样");
			return;
		}
		String strsql;
		//查询密码与用户名匹配的一项
		strsql=("select * from admin where Username='"+usertex.getText().trim()+"'and Password='"+oldpassword+"'");
		rs=db.getResult(strsql);
		
		boolean isexist=false;
		try{
			//把游标指向结果集的第一行，如果没有数据则返回false
			isexist=rs.first();		
		}
		catch(SQLException w)
		{
			System.out.println(w);}
		//判断结果是否正确
		if(!isexist){
			JOptionPane.showMessageDialog(null,"用户名不存在,或密码不正确");
			return;
		}
		else{
				strsql=("update admin set password='"+newpassword+"' where username='"+username+"'");
				System.out.println(strsql);
				boolean success=db.executeSql(strsql);
				if(!success)
				{
					JOptionPane.showMessageDialog(null,"修改不成功，请重试");
				}
				else
					JOptionPane.showMessageDialog(null,"修改成功");
				
			}
			this.dispose();
		}
		
	
		/*
			String user=usertex.getText();
			ch=passwordtex.getPassword();
			String password=new String(ch);
			if(user.trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"用户名不能为空!");
			return;
		}
		if(password.trim().equals(""))
		{
			JOptionPane.showMessageDialog(null,"密码名不能为空!");
			return;
		}
			if(user.equals("admin")&&password.equals("admin"))
			{
				myBook.setEnabled("管理员");
			}
			if(user.equals("borrowcontrol")&&password.equals("borrowcontrol"))
			{
				myBook.setEnabled("借阅操作员");
			}
			if(user.equals("bookcontrol")&&password.equals("bookcontrol"))
			{
				myBook.setEnabled("书籍管理员");
			}
			this.dispose();
		}*/
		if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
	}
	private JLabel userlbl;
	private JLabel oldpasswordlbl;
	private JLabel newpasswordlbl;
	private JLabel confirmlbl;
	private JTextField usertex;
	private JPasswordField oldpasswordtex;
	private JPasswordField confirmtex;
	private JPasswordField newpasswordtex;
	private JButton addbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private ResultSet rs;
	private DBManager db=new DBManager();
}