checklogin.java

NTsky新闻发布v1.0(提供JavaBean)

/**
********************************
*   NTsky新闻发布系统V 1.0     *
*   功能：验证用户登陆
*   代码编写：姚君林
*   编写日期：2003/4/1
*	代码修改：
*   修改日期：			
*******************************
*/
package ntsky.admin;

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

public class CheckLogin{
	private String username;
	private String password;
	private ResultSet rs = null;
	private int total; 

	//用户名
	public String username(String username){
		this.username = CodeFilter.toHtml(username);
		return username;
	}
	//密码
	public String password(String password){
		this.password = CodeFilter.toHtml(password);
		return password;
	}

	//用户名判断
	public ResultSet rs_username() throws Exception{
		String sql = "select username from admin where username=?;";	
		DBConnect dbc=new DBConnect(sql);
		dbc.setString(1,username);
		rs=dbc.executeQuery();
		dbc.close();
		return rs;
	}
	//判断是否有用户
	/**
	public int userTotal() throws Exception{
		String sql_total = "select count(username) as total from admin where username=? and password=?";
		DBConnect dbc = new DBConnect(sql_total);
		dbc.setString(1,username);
		dbc.setString(2,password);
		rs = dbc.executeQuery();
		rs.next();
		total = rs.getInt("total");
		return total;
	}
	*/
	//密码判断
	public ResultSet rs_password() throws Exception{
		String sql_password = "select username,password,purview from admin where username=? and password=?";
		DBConnect dbc=new DBConnect(sql_password);
		dbc.setString(1,username);
		dbc.setString(2,password);
		rs=dbc.executeQuery();
		dbc.close();
		return rs;
	}
	//跳转
	public void backDft(HttpServletResponse response,String url){
		try{
			response.sendRedirect(url);
		}
		catch(Exception e){
			System.out.print("backUser "+e.getMessage());
		}
	}
	//关闭数据库
	public void close() throws Exception{
		if(rs != null){
			rs.close();
		} 
	}
}