package cn.edu.chu.category;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;

import cn.edu.chu.user.User;
import cn.edu.chu.util.DB;

public class Category {
	private int id;
	private String name;
	private String descr;
	private int pid;
	private int cno;
	private int grade;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getDescr() {
		return descr;
	}
	public void setDescr(String descr) {
		this.descr = descr;
	}
	public int getPid() {
		return pid;
	}
	public void setPid(int pid) {
		this.pid = pid;
	}
	public int getCno() {
		return cno;
	}
	public void setCno(int cno) {
		this.cno = cno;
	}
	public int getGrade() {
		return grade;
	}
	public void setGrade(int grade) {
		this.grade = grade;
	}
	
	public static void add(Category c){
		CategoryDAO.save(c);
	}
	
	public  void delete(){
		CategoryDAO.delete(this.id,this.pid);
	}
	public  static void deleteCategory(int id){
		CategoryDAO.delete(id);
	}
	
	public static void addTopCategory(int pid,String name,String descr){
System.out.println("name:"+name+"descr:"+descr);
		Category c=new Category();
		c.setId(-1);
		c.setName(name);
		c.setDescr(descr);
		c.setPid(pid);
		c.setCno(1);
		c.setGrade(1);
		CategoryDAO.save(c);
		//add(c);
	}
	
	public static void addChildCategory(int pid,String name,String descr,int grade){
System.out.println("Grade:"+grade);
		Category c=new Category();
		c.setId(-1);
		c.setPid(pid);
		c.setName(name);
		c.setDescr(descr);
		c.setCno(1);
		c.setGrade(grade);
		CategoryDAO.save(c);
		//add(c);
	}
	
	
	
	/*public static void addTopCategory(int pid,String name,String descr){
		CategoryDAO.addChildCategory(pid);
	}
	*/
	public static List<Category> getCategories(){ 
		List<Category> list=new ArrayList<Category>();
		CategoryDAO.getCategories(list);
		/*Debug Line
		 * for(int i=0;i<list.size();i++){
			Category c=list.get(i);
			System.out.println(c.getName());
		}
		*/
		return list;
	}
	
	public static List<Category> getCategories(int id){ 
		List<Category> list=new ArrayList<Category>();
		CategoryDAO.getCategories(list,id);		
		return list;
	}
	
	public static List<Category> getCategoriesTree(int id){ 
		List<Category> list=new ArrayList<Category>();
		CategoryDAO.getCategoriesTree(list,id);		
		return list;
	}

	
}