logincheck.java

来自「JSP+JavaBean+Servlet 办公自动化管理系统由前台管理和后台管」· Java 代码 · 共 35 行

package oa.ajax;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oa.sys.Db;
public class LoginCheck {
	private static Statement stmt = null;
	private static ResultSet rs = null;
	private static Db db = new Db();
	public String checkEm(String id){
		String pwd = "";
		try {
			if(!id.matches("^\\d+$"))
				return pwd;
			stmt = db.getStmt();
			rs = stmt.executeQuery("select password from password where employeeid = '"+id+"'");
			if(rs.next())
				pwd = rs.getString("password");
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			db.close();
		}
		return pwd;
	}
	public String checkAdmin(String id){
		if(id!=null && id.equals("admin"))
			return "admin";
		else
			return "";
	}
}