guestbookdaojdbc.java

用java编写的程序

package webbook.guestbook.dao.jdbc;
import java.util.List;
import webbook.util.*;
import webbook.guestbook.Guestbook;
import webbook.guestbook.dao.GuestbookDAO;
import org.apache.commons.dbutils.handlers.BeanListHandler;

public class GuestbookDAOJdbc implements GuestbookDAO {
	private static final String SELECT_GUESTBOOKS_SQL = "select * from guestbook order by id desc";
	private static final String SELECT_GUESTBOOK_SQL = "select * from guestbook where id=?";
	private static final String SAVE_GUESTBOOK_SQL = "insert into guestbook (id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
	private static final String UPDATE_GUESTBOOK_SQL = "update guestbook set name=?,email=?,phone=?,title=? ,content=? where id=?";
	private static final String DELETE_GUESTBOOK_SQL = "delete from guestbook where id=?";
	public static final int PAGE_SIZE = 10;
	OracleUtil db = null;

	public GuestbookDAOJdbc() {
		db = new OracleUtil("java:/comp/env/jdbc/oracleds");
		db.init();
	}

	public Guestbook getGuestbook(Integer id) {
		String params[] = { id.toString() };
		List list = (List) db.query(SELECT_GUESTBOOK_SQL, params, new BeanListHandler(Guestbook.class));
		return (Guestbook) list.get(0);
	}

	public Pagination getGuestbooksByPage(int pageSize, int pageNumber) {
		Pagination p = new OraclePagination(SELECT_GUESTBOOKS_SQL, pageSize, pageNumber);
		return p;
	}

	public List getGuestbooks() {
		return (List) db.query(SELECT_GUESTBOOKS_SQL, null, new BeanListHandler(Guestbook.class));
	}

	public boolean remove(Integer id) {
		String params[] = { id.toString() };
		int result = db.update(DELETE_GUESTBOOK_SQL, params);
		if (result == 0) {
			return false;
		}
		return true;
	}

	public boolean save(Guestbook gb) {
		String param[] = {gb.getName(),gb.getEmail(),gb.getPhone(),gb.getTitle(), gb.getContent(),
				gb.getTime() };
		int result = db.update(SAVE_GUESTBOOK_SQL, param);
		if (result == 0) {
			return false;
		}
		return true;
	}

	public boolean update(Guestbook gb) {
		String params[] = { gb.getName(), gb.getEmail(),gb.getPhone(), gb.getTitle(), gb.getContent(),
				gb.getId().toString() };
		int result = db.update(UPDATE_GUESTBOOK_SQL, params);
		if (result == 0) {
			return false;
		}
		return true;
	}
}