📄 thingtome2.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 thingArraId=request.getParameter("thingArraId");
%>
<%//------如果接收数据有误------
  	if(thingId==null||thingArraId==null||
  	   thingId.length()==0||thingArraId.length()==0)
  	   response.sendRedirect("thingToMe1.jsp");
%>
<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">
  <form action="thingToMe3.jsp" method="post">
  	<tr><td>审批意见：</td>
  		<td><textarea name="content" rows="10" cols="54">
  		<%
  		String sqlStr2="select * from thingArra where thingArraId="+thingArraId;
  		java.sql.Statement sql2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  		java.sql.ResultSet rs2=null;
  		rs2=sql2.executeQuery(sqlStr2);
  		if(rs2.next())
  			if(rs2.getString("thingArraEnd")!=null)
  				out.print(rs2.getString("thingArraEnd"));%>
  		</textarea></td>
  	</tr>
  	<tr><td align="center" colspan="2">
  	<input type="hidden" value="<%=thingArraId%>" name="thingArraId">
  	<input type="hidden" value="<%=thingId%>" name="thingId">
  	<input type="submit" value="提交审批">
  	</td></tr>
  </form>
  </table>
  </body>
</html>
<%
	if(conn!=null){
  		conn.close();
  	}
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -