backuser.java

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

package ntsky.admin.usr;

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

public class BackUser{
	private int usr_total; 
	private String grade = null;
	private ResultSet rs = null;
	//判断有无用户
	public int Sum(){
		try{
			String sql = "select count(*) as total from admin where purview<>0;";
			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 username,purview from admin where purview<>0 order by purview;";
			DBConnect dbc = new DBConnect();
			rs = dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.print("rs_usr "+e.getMessage());
		}
		return rs;
	}
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
			rs = null;
		}
	}
}