📄 modiuser1.jsp

📁 此资源是jsp应用开发邓子云等编写的一书里的源代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*,javax.naming.*,javax.sql.DataSource" %>
<html>
  <body bgcolor="#DCDADA">
  当前位置：用户管理-->修改用户信息<br>
  <%int pageSize=10;//每页显示的记录条数
  	int allRecordCount=0;//记录总条数
  	int pageRecordCount=0;//当前页记录条数
  	int pageCount=0;//总页数
  	int diPage=1;//当前页码
  	//------接收请求参数------  	
  	try{
  		diPage=Integer.parseInt(request.getParameter("diPage"));
  	}catch(Exception e){
  		diPage=1;
  	}
  %>
  <%//------构造查询的SQL语句------
  	//sqlStr1为查询到当前页数据的SQL语句
  	//sqlStr2为查询到总记录条数的SQL语句
  	String sqlStr1="select top "+diPage*pageSize+" * from oaUser where "+
  		"oaUserId not in (select top "+(diPage-1)*pageSize+" oaUserId from"+
  		" oaUser order by oaUserId asc) order by oaUserId asc"; 		
  	String sqlStr2="select count(*) as allCount from oaUser";
  %>
  <%//------得到数据库连接------
  	Context initCtx = new InitialContext(); 
	Context ctx = (Context) initCtx.lookup("java:comp/env");
	Object obj = (Object) ctx.lookup("jdbc/sqlserver");
	DataSource ds = (javax.sql.DataSource)obj;
	Connection conn = ds.getConnection();
  %>
  <%//------得到总页数、总记录条数与当前页记录条数------
  	java.sql.Statement sql1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	java.sql.ResultSet rs1=null;
  	rs1=sql1.executeQuery(sqlStr2);
  	if(rs1!=null){
  		//---得到总页数、总记录条数与当前页记录条数---
  		rs1.next();
  		allRecordCount=rs1.getInt("allCount");
  		if(allRecordCount%pageSize==0)
  			pageCount=allRecordCount/pageSize;
  		else
  			pageCount=(int)(allRecordCount/pageSize)+1;
  		if(diPage==pageCount||pageCount==0)//最后一页或没有数据
  			pageRecordCount=allRecordCount-(diPage-1)*pageSize;
  		else
  			pageRecordCount=pageSize;
  	}
  %>
  <table border="1" CELLSPACING=0 CELLPADDING=0>
  	<tr><td colspan="6" align="center">
  		用户信息（共<%=allRecordCount%>条，当前页<%=pageRecordCount%>条）
  		&nbsp;&nbsp;&nbsp;&nbsp;
  		<%if(diPage!=1){//不是第一页
  			out.print("<a href='modiUser1.jsp?diPage=1'>首页</a>&nbsp;");
  			out.print("<a href='modiUser1.jsp?diPage="+(diPage-1)+"'>上一页</a>&nbsp;");
  		  }
  		  if(diPage!=pageCount&&pageCount!=0){//不是最后一页
  			out.print("<a href='modiUser1.jsp?diPage="+(diPage+1)+"'>下一页</a>&nbsp;");
  			out.print("<a href='modiUser1.jsp?diPage="+pageCount+"'>尾页</a>&nbsp;");
  		  }
  		%>
  	</td>
  	</tr>
  	<tr><td>用户ID号</td><td>用户名</td>
  		<td>用户真实姓名</td><td>用户所属部门</td>
  		<td>修改?</td><td>删除?</td>
  	</tr>
  	<%//------得到当前面数据并显示------
  	java.sql.ResultSet rs2=null;
  	java.sql.Statement sql2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	rs2=sql2.executeQuery(sqlStr1);
  	if(rs2!=null){
  		while(rs2.next()){%>
  	<tr><td><%=rs2.getLong("oaUserId")%></td>
  		<td><%=rs2.getString("oaUserName")%></td>
  		<td><%=rs2.getString("oaUserTrueName")%></td>
  		<td>
  		<%//------查询出部门名称并显示------
  		  String sqlStr3="select * from department where departmentId="+
  		  	rs2.getInt("departmentId");
  		  java.sql.Statement sql3=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  		  java.sql.ResultSet rs3=sql3.executeQuery(sqlStr3);
  		  if(rs3!=null){
  		  	rs3.next();
  		  	out.print(rs3.getString("departmentName"));
  		  }
  		%>&nbsp;
  		</td>
  		<td><a href="modiUser2.jsp?oaUserId=<%=rs2.getLong("oaUserId")%>">修改</a></td>
  		<td><a href="delUser.jsp?oaUserId=<%=rs2.getLong("oaUserId")%>">删除</a></td>
  	</tr>	
  	<%
  		}
  	 }%>
  	<%
  	  if(conn!=null)
  		conn.close();
  	%>
  </table>
  </body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -