publish.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>&#20940;&#23569;&#30041;&#35328;&#26412;&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="admin.jsp"><img src="image/t_new5.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="publish_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>&#20940;&#23569;&#30041;&#35328;&#26412;</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 background=image/bbs>
		公告修改
		  </TD>
          </TR>
        <TR vAlign=center bgColor=#ffffff  align="center">
          <TD>
 <textarea name="news" cols="50" rows="3" id="news" style="border:1px double rgb(187,185,185);font:9pt"><%=rs.getString("news")%></textarea>
		  
	  		  </TD>
          </TR>

		<TR vAlign=center align="center" bgColor=#ffffff>
          <TD bgColor=#ffffff align="center">
 <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>
<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();
%>