usersearch.java

NTsky新闻发布v1.0(提供JavaBean)

package ntsky.common;

import java.sql.*;
import javax.servlet.http.*;
import ntsky.database.*;
import ntsky.common.*;

public class UserSearch{
	public String search = null;
	public int select;
	private ResultSet rs = null;
	private int total;
	private int sum;
	
	//获取字符串的值
	public void setSearch(String search){
		this.search = search;
	}
	public String getSearch(){
		return CodeFilter.toHtml(search);
	}
	//select的值
	public void setSelect(int select){
		this.select = select;
	}
	public int getSelect(){
		return select;
	}
	//记录总数
	public int total(String search,String sessionuser){
		if((select == 0)){
			try{
				String sql = "select count(articleid) as t from article where state=1 and tag=1 and title like '%"+search+"%' and author='"+sessionuser+"';";
				DBConnect dbc = new DBConnect();
				rs = dbc.executeQuery(sql);
				rs.next();
				total = rs.getInt("t");
			}
			catch(Exception e){
				System.out.print("rs_result error");
			}
			return total;
		}
		else{
			try{
				String sql = "select count(articleid) as t from article where state=1 and tag=1 and content like '%"+search+"%' and author='"+sessionuser+"';";
				DBConnect dbc = new DBConnect();
				rs = dbc.executeQuery(sql);
				rs.next();
				total = rs.getInt("t");
			}
			catch(Exception e){
				System.out.print("rs_result error");
			}
			return total;
		}
	}
	//搜索
	public ResultSet rs_result(String search,String sessionuser){
		DBConnect dbc = new DBConnect();
		if(select == 0){
			try{
				String sql = "select articleid,title from article where state=1 and tag=1 and title like '%"+search+"%' and author='"+sessionuser+"';";
				rs = dbc.executeQuery(sql);
			}
			catch(Exception e){
				System.out.print("rs_result error");
			}
			return rs;
		}
		else{
			try{
				String sql = "select articleid,title from article where state=1 and tag=1 and content like '%"+search+"%' and author='"+sessionuser+"';";
				rs = dbc.executeQuery(sql);
			}
			catch(Exception e){
				System.out.print("rs_result error");
			}
			return rs;
		}
	}
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
			rs = null;
		}
	}
}