springboot整合mybaits
上手操作:我就想着前台到controller到数据库查所有的书返回给前台。
1.新建项目导依赖
数据库驱动,spring jdbc ,mybatis-springboot 支持
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.2</version>
</dependency>
2.一个最简单的操作,前台访问,调用controller---查数据库
controller ,pojo,mapper, yml 一顿操作,最后前台访问,给我两个250.。.贼惊喜。。
nvalid bound statement (not found):
2020-04-10 11:53:50.072 ERROR 33368 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.wang.mapper.BooksMapper.queryAllBooks] with root cause
说的好像是没找到mapper,没办法,我只能默默翻来覆去的看我的各个代码,
yml配置?,就这么点东西。。。改来改去,还是不行
spring:
datasource:
url: jdbc:mysql://localhost:3306/ssmbuild?userUnicode=true&serverTimezone=UTC&characterEncoding=utf-8
username: root
driver-class-name: com.mysql.cj.jdbc.Driver
password: 1111
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.wang.pojo
mapper配置文件?
namespace? 各sql?都没看出来有啥问题啊。
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wang.mapper.BooksMapper">
<select id="queryAllBooks" resultType="books">
select * from books;
</select>
<select id="queryBookById" resultType="com.wang.pojo.Books" parameterType="int">
select * from books where bookId = #{id}
</select>
<insert id="addBooks" parameterType="books">
insert into books (bookName, bookCounts, detail) VALUES
(#{bookName} ,#{bookCounts},#{detail})
</insert>
<update id="updateBooks" parameterType="books" >
update books set bookName = #{bookName} ,bookCounts = #{bookCounts},detail = #{detail}
where bookId = #{bookId}
</update>
<delete id="deleteBooks" parameterType="int">
delete from books where bookId = #{id}
</delete>
</mapper>
类接口?
就这么点东西,无非加了两个注解。。。
package com.wang.mapper;
import com.wang.pojo.Books;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
@Repository
public interface BooksMapper {
List<Books> queryAllBooks();
Books queryBookById(int id);
int addBooks(Books books);
int updateBooks(Books books);
int deleteBooks(int id);
}
但是,找不到一定和类接口和Mapper文件有关系吧。无奈,网上搜了半天,也没看出来问题。
。。最后又回到yml文件:
看啊看,终于,脑子灵光一现,看出来点东西。原来,我这个mapper文件根本不是.xml结尾的。wtm自己刚刚新建的时候没有加后缀。。。。。好吧,一个脑残问题。难怪网上找不到答案。。。
搞定: