firstleveltitledboperation.java

新闻发布系统

package DBOperation;

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

import JavaBean.FirstLevelTitle;

public class FirstLevelTitleDbOperation {
	DBConnection db;
	public FirstLevelTitleDbOperation()
	{
		db = new DBConnection("news");
	}
	
	//添加一级标题
	public boolean insertFirstLevelTitle(FirstLevelTitle title)
	{
		String sql = "insert into FirstLevelTitle values('"+title.getTitleName()+"','"+title.getCreater()+"','"+title.getDatatime()+"')";
		return db.executeUpdate(sql);
	}

	//获取所有一级标题
	public ArrayList getAllFirstLevelTitle()
	{
		String sql = "select * from FirstLevelTitle";
		
		db.executeQuery(sql);
		ArrayList lst = new ArrayList();
		FirstLevelTitle first = null;
		try {
			while(db.rs.next()) {
				first = new FirstLevelTitle();
				first.setId(db.rs.getLong("Id"));
				first.setTitleName(db.rs.getString("TitleName"));
				first.setCreater(db.rs.getString("Creater"));
				first.setDatatime(db.rs.getString("CreatTime"));
				lst.add(first);
			}
			return lst;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		
	}
	
	public void Close() {
		this.db.Close();
	}

}