?? managerbean.java
字號:
package cn.jack.bean;
import cn.jack.form.ManagerForm;
import cn.jack.tool.DBConnection;
import cn.jack.tool.MD5;
import java.sql.*;
public class ManagerBean {
DBConnection DBConn = new DBConnection();
MD5 md5 = new MD5();
public void Delete(int id){
Connection Conn = DBConn.getConn();
Statement stmt = null;
String sql = "delete from BookContent where id="+id;
try
{
stmt=Conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
Conn.close();
}catch(Exception e){}
}
public void update(String re,String retime,int id){
Connection Conn = DBConn.getConn();
Statement stmt = null;
String sql = "update BookContent set gbre= '" + re + "',gbretime='" + retime + "'where id="+id;
try
{
stmt=Conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
Conn.close();
}catch(Exception e){}
}
public void editpass(ManagerForm mf){
Connection Conn = DBConn.getConn();
Statement stmt = null;
String userpass = mf.getUserpass();
userpass = md5.getMD5ofStr(userpass);
String sql = "update Manager set username= '" + mf.getUsername() + "',userpass='" + userpass + "'";
try
{
stmt=Conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
Conn.close();
}catch(Exception e){}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -