admin.jsp

简单的jsp留言本 配置JSP环境

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" %>
<%@ page errorPage="index_error.jsp" %>
<jsp:useBean id="db" scope="request" class="com.msg.db.DBConnect">
</jsp:useBean>
<jsp:include page="inc/head.jsp"></jsp:include>
<BR><!----Navigation Bar Begin---->
<TABLE cellSpacing=0 cellPadding=0 width="75%" align=center border=0>
  <TBODY>
  <TR>
    <TD vAlign=center align=left width="70%"><IMG alt=""
      src="image/closedfold.gif" border=0>凌少留言本&gt;&gt; 管理员密码修改</TD>
    <TD vAlign=bottom align=right width="30%"><a href="addLink.jsp"><img src="image/link11.gif" border="0"></a>&nbsp;&nbsp;<a href="publish.jsp"><img src="image/t_new4.gif" border="0"></a>&nbsp;&nbsp;<a href="index.jsp"><img src="image/t_new3.gif" border="0"></a></TD>
  </TR></TBODY></TABLE><!----Navigation Bar End-----><BR>
<%
if(session.getAttribute("adminname")==null)
{ response.sendRedirect("login.jsp");}
%>
<%
Connection conn=db.getConn();
Statement stmt=conn.createStatement();
String sql="select * from system";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
%>
      <form method="post" action="admin_pro.jsp" name="form1">
<TABLE cellSpacing=0 cellPadding=0 width="35%" align=center border=0>
  <TBODY>
  <TR>
    <TD width=55 height=20><IMG src="image/left.gif"></TD>
    <TD align=middle width=* background=image/middle.gif><FONT
      color=#ffffff>凌少留言本</FONT></TD>
    <TD width=55><IMG src="image/right.gif"></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="95%" align=center border=0>
  <TBODY>
  <TR>
    <TD>
      <TABLE width="40%" border=0 align="center" cellPadding=5 cellSpacing=1 bgColor="#005fba">
	  <TBODY>
        <TR align=middle bgColor="#ebeff5" height=22>
          <TD colspan="2" background=image/bbs>
		管理员密码修改
		  </TD>
          </TR>
        <TR vAlign=center bgColor=#ffffff  align="center">
          <TD width="83">
            <span class="font0">用户名：</span></TD>
          <TD width="191" bgColor=#ffffff align="center"><input name="adminname" type="text" style="border:1px double rgb(187,185,185);font:9pt" value="<%=rs.getString("adminname")%>" size="25">
		  
		  </TD>
        </TR>
        <TR vAlign=center align="center" bgColor=#ffffff>
          <TD width="83">
		  <span class="font0">密码：</span>
		  </TD>
          <TD bgColor=#ffffff align="center" width="191"><input type="password" name="adminpassword" value="<%=rs.getString("adminpassword")%>" size="25" style="border:1px double rgb(187,185,185);font:9pt"></TD>
        </TR>
		<TR vAlign=center align="center" bgColor=#ffffff>
          <TD bgColor=#ffffff align="center" colspan="2">
 <input type="submit" value="更改" style="border:1 solid #BBB9B9;background:#ffffff" class="button"> 
         </TD>
        </TR>
       </TBODY></TABLE></TD></TR></TBODY></TABLE>

<TABLE cellSpacing=0 cellPadding=0 width="35%" align=center border=0>
  <TBODY>
  <TR>
    <TD width=40 height=6><IMG src="image/botleft.gif"></TD>
    <TD background=image/botmid.gif><IMG height=6></TD>
    <TD width=40><IMG
src="image/botright.gif"></TD></TR></TBODY></TABLE>
   </form><br><div align="center">
<jsp:include page="inc/link.jsp"></jsp:include>
<jsp:include page="inc/footer.jsp"></jsp:include></div>
   <BR>

</BODY></HTML>
<%
conn.close();
stmt.close();
%>