admininfo.java

用jsp实现留言板的功能

/**
 * @(#)adminInfo.java
 *
 *
 * @solin 
 * @version 1.00 2007/12/20
 */
package com.web;

import java.sql.*;

public class adminInfo {
	private String adminName;
	private String adminPwd;
	private Connection conn;

    public adminInfo() {
    	DBConn dbc=new DBConn();
    	conn=dbc.DBConn();
    }
    
    //set方法
    public void setAdminName(String adminName){
    	this.adminName=adminName;
    }
    public void setAdminPwd(String adminPwd){
    	this.adminPwd=adminPwd;
    }
    
    //get方法
    public String getAdminName(){
    	return this.adminName;
    }
    public String getAdminPwd(){
    	return this.adminPwd;
    }
    
    public String judgeAdmin() throws Exception
    {
    	String judgeResult="no";
    	String adminPasswd=null;
    	//SQL语句
    	String judgeSql="select * from admin where adminName = ?";
    	try
    	{
    		PreparedStatement pstm=conn.prepareStatement(judgeSql);
    		pstm.setString(1,adminName);
    		ResultSet res=pstm.executeQuery();
    		if(res.next())
    		{
    			adminPasswd=res.getString("adminPwd");
	    		if(adminPwd.equals(adminPasswd))
	    		{
	    			judgeResult="yes";
	    		}else{
	    			judgeResult="no";
	    		}
    		}else{
    			judgeResult="no";
    		}
			res.close();
		    pstm.close();
		    conn.close();
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    		throw e;
    	}
    	
    	return judgeResult;
    }
    
    //用main函数进行测试
    public static void main (String[] args) {
    	adminInfo adm=new adminInfo();
    	adm.setAdminName("a");
    	adm.setAdminPwd("a");
    	try
    	{
    		System.out.println(adm.judgeAdmin());
    	}catch(Exception e)
    	{
    		System.out.println(e);
    	}
    	
    }
    
}