OA系统

开发平台：
Java

userlogin.jsp~46~：源码内容
							<%@ 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>
<html>
<head>
<title>
天津市河东区经济贸易委员会内部办公网
</title>
<link href="css/sa.css" type="text/css" rel="stylesheet">
</head>
<body bgcolor="#ffffff">
<%
try{
  String message = request.getAttribute("msg")==null?"":request.getAttribute("msg").toString();
  out.print(message);
  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");
  if(pp!=null){
    out.print("已经登录!");
    response.sendRedirect("shouye.jsp");
  }
  %>
  <br>
  <div align="center">
    <form method="post" name="form1" action="userLoginAction.do">
    <table width="500" border="0" background="images/right1.gif">
      <tr>
        <td><font class="font1">用户名:</font></td>
        <td><input type="text" name="usern"></td>
          <td><font class="font1">密码:</font></td>
          <td><input type="password" name="pwd"></td>
            <td><input type="submit" value="进入>>"></td>
      </tr>
      <tr><td>&nbsp;</td>
      <td>&nbsp;</td>
        <td>
        <input type="radio" value="1" name="rem"/><font class="font1">记住我</font></td>
        <td>
        <input type="radio" value="0" name="rem" checked="checked"/><font class="font1">不记住</font>
      </td>
      <td>&nbsp;</td>
      </tr>
    </table>
    </form>
  </div>
  <table width="400" border="0" align="center" background="images/right.gif">
    <tr>
      <td align="center"><font class="font2">公告</font></td>
    </tr>
  </table>
  <br />
  <table width="600" height="230" border="0" align="center" class="tb">
    <tr>
      <td align="left">
      <%
      sql.getSQL2005conn("dbconfig.xml");
      ResultSet rs = sql.getStatement("select * from radio order by id desc;");
      int i=0;
      while(rs.next()){
        %>
        <br><font class="font3">
       <%=rs.getString("date")%>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
       <a href=showradio.jsp?id=<%=rs.getString("id")%> target="_blank" class="font3"><%=rs.getString("title")%>&nbsp;&nbsp;&nbsp;&nbsp;</a></font>
        <%
        i++;
        if(i==12){
          break;
        }
      }
      %>
      </td>
    </tr>
  </table><%
  }catch(Exception ex){
    ex.printStackTrace();
  }
%>
</body>
</html>

						