adminuserdaoex.java

本人做的个人留言本

package com.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.connection.DataBaseConnection;
import com.vo.AdminUser;

public class AdminUserDaoEx implements AdminUserDao {

	public boolean login(AdminUser user) throws Exception {
		{
			boolean flag = false;
			String sql = "SELECT * FROM adminuser WHERE account=? and pass=?";
			PreparedStatement pstmt = null;
			DataBaseConnection dbc = null;
			dbc = new DataBaseConnection();
			try {
				pstmt = dbc.getConnection().prepareStatement(sql);
				pstmt.setString(1, user.getAccount());
				pstmt.setString(2, user.getPass());
				ResultSet rs = pstmt.executeQuery();
				if (rs.next()) {
					flag = true;
					user.setName(rs.getString(2));
				}
				rs.close();
				pstmt.close();
			} catch (Exception e) {
				throw new Exception("操作出现错误！！！");
			} finally {
				dbc.close();
			}

			return flag;
		}
	}
}