67,549
社区成员




第一个页面:messagelist.jsp
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
String id=request.getParameter("id");
if(id==null){
id=(String)session.getAttribute("mid");
if(id==null) {id="1";}
}else{
session.setAttribute("mid",id);
}
int num=Integer.parseInt(id);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:jspdata";
String user="sa";
String pwd="";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("select * from message where id='"+id+"'");
while(rs.next()){
%>
<p>用户名:<%=rs.getString("username") %></p>
<p>标题:<%=rs.getString("title") %></p>
<p>留言内容:<%=rs.getString("content") %></p>
<%
}
%>
<p> </p>
<p> </p>
<hr>
<%
ResultSet rs1=stmt.executeQuery("select * from level where id='"+num+"'");
int i=1;
while(rs1.next()){
out.print("<p>"+i+"楼 留言时间:");
out.print(rs1.getString("createtime"));
out.print("</p>");
%>
<p><%=rs1.getString("message") %></p>
<hr>
<%
i++;
}
%>
<p><a href="blog.jsp">返回列表</a></p>
<p>我要回复</p>
<form action="inserhuifu.jsp" method="post">
<p><textarea name="textfield" cols="50" rows="10"></textarea></p>
<p><input type="submit" value="提交"><input type="reset" value="取消"></p>
</form>
</body>
</html>
第二个页面:inserhuifu.jsp
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
String id=(String)session.getAttribute("mid");
int num=Integer.parseInt(id);
String ma=request.getParameter("textfield");
ma=new String(ma.getBytes("ISO-8859-1"),"gb2312");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:jspdata";
String user="sa";
String pwd="";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="insert into level(id,message) values('"+num+"','"+ma+"')";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
response.setHeader("refresh","2;url=messagelist.jsp");
out.print("留言成功,3秒钟之后将自动跳转,如不跳转,<a href='messagelist.jsp'>请点击这里</a>");
%>
</body>
</html>
第三个页面:insermessage.jsp
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
String username=request.getParameter("username");
String title=request.getParameter("title");
String content=request.getParameter("textfield");
if(username!=null&&title!=null&&content!=null){
username=new String(username.getBytes("ISO-8859-1"),"gb2312");
title=new String(title.getBytes("ISO-8859-1"),"gb2312");
content=new String(content.getBytes("ISO-8859-1"),"gb2312");
}
else{
out.print("帐号,标题,内容都不能为空");
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:jspdata";
String user="sa";
String pwd="";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="insert into message(username,title,content) values('"+username+"','"+title+"','"+content+"')";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
out.print("非常感谢您的留言,3秒钟将自动返回留言列表,如不返回,<a href='blog.jsp'>请点击这里</a>");
response.setHeader("refresh","3;url=blog.jsp");
%>
</body>
</html>