login.java

经典的“企业内部管理信息系统”JSP源代码

/*
 * Created on 2004-9-20
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package util;
import news.sql_data;
import news.strFormat;
import java.sql.*;

/**
 * Title:       用户登录信息检查
 * Description:
 * Copyright:    Copyright (c) 2004
 * @author:		 ning
 * @version 1.0
 */

public class login {
	private String username; //登录用户名
	private String passwd; //登录密码
	private long userid = 0; //用户ID号
	private String authority; //用户权限
	String sqlStr; //检索数据库SQL语句
	sql_data sqlbean = new sql_data();
	public static void main(String[] args) {
	}
	public login() throws Exception {
		username = "";
		passwd = "";
	}

	public String getUsername() {
		return username;
	}
	public void setUsername(String newusername) {
		username = newusername;
	}

	public String getPasswd() {
		return passwd;
	}
	public void setPasswd(String newpasswd) {
		passwd = newpasswd;
	}

	public long getUserid() {
		return userid;
	}
	public String getAuthority() {
		return authority;
	}
	public void setUserid(long uid) {
		userid = uid;
	}

	public String getSql() {

		sqlStr =
			"select * from admin where adminuser = '"
				+ strFormat.toSql(username)
				+ "' and adminpass = '"
				+ strFormat.toSql(passwd)
				+ "'";

		return sqlStr;
	}
	public boolean excute() throws Exception {
		boolean flag = false;
		ResultSet rs = sqlbean.executeQuery(getSql());
		if (rs.next()) {
			userid = rs.getLong("id");
			authority = rs.getString("authority");
			flag = true;
		}
		rs.close();
		sqlbean.closeConn();
		return flag;
	}
	public void setinfo(String lastip, String username) throws Exception {

		sqlbean.executeUpdate(
			"UPDATE admin SET lasttime = getdate(),lastip='"
				+ lastip
				+ "' where adminuser='"
				+ username
				+ "' ");

		sqlbean.closeConn();
	}
}