package com.dao;

import java.sql.*;
import java.util.ArrayList;

import com.data.*;
import com.db.*;
import com.tools.Pageable;

public class BoardDao {
	
	
//	此函數(shù)沒有用到過
    public static Boards getBoardDao(int board_id){
    	String sql="select * from board where board_id="+board_id;
        Connection con=DataProcess.getConnection(); 
        Statement pStmt=null;
    	ResultSet rs=null;
    	Boards board=new Boards();
        try{
        	pStmt=con.createStatement();
        	rs=pStmt.executeQuery(sql);
        	if(rs.next()){
        		String boardname=rs.getString("boardname");
        		String boardmaster=rs.getString("boardmaster");
        		String masterpwd=rs.getString("masterpwd");
    			String masterword=rs.getString("masterword");
    			String masteremail=rs.getString("masteremail");
    			int boardhits=rs.getInt("boardhits");
    			int boardtopics=rs.getInt("boardtopics");
    			//int bbs_id=rs.getInt("bbs_id");
    			board.setBoardname(boardname);
    			board.setBoardmaster(boardmaster);
    			board.setMasterpwd(masterpwd);
    			board.setMasterword(masterword);
    			board.setMasteremail(masteremail);
    			board.setBoardhits(boardhits);
    			board.setBoardtopics(boardtopics);
    			board.setBoard_id(board_id);
        	}
        	
        	return board;
        }catch(Exception e){
        	e.printStackTrace();
        	return null;
        }finally{
        	try {
				rs.close();
			    pStmt.close();
        	    con.close();
        	} catch (SQLException e) {
				
				e.printStackTrace();
			}
        }
    }
    //根據(jù)版主要名獲取board
    public static Boards getBoardDao(String boardmaster){
    	String sql="select * from board where boardmaster='"+boardmaster+"'";
        Connection con=DataProcess.getConnection(); //連接
        Statement pStmt=null;
    	ResultSet rs=null;
    	Boards board=null;
        try{
        	pStmt=con.createStatement();
        	rs=pStmt.executeQuery(sql);//查詢
        	if(rs.next()){
        		board=new Boards();
        		int board_id=rs.getInt("board_id");
        		String boardname=rs.getString("boardname");
        		String masterpwd=rs.getString("masterpwd");
    			String masterword=rs.getString("masterword");
    			String masteremail=rs.getString("masteremail");
    			int boardhits=rs.getInt("boardhits");
    			int boardtopics=rs.getInt("boardtopics");
    			//int bbs_id=rs.getInt("bbs_id");
    			board.setBoardname(boardname);
    			board.setBoardmaster(boardmaster);
    			board.setMasterpwd(masterpwd);
    			board.setMasterword(masterword);
    			board.setMasteremail(masteremail);
    			board.setBoardhits(boardhits);
    			board.setBoardtopics(boardtopics);
    			board.setBoard_id(board_id);
        	}
        	
        	return board;//返回
        }catch(Exception e){
        	e.printStackTrace();
        	return null;
        }finally{
        	try {
				rs.close();
			    pStmt.close();
        	    con.close();
        	} catch (SQLException e) {
				
				e.printStackTrace();
			}
        }
    }
    //查詢board信息
    public static ArrayList getBoardDao(String sql,int page,int pageSize,int cupage){
    	ArrayList al=new ArrayList();
    	Connection con=DataProcess.getConnection();//連接
    	PreparedStatement pStmt=null;
    	ResultSet rs=null;
    	
    	try{
    		pStmt=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,
    				                    ResultSet.CONCUR_READ_ONLY );//滾動的結(jié)果集
    		rs=pStmt.executeQuery();//查詢
    		Pageable pgb=new Pageable(rs);
       		pgb.setPageSize(pageSize);
    		pgb.gotoPage(page,cupage);
    		
       		rs.absolute(pgb.getRowsCount());//定位
    		int totalpages=pgb.getTotalPages();
    		al.add(totalpages);//總頁數(shù)目
    		int currentpage=pgb.getCurrentPage();
    		al.add(currentpage);//當(dāng)前頁
    		int pagecounts=pgb.getCurrentPageRowsCount();
       		al.add(pagecounts);//當(dāng)前頁大小
    		int i=0;
    		System.out.println("pagecounts:"+pagecounts);
    		while(i<pagecounts)
    		{
    			Boards board=new Boards();
    			
    			String boardname=rs.getString("boardname");
        		String boardmaster=rs.getString("boardmaster");
        		String masterpwd=rs.getString("masterpwd");
    			String masterword=rs.getString("masterword");
    			String masteremail=rs.getString("masteremail");
    			int boardhits=rs.getInt("boardhits");
    			int boardtopics=rs.getInt("boardtopics");
    			int board_id=rs.getInt("board_id");
    			
    				
    			board.setBoardname(boardname);
    			board.setBoardmaster(boardmaster);
    			board.setMasterpwd(masterpwd);
    			board.setMasterword(masterword);
    			board.setMasteremail(masteremail);
    			board.setBoardhits(boardhits);
    			board.setBoardtopics(boardtopics);
    			board.setBoard_id(board_id);
    			
    			al.add(board);
    			i++;
    			rs.next();
    		}
    		
    		return al;//返回結(jié)果集
    		
    		
    	}catch(Exception e){
    		e.printStackTrace();
    		return null;
    	}
    	finally{
    		try {
				rs.close();
			    pStmt.close();
        	    con.close();
        	} catch (SQLException e) {
				e.printStackTrace();
			}
    	}
    	
    	
    } 


}