📄 thingarra2.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");
  	String man=request.getParameter("man");
%>
<%//------如果接收数据有误------
  	if(thingId==null||thingId.length()==0)
  	   response.sendRedirect("thingArra1.jsp");
%>
<%//------如果需要增加新的审批安排------
  if(man!=null){
	String sqlStrAdd="insert into thingArra(thingId,oaUserId) values(?,?)";
	PreparedStatement preSQLinsert=conn.prepareStatement(sqlStrAdd);
  	preSQLinsert.setLong(1,Long.parseLong(thingId));
  	preSQLinsert.setLong(2,Long.parseLong(man));
  	preSQLinsert.executeUpdate();
  }
%>
<html>
  <body bgcolor="#DCDADA">
  当前位置：行政审批-->安排审批事务<br>
  <table border="1" CELLSPACING=0 CELLPADDING=0 width="400">
  	<tr><td colspan="3" align="center">
  		增加一个审批过程：</tr>
  	<form action="thingArra2.jsp" method="post">
  	<input type="hidden" name="thingId" value="<%=thingId%>">
  	<tr><td align="right">选择审批人：</td>
  	<td align="left">
  	<select name="man">
  	<%String sqlStr1="select * from oaUser";
  	  java.sql.Statement sql1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	  java.sql.ResultSet rs1=null;
  	  rs1=sql1.executeQuery(sqlStr1);
  	  while(rs1.next()){%>
  	   	<option value="<%=rs1.getString("oaUserId")%>">
  	   		<%=rs1.getString("oaUserTrueName")%>
  	   	</option>
  	  <%}%>
  	</select>
  	</td><td>
  	<input type="submit" value="确 定">
  	</tr>
  	</form>
  </table><br>
  <table border="1" CELLSPACING=0 CELLPADDING=0 width="500">
  <tr><td colspan="4" align="center">
  		已有审批过程</tr>
  <tr><td>序号</td><td>审批人</td><td>删除?</td><td>审批结果</td></tr>
  <%//------查询出已有的审批过程数据------
  	String sqlStr2="select * from thingArra where thingId="+thingId;
  	java.sql.Statement sql2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	java.sql.ResultSet rs2=null;
  	rs2=sql2.executeQuery(sqlStr2);
  	int i=0;
  	while(rs2.next()){
  	i++;%>
  <tr><td><%=i%></td>
  	<td>
  	<%
  		String sqlStr3="select * from oaUser where oaUserId="+rs2.getString("oaUserId");
  		java.sql.Statement sql3=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  		java.sql.ResultSet rs3=null;
  		rs3=sql3.executeQuery(sqlStr3);
  		if(rs3.next())
  			out.print(rs3.getString("oaUserTrueName"));
  	%>&nbsp;</td>
  	<td><a href="delthingArra.jsp?thingArraId=<%=rs2.getString("thingArraId")%>&thingId=<%=thingId%>">删除</a></td>
  	<td>
  	<%
  		if(rs2.getString("thingArraEnd")!=null)
  			out.print(rs2.getString("thingArraEnd"));
  	%>&nbsp;
  	</td>
  </tr>
  <%}%>
  </table><br>
  <table border="1" CELLSPACING=0 CELLPADDING=0 width="500">
  <%//------查询出审批信息并显示------
  	String sqlStr4="select * from thing where thingId="+thingId;
  	java.sql.Statement sql4=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	java.sql.ResultSet rs4=null;
  	rs4=sql4.executeQuery(sqlStr4);
  	if(rs4.next()){
  %>
  <tr><td align="right" width="200">审批事务标题：</td>
  	  <td align="left"><%=rs4.getString("thingTitle")%></td>
  </tr>
  <tr><td align="right">审批内容详细说明：</td>
  	  <td align="left"><%=rs4.getString("thingContent")%></td>
  </tr>
  <%}%>
  </table>
  </body>
</html>
<%
	if(conn!=null){
  		conn.close();
  	}
%>
⌨️ 快捷键说明

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