boarddatabean.java

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

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

import java.sql.*;

import net.icefish.bean.Conn;
import net.icefish.bean.BoardBean;
/**
 * @author LittleChild
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class BoardDataBean {
	
	private Connection conn;	
	
	public BoardDataBean(){
		this.conn=Conn.connection();
	}

	
	//增加新版块
	public boolean addBoard(BoardBean boardBean){
		boolean flag=false;
		
        boolean board_isMother=boardBean.getBoard_IsMother();
        if(board_isMother){
        	PreparedStatement pstmt1=null;
        	try{
        		pstmt1=conn.prepareStatement("insert into icefish_board(board_name,board_info,board_isMother,board_master,board_postnum,board_topicnum,board_todaynum) values(?,?,'true',?,0,0,0)");
        		pstmt1.setString(1, boardBean.getBoard_Name());
        		pstmt1.setString(2, boardBean.getBoard_Info());
        		pstmt1.setString(3, boardBean.getBoard_Master());
        		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());
        	}
        }else{
        	PreparedStatement pstmt1=null;
        	try{
        		pstmt1=conn.prepareStatement("insert into icefish_board(board_name,board_info,board_isMother,board_master,board_bid,board_postnum,board_topicnum,board_todaynum) values(?,?,'false',?,?,0,0,0)");
        		pstmt1.setString(1, boardBean.getBoard_Name());
        		pstmt1.setString(2, boardBean.getBoard_Info());
        		pstmt1.setString(3, boardBean.getBoard_Master());
        		pstmt1.setString(4, boardBean.getBoard_BID());
        		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 editBoard(BoardBean boardBean){
		boolean flag=false;
		
        boolean board_isMother=boardBean.getBoard_IsMother();
        if(board_isMother){
        	PreparedStatement pstmt1=null;
        	try{
        		pstmt1=conn.prepareStatement("update icefish_board set board_name=?, board_info=?, board_isMother='true', board_master=?, board_postnum=0, board_topicnum=0, board_todaynum=0 where board_id="+boardBean.getBoard_ID());
        		pstmt1.setString(1, boardBean.getBoard_Name());
        		pstmt1.setString(2, boardBean.getBoard_Info());
        		pstmt1.setString(3, boardBean.getBoard_Master());
        		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());
        	}
        }else{
        	PreparedStatement pstmt1=null;
        	try{
        		pstmt1=conn.prepareStatement("update icefish_board set board_name=?, board_info=?, board_isMother='false', board_master=?, board_bid=?, board_postnum=0, board_topicnum=0, board_todaynum=0 where board_id="+boardBean.getBoard_ID());
        		pstmt1.setString(1, boardBean.getBoard_Name());
        		pstmt1.setString(2, boardBean.getBoard_Info());
        		pstmt1.setString(3, boardBean.getBoard_Master());
        		pstmt1.setString(4, boardBean.getBoard_BID());
        		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 delBoard(BoardBean boardBean){
		boolean flag=false;
		
        boolean board_isMother=boardBean.getBoard_IsMother();
        if(board_isMother){//如果所删除的版块为论坛一级分类版块，则连同其下属的子版块也删除，包括所有帖子
        	PreparedStatement pstmt1=null;
        	PreparedStatement pstmt2=null;
        	PreparedStatement pstmt3=null;
        	PreparedStatement pstmt4=null;        	
        	try{
        		pstmt4=conn.prepareStatement("select * from icefish_board where board_bid=?");
        		pstmt4.setString(1, boardBean.getBoard_ID());
        		ResultSet rs4=pstmt4.executeQuery();
        		while(rs4.next()){
                	PreparedStatement pstmt5=null;        		
            		pstmt5=conn.prepareStatement("delete from icefish_topic where topic_boardid=?");
            		pstmt5.setString(1, rs4.getString("board_id"));
            		int result5=pstmt5.executeUpdate();

                	PreparedStatement pstmt6=null;        		
            		pstmt6=conn.prepareStatement("delete from icefish_post where post_boardid=?");
            		pstmt6.setString(1, rs4.getString("board_id"));
            		int result6=pstmt6.executeUpdate();                 	
        			if (result6>0 && result5>0){
        				flag = true;
        			}
        			else{
        				flag = false;
        			}
        			pstmt5.close();
        			pstmt6.close();
        		}
        		pstmt4.close();
        		        		
        		pstmt1=conn.prepareStatement("delete from icefish_board where board_id=? or board_bid=?");
        		pstmt1.setString(1, boardBean.getBoard_ID());
        		pstmt1.setString(2, boardBean.getBoard_ID());
        		int result1=pstmt1.executeUpdate();
        		if (result1 > 0){
        			flag = true;
        		}
        		else{
        			flag = false;
        		}    		
        		pstmt1.close();
        		
        		pstmt2=conn.prepareStatement("delete from icefish_topic where topic_boardid=?");
        		pstmt2.setString(1, boardBean.getBoard_ID());
        		int result2=pstmt2.executeUpdate();
        		
        		pstmt3=conn.prepareStatement("delete from icefish_post where post_boardid=?");
        		pstmt3.setString(1, boardBean.getBoard_ID());
        		int result3=pstmt3.executeUpdate();
        		if (result3>0 && result2>0){
        			flag = true;
        		}
        		else{
        			flag = false;
        		}
        		pstmt2.close();    		
        		pstmt3.close();
        		conn.close();
        	}
        	catch(SQLException e){
        		flag=false;
        		System.out.println(e.toString());
        	}
        	
        }else{
        	PreparedStatement pstmt1=null;
        	PreparedStatement pstmt2=null;
        	PreparedStatement pstmt3=null;
        	try{
        		pstmt1=conn.prepareStatement("delete from icefish_board where board_id=?");
        		pstmt1.setString(1, boardBean.getBoard_ID());
        		int result1=pstmt1.executeUpdate();
        		if (result1 > 0){
        			flag = true;
        		}
        		else{
        			flag = false;
        		}    		
        		pstmt1.close();
        		
        		pstmt2=conn.prepareStatement("delete from icefish_topic where topic_boardid=?");
        		pstmt2.setString(1, boardBean.getBoard_ID());
        		int result2=pstmt2.executeUpdate();
        		if (result2 > 0){
        			flag = true;
        		}
        		else{
        			flag = false;
        		}    		
        		pstmt2.close();
        		
        		pstmt3=conn.prepareStatement("delete from icefish_post where post_boardid=?");
        		pstmt3.setString(1, boardBean.getBoard_ID());
        		int result3=pstmt3.executeUpdate();
        		if (result3 > 0){
        			flag = true;
        		}
        		else{
        			flag = false;
        		}    		
        		pstmt3.close();
        		conn.close();
        	}
        	catch(SQLException e){
        		flag=false;
        		System.out.println(e.toString());
        	}
    	}
		
		return flag;
	}
	
}