package cn.xwkj.dao;

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

import cn.xwkj.entity.Cate;
import cn.xwkj.entity.User;


public class CateDao extends BaseDao {

	// 查询方法(返回结果用集合存储)
		public List<Cate> list(String sql, Object... param){
			List<Cate> list=new ArrayList<Cate>();
			ResultSet rs=executeQuery(sql, param);
			try {
				while(rs.next())
				{
					Cate c=new Cate();
					c.setId(rs.getInt(1));
					c.setcName(rs.getString(2));
					list.add(c);
				}
				return list;
			} catch (SQLException e) {
				e.printStackTrace();
			}
			finally
			{
				closeAll();
			}
			return null;
		}
		
		/**
		 * id查询
		 * @param sql
		 * @param param
		 * @return
		 */
		public List<Cate> list(String sql, int id){
			List<Cate> list=new ArrayList<Cate>();
			ResultSet rs=executeQuery(sql, id);
			try {
				while(rs.next())
				{
					Cate c=new Cate();
					c.setcName(rs.getString(1));
					list.add(c);
				}
				return list;
			} catch (SQLException e) {
				e.printStackTrace();
			}
			finally
			{
				closeAll();
			}
			return null;
		}
		
		/**
		 * 添加
		 */
		public int add(String sql, Cate cate) {
			Object [] param = {cate.getcName()};
			return executeUpdate(sql, param);
		}
		/**
		 * 删除
		 * @param sql
		 * @param id
		 * @return
		 */
		public int delete(String sql, int id) {
			
			return executeUpdate(sql, id);
		}
		/**
		 * 修改
		 * @param sql
		 * @param cate
		 * @return
		 */
		public int Update(String sql, Cate cate) {
			Object [] param = {cate.getcName(),cate.getId()};
			return executeUpdate(sql, param);
		}
}