• 新闻发布项目——数据实现类(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;
    	}
    	
    }
    

  • 相关阅读:
    移动端常用状态
    css 动画
    jQuery源码解析 -- 概述
    Bearer Token && JWT --- 深入理解令牌机制
    字符串 ----> switch-case 语句
    Vuejs选项: provide/inject
    本地windows系统-》windows云服务器文件上传
    CSS基础点
    函数的调用 与 this
    两个有意思的网站
  • 原文地址:https://www.cnblogs.com/a1111/p/6540325.html
Copyright © 2020-2023  润新知