新闻标题发布（包含一级、二级新闻标题）

package com.news; import java.sql.*; import java.text.SimpleDateFormat; import java.util.*; import java.util.Date; public class FirstLeveTitleDbOpreation { /** * 从数据库中取出所有的新闻一级标题 * @return List 新闻一级标题的集合 */ public List getAllFirstLevelTitleList() { ArrayList list = new ArrayList(); Connection dbConnection = null; PreparedStatement pStatement = null; ResultSet res = null; try { dbConnection = ConnectionManager.getConnection(); String strSql = "select * from FirstLevelTitle order by CreateTime desc"; pStatement = dbConnection.prepareStatement(strSql); res = pStatement.executeQuery(); while (res.next()) { int id = res.getInt("id"); String title = res.getString("TitleName"); String creater = res.getString("Creator"); java.util.Date time = res.getDate("CreateTime"); //把各属性的值封装在一个FirstLevelTitle对象中 FirstLevelTitle fTitle = new FirstLevelTitle(id,title,creater,time); //把各FirstLevelTitle对象依次添加进集合中 list.add(fTitle); } } catch (SQLException sqlE) { sqlE.printStackTrace(); } finally { ConnectionManager.closeResultSet(res); ConnectionManager.closeStatement(pStatement); ConnectionManager.closeConnection(dbConnection); } return list; } /** * 向数据库中插入一条新闻一级标题 * @param 已封装好各属性值的FirstLevelTitle对象 * @return int 插入数据的行数 */ public int insertOneRecord(FirstLevelTitle fTitle) { int result = 0; Connection con = null; PreparedStatement pStatement = null; try { SimpleDateFormat HMFromat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String strCurrentTime = HMFromat.format( new Date()); con = ConnectionManager.getConnection(); String strSql = "insert into FirstLevelTitle values(?,?,?,?)"; pStatement = con.prepareStatement(strSql); pStatement.setInt(1, getNewId()); pStatement.setString(2, fTitle.getTitleName()); pStatement.setString(3, fTitle.getCreator()); pStatement.setString(4, strCurrentTime); result = pStatement.executeUpdate(); } catch (SQLException sqlE) { sqlE.printStackTrace(); } finally { ConnectionManager.closeStatement(pStatement); ConnectionManager.closeConnection(con); } return result; } /** * 从数据库中获取新闻一级标题表中最大的ID，并对它加一 * @return int 新的新闻一级标题ID */ private int getNewId() { int id = 0; Connection con = null; PreparedStatement pstmt = null; ResultSet resSet = null; try { con = ConnectionManager.getConnection(); String sqlStr = "select max(id) from FirstLevelTitle "; pstmt = con.prepareStatement(sqlStr); resSet = pstmt.executeQuery(); if (resSet.next()) { id = resSet.getInt(1); } }catch (Exception e) { e.printStackTrace(); }finally { ConnectionManager.closeResultSet(resSet); ConnectionManager.closeStatement(pstmt); ConnectionManager.closeConnection(con); } return id + 1; } // public static void main(String args[]){ // FirstLeveTitleDbOpreation ft=new FirstLeveTitleDbOpreation(); // List l=ft.getAllFirstLevelTitleList(); // for(int i=1 ;i<l.size();i++){ // FirstLevelTitle fTitle=(FirstLevelTitle)l.get(i); // System.out.println(fTitle.getTitleName()); // } // } }