managelogindao.java

网上购物系统

package com.cric.onlineshopclothes.dao;


import java.sql.ResultSet;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.cric.onlineshopclothes.javabean.User;
import com.cric.onlineshopclothes.util.DBUtils;


public class ManageLoginDAO {
	 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;
		 
		 
	 }
	 public boolean checkLoginParam(User user){
		 	 
		 boolean flag=false;
		 

		   //在数据库中查找是否有匹配的用户名和密码
		   String strSql="select * from admin where userName='"+user.getUserName()+"' and passWord='"+user.getPassWord()+"'";
		   System.out.println(strSql);
		   DBUtils db=new DBUtils();
		   //返回结果集
		   ResultSet rs=db.excuteQuery(strSql);
		   System.out.println("111");
		  
		   try {
			if(rs.next()){
				   flag=true;
			   }else{
				   flag=false;
			   }
		   } catch (Exception e) {
			e.printStackTrace();
			
		   }
		   System.out.print(flag);
		   return flag;  
	   }
	 
	 

}