PostgreSQL整合项目

数据库下载地址如下：
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Spring Boot项目集成PostgreSQL如下：

    1）添加项目依赖：

        <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>

    2）在application.properties或application.yml配置PostgreSQL参数如下

        spring.datasource.platform=postgres

        spring.datasource.url=jdbc:postgresql://127.0.0.1:5432/runoobdb

        spring.datasource.username=xxxx(系统下的用户名，可自建用户授权)

        spring.datasource.password=xxxx(同上)

        spring.datasource.driver-class-name=org.postgresql.Driver

        mybatis.config-location=classpath:mybatis-config.xml（配置时注意自己项目路径）

        mybatis.mapper-locations=classpath:mapper/*.xml（同上）

    3）配置mybatis-config.xml，mapper以及mapper.xml路径以及项目启动扫描

        mapper:

        @Mapper

        public interface UserMapper {

            List<User> getAll();

        }

        mapper.xml:

        <?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.norman.mapper.UserMapper">

            <resultMap id="BaseResultMap" type="com.norman.entity.User">

                <id column="id" property="id" jdbcType="BIGINT"></id>

                <result column="name" property="username" jdbcType="VARCHAR"></result>

            </resultMap>

            <select id="getAll" resultMap="BaseResultMap">

                select * from company order by name desc

            </select>

        </mapper>

        mybatis-config.xml（这里写的整合项目，并没有配置过多，所以留下了空的配置文件）:

        <?xml version="1.0" encoding="UTF-8"?>

        <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

        <configuration>

        </configuration>

   编写RestContorller访问如下

    @RestController

    @RequestMapping("/user")

    public class UserController {

        @Autowired(required = false)

        private UserMapper userMapper;

        @RequestMapping("/getUserList")

        @ResponseBody

        public List<User> getUserList() {

            List<User> list = userMapper.getAll();

            return list;

        }

    }