📄 manrecord.jsp

📁 此资源是jsp应用开发邓子云等编写的一书里的源代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*,javax.naming.*,javax.sql.DataSource" %>
<%//------得到数据库连接------
  	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();
%>
<%//------接收请求参数------
  	String thingId=request.getParameter("thingId");
%>
<html>
  <body bgcolor="#DCDADA">
  当前位置：行政审批-->审批情况<br>
    <table border="1" CELLSPACING=0 CELLPADDING=0 width="500">
  <%//------查询出审批信息并显示------
  	String sqlStr1="select * from thing where thingId="+thingId;
  	java.sql.Statement sql1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	java.sql.ResultSet rs1=null;
  	rs1=sql1.executeQuery(sqlStr1);
  	if(rs1.next()){
  %>
  <tr><td align="right" width="200">审批事务标题：</td>
  	  <td align="left"><%=rs1.getString("thingTitle")%></td>
  </tr>
  <tr><td align="right">审批内容详细说明：</td>
  	  <td align="left"><%=rs1.getString("thingContent")%></td>
  </tr>
  <%}%>
  </table><br>
   <table border="1" CELLSPACING=0 CELLPADDING=0 width="500">
   
    <%//------查询出审批记录并显示------
  	String sqlStr2="select thingArra.thingArraEnd as thingArraEnd,"
  		+"oaUser.oaUserName as oaUserName from thingArra,oaUser"+
  		" where oaUser.oaUserId=thingArra.oaUserId and thingArra.thingId="+thingId;
  	java.sql.Statement sql2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	java.sql.ResultSet rs2=null;
  	rs2=sql1.executeQuery(sqlStr2);
  	while(rs2.next()){
  %>
  <tr><td align="right" width="200">审批人：</td>
  	  <td align="left"><%=rs2.getString("oaUserName")%></td>
  </tr>
  <tr><td align="right">审批：</td>
  	  <td align="left">
  	  <%if(rs2.getString("thingArraEnd")!=null)
  	  		out.print(rs2.getString("thingArraEnd"));%>&nbsp;</td>
  </tr>
  <%}%>
  </table><br>
  </body>
 </html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -