请各位大神帮我看下我的代码 看看我应该怎么修改

qq744056399 qq744056399 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区

QueryMessageServlet.java


package com.MSG2.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


public class QueryMessageServlet extends HttpServlet {

@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}

private static final long serialVersionUID = 6370397999953861485L;

private List<Map<String,Object>> query(String serial,Connection conn) throws SQLException{
String sql1 = "SELECT Message,number,messa,user,Raply FROM reply WHERE Message=?";
PreparedStatement pst = conn.prepareStatement(sql1);
pst.setString(1, serial);
ResultSet rs = pst.executeQuery();
if (rs != null && rs.next()){
List<Map<String,Object>> list1 = new ArrayList<Map<String,Object>>();
while (true) {
Map<String, Object> map1 = new HashMap<String,Object>();
map1.put("Message",rs.getString("Message"));
map1.put("number",rs.getString("number"));
map1.put("messa",rs.getString("messa"));
map1.put("user",rs.getString("user"));
map1.put("Raply",rs.getString("Raply"));
List<Map<String,Object>> l = query(rs.getString("Message"),conn);
map1.put("replys", l);

list1.add(map1);

if(!rs.next()){
break;
}
}
return list1;
}
return null;
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
Connection conn = null;
String URL = "jdbc:mysql://localhost:3306/test3?useUnicode=true&characterEncoding=utf-8";
String USER = "root";
String PWD = "123456";
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER, PWD);
String sql = "SELECT serial,username,content FROM message";
PreparedStatement pre = conn.prepareStatement(sql);
ResultSet re = pre.executeQuery();
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
if (re != null) {
while (re.next()) {
Map<String, Object> map = new HashMap<String, Object>();
int serial1 = re.getInt("serial");
String serial = "" + serial1;
map.put("serial", serial);
map.put("username", re.getString("username"));
map.put("content", re.getString("content"));
List<Map<String,Object>> l = query(serial,conn);
map.put("replys", l);
list.add(map);
}
} else {
System.out.println("还未留言");
}
HttpSession session = req.getSession();
session.setAttribute("list",list);
session.setAttribute("list1",list);
resp.sendRedirect(req.getContextPath() + "/list.jsp");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
}

}

}

如果是以上代码的话 conn会以参数的方式传入query()方法 倒是这样的话又会造成死循环好像会影响到query()里面的游标

package com.MSG2.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


public class QueryMessageServlet extends HttpServlet {

@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
private static final long serialVersionUID = 6370397999953861485L;



private List<Map<String,Object>> query(String serial) throws SQLException{
Connection conn = null;
String sql1 = "SELECT Message,number,messa,user,Raply FROM reply WHERE Message=?";
PreparedStatement pst = conn.prepareStatement(sql1);
pst.setString(1, serial);
ResultSet rs = pst.executeQuery();
if (rs != null && rs.next()){
List<Map<String,Object>> list1 = new ArrayList<Map<String,Object>>();
while (true) {
Map<String, Object> map1 = new HashMap<String,Object>();
map1.put("Message",rs.getString("Message"));
map1.put("number",rs.getString("number"));
map1.put("messa",rs.getString("messa"));
map1.put("user",rs.getString("user"));
map1.put("Raply",rs.getString("Raply"));
List<Map<String,Object>> l = query(rs.getString("Message"));
map1.put("replys", l);

list1.add(map1);

if(!rs.next()){
break;
}
}
return list1;
}
return null;
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String URL = "jdbc:mysql://localhost:3306/test3?useUnicode=true&characterEncoding=utf-8";
String USER = "root";
String PWD = "123456";
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER, PWD);
String sql = "SELECT serial,username,content FROM message";
PreparedStatement pre = conn.prepareStatement(sql);
ResultSet re = pre.executeQuery();
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
if (re != null) {
while (re.next()) {
Map<String, Object> map = new HashMap<String, Object>();
int serial1 = re.getInt("serial");
String serial = "" + serial1;
map.put("serial", serial);
map.put("username", re.getString("username"));
map.put("content", re.getString("content"));
List<Map<String,Object>> l = query(serial);
map.put("replys", l);
list.add(map);
}
} else {
System.out.println("还未留言");
}
HttpSession session = req.getSession();
session.setAttribute("list",list);
session.setAttribute("list1",list);
resp.sendRedirect(req.getContextPath() + "/list.jsp");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
}

}

}


如果是这样的话代码的话又报这种错误严重: Servlet.service() for servlet query-message threw exception
java.lang.NullPointerException
at com.MSG2.servlet.QueryMessageServlet.query(QueryMessageServlet.java:34)
at com.MSG2.servlet.QueryMessageServlet.doPost(QueryMessageServlet.java:79)
at com.MSG2.servlet.QueryMessageServlet.doGet(QueryMessageServlet.java:25)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
我已经试了不少方法 但都不行 不少报空就是死循环
...全文
评论 5
收藏 已收藏
分享
返回顶部
qq744056399
Java EE 67,535 成员 225,843 内容