showradio.jsp~12~
资源名称:bangong.rar [点击查看]
上传用户:dlqqsh
上传日期:2021-11-13
资源大小:7840k
文件大小:1k
源码类别:
OA系统
开发平台:
Java
- <%@ page contentType="text/html; charset=GBK" import="officeol.mc.tools.*,java.sql.*,java.lang.*" %>
- <jsp:useBean id="sql" scope="page" class="control.sqlcontrol"></jsp:useBean>
- <%request.setCharacterEncoding("gbk"); %>
- <html>
- <head>
- <script language="javascript" type="">
- function goback(){
- history.back(-1);
- }
- </script>
- <%
- try{
- sql.getSQL2005conn("dbconfig.xml");
- String id = request.getParameter("id");
- ResultSet art = sql.getStatement("select * from radio where id="+id+";");art.next();
- %>
- <title>
- show
- </title>
- </head>
- <body bgcolor="#ffffff">
- <div align="center">
- <%
- DBConn dbc = new DBConn();
- String usql = "select username from [user] where id = '"+art.getString("usersid")+"'";
- String ndsql = "select deparname from deparment where id = '"+art.getString("depar")+"'";
- String[][] us = dbc.getArray(usql);
- String user = "";
- if(us==null){
- }else{
- user = us[0][0];
- }
- String dep ="";
- String[][] dep1 = dbc.getArray(ndsql);
- if(dep1==null){
- }else{
- dep=dep1[0][0];
- }
- %>
- <table cellpadding="0" cellspacing="0" border="1" width="80%">
- <tr>
- <td align="center"><%=art.getString("title") %></td>
- </tr>
- <tr>
- <td align="center">发布部门:<%=dep %>
- 发布人:<%=art.getString("usersid")%>
- 时间<%=art.getString("date") %></td>
- </tr>
- <tr>
- <td><%=art.getString("context") %></td>
- </tr>
- </table>
- </div>
- </body>
- <%
- art.close();
- sql.closeDB();
- }catch(Exception e){
- e.printStackTrace();
- } %>
- </html>