——卡尔马克思

解读#xff1a;马克思强调了实践的重要性#xff0c;主张哲学不仅要理解世界#xff0c;更要致力于改造世界。

本文我们引入

解读马克思强调了实践的重要性主张哲学不仅要理解世界更要致力于改造世界。

本文我们引入

https://mvnrepository.com/artifact/org.postgresql/postgresql

dependencygroupIdorg.postgresql/groupIdartifactIdpostgresql/artifactIdversion42.6.0/version

/dependency!--

https://mvnrepository.com/artifact/com.alibaba/druid

dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.2.8/version

/dependency!--

https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-boot-starter

dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.5.3.1/version

/dependency!--

https://mvnrepository.com/artifact/org.projectlombok/lombok

dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.18.30/versionscopeprovided/scope

/dependency!--

dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId

/dependency二、配置

jdbc:postgresql://127.0.0.1:5432/dbnameusername:

postgrespassword:

#################driver-class-name:

com.alibaba.druid.pool.DruidDataSource

三、配置

com.example.pgsqldemo.config;import

org.mybatis.spring.annotation.MapperScan;

import

org.springframework.context.annotation.Configuration;/***

version:

MapperScan(com.example.pgsqldemo.dao)

public

com.example.pgsqldemo.dto;import

lombok.Data;/***

com.example.pgsqldemo.dto;import

lombok.Data;import

com.example.pgsqldemo.handler;import

com.example.pgsqldemo.dto.MySettingsDTO;

import

org.apache.ibatis.type.BaseTypeHandler;

import

org.apache.ibatis.type.JdbcType;

import

org.postgresql.util.PGobject;import

java.sql.*;

BaseTypeHandlerListMySettingsDTO

{Overridepublic

setNonNullParameter(PreparedStatement

ps,

PGobject();pgObject.setType(type_my_setting);pgObject.setValue(String.format((%s,%s),

mySettingsDTO.getContent()));pgObjects[j]

pgObject;}//

conn.createArrayOf(type_my_setting,

ListMySettingsDTO

toList(rs.getArray(columnName));}Overridepublic

ListMySettingsDTO

toList(rs.getArray(columnIndex));}Overridepublic

ListMySettingsDTO

getNullableResult(CallableStatement

cs,

toList(cs.getArray(columnIndex));}private

ListMySettingsDTO

pgArray.getArray();ListMySettingsDTO

list

Objects.requireNonNull(pgObject.getValue()).replace((,

).replace(),

values[1]);list.add(mySettingsDTO);}return

list;}

com.example.pgsqldemo.dao;import

com.example.pgsqldemo.dto.TestDTO;

import

org.apache.ibatis.annotations.Mapper;

import

org.apache.ibatis.annotations.Param;import

java.util.HashMap;

dynamic_sql_query(#{dto.mySettingsDTOList,jdbcTypeARRAY,typeHandlercom.example.pgsqldemo.handler.MySettingsArrayTypeHandler});

/select

localhost:8080/api/dynamicSqlQuery#

请求报文