admindaojdbc.java

该系统是一个留言本

package com.v512.guestbook.dao.jdbc;

import java.util.List;

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

import com.v512.guestbook.Admin;
import com.v512.guestbook.dao.AdminDAO;
import com.v512.util.OracleUtil;

public class AdminDAOJdbc implements AdminDAO {
	private static final String SELECT_ADMIN_SQL = "select * from admin where username=? and password=?";
	OracleUtil db = null;

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

	@Override
	public Admin getAdmin(String username, String password) {
		String params[] = { username, password };
		List list = (List) db.query(SELECT_ADMIN_SQL, params, new BeanListHandler(Admin.class));
		if (list.size() >= 1) {
			return (Admin) list.get(0);
		} else {
			return null;
		}
	}
}