使用SpringBoot+Mybatis+postgresql在IDEA中搭建

绝地灬酷狼 2021-06-11 15:14 429阅读 0赞

**SpringBoot:**正是在这样的一个背景下被抽象出来的开发框架，它本身并不提供Spring框架的核心特性以及扩展功能，只是用于快速、敏捷地开发新一代基于Spring框架的应用程序。也就是说，它并不是用来替代Spring的解决方案，而是和Spring框架紧密结合用于提升Spring开发者体验的工具。总一个一个字爽

**postgresql:**PostgreSQL是一个开源的、对象关系型数据库管理系统（ORDBMS）

废话不多说上代码！

**第一步：新建项目**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 2][]

点击finaly结束

**第二步：下载jar包**

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.postgresql</groupId>
                <artifactId>postgresql</artifactId>
                <scope>runtime</scope>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.9</version>
            </dependency>

**第三步:编写实体类 dao层 service层 控制层 \*.xml**

实体类![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 3][]

dao层

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 4][]

service层

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 6][]

控制层

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 7][]

写\*.xml

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 8][]

<?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.szxs.dao.HaCmdDao">
    
        
        <select id="queryHaCmdList" resultType="HaCmd">
              select * from ha_cmd limit 5;
        </select>
    
    </mapper>

**第四步 :最重要的配置**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 9][]

#端口号
    server.port=8080 
    #前缀后缀
    spring.mvc.view.prefix=classpath:/templates/
    spring.mvc.view.suffix=.jsp
    #thymeleaf start
    spring.thymeleaf.mode=jsp
    spring.thymeleaf.encoding=UTF-8
    #开发时关闭缓存,不然没法看到实时页面
    spring.thymeleaf.cache=false
    #thymeleaf end
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    #配置url
    spring.datasource.url=jdbc:postgresql://地址:5432/数据库?useUnicode=true&characterEncoding=utf-8
    #用户名
    spring.datasource.username=用户名
    #密码
    spring.datasource.password=密码
    #驱动
    spring.datasource.driver-class-name=org.postgresql.Driver
    mybatis.mapper-locations=classpath:/mybatis/*.xml
    mybatis.type-aliases-package=com.szxs.demo
    mybatis.configuration.auto-mapping-behavior=full
    mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

**第五步:配置启动类**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 10][]

package com.xka;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.context.annotation.ComponentScan;
    import org.springframework.transaction.annotation.EnableTransactionManagement;
    import org.springframework.web.servlet.config.annotation.EnableWebMvc;
    
    @SpringBootApplication
    @ComponentScan("com.xka")       //加载@Service @Control注解类
    @MapperScan(value = "com.xka.dao")  //mybatis 需要扫描mapper接口 dao层
    @EnableWebMvc                   //启用mvc
    @EnableTransactionManagement    //启用事务管理
    public class DemoApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(DemoApplication.class, args);
        }
    
    }

**但是如果要运行页面的话要用HTML**

如果您要使用jsp页面的话，请看下面链接

[https://www.cnblogs.com/xbq8080/p/7764287.html][https_www.cnblogs.com_xbq8080_p_7764287.html]

**如本博客中有不对的地方，请各位老鸟赐教**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70]: /images/20210522/97df35b4faa440ae975a2162c6913fd8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 1]: /images/20210522/2a55162f1708478bba3526c92f1043b8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 2]: /images/20210522/c38d6aa83f7d423f9b105945283d4132.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 3]: /images/20210522/60f6917220c34d31b1602f79b060d9f6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 4]: /images/20210522/4c11c01972f342ccb209c6723ef88d64.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 5]: /images/20210522/3e3836d5e66d4678b4793e64bdf8a598.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 6]: /images/20210522/eaeb9211fa9a49e8819a48cdcb523b03.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 7]: /images/20210522/f54ab5c5886a41aabc79e37b6f86fdd2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 8]: /images/20210522/c5e4c5f08fd84cda90f42a7082837225.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 9]: /images/20210522/691fff1b4dc3467aa62aa40769a0fbc4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FkbWluUHdk_size_16_color_FFFFFF_t_70 10]: /images/20210522/d847bfda94be4e2bb48c07600c46c473.png
[https_www.cnblogs.com_xbq8080_p_7764287.html]: https://www.cnblogs.com/xbq8080/p/7764287.html