guestbookdaojdbc.java

该系统是一个留言本

package com.v512.guestbook.dao.jdbc;

import java.util.List;

import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.v512.guestbook.Guestbook;
import com.v512.guestbook.dao.GuestbookDAO;
import com.v512.util.OraclePagination;
import com.v512.util.OracleUtil;
import com.v512.util.Pagination;

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=?";
	OracleUtil db ;
	
	public GuestbookDAOJdbc(){
		db = new OracleUtil("java:/comp/env/jdbc/oracleds");
		db.init();
	}
	
	@Override
	public boolean delete(Integer id) {
		String params[]={id.toString()};
		int result=db.update(DELETE_GUESTBOOK_SQL, params);
		return (result==1);
		
	}

	@Override
	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);
	}

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

	@Override
	public boolean save(Guestbook gb) {
		String params[]={gb.getName(),gb.getEmail(),gb.getPhone(),gb.getTitle(),gb.getContent(),gb.getTime()};
		int result=db.update(SAVE_GUESTBOOK_SQL, params);
		return (result==1);
	}

	@Override
	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);
		return (result==1);
	}

	@Override
	public Pagination getGuestbookByPage(int pageSize, int pageNumber) {
		Pagination p = new OraclePagination(SELECT_GUESTBOOKS_SQL,pageSize,pageNumber);
		return p;
	}
	
/*	public  static void main(String args[]){
		GuestbookDAO dao =new GuestbookDAOJdbc();
		
		
	}*/

}