OA系统

开发平台：

Java

radiolist.jsp：源码内容

							<%@ page contentType="text/html; charset=GBK" import="java.sql.*,java.lang.*" %>
<%request.setCharacterEncoding("gbk");%>
<jsp:useBean id="sql" scope="page" class="control.sqlcontrol"></jsp:useBean>
<jsp:useBean id="fen" scope="page" class="control.Textcontrol.Pagecontrol"></jsp:useBean>
<html>
<head>
<title>
articlelist
</title>
</head>
<body bgcolor="#ffffff">
<%try{
  Connection conn=sql.getSQL2005conn("dbconfig.xml");
  if(request.getParameter("pageID")==null){
  }else{
  fen.setpages(request.getParameter("pageID"));
  }
  String ud = (String)session.getAttribute("UD");
String udid = (String)session.getAttribute("UDID");
String un = (String)session.getAttribute("UN");
String uid = (String)session.getAttribute("UID");
String pp = (String)session.getAttribute("POPE");
String login = (String)session.getAttribute("LOGIN");
String where = "type='1'";
if(login!=null&&login.equals("OK")){
  where ="type='1' or depar = "+udid;
}
  String select = fen.getPageinfsql(12,"radio","id","desc",where);
  ResultSet show = sql.getStatement(select);
  //out.print(select);
  %>
<div align="center">
<table cellpadding="0" cellspacing="0" border="1" width="80%">
<%
 while(show.next()){
  out.println("<tr><td><font color='#ff00ff'>[公告消息]</font>&nbsp;&nbsp;<a href=showradio.jsp?id="+show.getString("id")+" >"+show.getString("title")+"&nbsp;&nbsp;"+show.getString("date")+"</a></td></tr>");
 }
 out.println("</table>");
 out.println("<div>"+fen.controlPage("radiolist.jsp","pageID",8)+"</div>");
%>
</div>
</body>
</html>
<%
show.close();
sql.closeDB();
}catch(Exception e){
  e.printStackTrace();
} %>

						