问题遇到的现象和发生背景
使用tomcat mybatis servlet 进行web页面和数据库的交互
问题相关代码,请勿粘贴截图
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不连接数据库也正常可输出到控制台
我的解答思路和尝试过的方法
我卡了一天了 我实在不懂 我学的比较浅
我想要达到的结果
我想完成交互