chatservice.java

JSP写的一个简单聊天室。不需要连接数据库。实现简单

package service;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;

import model.Content;
import database.DataBase;
public class ChatService {
	private DataBase db;
	
	public ChatService(){
		db=new DataBase();
	}
	//将说话的内容取出放在数组中
	public List getContent(){
		List list = new ArrayList();
		Content content = null;
		String sql = "select * from content order by time desc fetch first 10 rows only";
		ResultSet rs = db.executeQuery(sql);
		try {
			while(rs.next()){
				content = new Content();
				content.setContent(rs.getString("content"));
				content.setNickname(rs.getString("nickname"));
				list.add(content);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		db.closeStmt();
		db.closeConn();
		return list;
	}
	//将说话的信息插入到数据库中
	public boolean addContent(String content,String name,Timestamp time){
		String sql="insert into content values('"+content+"','"+time+"','"+name+"')";
		boolean b = db.executeUpdate(sql);
		db.closeStmt();
		db.closeConn();
		return b;
	}
}