?? chaxun1.java
字號:
package superMarket;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javabean.OracleBean;
import javabean.PageBean;
public class ChaXun1 extends HttpServlet{
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
try{
HttpSession session = request.getSession();
response.setContentType("text/html;charset=GBK");
PrintWriter out = response.getWriter();
OracleBean conn = new OracleBean();
PageBean pb = new PageBean();
ResultSet rs = null;
String gname = null;
String f_name = null;
int s_num = 0;
int page;//起始頁
int total_pages;//總頁數(shù)
rs = conn.query("SELECT SUM(s_num) s_num,gname,f_name FROM sales,goods,factory WHERE (sales.g_id=goods.g_id) AND (sales.g_id=goods.g_id) AND (sales.f_id=factory.f_id) group by gname,f_name ORDER BY SUM(s_num)ASC");//分組函數(shù)來實現(xiàn)
pb.getPage(rs,1);
if(request.getParameter("Page")==null||request.getParameter("Page").equals("")){
page = 1;
}else{
page = Integer.parseInt(request.getParameter("Page"));
}
if(page<1){
page = 1;
}
total_pages = pb.getTotalRecords();
if(page>total_pages){
page = total_pages;
}
System.out.println(page);
Vector vector = pb.getPage(rs,page);
session.setAttribute("name",vector);
session.setAttribute("namea",page+"");
session.setAttribute("nameb",total_pages+"");
getServletConfig().getServletContext().getRequestDispatcher("/qian500.jsp").forward(request,response);
}catch(Exception e){
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
doGet(request,response);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -