customerregistdao.java

网上购物系统

package com.cric.onlineshopclothes.dao;

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

import com.cric.onlineshopclothes.javabean.Customer;
import com.cric.onlineshopclothes.javabean.User;
import com.cric.onlineshopclothes.util.DBUtils;



public class CustomerRegistDAO {
public Customer registParam(HttpServletRequest request, HttpServletResponse response){
		
		
		Customer customer=new Customer();
		
		String userName=request.getParameter("CustomerRegistName");
		String passWord=request.getParameter("CustomerRegistPassword");
		String sex=request.getParameter("sex");
		String email=request.getParameter("email");
		String address=request.getParameter("address");
		String contact=request.getParameter("contact");
		
		
		customer.setCustomerName(userName==null?"":userName);
		customer.setCustomerPass(passWord==null?"":passWord);
		customer.setSex(sex==null?"":sex);
		customer.setEmail(email==null?"":email);
		customer.setAddress(address==null?"":address);
		customer.setContact(contact==null?"":contact);
		
		
		return customer;
	}
	public boolean insertUser(Customer customer){
		boolean flag=false;	
		String sqlStr="insert into customer values('"+customer.getCustomerName()+"','"+customer.getCustomerPass()+"','"+customer.getSex()+"','"+customer.getEmail()+"','"+customer.getAddress()+"','"+customer.getContact()+"')";
		System.out.println(sqlStr);
		DBUtils db=new DBUtils();
		flag=db.excuteUpdate(sqlStr);
		db.closeStmt();
		db.closeConnection();
		System.out.println(flag);
		
		return flag;
	}
}