The Code for demo demo, using annotations to complete the integration of spring boot and mybatis, and to control things
Configuration of the data source:
1 spring.datasource.url=jdbc:mysql://localhost:3306/book2 Spring.datasource.username=Root3 spring.datasource.password=4 spring.datasource.driver-class-name=com.mysql.jdbc.driver
Dependent Packages:
1 <dependency>2 <groupId>mysql</groupId>3 <artifactid >mysql-connector-java</artifactId>4 </dependency>5 <dependency>6 <groupId>org.mybatis.spring.boot</groupId>7 <artifactId> Mybatis-spring-boot-starter</artifactid>8 <version>1.0.0</version>9 </dependency>
Mapper:
@Configuration Public Interface Bookmapper { @Update ("Update books set Publicsher =#{publicsher} where BookID = #{id}") publicint update (@Param ("Publicsher") String Publicsher, @Param ("id")int ID);}
Service:
@Service Public class Implements bookservice { @Autowired private bookmapper bookmapper; @Transactional publicvoidint bookId) { bookmapper.update ( Publicsher,bookid);} }
Controller:
@RestController Public class Bookcontroller { @Autowired private bookservice bookservice; @RequestMapping ("/updatabook") public string Updatabook (string name,int ID) { bookservice.update (name,id); return "Updata Success"; } }
APP:
@ComponentScan (basepackages = {"Com.szzt.controller", "Com.szzt.service", "Com.szzt.exceptionHandler"}) @ Mapperscan (basepackages= "Com.szzt.mapper") @EnableAutoConfigurationpublicclass App { publicstaticvoid main (string[] args) { Springapplication.run (App.class, args); } }
Spring Boot integrated mybatis+ transaction control