query_news.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;
import java.sql.*;
import java.util.*;
public class Query_News {
    ResultSet rs;
    Statement st;
    conn c;
    Connection con;
    public Query_News() {
        try
        {
            c=new conn();
            con=c.getConncetion();
        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
    }

    //Collection c=new ArrayList();
    //查询新闻
    public ResultSet News()
    {
        try
        {
            st=con.createStatement();
            rs=st.executeQuery("select top 5 * from Shop_News_Info");
        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
        return rs;
    }
}