loginuser.java

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

package adminUser;

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

public class loginUser
{
	private String admin_name;      //管理员昵称
	private String admin_pwd;       //管理员密码
	private int id = 0;             //管理员ID号
	private int admin_loginnum = 0; //管理员登录次数
	private String admin_class;     //管理员级别
	private String strsql;
	
	conn cn = new conn();
	
	public loginUser()
	{
		admin_name = "";
		admin_pwd = "";
	}
	
	public String getAdmin_name()
	{
		return admin_name;
	}
	public void setAdmin_name(String username)
	{
		this.admin_name = username;
	}
	
	public String getAdmin_pwd()
	{
		return admin_pwd;
	}
	public void setAdmin_pwd(String password)
	{
		this.admin_pwd = password;
	}
	
	public String getAdmin_class()
	{
		return admin_class;
	}
	public int getId()
	{
		return id;
	}
	public int getAdmin_loginnum()
	{
		return admin_loginnum;
	}
	
	public String getStrsql()
	{
		strsql = "select * from C_admin where admin_name='"+admin_name+"' and admin_pwd='"+admin_pwd+"'";
		return strsql;
	}
	
	public boolean execute()
	{
		boolean flag = false;
		try
		{
		    ResultSet rs = cn.executeQuery(getStrsql());
		    if (rs.next())
		    {
		    	id = rs.getInt("id");
		    	admin_class = rs.getString("admin_class");
		    	admin_loginnum = rs.getInt("admin_loginnum") + 1;
		    	flag = true;
		    }	
		    rs.close();
		    cn.closeconn();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return flag;
	}
	
	public void updateLoginnum(String admin_name)
	{
		cn.executeUpdate("update C_admin set admin_loginnum = admin_loginnum+1 where admin_name='"+admin_name+"'");
		cn.closeconn();
	}
	
	public static void main(String[] agrs)
	{
		System.out.println("success!");
	}
	
}