firstleveltitle.java

新闻发布系统 jsp制作。可应用与毕业设计

package com.newsIssueSystem.javaBean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;

public class FirstLevelTitle {
	private int id;

	private String firstTitleName;

	private String createTime;

	private String creater;

	public String getCreater() {
		return creater;
	}

	public void setCreater(String creater) {
		this.creater = creater;
	}

	public String getCreateTime() {
		return createTime;
	}

	public void setCreateTime(String createTime) {
		this.createTime = createTime;
	}

	public String getFirstTitleName() {
		return firstTitleName;
	}

	public void setFirstTitleName(String firstTitleName) {
		this.firstTitleName = firstTitleName;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	/*
	 * 增加一级新闻
	 */
	public boolean insertFirstLevelTitle(FirstLevelTitle flt) {
		DBConnection con = new DBConnection();
		String sql = "insert into FirstLevelTitle values(?,?,?)";
		try {
			con.presta = con.getCon().prepareStatement(sql);
			con.presta.setString(1, flt.getFirstTitleName());
			con.presta.setString(2, new Date().toLocaleString());
			con.presta.setString(3, flt.getCreater());
			con.presta.executeUpdate();
			con.presta.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return false;
		}
		return true;
	}

	/*
	 * 更新所有
	 */
	public boolean updateFirstLevelTitle(FirstLevelTitle firstLevelTitle) {
		String sql = "update FirstLevelTitle set CreateTime='"
				+ firstLevelTitle.getCreateTime() + "' , Creater='"
				+ firstLevelTitle.getCreater() + "' where FirstTitleName='"
				+ firstLevelTitle.getFirstTitleName() + "'";
		DBConnection con = new DBConnection();
		try {
			con.presta = con.getCon().prepareStatement(sql);
			con.presta.executeUpdate();
			con.closeCon();
			return true;

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return false;
		}
	}

	/*
	 * 得到所有的一级新闻
	 */
	public ArrayList getAllFirstLevelTitle() {
		DBConnection con = new DBConnection();
		String sql = "select * from FirstLevelTitle";
		ArrayList lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				FirstLevelTitle a = new FirstLevelTitle();
				a.setId(con.rs.getInt(1));
				a.setFirstTitleName(con.rs.getString(2));
				a.setCreateTime(con.rs.getString(3));
				a.setCreater(con.rs.getString(4));
				lst.add(a);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return lst;
	}
	
	/*
	 * 得到所有的一级新闻
	 */
	public List getAllFirstLevelTitleName() {
		DBConnection con = new DBConnection();
		String sql = "select FirstTitleName from FirstLevelTitle";
		ArrayList lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				FirstLevelTitle a = new FirstLevelTitle();
				a.setId(con.rs.getInt(1));
				a.setFirstTitleName(con.rs.getString(2));
			
				lst.add(a);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return lst;
	}
	

	/*
	 * 得到一级新闻 在page之间(重载 +1）
	 */
	public List getFirstLevelTitle(int page, int pagesize) {
		DBConnection con = new DBConnection();
		String sql = "select top " + pagesize
				+ " * from FirstLevelTitle where id not in (select top "
				+ (page - 1) * pagesize + " id from FirstLevelTitle  ) ";
		List lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				FirstLevelTitle a = new FirstLevelTitle();
				a.setId(con.rs.getInt(1));
				a.setFirstTitleName(con.rs.getString(2));
				a.setCreateTime(con.rs.getString(3));
				a.setCreater(con.rs.getString(4));
				lst.add(a);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return lst;
	}

	/*
	 * 得到一级新闻条数
	 */
	public String getCount() {
		DBConnection con = new DBConnection();
		String sql = "select count(*) as c from FirstLevelTitle";
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}

		String count = null;
		if (con.rs != null) {
			try {

				while (con.rs.next()) {
					count = con.rs.getString(1);
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return count;
	}

	/*
	 * 根据标题id更新
	 */
	public boolean updateTitle(int id, String titlename, String creater) {
		String sql = "update FirstLevelTitle set FirstTitleName='" + titlename
				+ "',Creater='" + creater + "' where id=" + id + "";

		DBConnection con = new DBConnection();
		try {
			con.presta = con.getCon().prepareStatement(sql);
			con.presta.executeUpdate();
			con.closeCon();
			return true;

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return false;
		}
	}

	/*
	 * 删除
	 */
	public boolean deleteTitle(int id) {
		String sql = "delete from FirstLevelTitle where id="+id+" ";

		DBConnection con = new DBConnection();
		try {
			con.presta = con.getCon().prepareStatement(sql);
			con.presta.executeUpdate();
			con.closeCon();
			return true;

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return false;
		}
	}

}