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; } }