secondleveltitle.java

新闻发布系统

package com.Bean;

import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import com.DB.DBConnection;

public class SecondLevelTitle
{
	private int secondTitleID;
	private String secondTitleName;
	private String filePath;
	private String creater;
	private String createTime;
	private int firstTitleID;
	
	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 getFirstTitleID() {
		return firstTitleID;
	}
	public void setFirstTitleID(int firstTitleID) {
		this.firstTitleID = firstTitleID;
	}
	public int getSecondTitleID() {
		return secondTitleID;
	}
	public void setSecondTitleID(int secondTitleID) {
		this.secondTitleID = secondTitleID;
	}
	public String getSecondTitleName() {
		return secondTitleName;
	}
	public void setSecondTitleName(String secondTitleName) {
		this.secondTitleName = secondTitleName;
	}
	//添加
	public boolean addSecondTitle(SecondLevelTitle second)
	{
		String str="insert into SecondLevelTitle values(?,?,?,?,?)";
		DBConnection db=new DBConnection();
		Connection c=db.getCon();
		Date time = new Date();
		SimpleDateFormat HMFromat = new SimpleDateFormat("yyyy-MM-dd");
		String strCurrentTime = HMFromat.format(time);
		try {
			db.ps=c.prepareStatement(str);
			//db.ps.setInt(1, this.secondTitleID);
			db.ps.setString(1, this.secondTitleName);
			db.ps.setString(2, this.filePath);
			db.ps.setString(3, this.creater);
			db.ps.setString(4, strCurrentTime);
			db.ps.setInt(5, this.firstTitleID);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//删除
	public boolean delSecondTitle(String sid)
	{
		String str="delete from SecondLevelTitle where SecondTitleID="+sid;
		DBConnection db=new DBConnection();
		db.getCon();
		try {
			db.st.executeUpdate(str);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//更新
	public boolean upSecondTitle(String sid)
	{
		DBConnection db=new DBConnection();
		Connection c=db.getCon();
		Date time=new Date();
		SimpleDateFormat HMFromat = new SimpleDateFormat("yyyy-MM-dd");
		String strCurrentTime = HMFromat.format(time);
		String str="update SecondLevelTitle set SecondTitleName=?, FilePath=?, creater=?, createTime=?, FirstTitleID=? where SecondTitleID="+sid;
		try {
			db.ps=c.prepareStatement(str);
			db.ps.setString(1, this.secondTitleName);
			db.ps.setString(2, this.filePath);
			db.ps.setString(3, this.creater);
			db.ps.setString(4, strCurrentTime);
			db.ps.setInt(5, this.firstTitleID);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//根据一级标题查询
	public ArrayList selSecondTitle(int oneID)
	{
		ArrayList arr=new ArrayList();
		String str="select * from SecondLevelTitle where FirstTitleID="+oneID+"  order by createTime desc";
		SecondLevelTitle second=null;
		DBConnection db=new DBConnection();
		db.getCon();
		try {
			db.rs=db.st.executeQuery(str);
			while(db.rs.next())
			{
				second=new SecondLevelTitle();
				second.setSecondTitleID(db.rs.getInt(1));
				second.setSecondTitleName(db.rs.getString(2));
				second.setFilePath(db.rs.getString(3));
				second.setCreater(db.rs.getString(4));
				second.setCreateTime(db.rs.getString(5));
				second.setFirstTitleID(db.rs.getInt(6));
				arr.add(second);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return arr;
	}
	//根据二级标题查询
	public ArrayList selSecondTitle()
	{
		ArrayList arr=new ArrayList();
		String str="select * from SecondLevelTitle order by createTime desc";
		SecondLevelTitle second=null;
		DBConnection db=new DBConnection();
		db.getCon();
		try {
			db.rs=db.st.executeQuery(str);
			while(db.rs.next())
			{
				second=new SecondLevelTitle();
				second.setSecondTitleID(db.rs.getInt(1));
				second.setSecondTitleName(db.rs.getString(2));
				second.setFilePath(db.rs.getString(3));
				second.setCreater(db.rs.getString(4));
				second.setCreateTime(db.rs.getString(5));
				second.setFirstTitleID(db.rs.getInt(6));
				arr.add(second);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return arr;
	}
}