managerbean.java

来自「开发环境：windows xp sp2 ＋ Eclipse5＋TOMCAT5.5」· Java 代码 · 共 53 行

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){}
	
}
}