news.rar_jsp 新闻发布_jsp 新闻发布系统_jsp 源码_jsp 鏂伴椈_news jsp

package com.accp.lqc.news.model.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import com.accp.lqc.news.model.entity.oneNews; import com.accp.lqc.news.model.entity.twoNews; public class twoNewsDAO { /*** * 添加2级标题 * @param two * @return */ public static int addTwo(twoNews two) { Connection con=null; PreparedStatement pstmt=null; int count=0; try { con=DBUtil.getCon(); String sql="insert into SecondLevelTitle values(?,?,?,?,?)"; pstmt=con.prepareStatement(sql); pstmt.setString(1, two.getTitleName()); pstmt.setString(2, two.getFilePath()); pstmt.setString(3, two.getCreater()); pstmt.setString(4, two.getCreatTime()); pstmt.setInt(5, two.getParentTitle()); count=pstmt.executeUpdate(); } catch(Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(null, pstmt, con); } return count; } /*** * 查询2级标题 * @return */ public static ArrayList gettwoAll() { ArrayList list = null; Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; try { con = DBUtil.getCon(); String sql = "select * from SecondLevelTitle"; pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); list = new ArrayList(); while(rs.next()) { twoNews two = new twoNews(); two.setId(rs.getInt("id")); two.setTitleName(rs.getString("titleName")); two.setFilePath(rs.getString("filePath")); two.setCreater(rs.getString("creater")); two.setCreatTime(rs.getString("creatTime")); two.setParentTitle(rs.getInt("parentTitle")); list.add(two); } } catch (Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(rs, pstmt, con); } return list; } /*** * 根据ID查询2级信息 * @param id * @return */ public static twoNews queryBytwoId(int id) { Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; twoNews two = null; try { con = DBUtil.getCon(); String sql = "select * from SecondLevelTitle where id = ?"; pstmt = con.prepareStatement(sql); pstmt.setInt(1, id); rs = pstmt.executeQuery(); if(rs.next()) { //next():游标向下移动 two = new twoNews(); two.setId(rs.getInt("id")); two.setTitleName(rs.getString("titleName")); two.setFilePath(rs.getString("filePath")); two.setCreater(rs.getString("creater")); two.setCreatTime(rs.getString("creatTime")); two.setParentTitle(rs.getInt("parentTitle")); } } catch (Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(rs, pstmt, con); } return two; } /*** * 2级标题删除 * @param id * @return */ public static int deleteTwonews(String id) { Connection con = null; PreparedStatement pstmt = null; int Count = 0; try { con = DBUtil.getCon(); String sql = "delete from SecondLevelTitle where id = ?"; pstmt = con.prepareStatement(sql); pstmt.setString(1, id); Count = pstmt.executeUpdate(); } catch (Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(null, pstmt, con); } return Count; } /*** * 修改2级标题 * @param one * @return */ public static int updateTwonews(twoNews two) { Connection con = null; PreparedStatement pstmt = null; int Count = 0; try { con = DBUtil.getCon(); String sql = "update SecondLevelTitle set TitleName=?,filePath=?,parentTitle=? where id = ?"; pstmt = con.prepareStatement(sql); pstmt.setString(1,two.getTitleName()); pstmt.setString(2,two.getFilePath()); pstmt.setInt(3,two.getParentTitle()); pstmt.setInt(4,two.getId()); Count = pstmt.executeUpdate(); } catch (Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(null, pstmt, con); } return Count; } /*** * * @param parent * @return */ /* public static twoNews queryByParent(int parent) { Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; twoNews two = null; try { con = DBUtil.getCon(); String sql = "select TitleName from SecondLevelTitle where ParentTitle=?"; pstmt = con.prepareStatement(sql); pstmt.setInt(1, parent); rs = pstmt.executeQuery(); if(rs.next()) { //next():游标向下移动 two = new twoNews(); two.setTitleName(rs.getString("titleName")); //two.setParentTitle(rs.getInt("ParentTitle")); } } catch (Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(rs, pstmt, con); } return two; }*/ /** * 获得指定页的记录 * @param pages：第几页 * @param pageSize：每一页的大小 * @return */ public static ArrayList getPageResults(int pages, int pageSize) { Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; ArrayList list = null; try { con = DBUtil.getCon(); String sql = "select top " + pageSize + " * from SecondLevelTitle where id not in (select top " + (pages - 1) * pageSize + " id from SecondLevelTitle)"; pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); list = new ArrayList(); while(rs.next()) { twoNews two=new twoNews(); two.setId(rs.getInt("id")); two.setTitleName(rs.getString("titleName")); two.setFilePath(rs.getString("filePath")); two.setCreater(rs.getString("creater")); two.setCreatTime(rs.getString("creatTime")); two.setParentTitle(rs.getInt("parentTitle")); list.add(two); } } catch (Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(rs, pstmt, con); } return list; } /** * 获得总的记录条数 * @return */ public static int getRows() { Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; int rows = 0; try { con = DBUtil.getCon(); String sql = "select count(*) from SecondLevelTitle"; pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); if(rs.next()) { rows = rs.getInt(1); } } catch (Exception ex) { ex.printStackTrace(); } finally { DBUtil.closeCon(rs, pstmt, con); } return rows; } /*** * 总的页数 * @param pageSize * @return */ public static int getTotalPages(int pageSize) { int totalPage = 0; int rows = getRows(); int temp = 0; temp = rows % pageSize; if(temp == 0) { totalPage = rows / pageSize; } else { totalPage = rows / pageSize + 1; } return totalPage; } }