springboot整合mybatis 快速入门

本篇文章主要介绍springboot+mybatis的快速整合

前期准备

• jdk1.8
• IntelliJ IDEA
• maven3.3

正文开始

打开我们的IntelliJ IDEA，创建一个新的Project

填写Group与Artifact，然后点击Next

左边选中web，勾上web

选中SQL，勾上MyBatis和SQL Server，点击Next
我这边用的是SQL Server，你们可按照自己实际情况选择数据库

选择项目存放路径，点击Next

打开application.properties，编写我们的数据库信息

注解式方式编写mapper，更加简洁高效

创建一个mapper并且编写SQL

@Mapper
public interface UserMapper {
    @Select("select Users from [dbo].[Sys_UserInfo] where ID = #{id}")
    String getUsersByID(@Param("id")Integer id);
}

编写访问的控制器

@RestController
@RequestMapping("/demo")
public class UserController {
    @Autowired
    private UserMapper userMapper;

    @RequestMapping("/query")
    public String query(){
        String userName = userMapper.getUsersByID(1);
        return userName;
    }
}

然后我们把启动类移动到上一级目录，并运行程序

启动成功，默认的端口号是8080

2019-04-02 16:35:10.720  INFO 4752 --- [           main] com.demo.MybatisdemoApplication          : Starting MybatisdemoApplication on B1WXVXYDGNX360Q with PID 4752 (started by Administrator in D:\IDEA project\springbootMybatis)
2019-04-02 16:35:10.720  INFO 4752 --- [           main] com.demo.MybatisdemoApplication          : No active profile set, falling back to default profiles: default
2019-04-02 16:35:15.192  INFO 4752 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2019-04-02 16:35:15.270  INFO 4752 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2019-04-02 16:35:15.270  INFO 4752 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.16]
2019-04-02 16:35:15.301  INFO 4752 --- [           main] o.a.catalina.core.AprLifecycleListener   : The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\Program Files\Java\jdk1.8.0_191\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Program Files\Java\jdk1.7.0_13\bin;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\TortoiseSVN\bin;E:\apache-maven-3.3.9\bin;C:\Users\Administrator.B1WXVXYDGNX360Q\AppData\Local\BypassRuntm;.]
2019-04-02 16:35:15.691  INFO 4752 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2019-04-02 16:35:15.691  INFO 4752 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 4565 ms
2019-04-02 16:35:17.018  INFO 4752 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2019-04-02 16:35:17.985  INFO 4752 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2019-04-02 16:35:17.985  INFO 4752 --- [           main] com.demo.MybatisdemoApplication          : Started MybatisdemoApplication in 9.498 seconds (JVM running for 13.941)

接下来我们运行一下程序

数据库数据