firstlevel.java

基于JAVA新闻发部系统

package com.mybean;

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

public class FirstLevel {
	private int id;
	private String titlename;
	private String creater;
	private String creattime;
	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 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 insertFirstLevel()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		String sql="insert into FirstLevelTitle values(?,?,?)";
		try {
			dbc.presta=dbc.con.prepareStatement(sql);
			dbc.presta.setString(1, this.getTitlename());
			dbc.presta.setString(2, this.getCreater());
			//dbc.presta.setString(3, new Date().toLocaleString());
			dbc.presta.setString(3, this.getCreattime());
			dbc.presta.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		dbc.close();
		return true;
	}
	public boolean deleteFirstLevel(String sid)
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		String sql="delete from FirstLevelTitle 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 updateFirstLevel()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		String sql="update FirstLevelTitle set TitleName='"+this.titlename+"',Creater='"+this.creater+"',CreatTime='"+this.creattime+"' 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 selectFirstLevel()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		ArrayList list=new ArrayList();
		FirstLevel first=null;
		String sql="select * from FirstLevelTitle order by id desc";
		try {
			dbc.rs=dbc.sta.executeQuery(sql);
			while(dbc.rs.next())
			{
				first=new FirstLevel();
				first.setId(dbc.rs.getInt(1));
				first.setTitlename(dbc.rs.getString(2));
				first.setCreater(dbc.rs.getString(3));
				first.setCreattime(dbc.rs.getString(4));
				list.add(first);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		dbc.close();
		return list;
	}

}