新闻发布项目——数据实现类（categoryTBDaoImpl）

package bdqn.newsMange.Dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import bdqn.newsMange.Dao.BaseDao;
import bdqn.newsMange.Dao.categoryTBDao;
import bdqn.newsMange.entity.categoryTB;
/**
 * 新闻类别实现类
 * 
 * @author Administrator
 * 
 */
public class categoryTBDaoImpl extends BaseDao implements categoryTBDao {
  // 查询
  public List<categoryTB> getCategoryTBAll() {
    String sql = "select categoryID,categoryName  from categoryTB";
    List<categoryTB> typelist = new ArrayList<categoryTB>();
    try {
      ResultSet rs = executeQurey(sql, null);
      while (rs.next()) {
        categoryTB cate = new categoryTB();
        cate.setCategoryID(rs.getInt(1));
        cate.setCategoryName(rs.getString(2));
        typelist.add(cate);
      }
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      closeAll();
    }
    return typelist;
  }
  // 添加
  public int addCategory(categoryTB cate) {
    int rel = 0;
    String sql = "insert categoryTB (categoryName) values(?)";
    List<Object> prams = new ArrayList<Object>();
    prams.add(cate.getCategoryName());
    try {
      rel = executeUpdate(sql, prams);
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      closeAll();
    }
    return rel;
  }
  // 修改
  public int updateCategory(categoryTB cate) {
    int rel = 0;
    String sql = "update categoryTB set categoryName=? where categoryId=?";
    List<Object> prams = new ArrayList<Object>();
    prams.add(cate.getCategoryName());
    prams.add(cate.getCategoryID());                
    try {
      rel = executeUpdate(sql, prams);
    } catch (ClassNotFoundException e) {
      e.printStackTrace();
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      closeAll();
    }
    return rel;
  } 
  // 删除
  public int delCategory(int id) {
    int rel = 0;
    String sql = "delete from categoryTB where categoryId=?";
    List<Object> prams = new ArrayList<Object>();
    prams.add(id);
    try {
      rel = executeUpdate(sql, prams);
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      closeAll();
    }
    return rel;
  }
  // 根据类别查询
  public categoryTB getCateByName(String catename) {
    categoryTB cate = null;
    String sql = "select categoryID,categoryName  from categoryTB where categoryName=?";
    List<Object> prams = new ArrayList<Object>();
    prams.add(catename);
    try {
      ResultSet rs = executeQurey(sql, prams);
      while (rs.next()) {
        cate = new categoryTB();
        cate.setCategoryID(rs.getInt("categoryId"));
        cate.setCategoryName(rs.getString("categoryName"));
      }
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      closeAll();
    }
    return cate;
  }
  // 获取类别，根据id
  public categoryTB getCateById(int id) {
    categoryTB cate = null;
    String sql = "select categoryID,categoryName  from categoryTB where categoryId=?";
    List<Object> prams = new ArrayList<Object>();
    prams.add(id);
    try {
      ResultSet rs = executeQurey(sql, prams);
      if (rs.next()) {
        cate = new categoryTB();
        cate.setCategoryID(rs.getInt(1));
        cate.setCategoryName(rs.getString(2));
      }
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      closeAll();
    }
    return cate;
  }
  public int categoryId(String categoryName) {
    int rel=0;
    String sql="select categoryID,CategoryName from categoryTB where categoryName=?";
    List<Object>prams=new ArrayList<Object>();
    prams.add(categoryName);
    ResultSet rs=null;
    try {
       rs=executeQurey(sql, prams);
      if(rs.next()){
        categoryTB cate=new categoryTB();
        cate.setCategoryID(rs.getInt("CategoryID"));
        cate.setCategoryName(rs.getString("CategoryName"));
      }
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }finally{
      closeAll();
    }
    
    return rel;
  }
  
}