context.java

一个手机新闻查看系统

package newsserver;

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

/**
 * <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 Context {
    private DataSource ds;
    public Context() {
        DataSourceSupport dss = DataSourceSupport.getInstance();
        ds = dss.getDataSource();
    }

    public String getNews(int id) {
        Connection con;
        Statement st;
        ResultSet rs;
        String news = "";
        try {
            con = ds.getConnection();
            st = con.createStatement();
            String sql = "select context from newsinfo where Id=" + id;
            rs = st.executeQuery(sql);
            rs.next();
            news = rs.getString("context");
            rs.close();
            st.close();
            con.close();
        } catch (Exception e) {
            System.out.println("出错");
            return null;
        }
        return news;

    }
}