JSP留言簿系统无版权 第6页

JSP留言簿系统无版权 第6页

alert("您输入的版主名称不正确,请重新输入!");

history.back();

</script>

<%}

}%>

 

        Logout_User.jsp

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>

<%

session.removeAttribute("username");  //清空Session变量

response.sendRedirect("index.jsp");

%>

 

      Topic_add.jsp

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>

<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>

<%

ResultSet rs=connBean.executeQuery("select * from tb_User where UserName='"+session.getAttribute("username")+"'");

if(!rs.next()){

       out.println("<script language='javascript'>alert('您没有登录,请先登录或注册!');window.location.href='index.jsp';</script>");

}else{

       int UID=rs.getInt("ID");

%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<link href="CSS/style.css" rel="stylesheet">

<title>蓝天一色留言簿</title>

</head>

<body onLoad="clockon()">

<jsp:include page="top.jsp"/>

<table width="777" height="197"  border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>

    <td width="53%" height="5" valign="top"></td>

  </tr>

  <tr>

    <td valign="top"><table width="100%" height="171"  border="0" cellpadding="0" cellspacing="0" class="table">

      <tr>

        <td width="2%" height="26" background="images/bg_banner.GIF">&nbsp;</td>

        <td width="98%" background="images/bg_banner.GIF" class="word">≡签写留言≡</td>

      </tr>

      <tr valign="top">

        <td colspan="2">

              <table width="100%" height="230"  border="0" cellpadding="0" cellspacing="0" class="table_B">

          <tr align="center">

            <td width="23" rowspan="2" align="left">&nbsp;</td>

            <td width="182" rowspan="2" align="left"><%=rs.getString("UserName")%><p>

                     <%=rs.getString("sex")%>

                     <p><img src="images/atusers.gif" alt="OICQ号码:<%=rs.getString("OICQ")%>" width="14" height="16">OICQ<%=rs.getString("OICQ")%><br>

                       <br><img src="images/home-menu.gif" alt="个人主页:<%=rs.getString("homepage")%>" width="26" height="20">个人主页:<%=rs.getString("homepage")%><br>

                       <br>IP地址:

                     <p><img src="images/email.GIF" alt="Email:<%=rs.getString("email")%>" width="16" height="16">Email<%=rs.getString("email")%></td>

            <td width="1" rowspan="2" align="center" valign="bottom" bgcolor="#07AFBE"></td>

            <td align="left" valign="top" class="word" style="padding-left:10pt">

                     <table width="80%"  border="0" align="center" cellpadding="0" cellspacing="0">

            <tr>

                <td width="12%" height="10">&nbsp;</td>

                <td width="88%">&nbsp;</td>

              </tr>

                       <form name="form1" method="post" action="Topic_add_deal.jsp">

              <tr>

                <td height="27" valign="middle">心情:</td>

                <td valign="top"><select name="face" id="face">

                  <option value="微笑" selected>微笑</option>

                  <option value="伤心">伤心</option>

                  <option value="大笑">大笑</option>

                  <option value="忧郁">忧郁</option>

                                                </select></td>

              </tr>

              <tr>

                <td height="156" valign="middle">留言:</td>

                <td valign="top"><textarea name="content" cols="50" rows="11" id="content"></textarea></td>

              </tr>

         <tr align="center" valign="middle">

           <td height="32" colspan="2">

<input name="UID" type="hidden" id="UID" value="<%=UID%>"> <input name="Submit" type="submit" class="button" value="保存">

&nbsp;                  <input name="Submit" type="reset" class="button" value="重置"></td>

                </tr>

                       </form>

            </table></td>

          </tr>

        </table>

              <br>      

              <%}%>

              </td>

        </tr>

    </table></td>

  </tr>

</table>

</body>

</html>

 

            Topic_add_deal.jsp

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>

<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>

<%

int UID=0;

UID=Integer.parseInt(request.getParameter("UID"));

String face1=request.getParameter("face");

 String face=(new String(face1.getBytes("iso-8859-1"),"gb2312"));

String content1=request.getParameter("content");

 String content=(new String(content1.getBytes("iso-8859-1"),"gb2312"));

String sql="insert into tb_Topic (author,face,content) values("+UID+",'"+face+"','"+content+"')";

int ret=0;

ret=connBean.executeUpdate(sql);

if (ret!=0){

       out.println("<script language='javascript'>alert('留言成功!');window.location.href='index.jsp';</script>");

}else{

       out.println("<script language='javascript'>alert('留言失败!');window.location.href='Topic_add.jsp';</script>");

}

%>

 

               modify.jsp

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>

<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>

<%

ResultSet rs=connBean.executeQuery("select * from tb_user where username='"+session.getAttribute("username")+"'");

if(!rs.next()){

       response.sendRedirect("index.jsp");

}else{

%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<link href="CSS/style.css" rel="stylesheet">

<title>蓝天一色留言簿</title>

</head>

<body onLoad="clockon()">

<jsp:include page="top.jsp"/>

<table width="777" height="197"  border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>

    <td width="53%" height="5" valign="top"></td>

  </tr>

  <tr>

    <td valign="top"><table width="100%" height="171"  border="0" cellpadding="0" cellspacing="0" class="table">

      <tr>

        <td width="2%" height="26" background="images/bg_banner.GIF">&nbsp;</td>

        <td width="98%" background="images/bg_banner.GIF" class="word">≡用户注册≡</td>

      </tr>

      <tr align="center" valign="top">

        <td colspan="2">

          <form name="form1" method="post" action="modify_deal.jsp">

              <table width="76%" height="295"  border="0" cellpadding="0" cellspacing="0">

          <tr>

            <td width="22%">&nbsp;</td>

            <td width="78%">&nbsp;</td>

            </tr>

          <tr>

            <td align="center">用户名:</td>

            <td><input name="username" type="text" class="table" id="username" value="<%=rs.getString("username")%>" readonly="yes">

              *</td>

          </tr>

          <tr>

            <td align="center">密码:</td>

            <td class="word"><input name="PWD1" type="password" class="table" id="PWD1">

              *</td>

          </tr>

          <tr>

            <td align="center">确认密码:</td>

            <td class="word"><input name="PWD2" type="password" class="table" id="PWD2">

              *</td>

          </tr>

          <tr>

            <td align="center">生日:</td>

            <td class="word"><input name="birthday" type="text" class="table" id="birthday" value="<%=rs.getDate("birthday")%>">

              (格式:1980-07-17</td>

          </tr>

          <tr>

            <td align="center">性别:</td>

            <td><input name="sex" type="radio" value="" <%if(rs.getString("sex").equals("")){%>checked<%}%>>

              男生 

                <input type="radio" name="sex" value="" <%if(rs.getString("sex").equals("")){%>checked<%}%>>

                女生</td>

          </tr>

          <tr>

            <td align="center">OICQ号码:</td>

            <td><input name="OICQ" type="text" class="table" id="OICQ" value="<%=rs.getString("OICQ")%>"></td>

          </tr>

          <tr>

            <td align="center">电话:</td>

            <td><input name="tel" type="text" class="table" id="tel" value="<%=rs.getString("tel")%>"></td>

          </tr>

上一页  [1] [2] [3] [4] [5] [6] [7] [8] 下一页

  • 上一篇文章:
  • 下一篇文章:
  • Copyright © 2007-2012 www.chuibin.com 六维论文网 版权所有