paihang.java

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

package ksnb;
import java.sql.*;
import java.util.*;
import ksnb.conn;
public class Paihang {
   // Collection c=new ArrayList();
    Statement st;
    ResultSet rs;
    conn cc;
    public Connection con;
    public Paihang() {
        try
        {
           cc=new conn();
           con=cc.getConncetion();
        }
        catch(Exception e)
        {}
    }

    public ResultSet Query_ten()
    {
        try
        {
            String ss="select top 10 * from Shop_Product_Info order by (Purchase_num) desc";
            st=con.createStatement();
            rs=st.executeQuery(ss);
        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
        return rs;
    }
    //得到特价书的方法，按打折率计算（小于等于5折）----前十条
    public ResultSet Q_tejiabook(){
        try{
            st=con.createStatement();
            rs=st.executeQuery("select top 10 * from Shop_product_info where discount<=5 order by discount");
        }catch(Exception e){
            System.out.println(e.toString());
        }
        return rs;
    }

}