secondlevel.java

基于JAVA新闻发部系统

package com.mybean;

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


public class SecondLevel {
	private int id;
	private String titlename;
	private String filepath;
	private String creater;
	private String creattime;
	private int parentid;
	public String getCreater() {
		return creater;
	}
	public void setCreater(String creater) {
		this.creater = creater;
	}
	public String getCreattime() {
		return creattime;
	}
	public void setCreattime(String 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 getParentid() {
		return parentid;
	}
	public void setParentid(int parentid) {
		this.parentid = parentid;
	}
	public String getTitlename() {
		return titlename;
	}
	public void setTitlename(String titlename) {
		this.titlename = titlename;
	}
	public boolean insertSecondLevel()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		String sql="insert into SecondLevelTitle values(?,?,?,?,?)";
		try {
			dbc.presta=dbc.con.prepareStatement(sql);
			dbc.presta.setString(1, this.titlename);
			dbc.presta.setString(2,this.filepath);
			dbc.presta.setString(3, this.creater);
			dbc.presta.setString(4, this.creattime);
			dbc.presta.setInt(5, this.parentid);
			dbc.presta.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		dbc.close();
		return true;
	}
	public boolean deleteSecondLevel(String sid)
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		String sql="delete from SecondLevelTitle where id='"+sid+"'";
		try {
			dbc.sta.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		dbc.close();
		return true;
	}
	public boolean updateSecondLevel()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		String sql="update SecondLevelTitle set TitleName='"+this.titlename+"',FilePath='"+this.filepath+"',Creater='"+this.creater+"',CreatTime='"+this.creattime+"',ParentId='"+this.parentid+"' where id="+this.id+"";
		try {
			dbc.sta.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		dbc.close();
		return true;
	}
	public ArrayList selectSecondLevel()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		ArrayList list=new ArrayList();
		SecondLevel second=null;
		String sql="select * from SecondLevelTitle";
		try {
			dbc.rs=dbc.sta.executeQuery(sql);
			while(dbc.rs.next())
			{
				second=new SecondLevel();
				second.setId(dbc.rs.getInt(1));
				second.setTitlename(dbc.rs.getString(2));
				second.setFilepath(dbc.rs.getString(3));
				second.setCreater(dbc.rs.getString(4));
				second.setCreattime(dbc.rs.getString(5));
				second.setParentid(dbc.rs.getInt(6));
				list.add(second);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		dbc.close();
		return list;
	}
	public ArrayList selectSecondLevel(int firstid)
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		ArrayList list=new ArrayList();
		SecondLevel second=null;
		String sql="select * from SecondLevelTitle where ParentId="+firstid+"";
		try {

			dbc.rs=dbc.sta.executeQuery(sql);
			while(dbc.rs.next())
			{
				second=new SecondLevel();
				second.setId(dbc.rs.getInt(1));
				second.setTitlename(dbc.rs.getString(2));
				second.setFilepath(dbc.rs.getString(3));
				second.setCreater(dbc.rs.getString(4));
				second.setCreattime(dbc.rs.getString(5));
				second.setParentid(dbc.rs.getInt(6));
				list.add(second);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		dbc.close();
		return list;
	}
	

}