helpdatabean.java

来自「采用j2ee架构做的bbs」· Java 代码 · 共 110 行

/*
 * 创建日期 2006-6-16
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package net.icefish.bean;

import java.sql.*;

import net.icefish.bean.Conn;
import net.icefish.bean.HelpBean;

/**
 * @author LittleChild
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class HelpDataBean {
	
	private Connection conn;	
	
	public HelpDataBean(){
		this.conn=Conn.connection();
	}
	
	//增加新帮助
	public boolean addHelp(HelpBean helpBean){
		boolean flag=false;
        
    	PreparedStatement pstmt1=null;
    	try{
    		pstmt1=conn.prepareStatement("insert into icefish_help(help_name,help_info) values(?,?)");
    		pstmt1.setString(1, helpBean.getHelp_Name());
    		pstmt1.setString(2, helpBean.getHelp_Info());
    		int result1=pstmt1.executeUpdate();
    		if (result1 > 0){
                flag = true;
            }
            else{
                flag = false;
            }
    		
    		pstmt1.close();
    		conn.close();
    	}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
    	
		return flag;		
	}
	
	//修改帮助内容
	public boolean editHelp(HelpBean helpBean){
		boolean flag=false;
		
    	PreparedStatement pstmt1=null;
    	try{
    		pstmt1=conn.prepareStatement("update icefish_help set help_name=?, help_info=? where help_id="+helpBean.getHelp_ID());
    		pstmt1.setString(1, helpBean.getHelp_Name());
    		pstmt1.setString(2, helpBean.getHelp_Info());
    		int result1=pstmt1.executeUpdate();
    		if (result1 > 0){
    			flag = true;
    		}
    		else{
    			flag = false;
    		}    		
    		pstmt1.close();
    		conn.close();
    	}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
		
    	return flag;	
	}

	//删除帮助内容
	public boolean delHelp(HelpBean helpBean){
		boolean flag=false;
		
    	PreparedStatement pstmt1=null;
    	try{
    		pstmt1=conn.prepareStatement("delete from icefish_help where help_id=?");
    		pstmt1.setString(1, helpBean.getHelp_ID());
    		int result1=pstmt1.executeUpdate();
    		if (result1 > 0){
    			flag = true;
    		}
    		else{
    			flag = false;
    		}    		
    		pstmt1.close();
    		conn.close();
    	}
    	catch(SQLException e){
    		flag=false;
    		System.out.println(e.toString());
    	}
		
    	return flag;		
	}
	
}