package com.cric.onlineshopclothes.dao;

import java.sql.Date;
import java.text.SimpleDateFormat;

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");
	    SimpleDateFormat format=new SimpleDateFormat();
	    String ctime=format.format(new Date(0));
	    
	
		category.setCategoryName(categoryName==null?"":categoryName);
		category.setCategoryState(categoryState);
		category.setUpdateTime(ctime);
		//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;
	}
}