listtie.java

jsp bbs 论坛源码

package bbs.ahut.javabean;

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

import bbs.ahut.db.DbConSql;

public class ListTie {
	DbConSql db=new DbConSql();

	public List<TieBean> findList(int id){
		
		List<TieBean> list=new ArrayList<TieBean>();
	    String sql1="select * from zhuTie where id='"+id+"'";
	    String sql2="select * from huiTie where idtie='"+id+"'";
	    ResultSet rs;
	    try {
	        rs=db.getQuery(sql1);
	        if(rs.next()){
	        	TieBean tie=new TieBean();
				tie.setUserno(rs.getString("userno"));
				tie.setUsername(rs.getString("username"));
				tie.setTitle(rs.getString("title"));
				tie.setContext(rs.getString("context"));
				tie.setCreateTime(rs.getString("createTime"));	
				tie.setId(id);
				list.add(tie);
			}
	        rs=db.getQuery(sql2);
	        while(rs.next()){
	        	TieBean tie=new TieBean();
	        	tie.setUserno(rs.getString("userno"));
				tie.setUsername(rs.getString("username"));
				tie.setContext(rs.getString("context"));
				tie.setCreateTime(rs.getString("createTime"));	
				list.add(tie);
	        }
		} catch (Exception e) {
			e.printStackTrace();
		}
		
        return list;
    }
	
	
}