login.java

本系统是基于JAVA语言的办公系统

package org.pan.web;

import java.sql.*;
import org.pan.util.*;

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

public class login extends DataBase {
	private String adminName;	//登录用户名
	private String password;		//登录密码
  public String sqlStr = "";		//sql String
	public String errorMessage = ""; //数据库错误信息
	
	public login() throws Exception{
		super();
		adminName = "";
		password = "";
	}

	public String getAdminName() {
		return adminName;
	}
	public void setAdminName(String newAdminName) {
		adminName = newAdminName;
	}

	public String getPassword() {
		return password;
	}
	public void setPassword(String newpassword) {
		password = newpassword;
	}

	public String getSql() {
		sqlStr = "select * from admin where adminName = '" + strFormat.toSql(adminName) + "' and password = '" + strFormat.toSql(password) + "'";
		return sqlStr;
	}

  //根据用户名和密码查询数据库并返回登陆是否成功
	public boolean excute() throws Exception {
		boolean flag = false;
		try {
		  rs = stmt.executeQuery(getSql());
		  if (rs.next()){		
		  	flag = true;
		  	rs.close();
		  } else {
		  	this.errorMessage = "对不起,输入的登陆帐号或密码错误!";
		  }
		}
		catch(Exception ex) {
			this.errorMessage = sqlStr + ex.getMessage();
		} finally {
		  close();
	  }
		return flag;		
	}
};