package com.cric.onlineshopclothes.dao;

import java.util.Date;
import java.text.SimpleDateFormat;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

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

import com.cric.onlineshopclothes.javabean.Category;
import com.cric.onlineshopclothes.javabean.Product;
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("yyyy年MM月dd日 HH:mm:ss");
	    String ctime=format.format(new Date());
	    
	
		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;
	}
	
	public List getAllCategory(){
		DBUtils db=new DBUtils();
		List list=new ArrayList();
		String sql="select * from category";
		try{
			ResultSet rs=db.excuteQuery(sql);
			while(rs.next()){
				Category category=new Category();
				category.setCategoryId(rs.getInt("categoryId"));
				category.setCategoryName(rs.getString("categoryName"));
				category.setCategoryState(rs.getString("categoryState"));
				category.setUpdateTime(rs.getString("updateTime"));
				list.add(category);
				
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		return list;
	}
	
	public List getCategoryByUsername(String categoryName){
		DBUtils db=new DBUtils();
		List list=new ArrayList();
		String sql="select * from category where categoryName like '%"+categoryName+"%'";
		try{
			ResultSet rs=db.excuteQuery(sql);
			while(rs.next()){
				Category category=new Category();
				category.setCategoryId(rs.getInt("categoryId"));
				category.setCategoryName(rs.getString("categoryName"));
				category.setCategoryState(rs.getString("categoryState"));
				category.setUpdateTime(rs.getString("updateTime"));
				list.add(category);
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		return list;
	}
	
	public List getProductCategory(){
		DBUtils db=new DBUtils();
		List list=new ArrayList();
		String sql="select * from category" ;
		try{
			ResultSet rs=db.excuteQuery(sql);
			while(rs.next()){
				Category category=new Category();
				category.setCategoryId(rs.getInt("categoryId"));
				category.setCategoryName(rs.getString("categoryName"));
				category.setCategoryState(rs.getString("categoryState"));
				category.setUpdateTime(rs.getString("updateTime"));
				list.add(category);
				
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		return list;
	}
	
	public boolean insertProduct(Product product){
		boolean flag=false;
		DBUtils db=new DBUtils();
		String sqlStr="insert into product(" +
		        "categoryId," +
				"PName," +
				"Detail," +
				"InPrice," +
				"OutPrice," +
				"Amount," +
				"Picture,"+
				"State," +
				"ProductTime," +
				" Hot," +
				"SaledAmount) " +
				"values('"+
				        +product.getPName()+"'," +
						"'"+product.getDetail()+"',"
						+product.getInPrice()+","
						+product.getOutPrice()+",'"
						+product.getAmount()+"',"
						+product.getPicture()+"',"
						+product.getState()+"',"
						+product.getProductTime()+"',"
						+product.getHot()+"',"
						+product.getSaledAmount()+")";
		flag=db.excuteUpdate(sqlStr);
		return flag;
	}
	
}