nextboarddao.java

一个很好的BBS论坛项目

package com.ibm.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.ibm.common.DBConnection;
import com.ibm.dto.NextBoardDTO;
import com.ibm.vo.NextBoardVO;

public class NextBoardDAO {

	public ArrayList<NextBoardVO> queryNextBoard(Connection conn)
	{
		PreparedStatement ps = null;
		ArrayList<NextBoardVO> list = new ArrayList<NextBoardVO>();
		NextBoardVO nbdto = null;
		String sql = "select * from secondboard";
		try {
			ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while(rs.next())
			{
				nbdto = new NextBoardVO();
				nbdto.setBoardid(rs.getInt(1));
				nbdto.setBoardname(rs.getString(2));
				nbdto.setParentid(rs.getInt(3));
				list.add(nbdto);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
			DBConnection.getInstance().close(null, ps, null, conn);
		}
		
		return list;
	}
}