boarddaoimp.java

学习资料学习资料学习资料学习资料学习资料

package com.java.dao;

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.java.dao.impl.BoardDao;
import com.java.entity.Board;
import com.java.entity.zBoard;

public class BoardDaoimp extends Conn implements BoardDao {

	public int AddBoard(Board board) {
		String sql="insert into Board values(?,?,?)";
		String [] boards=new String[3];
		boards[0]=String.valueOf(board.getBoardId());
		boards[1]=board.getBoardName();
		boards[2]=String.valueOf(board.getParentId());
		
		return executeSql(sql,boards);
	}

	public int DeleteBoard(Board board) {
		String sql="delete from Board where parentid=?";
		String [] boards=new String[1];
		boards[0]=String.valueOf(board.getParentId());
		return executeSql(sql,boards);
	}

	public List<Board> findBoard(int boardid) {
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		List<Board> list=new ArrayList();
		String sql="select * from board where boardid=?";
		try {
			conn = sqlconnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, String.valueOf(boardid));
			rs=pstmt.executeQuery();
			while(rs.next()){
				Board bd=new Board();
				bd.setBoardId(rs.getInt("boardid"));
				bd.setBoardName(rs.getString("boardname"));
				bd.setParentId(rs.getInt("parentid"));
				list.add(bd);
			}
		} catch (Exception e) {
			// TODO: handle exception
		}finally{
			closeConnection(conn, pstmt, rs);
		}
		return list;
	}
	public List findzboard(){
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		List list=new ArrayList();
		String sql="select * from zboard";
		try {
			conn = sqlconnection();
			pstmt = conn.prepareStatement(sql);
			rs=pstmt.executeQuery();
			
			while(rs.next()){
				zBoard zboard=new zBoard();
				zboard.setZboardId(rs.getInt("zboardid"));
				zboard.setZboardName(rs.getString("zboardname"));
				list.add(zboard);
			}
		} catch (Exception e) {
			// TODO: handle exception
		}finally{
			closeConnection(conn, pstmt, rs);
		}
		return list;
	}
}