getuserinfor.java

本远程教育系统是采用jsp技术配合SqlServer 2000数据库和Tomcat服务器开发的动态交互式网站。基本实现了用户管理

package condb;
import condb.ConDB;
import java.sql.*;
public class GetUserInfor{
	private Statement stmt;
	private ResultSet rs;
	private String user_id;
	private String user_realname;
	private String user_password;
	private int user_age;
	private String user_type;
	private String user_sex;
	private String qianzi;
	private boolean isExist;
	public GetUserInfor(){
		stmt = null;
		rs = null;
		user_id = "";
		user_realname = "";
		user_password = "";
		user_age = 0;
		user_type = "";
		user_sex = "";
		qianzi = "";
		isExist = false;
	}

	public void setUser_id(String user_id){	
		this.user_id=user_id;
		 ConDB condb=new ConDB(); 
		 String sql="select * from users where user_id='" + user_id +"'";
		 rs=condb.getRs(sql);
		 try{
			 if(rs.next()){
				 user_realname=rs.getString("user_realname");
				 user_password=rs.getString("user_password");
				 user_age=rs.getInt("user_age");
				 user_type=rs.getString("user_type");
				 user_sex=rs.getString("user_sex");
				 qianzi=rs.getString("qianzi");
				 isExist = true;
			 }
			 else{
			 	isExist = false;
			 }
		 }
		 catch(Exception e){
		 	System.err.println(e.getMessage());
		 }
		 condb.close();
	}
	public String getUser_id(){
		return user_id;
	}
	public String getUser_realname(){
		return user_realname;
	}
	public String getUser_password(){
		return user_password;
	}
	public int getUser_age(){
		return user_age;
	}
	public String getUser_sex(){
		return user_sex;
	}
	public String getQianzi(){
		return qianzi;
	}
	public String getUser_type(){
		return user_type;
	}
	public boolean isExist(){
		return isExist;
	}

}