bookmessagedao.java

这是我们几个人在培训过程中做的第一个 小项目 仅供参考

package com.t2.myblog.dao;

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

import com.t2.myblog.entity.BookMessage;

public class BookMessageDao extends CommonSql {
    
	public boolean insertBookMessage(BookMessage book){
		boolean flag=false;
		String sql="insert into bookmessage(bs_user,bs_title,bs_imageurl,bs_content) values('";
		sql+=book.getBuser()+"','";
		sql+=book.getBtitle()+"','";
		sql+=book.getBimageurl()+"','";
		sql+=book.getBcontent()+"')";
		flag=execUpdate(sql);
		
		//closeAll();
		return flag;
	}
	public List selectAll(){
		List list=new ArrayList();
		String sql="select * from BookMessage";
		ResultSet rs1=this.execQuery(sql);
		try {
			while(rs1.next()){
				//封装
				BookMessage bm=new BookMessage();
				bm.setBid(rs1.getInt("bs_id"));
				bm.setBuser(rs1.getString("bs_user"));
				bm.setBtitle(rs1.getString("bs_title"));
				bm.setBcontent(rs1.getString("bs_content"));
				bm.setBtime(rs1.getString("bs_time"));
				bm.setBip(rs1.getString("bs_ip"));
				bm.setBimageurl(rs1.getString("bs_imageurl"));
				//加入list
				list.add(bm);
			}
			rs1.close();
			this.closeAll();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	public List selectPage(int pageindex,int pagesize){
		List list=new ArrayList();
		String sql="select top "+ pagesize+" * from BookMessage where bs_id not in";
		sql+="(select top "+(pageindex-1)*pagesize +" bs_id from BookMessage order by bs_id ) order by bs_id";
		ResultSet rs1=this.execQuery(sql);
		try {
			while(rs1.next()){
				//封装
				BookMessage bm=new BookMessage();
				bm.setBid(rs1.getInt("bs_id"));
				bm.setBuser(rs1.getString("bs_user"));
				bm.setBtitle(rs1.getString("bs_title"));
				bm.setBcontent(rs1.getString("bs_content"));
				bm.setBtime(rs1.getString("bs_time"));
				bm.setBip(rs1.getString("bs_ip"));
				bm.setBimageurl(rs1.getString("bs_imageurl"));
				//加入list
				list.add(bm);
			}
			rs1.close();
			this.closeAll();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public int selectCount(){
		int count=0;
		String sql="select count(*) from BookMessage ";
		ResultSet rs1=this.execQuery(sql);
		try {
			rs1.next();
			count=rs1.getInt(1);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
				
		return count;
	}
}