secondleveltitle.java

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

package com.newsIssueSystem.javaBean;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SecondLevelTitle {
	private int id;

	private String secondTitleName;

	private String createTime;

	private String creater;

	private String filePath;

	private int parentTitleid;
	
	private String parentTitleName;

	

	/*
	 * 得到所有列表
	 */
	public ArrayList getAllSecondLevelTitle() {
		DBConnection con = new DBConnection();
		String sql = "select SecondtLevelTTitle.*, FirstLevelTitle.FirstTitleName from SecondtLevelTTitle inner join FirstLevelTitle on FirstLevelTitle.id=SecondtLevelTTitle.ParentTitleid";
		ArrayList lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				SecondLevelTitle b = new SecondLevelTitle();
				b.setId(con.rs.getInt(1));
				b.setSecondTitleName(con.rs.getString(2));
				b.setCreateTime(con.rs.getString(3));
				b.setCreater(con.rs.getString(4));
				b.setFilePath(con.rs.getString(5));
				b.setParentTitleid(con.rs.getInt(6));
				b.setParentTitleName(con.rs.getString(7));
				
				lst.add(b);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return lst;
	}
	
	
	/*
	 * 得到所有在一级新闻中的二级新闻列表
	 */
	public ArrayList getAllSecondLevelTitle(int fid) {
		DBConnection con = new DBConnection();
		String sql = "select SecondtLevelTTitle.*, FirstLevelTitle.FirstTitleName from SecondtLevelTTitle inner join FirstLevelTitle on FirstLevelTitle.id=SecondtLevelTTitle.ParentTitleid where SecondtLevelTTitle.ParentTitleid="+fid;
		ArrayList lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				SecondLevelTitle b = new SecondLevelTitle();
				b.setId(con.rs.getInt(1));
				b.setSecondTitleName(con.rs.getString(2));
				b.setCreateTime(con.rs.getString(3));
				b.setCreater(con.rs.getString(4));
				b.setFilePath(con.rs.getString(5));
				b.setParentTitleid(con.rs.getInt(6));
				b.setParentTitleName(con.rs.getString(7));
				lst.add(b);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return lst;
	}
	
	/*
	 * 得到所有在一级新闻中的二级新闻列表
	 */
	public int getCount(int fid) {
		DBConnection con = new DBConnection();
		String sql = "select count(*) from SecondtLevelTTitle where ParentTitleid="+fid;
		ArrayList lst = new ArrayList();
		int count =0;
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				 count=con.rs.getInt(1);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return -1;
		}
		return count;
	}
	

	/*
	 * 增加二级新闻
	 */
	public boolean insertSecondLevelTitle(SecondLevelTitle slt) {
		DBConnection con = new DBConnection();
		String sql = "insert into SecondtLevelTTitle values(?,?,?,?,?)";
		try {
			con.presta = con.getCon().prepareStatement(sql);
			con.presta.setString(1, slt.getSecondTitleName());
			con.presta.setString(2, slt.getCreateTime());
			con.presta.setString(3, slt.getCreater());
			con.presta.setString(4, slt.getFilePath());
			con.presta.setInt(5, slt.getParentTitleid());
			con.presta.executeUpdate();
			con.presta.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return false;
		}
		return true;
	}

	/*
	 * 得到二级新闻 在page之间(重载 +1）
	 */
	public List getSecondLevelTitle(int page, int pagesize) {
		DBConnection con = new DBConnection();
		String sql = "select top " + pagesize
				+ " SecondtLevelTTitle.*, FirstLevelTitle.FirstTitleName from SecondtLevelTTitle inner join FirstLevelTitle on FirstLevelTitle.id=SecondtLevelTTitle.ParentTitleid where SecondtLevelTTitle.id not in (select top "
				+ (page - 1) * pagesize + " id from SecondtLevelTTitle  ) ";
		List lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				SecondLevelTitle b = new SecondLevelTitle();
				b.setId(con.rs.getInt(1));
				b.setSecondTitleName(con.rs.getString(2));
				b.setCreateTime(con.rs.getString(3));
				b.setCreater(con.rs.getString(4));
				b.setFilePath(con.rs.getString(5));
				b.setParentTitleid(con.rs.getInt(6));
				b.setParentTitleName(con.rs.getString(7));
				lst.add(b);
			}
			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 SecondtLevelTTitle";
		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 filepath, int parentid) {
		String sql = "update SecondtLevelTTitle set SecondTitleName='"
				+ titlename + "',CreateTime='" + new Date().toLocaleString()
				+ "',FilePath='" + filepath + "',ParentTitleid='" + parentid
				+ "',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 SecondtLevelTTitle 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 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 getFilePath() {
		return filePath;
	}


	public void setFilePath(String filePath) {
		this.filePath = filePath;
	}


	public int getId() {
		return id;
	}


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


	public int getParentTitleid() {
		return parentTitleid;
	}


	public void setParentTitleid(int parentTitleid) {
		this.parentTitleid = parentTitleid;
	}


	public String getParentTitleName() {
		return parentTitleName;
	}


	public void setParentTitleName(String parentTitleName) {
		this.parentTitleName = parentTitleName;
	}


	public String getSecondTitleName() {
		return secondTitleName;
	}


	public void setSecondTitleName(String secondTitleName) {
		this.secondTitleName = secondTitleName;
	}

}