package com.xk.view;
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 java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ManagerUsers extends HttpServlet
{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException
{
resp.setContentType("text/html;charset=utf-8");
PrintWriter out = resp.getWriter();
Connection ct = null;
PreparedStatement ps = null;
ResultSet rs = null;
String spageNow = req.getParameter("pageNow");
if(spageNow !=null)
{
pageNow = Integer.parseInt(spageNow);
int rowCount = 1;
int pageCount = 1;
try
{
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.建立连接
ct = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","Oracle123");
//3.生成preparedstatement
ps = ct.prepareStatement("select count(*) from scott.emp");
rs = ps.executeQuery();
rs.next();
rowCount = rs.getInt(1);
pageCount = rowCount%pageSize==0 ? rowCount/pageSize : (rowCount/pageSize+1);
ps = ct.prepareStatement("select * from (select t.*, rownum rn from (select * from scott.emp order by empno) t where rownum <="+pageSize*pageNow+") where rn >="+(pageSize*(pageNow-1)+1));
//4.执行查询
rs = ps.executeQuery();
out.println("<h1 align='center'>管理雇员</h1><hr/>");
out.println("<table border='1' bordercolor='green' cellsapcing=0 align='center' width='80%'><tr><th>账号</th><th>姓名</th>" +
"<th>工作</th><th>上级</th><th>雇用日期</th><th>薪水</th><th>加薪</th><th>部门</th>"
+"<th>修改用户</th><th>删除用户</th></tr>");
while(rs.next())
{
out.println("<tr><th>"+rs.getInt(1)+"</th><th>"+rs.getString(2)+"</th><th>"+rs.getString(3)
+"</th><th>"+rs.getInt(4)+"</th><th>"+rs.getDate(5)+"</th><th>"+rs.getInt(6)+
"</th><th>"+rs.getInt(7)+"</th><th>"+rs.getInt(8)+
"</th><th><font color='blue'>修改用户</font></th><th><font color='blue'>删除用户</font></th><tr>");
}
out.println("</table>");
for(int i=1;i<=pageCount;i++)
{
out.println("<a href='/review/ManagerUsers?pageNow="+i+"'><"+i+"></a>");
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
//5.关闭资源
if(null != rs)
{
try
{
rs.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
rs =null;
}
if(null != ps)
{
try
{
ps.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
ps=null;
}
if(null !=ct)
{
try
{
ct.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
ct = null;
}
}
}
}
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 java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ManagerUsers extends HttpServlet
{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException
{
resp.setContentType("text/html;charset=utf-8");
PrintWriter out = resp.getWriter();
Connection ct = null;
PreparedStatement ps = null;
ResultSet rs = null;
//四个参数 : pageNow 当前所在页,pageSize 每页多少行, pageCount 总共有多少页, rowCount 总共用多少行记录
//pageCount = rowCount%pageSize==0 ? rowCount/pageSize : (rowCount/pageSize+1);
String spageNow = req.getParameter("pageNow");
if(spageNow !=null)
{
pageNow = Integer.parseInt(spageNow);
}
int pageSize = 4;
int rowCount = 1;
int pageCount = 1;
try
{
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.建立连接
ct = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","Oracle123");
//3.生成preparedstatement
ps = ct.prepareStatement("select count(*) from scott.emp");
rs = ps.executeQuery();
rs.next();
rowCount = rs.getInt(1);
pageCount = rowCount%pageSize==0 ? rowCount/pageSize : (rowCount/pageSize+1);
ps = ct.prepareStatement("select * from (select t.*, rownum rn from (select * from scott.emp order by empno) t where rownum <="+pageSize*pageNow+") where rn >="+(pageSize*(pageNow-1)+1));
//4.执行查询
rs = ps.executeQuery();
out.println("<h1 align='center'>管理雇员</h1><hr/>");
out.println("<table border='1' bordercolor='green' cellsapcing=0 align='center' width='80%'><tr><th>账号</th><th>姓名</th>" +
"<th>工作</th><th>上级</th><th>雇用日期</th><th>薪水</th><th>加薪</th><th>部门</th>"
+"<th>修改用户</th><th>删除用户</th></tr>");
while(rs.next())
{
out.println("<tr><th>"+rs.getInt(1)+"</th><th>"+rs.getString(2)+"</th><th>"+rs.getString(3)
+"</th><th>"+rs.getInt(4)+"</th><th>"+rs.getDate(5)+"</th><th>"+rs.getInt(6)+
"</th><th>"+rs.getInt(7)+"</th><th>"+rs.getInt(8)+
"</th><th><font color='blue'>修改用户</font></th><th><font color='blue'>删除用户</font></th><tr>");
}
out.println("</table>");
for(int i=1;i<=pageCount;i++)
{
out.println("<a href='/review/ManagerUsers?pageNow="+i+"'><"+i+"></a>");
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
//5.关闭资源
if(null != rs)
{
try
{
rs.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
rs =null;
}
if(null != ps)
{
try
{
ps.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
ps=null;
}
if(null !=ct)
{
try
{
ct.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
ct = null;
}
}
}
}