firstleveltitle.java

新闻发布系统

package com.mynews;

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

import javax.servlet.http.HttpSession;

public class FirstLevelTitle {
	private int id;
	private String titleName;
	private int creater;
	private Date CreatTime;
	public int getCreater() {
		return creater;
	}
	public void setCreater(int creater) {
		this.creater = creater;
	}
	public Date getCreatTime() {
		return CreatTime;
	}
	public void setCreatTime(Date creatTime) {
		CreatTime = creatTime;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getTitleName() {
		return titleName;
	}
	public void setTitleName(String titleName) {
		this.titleName = titleName;
	}
	
	public boolean addFirst(){   //添加一个一级标题
		String sql = "insert into FirstLevelTitle(TitleName,Creater) values(?,?)";
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.prs = db.con.prepareStatement(sql);
			db.prs.setString(1, this.getTitleName());
			db.prs.setInt(2, this.getCreater());
		//	db.prs.setDate(3, this.getCreatTime());
			db.prs.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	public boolean updateFirst(){  //修改一级标题
		String sql = "update FirstLevelTitle set TitleName=?,Creater=? where Id=?";
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.prs = db.con.prepareStatement(sql);
			db.prs.setString(1, this.getTitleName());
			db.prs.setInt(2, this.getCreater());
			db.prs.setInt(3, this.getId());
			db.prs.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	public ArrayList selectAllFirst(){  //查询所有的一级标题的信息
		String sql = "select * from FirstLevelTitle";
		ArrayList list = new ArrayList();
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.sta = db.con.createStatement();
			db.rs = db.sta.executeQuery(sql);
			FirstLevelTitle  first = null; 
			while(db.rs.next()){
				first = new FirstLevelTitle();
				first.setId(db.rs.getInt(1));
				first.setTitleName(db.rs.getString(2));
				first.setCreater(db.rs.getInt(3));
				first.setCreatTime(db.rs.getDate(4));
				list.add(first);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return list;
	}
	
	public ArrayList selectTitle(int id){  //查询所有的一级标题的信息
		String sql = "select * from FirstLevelTitle where Id <> " + id+"";
		ArrayList list = new ArrayList();
		DBConnection db = new DBConnection();
		db.getConnection();
		try {
			db.sta = db.con.createStatement();
			db.rs = db.sta.executeQuery(sql);
			FirstLevelTitle  first = null; 
			while(db.rs.next()){
				first = new FirstLevelTitle();
				first.setId(db.rs.getInt(1));
				first.setTitleName(db.rs.getString(2));
				first.setCreater(db.rs.getInt(3));
				first.setCreatTime(db.rs.getDate(4));
				list.add(first);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return list;
	}
	
	public int selectId(){ //根据标题名获得标题编号
		String sql = "select Id from FirstLevelTitle where TitleName = ?";
		DBConnection db = new DBConnection();
		db.getConnection();
		int id = -1;
		try {
			db.prs = db.con.prepareStatement(sql);
			db.prs.setString(1, this.getTitleName());
			db.rs =  db.prs.executeQuery();
			while(db.rs.next()){
				id = db.rs.getInt("Id");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return -1;
		}
		return id;
	}
	
	public String selectParentName(int parentId){ //根据标题名获得标题编号
		String sql = "select TitleName from FirstLevelTitle where Id = ?";
		DBConnection db = new DBConnection();
		db.getConnection();
		String ParentName="";
		try {
			db.prs = db.con.prepareStatement(sql);
			db.prs.setInt(1, parentId);
			db.rs =  db.prs.executeQuery();
			while(db.rs.next()){
				ParentName = db.rs.getString("TitleName");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return "";
		}
		return ParentName;
	}

	//////////////////****************************未完成********************//
	public boolean deleteFirst(int id){  ///删除一个一级标题，当有引用时，将二级标题也删除
		String sql1 = "delete FirstLevelTitle where Id = "+ id+"" ;
		DBConnection db = new DBConnection ();
		db.getConnection();
		SecondLevelTitle second = new SecondLevelTitle();
		boolean t = second.deleteSecondParent(id);
		if (t){
			try {
				db.sta = db.con.createStatement();
				db.sta.execute(sql1);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				return false;
			}
			return true;
		}else{
			return false;
		}
	}
}