checkuser.java

来自「NTsky新闻发布v1.0(提供JavaBean)」· Java 代码 · 共 74 行

package ntsky.news;

import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import ntsky.database.*;

public class CheckUser{
	private String user = null;
	private String passwd = null;
	private ResultSet rs = null;
	//用户名
	public String getuser(HttpServletRequest request,String Suser){
		try{
			user=request.getParameter(Suser);
		}
		catch(Exception e){
			System.out.print("getuser "+e.getMessage());
		}
		return user;
	}
	//密码
	public String getpasswd(HttpServletRequest request,String Spasswd){
		try{
			passwd=request.getParameter(Spasswd);
		}
		catch(Exception e){
			System.out.print("passwd" +e.getMessage());
		}
		return passwd;
	}
	//判断数据库里有无此用户名
	public ResultSet user(){
		try{
			String sql = "select * from usr where user=?;";
			DBConnect dbc=new DBConnect(sql);
			dbc.setString(1,user);
			rs = dbc.executeQuery();
		}catch(Exception e){
			System.out.println("user "+e.getMessage());
		}
		return rs;
	}
	//判断用户的密码是否正确
	public ResultSet passwd(){
		try{
			String sql = "select * from usr where user=? and passwd=?;";
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			dbc.setString(2,passwd);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("passwd " +e.getMessage());
		}
		return rs;
	}
	//返回到个人区
	public void rdtPersonal(HttpServletResponse response,String url){
		try{
			response.sendRedirect(url);			
		}
		catch(Exception e){
			System.out.println("rdtaddarticle" +e.getMessage());
		}
	}
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
			rs = null;
		}
	}
}