adminsearch.java

来自「NTsky新闻发布v1.0(提供JavaBean)」· Java 代码 · 共 54 行

package ntsky.common;

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

public class AdminSearch{

	public String search = null;
	private ResultSet rs = null;
	private int total;
	
	//获取字符串的值
	public void setSearch(String search){
		this.search = search;
	}
	public String getSearch(){
		return CodeFilter.toHtml(search);
	}
	//记录总数
	public int total(String search){
		try{
			String sql = "select count(articleid) as t from article where state=1 and title like '%"+search+"%';";
			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){
		DBConnect dbc = new DBConnect();
		try{
			String sql = "select * from article where state=1 and title like '%"+search+"%';";
			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;
		}
	}
}