message.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
<!-- 用于显示留言 -->
<form name="form3" method="post" action="msgs.jsp">
<textarea name="text2" rows="8" cols="40" >
</textarea>
<br>
<input type="reset" value="清空">
                    
                  
<input type="submit" value="发表" >
<!-- <br>
请输入你要回复的ID:<input name="id" type="text" value="回复"> -->
</form>
<%
/* String text=new String(request.getParameter("text2").getBytes("ISO-8859-1"),"UTF-8"); */
/* session.setAttribute("text2",text); */
String name7=(String)session.getAttribute("visitorName");
/* String id=new String(request.getParameter("id").getBytes("ISO-8859-1"),"UTF-8"); */
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("加载数据库驱动时抛出异常,内容如下:");
e.printStackTrace();
}
Connection conn4 = DriverManager.getConnection("jdbc:mysql://localhost:3306/visitor","root","123456");
Statement stmt4=conn4.createStatement();
Statement stmt5=conn4.createStatement();
ResultSet rs6=stmt4.executeQuery("select * from message ");
ResultSet rs7=stmt5.executeQuery("select * from replyed ");
while(rs6.next()){
out.println("id:"+rs6.getString(1)+"用户"+rs6.getString(2)+"留言内容:"+rs6.getString(3)+"日期"+rs6.getString(4));
out.println("<br>");
out.println("<form action='reply.jsp' method='post'>");
out.println("<textarea name='text3' rows='3' cols='40'>");
out.println("</textarea>");
out.println("<br>");
out.println("<input name='replyName' type='hidden' value='rs6.getString(1)'> ");
out.println("<input type='reset' value='清空'> ");
out.println("<input type='submit' value='回复'> ");
out.println("</form>");
while(rs7.next()){
out.println("<br>");
out.println("id:"+rs7.getString(1)+"用户"+rs7.getString(2)+"回复内容:"+rs7.getString(3)+"日期"+rs7.getString(4)+"回复ID"+rs7.getString(5));
}
}
stmt4.close();
stmt5.close();
conn4.close();
rs6.close();
%>
msgs.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
<!-- 将留言存入数据库并返回message.jsp显示 -->
<%
String text=new String(request.getParameter("text2").getBytes("ISO-8859-1"),"UTF-8");
String name7=(String)session.getAttribute("visitorName");
/* String text3=(String)session.getAttribute("text2"); */
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("加载数据库驱动时抛出异常,内容如下:");
e.printStackTrace();
} Connection conn4 = DriverManager.getConnection("jdbc:mysql://localhost:3306/visitor","root","123456");
Statement stmt4=conn4.createStatement();
int rs5=stmt4.executeUpdate("insert into message(name,text)values('"+name7+"','"+text+"')");
/* ResultSet rs6=stmt4.executeQuery("select * from message where name='"+name7+"' ");
while(rs6.next()){
out.println("id:"+rs6.getString(1)+"用户"+rs6.getString(2)+"留言内容:"+rs6.getString(3)+"日期"+rs6.getString(4));
out.println("<br>");
} */
stmt4.close();
conn4.close();
/* rs6.close(); */
%>
<jsp:forward page="message.jsp"/>
reply.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*" %>
<!-- 将回复存入数据库,并返回message.jsp中显示 -->
<%
String name7=(String)session.getAttribute("visitorName");
String replyId=new String(request.getParameter("replyName").getBytes("ISO-8859-1"),"UTF-8");
String replyText=new String(request.getParameter("text3").getBytes("ISO-8859-1"),"UTF-8");
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("加载数据库驱动时抛出异常,内容如下:");
e.printStackTrace();
}
Connection conn7 = DriverManager.getConnection("jdbc:mysql://localhost:3306/visitor","root","123456");
Statement stmt7=conn7.createStatement();
int rs7=stmt7.executeUpdate("insert into replyed(name,message,replyId)values('"+name7+"','"+replyText+"','"+replyId+"')");
stmt7.close();
conn7.close();
%>
<jsp:forward page="message.jsp"/>
//////session.setAttribute("visitorName",name6);
/////上边的visitorName是从这里来的,在用户登陆的时候提取用户的name6这个参数
这个问题卡了我两天了,自己一个人想想不出来,,厚着脸皮看看有没有人能帮我看看该怎么改,谢谢了
相关分类