boarddao.java

来自「java web网络编程示例,原代码资源」· Java 代码 · 共 112 行

package edu.liusong.dao;

import edu.liusong.common.DBConnect;
import edu.liusong.mo.Board;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class BoardDAO {
	private DBConnect conn;

	private ResultSet rs;

	public Board getById(long id) {
		Board board = null;
		try {
			conn=new DBConnect();
			String sql="select * from board where bid=?";
			String []values={String.valueOf(id)};
			rs=conn.executeQuery(sql, values);
			if(rs.next()){
				board=new Board();
				board.setBid(rs.getLong(1));
				board.setName(rs.getString(2));				
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(conn!=null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return board;
	}

	public List getBoardByName(String name) {
		List<Board> list = new ArrayList<Board>();
		try {
			conn = new DBConnect();
			String sql = "select * from board where name=?";
			String[] values = { name };
			rs = conn.executeQuery(sql, values);
			if (rs.next()) {
				Board board = new Board();
				board.setBid(rs.getLong(1));
				board.setName(rs.getString(2));
				list.add(board);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}

	public int save(Board board) {
		int i = 0;
		try {
			conn = new DBConnect();
			String sql = "insert into board values(?,?)";
			String[] values = { String.valueOf(board.getBid()), board.getName() };
			i = conn.executeUpdate(sql, values);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return i;
	}

	public List getBoards() {
		List<Board> list = new ArrayList<Board>();
		try {
			conn = new DBConnect();
			String sql = "select * from board";
			rs = conn.executeQuery(sql, null);
			while (rs.next()) {
				Board board = new Board();
				board.setBid(rs.getLong(1));
				board.setName(rs.getString(2));
				board.setArticles(new ArticleDAO().getTopArticles("6", board.getBid()));
				list.add(board);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}

}