persondaoimpl.java

网站 JSP 实现的 银行系统 数据库用的ORA啊 功能全

package ly.impl ;

import ly.dbc.* ;
import ly.vo.* ;
import java.sql.* ;
import ly.dao.* ;
public class personDAOImpl implements personDAO
{
	public boolean login(personVO pv) throws Exception
	{
		boolean flag = false ;
		String sql = "select xm from person where yhm=? and yhmm=?" ;
		PreparedStatement pstmt = null ;
		DBConnection dbc= null ;
		dbc= new DBConnection();

		try
		{
			pstmt = dbc.getConnection().prepareStatement(sql);
			pstmt.setString(1,pv.getName()) ;
			pstmt.setString(2,pv.getPassword());
			ResultSet rs = pstmt.executeQuery();

			if (rs.next())
			{
				flag = true ;
				pv.setXm(rs.getString(1)) ;
			}
			rs.close();
			pstmt.close();
		}
		catch (Exception e)
		{
			e.printStackTrace() ;
		}
		finally
		{
			dbc.close();
		}
		return flag ;
	}
}