persondaoimpl.java

Struts+DAO实现的留言板管理程序

/*
 *@author RenGuiju ,Creation date:Nov 18, 2008
 *
 *Email:[e-mail]
 */
package edu.bupt.struts.note.impl;

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

import edu.bupt.struts.note.dao.PersonDAO;
import edu.bupt.struts.note.dbc.DataBaseConnection;
import edu.bupt.struts.note.vo.Person;

public class PersonDAOImpl implements PersonDAO {
	/*
	 * 功能： · 判断是否是正确的用户名或密码 · 从数据库中取出用户的真实姓名
	 */
	public boolean login(Person person) throws Exception {
		boolean flag = false;
		String sql = "SELECT name FROM person WHERE id=? and password=?";
		PreparedStatement pstmt = null;
		DataBaseConnection dbc = null;
		
		dbc = new DataBaseConnection();
		
		try {
			pstmt = dbc.getConnection().prepareStatement(sql);
			pstmt.setString(1, person.getId());
			pstmt.setString(2, person.getPassword());
			ResultSet rs = pstmt.executeQuery();
			if (rs.next()) {
				flag = true;
				person.setName(rs.getString(1));
			}
			rs.close();
			pstmt.close();
		} catch (Exception e) {
			throw new Exception("操作出现错误！！！");
		} finally {
			dbc.close();
		}

		return flag;
	}

}