firstleveltitlelogicoperation.java

新闻发布系统

package logic;

import java.sql.*;
import java.util.*;
import java.text.SimpleDateFormat;
import beans.FirstLevelTitle;
import manager.ConnectionManager;

public class FirstLevelTitleLogicOperation {
	/**
	 * insert a row into FirstLevelTitle table.
	 * @param fTitle FirstLevelTitle
	 * @return int
	 */
	public int insertOneRecord(FirstLevelTitle fTitle) {
	    int result = 0;
	    Connection con = null;
	    PreparedStatement pStatement = null;

	    try {
	      java.util.Date currentTime = new java.util.Date();
	      SimpleDateFormat HMFromat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
	      String strCurrentTime = HMFromat.format(currentTime);

	      con = ConnectionManager.getConnction();
	      String sqlstr =
	          "insert into FirstLevelTitle values(?,?,?,?)";
	      pStatement = con.prepareStatement(sqlstr);
	      pStatement.setInt(1, getNewId());
	      pStatement.setString(2, fTitle.getTitleName());
	      pStatement.setString(3, fTitle.getCreater());
	      pStatement.setString(4, strCurrentTime);
	      //excute update
	      result = pStatement.executeUpdate();
	    } catch (SQLException sqlE) {
	      sqlE.printStackTrace();
	    } finally {
	      ConnectionManager.closeStatement(pStatement);
	      ConnectionManager.closeConnection(con);
	    }
	    return result;
	 }

	/**
	 * create a new  id of FirstLevelTitle.
	 * @return int
	 */
	private int getNewId() {
	    int id = 0;
	    Connection con = null;
	    PreparedStatement pstmt = null;
	    ResultSet rs = null;
	    try {
	      con = ConnectionManager.getConnction();
	      // 查询数据SQL语句
	      String sqlstr = "select max(id) from FirstLevelTitle";
	      //查询操作
	      pstmt = con.prepareStatement(sqlstr);
	      rs = pstmt.executeQuery();
	      if (rs.next()) {
	        id = rs.getInt(1);
	      }
	    } catch (Exception e) {
	      e.printStackTrace();
	    } finally {
	      ConnectionManager.closeResultSet(rs);
	      ConnectionManager.closeStatement(pstmt);
	      ConnectionManager.closeConnection(con);
	    }
	    return id + 1;
	}
	
	/**
	 * get all first level title list.
	 * @return ArrayList
	 */
	public ArrayList getAllFirstLevelTitleList() {
		ArrayList list  = new ArrayList();
		Connection con = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
	        con = ConnectionManager.getConnction();
	        // 查询数据SQL语句
	        String sqlstr = "select * from FirstLevelTitle order by CreateTime desc";
	        // 查询操作
	        pstmt = con.prepareStatement(sqlstr);
	        rs = pstmt.executeQuery();
	        while (rs.next()) {
	          FirstLevelTitle fTitle = new FirstLevelTitle();
	          fTitle.setId(rs.getInt("id"));
	          fTitle.setTitleName(rs.getString("TitleName"));
	          fTitle.setCreater(rs.getString("Creater"));
	          fTitle.setCreateTime(rs.getDate("CreateTime"));
	          list.add((Object)fTitle);
	        }
		} catch(SQLException e) {
	        e.printStackTrace();
		} finally {
			ConnectionManager.closeResultSet(rs);
	        ConnectionManager.closeStatement(pstmt);
	        ConnectionManager.closeConnection(con);
		}
		return list;
	}
}