package com.cric.onlineshopclothes.dao;

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

import com.cric.onlineshopclothes.javabean.Category;
import com.cric.onlineshopclothes.util.DBUtils;

public class ProductDAO {
public Category addCategoryParam(HttpServletRequest request, HttpServletResponse response){
		
		
	   Category category=new Category();
		
		String categoryName=request.getParameter("categoryName");
		//String categoryState=request.getParameter("categoryState");
		category.setCategoryName(categoryName==null?"":categoryName);
		category.setCategoryState("1");
		category.setUpdateTime("2009.1.1");
		//category.setCategoryState(categoryState==null?"":categoryState);
		
		return category;
	}
	public boolean insertCategory(Category category){
		boolean flag=false;	
		String sqlStr="insert into category values('"+category.getCategoryName()+"','"+category.getCategoryState()+"','"+category.getUpdateTime()+"')";
		System.out.println(sqlStr);
		DBUtils db=new DBUtils();
		flag=db.excuteUpdate(sqlStr);
		db.closeStmt();
		db.closeConnection();
		System.out.println(flag);
		
		return flag;
	}
}