updateadmin.java

是一个JSP与数据库应用系统

package adminUser;

import database.*;
import java.sql.*;

public class updateAdmin
{
	private int id = 0;         //管理员ID
	private String oldpwd;      //管理员旧有密码
	private String pwd1;        //管理员第一次新密码
	private String pwd2;        //管理员第二次新密码
	private String strsql;
	
	conn cn = new conn();
	
	public updateAdmin()
	{
		id = 0;
		oldpwd = "";
		pwd1 = "";
		pwd2 = "";
	}
	

	public void setId(int id)
	{
		this.id = id;
	}
	
	
	public void setOldpwd(String oldpwd)
	{
		this.oldpwd = oldpwd.trim();
	}
	
	public void setPwd1(String pwd1)
	{
		this.pwd1 = pwd1;
	}
	
	public void setPwd2(String pwd2)
	{
		this.pwd2 = pwd2;
	}
	
	public boolean execute()
	{
		boolean flag = false;
		try
		{
			strsql = "select * from C_admin where id='"+id+"' and admin_pwd='"+oldpwd+"'";
			ResultSet rs = cn.executeQuery(strsql);
			if (rs.next())
			{
				flag = true;
			}
			rs.close();
			cn.closestmt();
			cn.closeconn();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return flag;
	}
	
	public void updateAdmin()
	{
		try
		{
				strsql = "update C_admin set admin_pwd='"+pwd1+"' where id='"+id+"'";
				cn.executeUpdate(strsql);
				cn.closeconn();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}