searchtitle.java

一个手机新闻查看系统

package newsserver;

import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;
import java.sql.Date;
import java.io.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: server for news</p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author wenyang
 * @version 2.0
 */
public class SearchTitle {
    private DataSource ds;
    public SearchTitle() {
        DataSourceSupport dss = DataSourceSupport.getInstance();
        ds = dss.getDataSource();
    }

    public String[] getTitle(String k, String date) {
        String sql = null;
        String key = null;
            key = k;
        if (date.equals("today")) { //今天的新闻
            Calendar today = Calendar.getInstance();
            int year = today.get(Calendar.YEAR);
            int month = today.get(Calendar.MONTH) + 1;
            int day = today.get(Calendar.DATE);
            date = new Integer(year).toString() + "-" +
                   new Integer(month).toString() + "-" +
                   new Integer(day).toString();
            sql = "select * from newsinfo where Date='" + date + "'";
        } else {
            if ((key.equals("all")) && (date.equals("all"))) { //所有新闻
                sql = "select * from newsinfo";
            } else {
                if ((!key.equals("")) && (date.equals(""))) { //根据关键字搜索
                    sql = "select * from newsinfo where context like '%" + key +
                          "%'";
                } else {
                    if ((key.equals("")) && (!date.equals(""))) { //根据时间搜索
                        sql = "select * from newsinfo where Date='" + date +
                              "'";
                    } else {
                        if ((!key.equals("")) && (!date.equals(""))) { //根据关键字和时间搜索
                            sql = "select * from newsinfo where context like '%" +
                                  key + "%' and Date='" + date + "'";
                        } else {
                            sql = null;
                        } //else
                    } //else
                } //else
            } //else
        } //else
        if (sql == null) {
            return new String[0];
        } else {
            return searchBySql(sql);
        } //else
    }

    private String[] searchBySql(String sql) {
        Connection con;
        Statement st;
        ResultSet rs;
        Vector v = null;
        try {
            con = ds.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            v = new Vector();
            while (rs.next()) {
                v.addElement(rs.getString("Id"));
                v.addElement(rs.getString("newstitle"));
            }
            rs.close();
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("数据库出错");
            return new String[0];
        }
        String title[] = new String[v.size()];
        for (int i = 0; i < v.size(); i++) {
            title[i] = v.elementAt(i).toString();
        }
        return title;
    }
}