firstleveltitle.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 FirstLevelTitle 
{
	public int titleID;
	public String titleName;
	public String createTime;
	public String creater;
	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 int getTitleID() {
		return titleID;
	}
	public void setTitleID(int titleID) {
		this.titleID = titleID;
	}
	public String getTitleName() {
		return titleName;
	}
	public void setTitleName(String titleName) {
		this.titleName = titleName;
	}
//	添加
	public boolean addFirstTitle(FirstLevelTitle first)
	{
		String str="insert into FirstLevelTitle 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.setString(1, this.titleName);
			db.ps.setString(2, strCurrentTime);
			db.ps.setString(3, this.creater);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//删除
	public boolean delFirstTitle(String sid)
	{
		String str="delete from FirstLevelTitle where FirstTitleID="+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 upUser(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 FirstLevelTitle set FirstTitleName=?, createTime=?, creater=?  where FirstTitleID="+sid;
		try {
			db.ps=c.prepareStatement(str);
			db.ps.setString(1, this.titleName);
			db.ps.setString(2, strCurrentTime);
			db.ps.setString(3, this.creater);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//查询
	public ArrayList selFirstTitle()
	{
		ArrayList arr=new ArrayList();
		String str="select * from FirstLevelTitle";
		DBConnection db=new DBConnection();
		FirstLevelTitle firstTitle=null;
		db.getCon();
		try {
			db.rs=db.st.executeQuery(str);
			while(db.rs.next())
			{
				firstTitle=new FirstLevelTitle();
				firstTitle.setTitleID(db.rs.getInt(1));
				firstTitle.setTitleName(db.rs.getString(2));
				firstTitle.setCreateTime(db.rs.getString(3));
				firstTitle.setCreater(db.rs.getString(4));
				arr.add(firstTitle);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return arr;
	}
}