mainboarddao.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.MainBoardDTO;
import com.ibm.vo.MainBoardVO;

public class MainBoardDAO {

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