search.java

sample struct article, ... ...

/**
 * Copyright (C) 2003-2006 TiandiNet.com
 * 
 * Struts 文章系统 1.1
 * 
 * release-date: 2006-02-25
 */

package com.tiandinet.StrutsArticle.FunctionBeans;

import java.sql.*;
import java.util.*;
import com.tiandinet.StrutsArticle.Utils.DBConnection;
import com.tiandinet.StrutsArticle.Utils.TimeMaker;
import com.tiandinet.StrutsArticle.Utils.Tools;
import com.tiandinet.StrutsArticle.FormBeans.Article;

/**
 * @author Meng Yang
 * @version 1.1
 */
public class Search {
	private Collection coll = new ArrayList();

	private Connection conn = null;

	private int articleTotal = 0;

	public Search() {
		try {
			this.conn = DBConnection.getConnection();
		} catch (Exception e) {
		}
	}

	public Collection getColl() {
		return this.coll;
	}

	public int getArticleTotal() {
		return this.articleTotal;
	}

	public void doSearch(String key) {
		String where = "";

		if (key == null || key.equals("")) {
			return;
		} else {
			where = "`Article`.`show`=1 AND `Class`.`class`=`Article`.`class` AND (`Article`.`title` LIKE '%"
					+ key + "%' OR `Article`.`content` LIKE '%" + key + "%')";
		}
		String query = "SELECT `Article`.`id`,`Article`.`title`,`Article`.`author`,`Article`.`time`,`Article`.`class`,`Article`.`read`,`Class`.`name` FROM `com_tiandinet_jsp_struts_article_content` AS `Article`,`com_tiandinet_jsp_struts_article_class` AS `Class` WHERE "
				+ where + " ORDER BY `Article`.`time` DESC ";

		String titleTemp = "";
		long longTime = 0L;
		TimeMaker tMaker = new TimeMaker();
		String classNameTemp = "";

		try {
			Statement stmt = this.conn.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while (rs.next()) {
				Article art = new Article();
				art.setId(rs.getInt(1));
				titleTemp = rs.getString(2);
				art.setTitle(Tools.getCNSubString(titleTemp, 40));
				art.setAuthor(rs.getString(3));

				// 设置时间
				longTime = rs.getLong(4);
				tMaker.makeTime(longTime);

				art.setTime(tMaker.getFormatTime());

				art.setClassId(rs.getString(5));
				art.setRead(rs.getInt(6));

				classNameTemp = rs.getString(7);
				art.setClassName(classNameTemp);

				this.coll.add(art);
				this.articleTotal++;
			}

			rs.close();
		} catch (Exception e) {
		}

		try {
			this.conn.close();
		} catch (Exception e) {
		}

		return;
	}
}