messagebean.java

jsp+Struts1.2+Hibernate3.1+mysql

package bbs.struts.bean;


import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import bbs.db.DBConnection;
import bbs.struts.vo.Message;

public class MessageBean {
	
	public void save (Message m)
	{	
	}
	public List<Message> getMessages ()
	{
		List<Message> lists =  new ArrayList<Message>();
		String sqlString = "select * from message";
		DBConnection dbConnection = new DBConnection ();
		java.sql.ResultSet rs = dbConnection.query(sqlString);
		try {
			while (rs.next())
			{
				String id = rs.getString("id");
				String title = rs.getString("title");
				String content = rs.getString("content");
				String time = rs.getString("time");
				int leaverId=rs.getInt("leaver");
				String sqlString2 = "select * from users where id="+leaverId;
				ResultSet resultSet = dbConnection.query(sqlString2);
				String leaver = null ;
				while (resultSet.next())
				{
					leaver=resultSet.getString("userName");
				}
				Message message = new Message(id ,title,leaver,content,time);
				lists.add(message);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return lists ;
	}
	

}