?? 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;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -