userdaoimpl.java

超市进销存系统,采用mvc+DAO模式编写

package mybaobao;

import java.sql.*;
public class UserDAOImpl implements UserDAO {

	public boolean islogin(User user) throws Exception{
		
		boolean flag=false;
		String sql="select * from user where id=? and password=?";
		PreparedStatement pstmt = null ;
		DBConnection dbc =new DBConnection();
		try
		{
			pstmt = dbc.getConnection().prepareStatement(sql) ;
			pstmt.setString(1, user.getId());
			pstmt.setString(2,user.getPassword()) ;
			ResultSet rs = pstmt.executeQuery() ;
			if(rs.next())
			{
				flag = true ;
				
			}
			rs.close() ;
			pstmt.close() ;
		}
		catch (Exception e)
		{
			throw new Exception("操作出现错误！！！") ;
		}
		finally
		{
			dbc.close() ;
		}
		
		return flag ;
	
	}

}