?? admin.java
字號:
}
}
if(!foundErr){
password = MD5.toMD5(password);
answer = MD5.toMD5(answer);
}
if(!foundErr){
dbc.prepareStatement("INSERT INTO admin (name,password,sex,email,qq,phone,question,answer,date) VALUES (?,?,?,?,?,?,?,?,Now())");
dbc.setBytes(1,name.getBytes("GBK"));
dbc.setBytes(2,password.getBytes("GBK"));
dbc.setBytes(3,sex.getBytes("GBK"));
dbc.setBytes(4,email.getBytes("GBK"));
dbc.setInt(5,qq);
dbc.setBytes(6,phone.getBytes("GBK"));
dbc.setBytes(7,question.getBytes("GBK"));
dbc.setBytes(8,answer.getBytes("GBK"));
//dbc.setBytes(9,dat.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 修改管理員信息
*/
public static void editAdmin(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String name = ParamUtils.getString(request,"name","");
String password = ParamUtils.getString(request,"password","");
String repassword = ParamUtils.getString(request,"repassword","");
String question = ParamUtils.getString(request,"question","");
String sex = ParamUtils.getString(request,"sex","");
String answer = ParamUtils.getString(request,"answer","");
String email = ParamUtils.getString(request,"email","");
int qq = ParamUtils.getInt(request,"qq",0);
String phone = ParamUtils.getString(request,"phone","");
DBConnect dbc = new DBConnect();
if(name.equals("") || name==null){
errMsg = errMsg + "□ 您沒有輸入用戶名！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(password.equals("") || password==null){
errMsg = errMsg + "□ 您沒有輸入密碼！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(repassword.equals("") || repassword==null){
errMsg = errMsg + "□ 您沒有輸入確認密碼！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(email.equals("") || email==null){
errMsg = errMsg + "□ 您沒有輸入email！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(qq<=0){
errMsg = errMsg + "□ 您沒有輸入qq號碼！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(phone.equals("") || phone==null){
errMsg = errMsg + "□ 您沒有輸入電話號碼！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(question.equals("") || question==null){
errMsg = errMsg + "□ 您沒有輸入忘記密碼提示問題！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(answer.equals("") || answer==null){
errMsg = errMsg + "□ 您沒有輸入問題答案！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!password.equals(repassword)){
errMsg = errMsg + "□ 您兩次輸入的密碼不一致！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
password = MD5.toMD5(password);
answer = MD5.toMD5(answer);
}
if(!foundErr){
dbc.prepareStatement("UPDATE admin SET password=?,sex=?,email=?,qq=?,phone=?,question=?,answer=? WHERE name=?");
dbc.setBytes(1,password.getBytes("GBK"));
dbc.setBytes(2,sex.getBytes("GBK"));
dbc.setBytes(3,email.getBytes("GBK"));
dbc.setInt(4,qq);
dbc.setBytes(5,phone.getBytes("GBK"));
dbc.setBytes(6,question.getBytes("GBK"));
dbc.setBytes(7,answer.getBytes("GBK"));
dbc.setBytes(8,name.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 添加管理員
*/
public static void addAdmin(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
int user_id = ParamUtils.getInt(request,"user_id",0);
int clas = ParamUtils.getInt(request,"clas",0);
if(user_id<=0){
errMsg = errMsg + "□ 您沒有輸入序號!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
/**if(clas<=0){
errMsg = errMsg + "□ 您沒有輸入級別!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}*/
if(!foundErr){
DBConnect dbc = new DBConnect();
dbc.prepareStatement("UPDATE admin SET clas=? WHERE user_id=?");
dbc.setInt(1,clas);
dbc.setInt(2,user_id);
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 讀取所有管理員基本信息
*/
public Vector adminAll(){
DBConnect dbc = null;
Vector adminVector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("Select * from admin");
ResultSet rs = dbc.executeQuery();
while(rs.next()){
Admin admin = new Admin();
admin.setuser_id(rs.getString("user_id"));
admin.setname(rs.getString("name"));
admin.setsex(rs.getString("sex"));
admin.setqq(rs.getString("qq"));
admin.setemail(rs.getString("email"));
admin.setphone(rs.getString("phone"));
admin.setclas(rs.getString("clas"));
admin.setdat(rs.getString("date"));
admin.setnews_coun(rs.getString("news_coun"));
adminVector.add(admin);
}
}
catch(Exception e){
System.err.println(e+"error");
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return adminVector;
}
/**
* 忘記管理員密碼一
*/
public static void forgetAdmin(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String name = ParamUtils.getString(request,"name","");
ResultSet rs;
if(name.equals("") || name==null){
errMsg = errMsg + "□ 您沒有輸入用戶名！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
DBConnect dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM admin WHERE name = ?");
dbc.setBytes(1,name.getBytes("GBK"));
rs = dbc.executeQuery();
if(rs.next()){
String clas=rs.getString("clas");
Admin user=new Admin();
user.setname(name);
user.setpassword(rs.getString("password"));
user.setclas(rs.getString("clas"));
user.setuser_id(rs.getString("user_id"));
user.setsex(rs.getString("sex"));
user.setqq(rs.getString("qq"));
user.setemail(rs.getString("email"));
user.setphone(rs.getString("phone"));
user.setquestion(rs.getString("question"));
user.setanswer(rs.getString("answer"));
HttpSession session=request.getSession(true);
GetSession.addAdminSession(session,user);
rs.close();
dbc.close();
}
else{
errMsg = errMsg +"□ 您輸入的用戶名錯誤！<br>□ 五秒鐘后會自動返回登錄頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 刪除管理員
*/
public static void delAdmin(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
int user_id = ParamUtils.getInt(request,"user_id",0);
if(user_id<=0){
errMsg = errMsg + "□ 您沒有輸入序號!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
DBConnect dbc = new DBConnect();
dbc.prepareStatement("delete from admin WHERE user_id=?");
dbc.setInt(1,user_id);
dbc.executeUpdate();
dbc.prepareStatement("alter table admin drop user_id");
dbc.executeUpdate();
dbc.prepareStatement("alter table admin add user_id TINYINT auto_increment primary key");
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -