secondleveltitle.java

新闻发布系统

package com.mynews;

import java.sql.*;
import java.util.ArrayList;

public class SecondLevelTitle {
	private int id;
	private String titleName ;
	private String filePath;
	private int creater;
	private Date creatTime;
	private int parentTitle;
	public int getCreater() {
		return creater;
	}
	public void setCreater(int creater) {
		this.creater = creater;
	}
	public Date getCreatTime() {
		return creatTime;
	}
	public void setCreatTime(Date creatTime) {
		this.creatTime = creatTime;
	}
	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 getParentTitle() {
		return parentTitle;
	}
	public void setParentTitle(int parentTitle) {
		this.parentTitle = parentTitle;
	}
	public String getTitleName() {
		return titleName;
	}
	public void setTitleName(String titleName) {
		this.titleName = titleName;
	}
	
	public boolean addSecond(){  //添加一个二级标题
		String sql = "insert into SecondLevelTitle(TitleName,FilePath,Creater,ParentTitle) values(?,?,?,?)";
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.prs = db.con.prepareStatement(sql);
			db.prs.setString(1, this.getTitleName());
			db.prs.setString(2, this.getFilePath());
			db.prs.setInt(3, this.getCreater());
			//db.prs.setDate(4, this.getCreatTime());
			db.prs.setInt(4, this.getParentTitle());
			db.prs.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	public boolean updateSecond(){   //修改一个二级标题
		String sql = "update SecondLevelTitle set TitleName=?,FilePath=?,Creater=?, ParentTitle=? where Id=?";
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.prs = db.con.prepareStatement(sql);
			db.prs.setString(1, this.getTitleName());
			db.prs.setString(2, this.getFilePath());
			db.prs.setInt(3, this.getCreater());
			db.prs.setInt(4, this.getParentTitle());
			db.prs.setInt(5, this.getId());
			db.prs.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	public ArrayList selectAllSecond(String condiction,boolean t){   //查询所有二级标题的信息
		String sql = "";
		if (t){
			 sql = "select * from SecondLevelTitle where " + condiction;
		}else{
			sql = "select * from SecondLevelTitle where ParentTitle = " + condiction;
		}
		ArrayList list = new ArrayList();
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.sta = db.con.createStatement();
			db.rs = db.sta.executeQuery(sql);
			SecondLevelTitle  second = null; 
			while(db.rs.next()){
				second = new SecondLevelTitle();
				second.setId(db.rs.getInt(1));
				second.setTitleName(db.rs.getString(2));
				second.setFilePath(db.rs.getString(3));
				second.setCreater(db.rs.getInt(4));
				second.setCreatTime(db.rs.getDate(5));
				second.setParentTitle(db.rs.getInt(6));
				list.add(second);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return list;
	}
	
	public boolean deleteSecond(int id){  //删除一个二级标题
		String sql = "delete SecondLevelTitle where Id = "+id+"";
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.sta = db.con.createStatement();
			db.sta.execute(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	public boolean deleteSecondParent(int id){  //删除一个二级标题
		String sql = "delete SecondLevelTitle where ParentTitle = "+id+"";
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.sta = db.con.createStatement();
			db.sta.execute(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
}