user.java

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

package ntsky.admin.usr;

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

public class User{
	private int usr_total; 
	private String grade = null;
	private ResultSet rs = null;
	//判断有无用户
	public int Sum(){
		try{
			String sql = "select count(*) as total from usr;";
			DBConnect dbc = new DBConnect();
			rs = dbc.executeQuery(sql);
			rs.next();
			usr_total = rs.getInt("total");
		}
		catch(Exception e){
			System.out.print("User "+e.getMessage());
		}
		return usr_total;
	}
	//取得用户资料
	public ResultSet rs_usr(){
		try{
			String sql = "select user,purview from usr;";
			DBConnect dbc = new DBConnect();
			rs = dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.print("rs_usr "+e.getMessage());
		}
		return rs;
	}
	//取得用户的等级
	public String grade(int purview){
		try{
			String sql = "select grade from popedom where gradeid='"+purview+"';";
			DBConnect dbc = new DBConnect();
			rs = dbc.executeQuery(sql);
			rs.next();
			grade = rs.getString("grade");
		}
		catch(Exception e){
			System.out.print("grade "+e.getMessage());		
		}
		return grade;
	}
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
			rs = null;
		}
	}
}