Tomact mybatis web交互

问题遇到的现象和发生背景

使用tomcat mybatis servlet 进行web页面和数据库的交互

问题相关代码,请勿粘贴截图

img

package Class;

import com.mapper.Usermapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.io.InputStream;

@WebServlet("/dd")
public class Servlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession();
        Usermapper mapper = session.getMapper(Usermapper.class);
        String username =request.getParameter("username");
         String password =request.getParameter("password");
        User user= mapper.Select(username,password);
        System.out.println(user);
        System.out.println(username);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        System.out.println("hjiuhjui");
    }
}


运行结果及报错内容

显示500 我测试了数据库 数据可以输出到控制台
单独的doget不连接数据库也正常可输出到控制台

我的解答思路和尝试过的方法

我卡了一天了 我实在不懂 我学的比较浅

我想要达到的结果

我想完成交互

看你这边的描述,大概是tomcat里缺少mybatis的核心jar包,可以把mybatis的核心jar包放到tomcat的lib里再重启tomcat后试一下