import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;public class Welcome extends HttpServlet { protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
try {
int pagesize=3;
int pagenow=1;
int pagecount=0;
int rowcount=0;
String sn=req.getParameter("pagenowok");
if(sn!=null){
pagenow=Integer.parseInt(sn);
}
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
resp.setContentType("text/html;charset=gbk");
PrintWriter pw = resp.getWriter();
Class.forName("oracle.jdbc.driver.OracleDriver");
ct = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.6:1521:orcl","scott", "tiger");
ps=ct.prepareStatement("select count(*) from usersfenye");
rs=ps.executeQuery();
if(rs.next()){
rowcount=rs.getInt(1);
}if(rowcount%pagesize==0){
pagecount=rowcount/pagesize;
}else{
pagecount=rowcount/pagesize+1;
}
ps=ct.prepareStatement("select * from usersfenye where rownum<="+pagesize*pagenow+" minus select * from usersfenye where rownum<="+(pagesize*pagenow-3)+""); rs=ps.executeQuery();
pw.println("<table border=1>");
pw.println("<tr><th>id</th><th>name</th><th>password</th><th>mail</th><th>grade</th><tr>");
while(rs.next()){
pw.println("<tr>");
pw.println("<td>"+rs.getInt(1)+"</td>");
pw.println("<td>"+rs.getString(2)+"</td>");
pw.println("<td>"+rs.getString(3)+"</td>");
pw.println("<td>"+rs.getString(4)+"</td>");
pw.println("<td>"+rs.getInt(5)+"</td>");
pw.println("</tr>");
}
pw.println("</table>");
for(int i=1;i<=pagecount;i++){
pw.println("<a href=Wolcomepagenowok="+i+">"+i+"</a>");
}
pw.println("<p align='center'>欢迎进入</p>");
} catch (Exception e) {
e.printStackTrace();
}
} protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doGet(req, resp);
}}
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;public class Welcome extends HttpServlet { protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
try {
int pagesize=3;
int pagenow=1;
int pagecount=0;
int rowcount=0;
String sn=req.getParameter("pagenowok");
if(sn!=null){
pagenow=Integer.parseInt(sn);
}
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
resp.setContentType("text/html;charset=gbk");
PrintWriter pw = resp.getWriter();
Class.forName("oracle.jdbc.driver.OracleDriver");
ct = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.6:1521:orcl","scott", "tiger");
ps=ct.prepareStatement("select count(*) from usersfenye");
rs=ps.executeQuery();
if(rs.next()){
rowcount=rs.getInt(1);
}if(rowcount%pagesize==0){
pagecount=rowcount/pagesize;
}else{
pagecount=rowcount/pagesize+1;
}
ps=ct.prepareStatement("select * from usersfenye where rownum<="+pagesize*pagenow+" minus select * from usersfenye where rownum<="+(pagesize*pagenow-3)+""); rs=ps.executeQuery();
pw.println("<table border=1>");
pw.println("<tr><th>id</th><th>name</th><th>password</th><th>mail</th><th>grade</th><tr>");
while(rs.next()){
pw.println("<tr>");
pw.println("<td>"+rs.getInt(1)+"</td>");
pw.println("<td>"+rs.getString(2)+"</td>");
pw.println("<td>"+rs.getString(3)+"</td>");
pw.println("<td>"+rs.getString(4)+"</td>");
pw.println("<td>"+rs.getInt(5)+"</td>");
pw.println("</tr>");
}
pw.println("</table>");
for(int i=1;i<=pagecount;i++){
pw.println("<a href=Wolcomepagenowok="+i+">"+i+"</a>");
}
pw.println("<p align='center'>欢迎进入</p>");
} catch (Exception e) {
e.printStackTrace();
}
} protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doGet(req, resp);
}}
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class Welcome extends HttpServlet { protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
try {
int pagesize=3;
int pagenow=1;
int pagecount=0;
int rowcount=0;
String sn=req.getParameter("pagenowok");
if(sn==null){
}else{
pagenow=Integer.parseInt(sn);
}
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
resp.setContentType("text/html;charset=gbk");
PrintWriter pw = resp.getWriter();
Class.forName("oracle.jdbc.driver.OracleDriver");
ct = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.6:1521:orcl","scott", "tiger");
ps=ct.prepareStatement("select count(*) from usersfenye");
rs=ps.executeQuery();
if(rs.next()){
rowcount=rs.getInt(1);
}if(rowcount%pagesize==0){
pagecount=rowcount/pagesize;
}else{
pagecount=rowcount/pagesize+1;
}
ps=ct.prepareStatement("select * from usersfenye where rownum<="+pagesize*pagenow+" minus select * from usersfenye where rownum<="+(pagesize*pagenow-3)+""); rs=ps.executeQuery();
pw.println("<table border=1>");
pw.println("<tr><th>id</th><th>name</th><th>password</th><th>mail</th><th>grade</th><tr>");
while(rs.next()){
pw.println("<tr>");
pw.println("<td>"+rs.getInt(1)+"</td>");
pw.println("<td>"+rs.getString(2)+"</td>");
pw.println("<td>"+rs.getString(3)+"</td>");
pw.println("<td>"+rs.getString(4)+"</td>");
pw.println("<td>"+rs.getInt(5)+"</td>");
pw.println("</tr>");
}
pw.println("</table>");
pw.println("<a href=Wolcome?pagenowok="+(pagenow-1)+">上一页</a>");
for(int i=1;i<=pagecount;i++){
pw.println("<a href=Wolcome?pagenowok="+i+">"+i+"</a>");
}
pw.println("<a href=Wolcome?pagenowok="+(pagenow+1)+">下一页</a>");
} catch (Exception e) {
e.printStackTrace();
}
} protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doGet(req, resp);
}}