tiemanager.java

jsp bbs 论坛源码

package bbs.ahut.javabean;

import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

import bbs.ahut.db.DbConSql;

public class TieManager {
	DbConSql db=new DbConSql();
	
	public ResultSet findZhuTieSY(){
		String sql="select * from zhuTie";
		ResultSet rs=db.getQuery(sql);
		return rs;
	}
	
	public ResultSet findZhuTieBT(String biaoti){
		String sql="select * from zhuTie where title like '%"+biaoti+"%'";
		List<String> list=Lucene.fenci(biaoti);
		Iterator<String> it=list.iterator();
		while(it.hasNext()){
			sql=sql+"or title like '%"+it.next()+"%'";
		}
		
		ResultSet rs=db.getQuery(sql);
		return rs;
	}
	
	public ResultSet findZhuTieSJ(int shijian){
	    SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	    Date nowDate=new Date();
	    nowDate.setDate(nowDate.getDate()-shijian);
	    String now=df.format(nowDate);
		String sql="select * from zhuTie where createTime>='"+now+"'";
		ResultSet rs=db.getQuery(sql);
		return rs;
	}
	public ResultSet findZhuTie(String userno){
		String sql="select * from zhuTie where userno='"+userno+"'";
		ResultSet rs=db.getQuery(sql);
		return rs;
	}
	
	public int addZhuTie(TieBean huitie){
		String sql="insert into zhuTie(userno,username,title,context,createTime) values('"+huitie.getUserno()+"','"+huitie.getUsername()+"','"+huitie.getTitle()+"','"+huitie.getContext()+"','"+huitie.getCreateTime()+"')";
		return db.insert(sql);
	}
	
	public int addHuiTie(TieBean zhutie){
		String sql="insert into huiTie(idtie,userno,username,context,createTime) values('"+zhutie.getId()+"','"+zhutie.getUserno()+"','"+zhutie.getUsername()+"','"+zhutie.getContext()+"','"+zhutie.getCreateTime()+"')";
		return db.insert(sql);
	}
	
	public void deleteZhuTie(String[] str){
		String sql1="delete from zhuTie where id=-1";
		String sql2="delete from huiTie where idtie=-1";
		for(int i=0;i<str.length;i++ ){
			sql1=sql1+" or id='"+str[i]+"'";
			sql2=sql2+" or idtie='"+str[i]+"'";
		}
		db.delete(new String[]{sql2,sql1});
	}
}