logindao.java

来自「网上购物书店。包括购物车」· Java 代码 · 共 57 行

package com.cric.onlineshop.dao;

import java.sql.ResultSet;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cric.onlineshop.javabean.User;
import com.cric.onlineshop.util.DBUtils;
/**
 * 
 * @author feng
 * @version1.0
 *
 */
public class LoginDAO {
	/**
	 * 获得登陆页面参数
	 * @param request
	 * @param response
	 * @return User
	 */
	public User getLoginParam(HttpServletRequest request, HttpServletResponse response){
		String userName=request.getParameter("userName");
		String passWord=request.getParameter("passWord");
		
		User user=new User();
		user.setUserName(userName);
		user.setPassWord(passWord);
		
		return user;
	}
	/**
	 * 验证用户是否存在
	 * @param user
	 * @return
	 */
	public boolean checkLoginParam(User user){
		boolean flag=false;
		
		String strSql="select * from shopuser where username='"+user.getUserName()+"' and password='"+user.getPassWord()+"'";
		DBUtils db=new DBUtils();
		ResultSet rs=db.excuteQuery(strSql);
		try{
			if(rs.next()){
				flag=true;
			}else{
				flag=false;
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return flag;
	}
	
}