edit.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="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 idz = new String(request.getParameter("id").getBytes("iso-8859-1"));
int id = Integer.parseInt(idz);
String condition="select * from message where id="+id;
ResultSet rs=stmt.executeQuery(condition);
rs.next();
%>
<form name="form1" method="POST" action="edit_pro.jsp?id=<%=rs.getInt("id")%>">
<TABLE cellSpacing=0 cellPadding=0 width="55%" 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><B>凌少留言本</B></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="60%" 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="name" type="text" value="<%=rs.getString("name")%>" size="70" style="border:1px double rgb(187,185,185);font:9pt">
          </td>
        </tr>
        <tr valign=center align="center" bgcolor=#ffffff>
          <td width="83"> <span class="font0">留言：</span> </td>
          <td bgcolor=#ffffff align="center" width="191">
            <textarea name="content" cols="70" rows="5" style="border:1px double rgb(187,185,185);font:9pt"><%=rs.getString("content")%></textarea>
          </td>
        </tr>
        <tr valign=center align="center" bgcolor=#ffffff>
          <td width="83"> <span class="font0">回复：</span></td>
          <td bgcolor=#ffffff align="center" width="191">
<textarea name="recontent" cols="70" rows="5" style="border:1px double rgb(187,185,185);font:9pt"><%=rs.getString("recontent")%></textarea>
          </td>
        </tr>
        <tr valign=center align="center" bgcolor=#ffffff>
          <td bgcolor=#ffffff align="center" colspan="2">
              <input type="submit" name="Submit" value="提交" style="border:1 solid #BBB9B9;background:#ffffff" class="button">
&nbsp;  &nbsp;              <input type="reset" name="Submit2" value="取消" style="border:1 solid #BBB9B9;background:#ffffff" class="button">
          </td>
        </tr>
      </tbody>
    </table></TD>
  </TR></TBODY></TABLE>

<TABLE cellSpacing=0 cellPadding=0 width="55%" 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>
<TABLE height=10 cellSpacing=0 cellPadding=0 width=10 border=0>
  <TBODY>
  <TR>
    <TD width="10"></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>

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