求解:运行web项目时报错实例化servlet类异常
第一次打开报错500!实例化servlet类异常,然后再次刷新之后报错404!
这个类的源码如下
package top.yocont.servlet;
import com.google.gson.Gson;
import top.yocont.entity.KaoxiangWendu;
import top.yocont.utils.JdbcUtils;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
@WebServlet(name = "KxwdList", urlPatterns = "/KxwdList")
public class KxwdList extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
/**
* 读取数据库查询所有烤箱温度
*/
String json = null;
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
con = JdbcUtils.getConnection();
String sql = "select * from kxwdzhejianglanniao";
pstmt = con.prepareStatement(sql);
rs =pstmt.executeQuery();
/**
* 封装成多个烤箱温度对象
*/
List<KaoxiangWendu> kxwds = new ArrayList<KaoxiangWendu>();
while (rs.next()){
KaoxiangWendu kw = new KaoxiangWendu();
/**
* 封装对象
*/
kw.setId(rs.getInt("Id"));
kw.setKxbh(rs.getString("kxbh"));
kw.setJlrq(rs.getString("jlrq"));
kw.setD1(rs.getDouble("d1"));
kw.setD2(rs.getDouble("d2"));
kw.setD3(rs.getDouble("d3"));
kw.setD4(rs.getDouble("d4"));
kw.setD5(rs.getDouble("d5"));
kw.setD6(rs.getDouble("d6"));
kw.setD7(rs.getDouble("d7"));
kw.setD8(rs.getDouble("d8"));
kw.setD9(rs.getDouble("d9"));
kw.setD11(rs.getDouble("d11"));
kw.setD12(rs.getDouble("d12"));
kw.setD13(rs.getDouble("d13"));
kw.setD14(rs.getDouble("d14"));
kw.setD15(rs.getDouble("d15"));
kw.setD16(rs.getDouble("d16"));
kw.setD17(rs.getDouble("d17"));
kw.setD18(rs.getDouble("d18"));
kw.setD19(rs.getDouble("d19"));
kw.setD20(rs.getDouble("d20"));
kw.setD21(rs.getDouble("d21"));
kw.setD22(rs.getDouble("d22"));
kw.setD23(rs.getDouble("d23"));
kw.setD24(rs.getDouble("d24"));
kw.setD25(rs.getDouble("d25"));
kw.setD26(rs.getDouble("d26"));
kw.setD27(rs.getDouble("d27"));
kw.setD28(rs.getDouble("d28"));
kw.setD29(rs.getDouble("d29"));
kw.setD30(rs.getDouble("d30"));
kw.setD31(rs.getDouble("d31"));
kw.setD32(rs.getDouble("d32"));
kw.setD33(rs.getDouble("d33"));
kw.setD34(rs.getDouble("d34"));
kw.setD35(rs.getDouble("d35"));
kw.setD36(rs.getDouble("d36"));
kw.setD37(rs.getDouble("d37"));
/**
* 添加对象到集合
*/
kxwds.add(kw);
/**
* 转换成json字符串
*/
Gson gson = new Gson();
json = gson.toJson(kxwds);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
JdbcUtils.releaseResource(con, pstmt, rs);
}
/**
* 响应给前端
*/
response.setCharacterEncoding("utf-8");
response.setContentType("application/json");
response.getWriter().write(json);
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
}
}
有没有大佬解答一下什么原因?我快裂开了找不到问题出在哪