⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 saysucc.jsp

📁 圣洁JSP留言板源码 以上程序在Win2k Server+Mysql+Resin+J2sdk下面通过。 把lyb的文件夹拷贝到你的虚拟目录。 把chclyb文件夹拷贝到X:mysqldata
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>简单留言簿Version1.0</title>
<link href="css.css" rel="stylesheet" type="text/css">
<jsp:useBean id="workM" scope="page" class="lyb.jdbc" />
<jsp:useBean id="bbcode" scope="page" class="lyb.bbcode"/>
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<TABLE cellSpacing=1 cellPadding=3 width=98% align=center 
background="images/top_line.gif" border=0>
  <TR align=middle> 
    <TD width="20%" align="left" nowrap><FONT color=#78b3f9> &nbsp;&nbsp; 
      <SCRIPT language=JavaScript>
var day="";
var month="";
var ampm="";
var ampmhour="";
var myweekday="";
var year="";
mydate=new Date();
myweekday=mydate.getDay();
mymonth=mydate.getMonth()+1;
myday= mydate.getDate();
myyear= mydate.getYear();
year=(myyear > 200) ? myyear : 1900 + myyear;
if(myweekday == 0)
weekday=" 星期天 ";
else if(myweekday == 1)
weekday=" 星期一";
else if(myweekday == 2)
weekday=" 星期二 ";
else if(myweekday == 3)
weekday=" 星期三";
else if(myweekday == 4)
weekday=" 星期四 ";
else if(myweekday == 5)
weekday=" 星期五 ";
else if(myweekday == 6)
weekday=" 星期六 ";
document.write(year+"-"+mymonth+"-"+myday+weekday);
</SCRIPT>
      </FONT></TD>
    <TD width="20%" nowrap>&nbsp;</TD>
    <TD width="20%" nowrap>&nbsp;</TD>
    <TD width="20%" nowrap>&nbsp; </TD>
    <TD width="20%" nowrap>&nbsp;</TD>
  </TR>
</TABLE>
<TABLE height=76 cellSpacing=0 cellPadding=0 width=98% align=center 
background="images/bottom_line.jpg" 
  border=0>
  <TR> 
    <TD><TABLE height=72 cellSpacing=0 cellPadding=0 width="99%" align=center 
      bgColor=#ffffff border=0>
        <TR> 
          <TD width="163" align="center"><IMG 
            src="images/login.gif" 
            border=0></TD>
          <TD width="476" align=right><img src="images/banner.gif" width="468" height="60" border=0 usemap="#Map" scr="images/banner.gif"></TD>
          <TD align=center width=123> <TABLE width="90%" border=0 cellPadding=1 cellSpacing=0>
              <TR vAlign=center align=middle> 
                <TD><IMG height=16 
                  src="images/homepage.gif" 
                  width=16></TD>
                <TD>&nbsp;&nbsp;<a href="about.jsp">About Me</a></TD>
              </TR>
              <TR vAlign=center align=middle> 
                <TD>&nbsp;</TD>
                <TD>&nbsp;</TD>
              </TR>
              <TR vAlign=center align=middle> 
                <TD><IMG height=16 
                  src="images/Favorites.gif" 
                  width=16></TD>
                <TD>&nbsp;<a href="chen_shengjie@tom.com">&nbsp;Contact Me</a></TD>
              </TR>
            </TABLE></TD>
        </TR>
      </TABLE></TD>
  </TR>
</TABLE>
<table width="98%" align="center" cellpadding="0" cellspacing="0" background="images/index-t.gif">
  <tr> 
    <td width="5%" align="left"> 
   
    </td>
    <td height="22" align="left"><a href="index.jsp">返回首页</a> </td>
  </tr>
</table>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr> 
    <td width="36%">
      <%
Connection conn = workM.getConn() ;
Statement stmt = conn.createStatement() ;
String IP=request.getRemoteAddr();	  
String username=request.getParameter("name");
String sex=request.getParameter("sex");
String www=request.getParameter("www");
String oicq=request.getParameter("oicq");
String email=request.getParameter("email");
String memo=request.getParameter("memo");
String face=request.getParameter("face");
username=username.trim();
www=www.trim();
oicq=oicq.trim();
email=email.trim();
memo=bbcode.HTMLEncode(request.getParameter("memo"));
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
java.util.Date currentTime_1 = new java.util.Date(); 
String dd=formatter.format(currentTime_1); 
String sql;
sql="INSERT INTO lyb (id,name,IP,email,oicq,www,time,memo,sex,face) VALUES ('','"+username+"','"+IP+"','"+email+"','"+oicq+"','"+www+"','"+dd+"','"+memo+"','"+sex+"','"+face+"')"; 
    stmt.executeUpdate(sql) ;
try {
  stmt.close();
  conn.close();
}
catch (Exception ex) {

}
%>
    </td>
    <td width="23%">&nbsp;</td>
    <td width="41%">


    </td>
  </tr>
  <tr> 
    <td width="36%">&nbsp;</td>
    <td width="23%">&nbsp;</td>
    <td width="41%">&nbsp;</td>
  </tr>
  
  <tr> 
    <td width="36%">&nbsp;</td>
    <td width="23%">&nbsp;</td>
    <td width="41%">&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>留言成功,请返<a href="index.jsp"><font color="#FF0000">回首页</font></a>查看留言</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
<br>
<br>
<br>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="2" background="images/bottom_line.gif">
  <tr> 
    <td width="27%">&nbsp;</td>
    <td width="73%">圣洁工作室&copy;版权所有(2002-2005)</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>建议800*600 IE5.5以上(推荐6.0)</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>技术支持<a href="http://www.sc666.com/chc/" target="_blank">圣洁工作室</a></td>
  </tr>
</table>
<map name="Map">
  <area shape="rect" coords="1,2,468,60" href="http://www.sc666.com/chc/" target="_blank">
</map>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -