fetchpwd.java

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

package ntsky.news;

import java.sql.*;
import ntsky.database.*;

public class FetchPwd{
	public String user = null;
	public String answer = null;
	public int total;
	public ResultSet rs = null;

	//用户名
	public void setUser(String user){
		this.user = user;
	}
	public String getUser(){
		return user;
	}
	//问题
	public void setAnswer(String answer){
		this.answer = answer;
	}
	public String getAnswer(){
		return this.answer;
	}
	//判断是否由此用户
	public int user_total(){
		try{
			String sql = "select count(user) as t from usr where user=?";
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			rs = dbc.executeQuery();
			rs.next();
			total = rs.getInt("t");
		}
		catch(Exception e){
			System.out.print("rs_user() "+e.getMessage());
		}
		return total;
	}
	//取出用户资料
	public ResultSet rs_user(){
		try{
			String sql = "select question from usr where user=?;";
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.print("rs_user() "+e.getMessage());
		}
		return rs;
	}
	//判断用户输入的答案是否正确
	public int user_answer(){
		try{
			String sql = "select count(user) as t from usr where user=? and answer=?";
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			dbc.setString(2,answer);
			rs = dbc.executeQuery();
			rs.next();
			total = rs.getInt("t");
		}
		catch(Exception e){
			System.out.print("rs_user() "+e.getMessage());
		}
		return total;
	}
	//显示用户密码
	public ResultSet rs_passwd(){
		try{
			String sql = "select passwd from usr where user=? and answer=?;";
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			dbc.setString(2,answer);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.print("rs_user() "+e.getMessage());
		}
		return rs;
	}
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
			rs = null;
		}
	}
}