求解:运行web项目时报错实例化servlet类异常

求解:运行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");
    }

}

有没有大佬解答一下什么原因?我快裂开了找不到问题出在哪

评论 18
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值