persondaoimpl.java

一种java ee 中dao设计模式加mvc设计模式的用户登陆程序

package com.loginmvc.impl;

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

import com.loginmvc.dbc.DatabaseConnection;
import com.loginmvc.inter.PersonDAO;
import com.loginmvc.personvo.Person;


public class PersonDAOImpl implements PersonDAO {
	//登陆验证的方法
	public boolean isLogin(Person person)throws Exception{
		boolean flag=false;
		String sqlstring="select name from person where id=? and password=?";
		DatabaseConnection dbc=null;
		PreparedStatement psmt=null;
		ResultSet rs=null;
		//数据库的操作
		try{
			dbc=new DatabaseConnection();
			psmt=dbc.getConnection().prepareStatement(sqlstring);
			psmt.setString(1,person.getId());
			psmt.setString(2, person.getPassword());
			rs=psmt.executeQuery();
			if(rs.next()){
				flag=true;
				person.setName(rs.getString(1));
			}
			rs.close();
			psmt.close();
		}catch(Exception e)
		{}
		finally{
			dbc.closeConnection();
		}
		return flag;
	}

}