admininfo.java

实现叫简单但是很经典的新闻发布管理系统

package news;
import java.sql.*;
public class AdminInfo {
  int adminid=0;
  int power=0;
  public AdminInfo(){}
  DBConn conn=new DBConn();
  public int isExist(String name,String psw){
    String sql="SELECT * FROM admin WHERE adminname='"+name+"' AND password='"+psw+"'";
    try{
      ResultSet rs=conn.query(sql);
      if(rs.next()){
        adminid=rs.getInt("id");
        power=rs.getInt("power");
      }
      rs.close();
      conn.DBclose();
    }
    catch(Exception e){
     System.out.print(e.toString());
    }
    return adminid;
  }
  public int getPower(){
    return power;
  }
  public String getNickname(int id){
    String nickname="";
    String sql="SELECT * FROM admin WHERE id="+id;
    try{
      ResultSet rs=conn.query(sql);
      if(rs.next())
         nickname=rs.getString("nickname");
      rs.close();
      conn.DBclose();
     }
    catch(Exception e){
       System.out.print(e.toString());
    }
    return nickname;
  }
}