ibatis <sql>和<include>

最新推荐文章于 2024-01-12 00:11:33 发布
原创 最新推荐文章于 2024-01-12 00:11:33 发布 · 297 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

<sql>和<include>，前者用来创建一个文本片段，这些片段可以组合起来创建完整的SQL语句；后者很显然就是包含的意思

 

<sql id="select-user">  

    select * from users  

</sql>  

<sql id="select-count">  

    select count(*) as value from users  

</sql>  

<sql id="where-age-over-value">  

    <![CDATA[ 

        where age > #value:INT# 

    ]]>  

</sql>  

<select id="getUserAgeOver" resultClass="hashmap">  

    <include refid="select-user" />  

    <include refid="where-age-over-value" />  

</select>  

<select id="getUserCountAgeOver" resultClass="int">  

    <include refid="select-count" />  

    <include refid="where-age-over-value" />  

</select> 

MyBatis 中动态 SQL 标签
YiHanXii的博客
01-14 2047
在 MyBatis 中，动态 SQL 是构建灵活且高效的 SQL 语句的重要工具。通过使用动态 SQL 标签，开发者可以根据不同的条件动态生成 SQL 语句的各个部分，从而避免手动拼接字符串带来的复杂性和潜在的错误。
IBATIS中的include功能
huiy的专栏
08-13 1124
[code="java"] FROM items WHERE parentid = 6 SELECT COUNT(*) AS total SELECT id, name [/code]
iBATIS的SQLMap的命名空间得使用
蓝剑专栏
06-06 1万+
在我们写SQL Map文件时，如下行基本上我们是按照每个表一个命名空间(namespace)的。在这个命名空间内有如下的SQLID行      SELECT id, username, password FROM users WHERE id = #id#  ]]> 请注意这里的 id="getUserById" 在同一个命名空间中是不允许重复的，那么也就意味着在不同的命名空间
为代码减负之<一>触发器（SQL）
weixin_33708432的博客
01-11 110
对触发器一词早有耳闻（最早是在耿大妈的数据库视频中），当初看完视频后，对理解不深刻的东西如：触发器，存储过程，事务，日志等等没有具体的去查阅，也没有具体的去尝试，应用。所以才导致了今天的博客（把曾经丢下的补上）。提到触发器一词，首先想到的是“触发器不能乱用”，“慎用触发器”，只是我们可不能把这些提醒的话，当成了自己不去尝试的借口。学习要有无知者无畏的精神，管他呢，先试了再说。 简介 ...
SQL语句中“<>”含义
热门推荐
Buevara的博客
08-13 2万+
在SQL语句中，“<>”代表的是不等于，和 " != "是一个意思！
ibatis 的<![CDATA[干嘛的
静姐姐的专栏
06-06 1616
一直写sql语句都是直接copy，写自己想要的，今天看了下究竟这个&lt;![CDATA[是干嘛的居然很简单，只是为了让系统知道，并且识别到一些特殊字符，以“]]&gt;”结束只有以下几种情况才需要，特殊注意，下面说：&lt; &amp;gt;  小于号&gt; &amp;lt;  大于号&amp; &amp; 和&amp;apos; ' 单引号" " 双引号&lt;![CDATA[ select...
<?xml version="1.0"?> <!-- project:根标签 xsi:schemaLocation：指定了 XML 模式文件的位置，用于验证 POM 文件的结构。 xmlns：指定了 POM 文件使用的 XML 命名空间为 http://maven.apache.org/POM/4.0.0。 xmlns:xsi：指定了 XML 模式实例的命名空间。 --> <project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <!-- 指定了 POM 模型的版本，目前 Maven 项目通常使用的是 4.0.0。 --> <modelVersion>4.0.0</modelVersion> <!-- 定义了该项目的父项目信息，继承父项目的配置可以避免重复配置。 --> <parent> <!-- 父项目的组标识，用于唯一标识项目所属的组织或团队。 --> <groupId>com.axatp</groupId> <!-- 父项目的项目标识，用于唯一标识项目的名称。 --> <artifactId>axatp-parent</artifactId> <!-- 父项目的版本号。 --> <version>0.0.2</version> <!-- 指定父项目 POM 文件的相对路径，这里表示父项目 POM 文件在当前项目的上一级目录的 axatp-parent 目录下。 --> <relativePath>../axatp-parent</relativePath> </parent> <!-- 当前项目的项目标识，用于唯一标识该项目。 --> <artifactId>ereporting</artifactId> <!-- 当前项目的版本号，-SNAPSHOT 表示这是一个快照版本，通常用于开发阶段。 --> <version>0.0.1-SNAPSHOT</version> <!-- 指定项目的打包方式，这里是 war，表示该项目将被打包成 Web 应用程序归档文件。 --> <packaging>war</packaging> <!-- 项目的名称，通常用于显示在 Maven 构建的日志和报告中。 --> <name>ereporting</name> <!-- 项目的主页 URL，通常指向项目的官方网站或文档页面。 --> <url>http://maven.apache.org</url> <properties> <!-- 编译环境版本 --> <compile.version>1.8</compile.version> <!-- Spring核心版本 --> <spring.version>5.3.26</spring.version> <!-- Spring Session版本 --> <spring.session.version>1.3.0.RELEASE</spring.session.version> <!-- Spring Session + Redis版本 --> <spring.session.data.redis.version>1.3.0.RELEASE</spring.session.data.redis.version> <!-- Log4j日志版本 --> <log4j.version>2.20.0</log4j.version> </properties> <dependencies> <!-- 添加spring依赖包 --> <!--一、 Spring Framework 核心模块 --> <dependency> <groupId>${spring.groupId}</groupId> <!-- IoC 容器核心，提供依赖注入（DI）和事件驱动支持。 --> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>${spring.groupId}</groupId> <!-- 基础工具库，包含核心工具类和资源加载。 --> <artifactId>spring-core</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>${spring.groupId}</groupId> <!-- Bean 工厂支持，管理 Java 对象的生命周期和配置。 --> <artifactId>spring-beans</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>${spring.groupId}</groupId> <!-- AOP 支持，提供面向切面编程（如事务管理、日志拦截）。 --> <artifactId>spring-aop</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>${spring.groupId}</groupId> <!-- ORM 集成，支持 Hibernate/JPA 等持久层框架。 --> <artifactId>spring-orm</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>${spring.groupId}</groupId> <!-- 扩展工具，如缓存（EhCache）、邮件（JavaMail）、任务调度（TaskExecutor）。 --> <artifactId>spring-context-support</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>${spring.groupId}</groupId> <!-- MVC 框架，用于构建 Web 应用（控制器、视图解析、RESTful 支持）。 --> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <!-- 二、 Spring Security 安全框架 --> <dependency> <groupId>${spring.groupId}.security</groupId> <!-- 安全核心，提供认证（Authentication）和授权（Authorization）基础功能。 --> <artifactId>spring-security-core</artifactId> <version>3.2.9.RELEASE</version> </dependency> <dependency> <groupId>${spring.groupId}.security</groupId> <!-- Web 安全支持，过滤链（FilterChain）、URL 权限控制。 --> <artifactId>spring-security-web</artifactId> <version>3.2.9.RELEASE</version> </dependency> <dependency> <groupId>${spring.groupId}.security</groupId> <!-- 配置命名空间，支持 XML 和注解配置（如 @EnableWebSecurity）。 --> <artifactId>spring-security-config</artifactId> <version>3.2.9.RELEASE</version> </dependency> <dependency> <groupId>${spring.groupId}.security</groupId> <!-- JSP 标签库，用于页面中控制权限显示（如 <sec:authorize>）。 --> <artifactId>spring-security-taglibs</artifactId> <version>3.2.9.RELEASE</version> </dependency> <dependency> <groupId>org.springframework.security</groupId> <!-- Web 安全支持，过滤链（FilterChain）、URL 权限控制。 --> <artifactId>spring-security-web</artifactId> <version>3.2.9.RELEASE</version> </dependency> <!-- 三、Wicket JSR-303 验证支持库 --> <dependency> <groupId>org.wicketstuff</groupId> <artifactId>jsr303</artifactId> <!-- 作用：为Apache Wicket框架添加JSR-303 Bean Validation支持 典型场景：在Wicket模型对象中使用@NotNull/@Size等注解进行表单验证 版本说明：版本号通常由父POM或dependencyManagement统一管理 --> <exclusions> <!-- 排除组：声明需要排除的传递性依赖（解决冲突/替换实现） --> <exclusion> <!-- 排除javax.validation:validation-api 原因：避免与项目中其他验证API（如Hibernate Validator）冲突 替代方案：显式引入jakarta.validation-api 3.0.2+ --> <groupId>javax.validation</groupId> <artifactId>validation-api</artifactId> </exclusion> <exclusion> <!-- 排除log4j 1.x 原因：Log4j 1.x已停止维护且存在安全漏洞（CVE-2019-17571） 替代方案：使用Log4j 2.x或Logback --> <groupId>log4j</groupId> <artifactId>log4j</artifactId> </exclusion> <exclusion> <!-- 排除slf4j-log4j12桥接器 原因：这是SLF4J与Log4j 1.x的桥接，排除后需绑定其他日志实现 替代方案：使用logback-classic或log4j-slf4j-impl --> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> </exclusion> <exclusion> <!-- 排除传递性slf4j-api 原因：避免多版本冲突，应由项目统一管理SLF4J版本 建议：在dependencyManagement中显式声明slf4j-api版本 --> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> </exclusion> </exclusions> </dependency> <!-- 四、Jackson JSON 处理库（核心三件套） --> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <!-- Jackson 核心流式解析器，提供高性能的JSON读写能力 --> <artifactId>jackson-core</artifactId> <version>2.11.0</version><!-- 注意：此版本存在漏洞，建议升级到2.15.3+ --> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <!-- Jackson 数据绑定模块，实现Java对象与JSON的相互转换 --> <artifactId>jackson-databind</artifactId> <version>2.11.0</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <!-- Jackson 注解模块，支持通过注解控制序列化行为 --> <artifactId>jackson-annotations</artifactId> <version>2.11.0</version><!-- 通常与其他模块版本保持一致 --> </dependency> <!--五、JavaMail 邮件客户端 --> <dependency> <groupId>com.sun.mail</groupId> <!-- JavaMail API 实现，用于发送/接收邮件（SMTP/POP3/IMAP） --> <artifactId>javax.mail</artifactId> <version>1.6.1</version> </dependency> <!-- 六、Ehcache 缓存框架 --> <dependency> <groupId>net.sf.ehcache</groupId> <!-- Ehcache 核心库，提供内存+磁盘缓存管理 --> <artifactId>ehcache-core</artifactId> </dependency> <dependency> <groupId>com.googlecode.ehcache-spring-annotations</groupId> <!-- Ehcache 与 Spring 集成的注解支持 --> <artifactId>ehcache-spring-annotations</artifactId> <version>1.2.0</version> </dependency> <!-- 七、MyBatis 核心库 --> <dependency> <groupId>org.mybatis</groupId> <!-- MyBatis 核心ORM框架，提供SQL映射和数据库访问能力 --> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <!-- 八、MyBatis-Spring 整合 --> <dependency> <groupId>org.mybatis</groupId> <!-- MyBatis与Spring框架的桥接库，实现Spring事务管理 --> <artifactId>mybatis-spring</artifactId> <version>1.3.1</version><!-- 需与MyBatis主版本匹配，建议升级到2.1.1+ --> </dependency> <!-- 九、MyBatis 分页插件 --> <dependency> <groupId>com.github.miemiedev</groupId> <!-- 第三方分页插件，提供物理分页和排序功能 --> <artifactId>mybatis-paginator</artifactId> <version>1.2.9</version><!-- 已停止维护，建议改用PageHelper --> </dependency> <!-- 十、 Hibernate Validator（Bean验证） --> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> <version>6.2.0.Final</version> </dependency> <!-- 数据库依赖包 --> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc8</artifactId> <version>19.15.0.0.0</version> </dependency> <!--和上边这个ojdbc8一起的不然字符集乱码--> <dependency> <groupId>cn.easyproject</groupId> <artifactId>orai18n</artifactId> <version>12.1.0.2.0</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.16</version> </dependency> <!-- 支持注入的包，如注入Resource --> <dependency> <groupId>com.kenai.nbpwr</groupId> <artifactId>javax-inject</artifactId> </dependency> <!-- dbcp数据源 --> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> </dependency> <!-- um系统依赖 --> <!-- <dependency> <groupId>com.axatp</groupId> <artifactId>um-client</artifactId> <version>1.0.4.RELEASE</version> </dependency>--> <dependency> <groupId>cn.axa</groupId> <artifactId>idac-client</artifactId> <version>1.0.1</version> <exclusions> <exclusion> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> </exclusion> <exclusion> <groupId>org.slf4j</groupId> <artifactId>jcl-over-slf4j</artifactId> </exclusion> <exclusion> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-api</artifactId> </exclusion> <exclusion> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-core</artifactId> </exclusion> <exclusion> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-slf4j-impl</artifactId> </exclusion> <exclusion> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-web</artifactId> </exclusion> <exclusion> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-log4j2</artifactId> </exclusion> <exclusion> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-log4j2</artifactId> </exclusion> </exclusions> </dependency> <!-- json转换包 --> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.83</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> </dependency> <dependency> <groupId>jsptags</groupId> <artifactId>pager-taglib</artifactId> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>tpfa</artifactId> <version>1.3.0.0</version> </dependency> <dependency> <groupId>commons-httpclient</groupId> <artifactId>commons-httpclient</artifactId> <version>3.0.1</version> </dependency> <dependency> <groupId>org.jdom</groupId> <artifactId>jdom</artifactId> <version>1.1</version> </dependency> <dependency> <groupId>net.sf.json-lib</groupId> <artifactId>json-lib</artifactId> <version>2.4</version> <classifier>jdk15</classifier> </dependency> <!--用于与sfl4j保持桥接--> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-slf4j-impl</artifactId> <version>${log4j.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.7.30</version> </dependency> <dependency> <groupId>org.apache.logging.log4j</groupId> <artifactId>log4j-web</artifactId> <version>${log4j.version}</version> </dependency> <!-- disconf configuration begin <dependency> <groupId>org.apache.zookeeper</groupId> <artifactId>zookeeper</artifactId> <version>3.3.6</version> <exclusions> <exclusion> <groupId>com.sun.jmx</groupId> <artifactId>jmxri</artifactId> </exclusion> <exclusion> <groupId>com.sun.jdmk</groupId> <artifactId>jmxtools</artifactId> </exclusion> <exclusion> <groupId>javax.jms</groupId> <artifactId>jms</artifactId> </exclusion> </exclusions> </dependency> --> <dependency> <groupId>org.apache.dubbo</groupId> <artifactId>dubbo</artifactId> <version>3.2.17</version> </dependency> <!--nacos包--> <!-- <dependency>--> <!-- <groupId>org.apache.dubbo</groupId>--> <!-- <artifactId>dubbo-registry-nacos</artifactId>--> <!-- <version>2.7.7</version>--> <!-- </dependency>--> <!-- <dependency>--> <!-- <groupId>com.alibaba.nacos</groupId>--> <!-- <artifactId>nacos-client</artifactId>--> <!-- <version>1.2.1</version>--> <!-- </dependency>--> <!-- https://mvnrepository.com/artifact/org.apache.curator/curator-framework --> <dependency> <groupId>org.apache.curator</groupId> <artifactId>curator-framework</artifactId> <version>2.12.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.curator/curator-x-discovery-server --> <dependency> <groupId>org.apache.curator</groupId> <artifactId>curator-x-discovery-server</artifactId> <version>2.12.0</version> </dependency> <dependency> <groupId>io.netty</groupId> <artifactId>netty-all</artifactId> <version>4.1.105.Final</version> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.zookeeper/zookeeper --> <dependency> <groupId>org.apache.zookeeper</groupId> <artifactId>zookeeper</artifactId> <version>3.9.2</version> <exclusions> <exclusion> <groupId>log4j</groupId> <artifactId>log4j</artifactId> </exclusion> <exclusion> <artifactId>slf4j-log4j12</artifactId> <groupId>org.slf4j</groupId> </exclusion> <exclusion> <artifactId>logback-classic</artifactId> <groupId>ch.qos.logback</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.reflections</groupId> <artifactId>reflections</artifactId> <version>0.9.9-RC1</version> </dependency> <dependency> <groupId>org.javassist</groupId> <artifactId>javassist</artifactId> <version>3.18.2-GA</version> </dependency> <dependency> <groupId>org.apache.httpcomponents</groupId> <artifactId>httpcore</artifactId> <version>4.4.3</version> </dependency> <dependency> <groupId>org.apache.httpcomponents</groupId> <artifactId>httpclient</artifactId> <version>4.5.1</version> </dependency> <dependency> <groupId>org.apache.httpcomponents</groupId> <artifactId>httpmime</artifactId> <version>4.5.9</version> </dependency> <!-- <dependency> <groupId>com.google.guava</groupId> <artifactId>guava</artifactId> <version>r09</version> </dependency> --> <dependency> <groupId>com.google.code.gson</groupId> <artifactId>gson</artifactId> <version>2.2.4</version> </dependency> <dependency> <groupId>com.google.guava</groupId> <artifactId>guava</artifactId> <version>18.0</version> </dependency> <dependency> <groupId>com.baidu.disconf</groupId> <artifactId>disconf-core</artifactId> <version>2.6.36</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>disconf-client</artifactId> <version>2.6.36.5</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> <version>3.4</version> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjtools</artifactId> <version>1.7.4</version> </dependency> <!-- disconf configuration end --> <!-- jasypt begin --> <dependency> <groupId>org.jasypt</groupId> <artifactId>jasypt</artifactId> <version>1.9.2</version> </dependency> <dependency> <groupId>org.jasypt</groupId> <artifactId>jasypt-spring3</artifactId> <version>1.9.2</version> </dependency> <!-- jasypt end --> <dependency> <groupId>bsh</groupId> <artifactId>bsh</artifactId> <version>2.0b4</version> </dependency> <dependency> <groupId>org.apache.velocity</groupId> <artifactId>velocity</artifactId> <version>1.7</version> </dependency> <dependency> <groupId>org.apache.velocity</groupId> <artifactId>velocity-tools</artifactId> <version>2.0</version> <exclusions> <exclusion> <groupId>org.apache.struts</groupId> <artifactId>struts-core</artifactId> </exclusion> <exclusion> <groupId>org.apache.struts</groupId> <artifactId>struts-taglib</artifactId> </exclusion> <exclusion> <groupId>org.apache.struts</groupId> <artifactId>struts-tiles</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.freemarker</groupId> <artifactId>freemarker</artifactId> <version>2.3.23</version> </dependency> <dependency> <groupId>net.sourceforge.jexcelapi</groupId> <artifactId>jxl</artifactId> <version>2.6.12</version> <exclusions> <exclusion> <groupId>log4j</groupId> <artifactId>log4j</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>javax.activation</groupId> <artifactId>activation</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>org.apache.ws.commons.axiom</groupId> <artifactId>axiom-api</artifactId> <version>1.2.20</version> </dependency> <dependency> <groupId>org.apache.ws.commons.axiom</groupId> <artifactId>axiom-impl</artifactId> <version>1.2.9</version> </dependency> <dependency> <groupId>org.apache.axis2</groupId> <artifactId>axis2-adb</artifactId> <version>1.7.4</version> </dependency> <dependency> <groupId>org.apache.axis2</groupId> <artifactId>axis2-adb-codegen</artifactId> <version>1.7.4</version> </dependency> <dependency> <groupId>org.apache.axis2</groupId> <artifactId>axis2-codegen</artifactId> <version>1.7.4</version> </dependency> <dependency> <groupId>org.apache.axis2</groupId> <artifactId>axis2-java2wsdl</artifactId> <version>1.7.4</version> </dependency> <dependency> <groupId>org.apache.axis2</groupId> <artifactId>axis2-kernel</artifactId> <version>1.7.4</version> </dependency> <dependency> <groupId>org.apache.servicemix.bundles</groupId> <artifactId>org.apache.servicemix.bundles.commons-codec</artifactId> <version>1.3_5</version> </dependency> <dependency> <groupId>stax</groupId> <artifactId>stax-api</artifactId> <version>1.0.1</version> </dependency> <dependency> <groupId>wsdl4j</groupId> <artifactId>wsdl4j</artifactId> <version>1.6.3</version> </dependency> <!-- <dependency> --> <!-- <groupId>woodstox</groupId> --> <!-- <artifactId>wstx-asl</artifactId> --> <!-- <version>3.2.7</version> --> <!-- </dependency> --> <dependency> <groupId>org.apache.ws.xmlschema</groupId> <artifactId>xmlschema-core</artifactId> <version>2.2.1</version> </dependency> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>xml-apis</groupId> <artifactId>xml-apis</artifactId> <version>1.3.04</version> </dependency> <dependency> <groupId>xalan</groupId> <artifactId>xalan</artifactId> <version>2.7.1</version> </dependency> <dependency> <groupId>xerces</groupId> <artifactId>xercesImpl</artifactId> <version>2.9.1</version> </dependency> <dependency> <groupId>xml-apis</groupId> <artifactId>xml-apis-ext</artifactId> <version>1.3.04</version> </dependency> <dependency> <groupId>org.plutext</groupId> <artifactId>jaxb-xslfo</artifactId> <version>1.0.1</version> </dependency> <dependency> <groupId>org.apache.avalon.framework</groupId> <artifactId>avalon-framework-api</artifactId> <version>4.3.1</version> </dependency> <dependency> <groupId>org.apache.avalon.framework</groupId> <artifactId>avalon-framework-impl</artifactId> <version>4.3.1</version> </dependency> <dependency> <groupId>org.apache.xmlgraphics</groupId> <artifactId>xmlgraphics-commons</artifactId> <version>2.1</version> </dependency> <dependency> <groupId>org.eclipse.birt.runtime.3_7_1</groupId> <artifactId>org.apache.xml.serializer</artifactId> <version>2.7.1</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>fop</artifactId> <version>2.1</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>fontbox</artifactId> <version>1.8.5</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>batik-all</artifactId> <version>1.8</version> </dependency> <dependency> <groupId>io.jsonwebtoken</groupId> <artifactId>jjwt</artifactId> <version>0.9.0</version> </dependency> <dependency> <groupId>javax.ejb</groupId> <artifactId>ejb-api</artifactId> <version>3.0</version> </dependency> <dependency> <groupId>eu.limetri.platform</groupId> <artifactId>platform-client</artifactId> <version>0.7</version> </dependency> <dependency> <groupId>org.apache.skywalking</groupId> <artifactId>apm-toolkit-log4j-2.x</artifactId> <version>9.1.0</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>party</artifactId> <version>4.0.0-RELEASE</version> <exclusions> <exclusion> <groupId>org.apache.dubbo</groupId> <artifactId>dubbo</artifactId> </exclusion> <exclusion> <groupId>org.apache.curator</groupId> <artifactId>curator-recipes</artifactId> </exclusion> <exclusion> <groupId>org.apache.dubbo</groupId> <artifactId>dubbo-registry-nacos</artifactId> </exclusion> <exclusion> <groupId>org.hibernate.validator</groupId> <artifactId>hibernate-validator</artifactId> </exclusion> <exclusion> <groupId>org.apache.skywalking</groupId> <artifactId>apm-toolkit-log4j-1.x-activation</artifactId> </exclusion> <exclusion> <groupId>log4j</groupId> <artifactId>log4j</artifactId> </exclusion> <exclusion> <groupId>com.axatp</groupId> <artifactId>disconf-client</artifactId> </exclusion> <exclusion> <groupId>com.axatp</groupId> <artifactId>um-client</artifactId> </exclusion> <exclusion> <groupId>com.baidu.disconf</groupId> <artifactId>disconf-core</artifactId> </exclusion> <exclusion> <groupId>com.baomidou</groupId> <artifactId>kisso</artifactId> </exclusion> <exclusion> <groupId>com.sun.mail</groupId> <artifactId>javax.mail</artifactId> </exclusion> <exclusion> <groupId>com.axatp</groupId> <artifactId>tpfa</artifactId> </exclusion> <exclusion> <groupId>com.axatp</groupId> <artifactId>sso-client</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>ruleengine-client</artifactId> <version>1.0.0</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.17</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.17</version> <exclusions> <exclusion> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>ike</artifactId> <version>0.0.1</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>non-motor-net-client</artifactId> <version>0.0.0.3</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>auto-vehicle</artifactId> <version>0.0.0.1</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>schedule</artifactId> <version>0.0.0.1</version> </dependency> <dependency> <groupId>commons-net</groupId> <artifactId>commons-net</artifactId> <version>3.6</version> </dependency> <dependency> <groupId>com.jcraft</groupId> <artifactId>jsch</artifactId> <version>0.1.54</version> </dependency> <dependency> <groupId>com.ibatis</groupId> <artifactId>ibatis</artifactId> <version>2.3.2</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.9</version> </dependency> <dependency> <groupId>org.quartz-scheduler</groupId> <artifactId>quartz</artifactId> <version>2.1.5</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>property_client</artifactId> <version>1.0.1</version> </dependency> <dependency> <groupId>itext</groupId> <artifactId>itext</artifactId> <version>1.3.1</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>healthInsurance</artifactId> <version>1.0.2</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-scratchpad</artifactId> <version>3.17</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>commonHttpService</artifactId> <version>1.0.3</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>common-utils</artifactId> <version>0.0.2</version> </dependency> <dependency> <groupId>cn.axa</groupId> <artifactId>common-utils</artifactId> <version>1.4.0</version> <exclusions> <exclusion> <artifactId>log4j-core</artifactId> <groupId>org.apache.logging.log4j</groupId> </exclusion> <exclusion> <artifactId>log4j-api</artifactId> <groupId>org.apache.logging.log4j</groupId> </exclusion> <exclusion> <artifactId>log4j-slf4j-impl</artifactId> <groupId>org.apache.logging.log4j</groupId> </exclusion> <exclusion> <artifactId>log4j-web</artifactId> <groupId>org.apache.logging.log4j</groupId> </exclusion> <exclusion> <artifactId>disconf-client</artifactId> <groupId>com.axatp</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>5.1.5</version> </dependency> <dependency> <groupId>com.github.jsqlparser</groupId> <artifactId>jsqlparser</artifactId> <version>1.3</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>pay-client</artifactId> <version>0.0.5</version> </dependency> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-redis</artifactId> <version>1.8.0.RELEASE</version> </dependency> <dependency> <groupId>redis.clients</groupId> <artifactId>jedis</artifactId> <version>2.9.0</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>e-nonmotor-print</artifactId> <version>1.6.6</version> <exclusions> <exclusion> <groupId>com.axatp</groupId> <artifactId>enonmotor-party</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>e-nonmotor-client</artifactId> <version>0.0.8</version> </dependency> <!-- <dependency> <groupId>com.axatp</groupId> <artifactId>e-nonmotor-print</artifactId> <version>1.0.2</version> </dependency> --> <!--hikariCP连接池 --> <dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> <version>4.0.3</version> </dependency> <dependency> <groupId>org.apache.skywalking</groupId> <artifactId>apm-toolkit-log4j-1.x-activation</artifactId> <version>7.0.0</version> </dependency> <dependency> <groupId>com.belerweb</groupId> <artifactId>pinyin4j</artifactId> <version>2.5.1</version> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>plclaim-client</artifactId> <version>0.0.6</version> </dependency> <!-- mq--> <dependency> <groupId>com.axatp</groupId> <artifactId>common-mq</artifactId> <version>0.0.6</version> <exclusions> <exclusion> <groupId>log4j</groupId> <artifactId>log4j</artifactId> </exclusion> <exclusion> <artifactId>rocketmq-logback-classic</artifactId> <groupId>io.github.aliyunmq</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>com.axatp</groupId> <artifactId>auto-mid-client</artifactId> <version>0.0.1</version> </dependency> <dependency> <groupId>org.springframework.session</groupId> <artifactId>spring-session</artifactId> <version>${spring.session.version}</version> </dependency> <dependency> <groupId>org.springframework.session</groupId> <artifactId>spring-session-data-redis</artifactId> <version>${spring.session.data.redis.version}</version> </dependency> <!-- ENONMOTOR-R4103 okhttp上传 解决下载文件名为：______ .? --> <dependency> <groupId>com.squareup.okhttp3</groupId> <artifactId>okhttp</artifactId> <version>4.9.3</version> </dependency> <!--Lombok依赖--> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.24</version> </dependency> <!--easyexcel依赖--> <dependency> <groupId>com.alibaba</groupId> <artifactId>easyexcel</artifactId> <version>2.2.3</version> <exclusions> <exclusion> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> </exclusion> <exclusion> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>cn.axa</groupId> <artifactId>common-utils</artifactId> <version>1.7.0-SNAPSHOT</version> </dependency> <!--ENONMOTOR-R9432 邮件统一对接-商业险承保系统--> <dependency> <groupId>com.axatp</groupId> <artifactId>linkmonitor-bg</artifactId> <version>1.0.2</version> </dependency> <!--ENONMOTOR-R10065 根据销管系统账号有效性判断账号是否有效 销管jar--> <dependency> <groupId>com.axatp</groupId> <artifactId>sales</artifactId> <version>1.9.4</version> </dependency> </dependencies> <build> <finalName>ereporting</finalName> <!-- maven war 插件 --> <plugins> <plugin> <artifactId>maven-war-plugin</artifactId> <version>3.2.0</version> <!-- 排除某个文件夹下所有的文件 --> <configuration> <packagingExcludes>WEB-INF/classes/com/axatp/enonmotor/sessionFixed/*.*</packagingExcludes> <packagingExcludes>WEB-INF/classes/log4j.properties</packagingExcludes> <!-- oracle数据库升级，排除父pom文件里的ojdbc7 jar包 --> <packagingExcludes>WEB-INF/lib/ojdbc7-*.jar</packagingExcludes> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.8</source> <target>1.8</target> <encoding>UTF-8</encoding> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-surefire-plugin</artifactId> <version>2.19.1</version> <configuration> <skipTests>true</skipTests> </configuration> </plugin> </plugins> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> <include>**/*.properties</include> </includes> </resource> <resource> <directory>src/main/resources</directory> </resource> </resources> </build> </project>这个都给我用注释的方式给我解释下
10-18
<modelVersion>4.0.0</modelVersion> <!-- 项目的唯一标识符，通常使用公司或组织的域名倒序，如 com.example --> <groupId>com.example</groupId> <!-- 项目的唯一名称，通常是项目的名称或模块名 --> ...
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.7.10</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.example</groupId> <artifactId>weekly-report</artifactId> <version>0.0.1-SNAPSHOT</version> <name>weekly-report</name> <description>Employee Weekly Report System</description> <properties> <java.version>17</java.version> <maven.compiler.source>17</maven.compiler.source> <maven.compiler.target>17</maven.compiler.target> </properties> <!-- pom.xml --> <dependencies> <!-- Spring Boot Starter --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!-- MyBatis + MySQL --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.2.2</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus</artifactId> <version>3.5.7</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.30</version> <scope>runtime</scope> </dependency> <!-- Lombok --> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <!-- 其他工具 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-validation</artifactId> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.2</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> <version>2.2.2.RELEASE</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <configuration> <excludes> <exclude> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </exclude> </excludes> </configuration> </plugin> </plugins> </build> </project> 我还是决定用mybatis和mybatisPlus，请为我调整本项目的pom
最新发布
10-30
<think>我们决定使用MyBatis和MyBatis-Plus，但是项目中同时存在JPA依赖（spring-boot-starter-data-jpa）可能会引起冲突。因此，我们需要调整pom.xml，移除JPA依赖（除非有特殊原因需要同时使用两者，但通常不推荐...
### DB config # 动态数据源配置 # 设置默认的数据源 注意：primary属性指定了默认数据源，当没有明确指定数据源时，会使用这个默认数据源。 spring.datasource.dynamic.primary=master # 严格匹配数据源，未匹配到时使用默认数据源 spring.datasource.dynamic.strict=false # 主数据源配置 spring.datasource.dynamic.datasource.master.url=jdbc:oracle:thin:@//x08ddb02-vip.hkbn.com.hk:1526/ESIDDUAT spring.datasource.dynamic.datasource.master.username=fe_esone_user spring.datasource.dynamic.datasource.master.password=mpw:ZqHPBogWNSPTcHt11AdheATSlNujcH6bhhlEsbQyrQg= spring.datasource.dynamic.datasource.master.driver-class-name=oracle.jdbc.OracleDriver #spring.datasource.url=jdbc:oracle:thin:@//x08ddb02-vip.hkbn.com.hk:1526/ESIDDUAT #spring.datasource.username=fe_esone_user #spring.datasource.password=mpw:ZqHPBogWNSPTcHt11AdheATSlNujcH6bhhlEsbQyrQg= #spring.datasource.driver-class-name=oracle.jdbc.OracleDriver # 基础据源配置 #spring.datasource.dynamic.datasource.slave.url=jdbc:oracle:thin:@//x08ddb02-vip.hkbn.com.hk:1525/ESBNUAT #spring.datasource.dynamic.datasource.slave.username=FE_ESONE_USER #spring.datasource.dynamic.datasource.slave.password=mpw:/KYxwRh4EAYZfDqC5eVaeA== #spring.datasource.dynamic.datasource.slave.driver-class-name=oracle.jdbc.OracleDriver server.servlet.session.cookie.same-site=none ### SSL config server.ssl.key-store-type=PKCS12 # The path to the keystore containing the certificate server.ssl.key-store=classpath:keystore/selfsignsfdc.p12 # The password used to generate the certificate server.ssl.key-store-password=sfdcetl # The alias mapped to the certificate server.ssl.key-alias=sfdcEtl # server.ssl.enabled=false server.port=10001 server.ssl.protocol=TLS server.ssl.enabled-protocols=TLSv1.2 ### Development config embedded.tomcat.enabled=true dummy.login.enabled=false dummy.login.user.email=ben.kam@hkbn.com.hk # 开发时给默认值 test-dummy-token-123 dummy.login.token=test-dummy-token-123 logging.level.org.springframework.web.client.RestTemplate=DEBUG logging.config= # mybatis-plus Configure mapper file path mybatis-plus.mapper-locations=classpath:/mapper/*.xml mybatis-plus.type-aliases-package=com.hkbn.esidd.offer.**.entity # Print SQL log mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl logging.level.com.dormitory.dormitory_backend.mapper=DEBUG mybatis-plus.configuration.map-underscore-to-camel-case=true mybatis-plus.configuration.cache-enabled=false <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.4.1</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.hkbn.essr</groupId> <artifactId>esidd-offer</artifactId> <version>2.7.2</version> <packaging>war</packaging> <name>esidd-offer</name> <description>ESIDD-OFFER</description> <properties> <java.version>17</java.version> <skipTests>true</skipTests> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> <spring-boot.repackage.skip>true</spring-boot.repackage.skip> <org.mapstruct.version>1.5.5.Final</org.mapstruct.version> <lombok.version>1.18.24</lombok.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> <exclusions> <exclusion> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-logging</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-security</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> <exclusions> <exclusion> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <scope>runtime</scope> <optional>true</optional> </dependency> <dependency> <groupId>com.oracle.database.jdbc</groupId> <artifactId>ojdbc11</artifactId> <version>23.4.0.24.05</version> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-configuration-processor</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> <scope>provided</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-log4j2</artifactId> </dependency> <dependency> <groupId>org.springframework.security</groupId> <artifactId>spring-security-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-oauth2-client</artifactId> </dependency> <dependency> <groupId>com.azure.spring</groupId> <artifactId>spring-cloud-azure-starter-active-directory</artifactId> <version>4.19.0</version> </dependency> <dependency> <groupId>com.auth0</groupId> <artifactId>java-jwt</artifactId> <version>3.3.0</version> </dependency> <dependency> <groupId>com.auth0</groupId> <artifactId>mvc-auth-commons</artifactId> <version>1.11.0</version> </dependency> <dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports</artifactId> <version>6.21.4</version> </dependency> <dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports-fonts</artifactId> <version>6.21.4</version> </dependency> <dependency> <groupId>org.mapstruct</groupId> <artifactId>mapstruct</artifactId> <version>${org.mapstruct.version}</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> <version>3.12.0</version> </dependency> <dependency> <groupId>org.reflections</groupId> <artifactId>reflections</artifactId> <version>0.10.2</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>5.3.0</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>5.3.0</version> </dependency> <dependency> <groupId>com.google.zxing</groupId> <artifactId>core</artifactId> <version>3.5.3</version> </dependency> <dependency> <groupId>com.google.zxing</groupId> <artifactId>javase</artifactId> <version>3.5.3</version> </dependency> <dependency> <groupId>org.apache.httpcomponents.client5</groupId> <artifactId>httpclient5</artifactId> <version>5.4.1</version> </dependency> <dependency> <groupId>com.hkbnes.essr</groupId> <artifactId>eform_common</artifactId> <version>1.8.2.RELEASE</version> </dependency> <dependency> <groupId>com.hkbnes.dms</groupId> <artifactId>dms-util</artifactId> <version>1.0</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.module</groupId> <artifactId>jackson-module-jakarta-xmlbind-annotations</artifactId> <version>2.17.1</version> </dependency> <!-- mybatis-plus --> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-spring-boot3-starter</artifactId> <version>3.5.12</version> </dependency> <!-- mybatis-plus 动态数据源 --> <dependency> <groupId>com.baomidou</groupId> <artifactId>dynamic-datasource-spring-boot-starter</artifactId> <version>4.3.1</version> </dependency> </dependencies> <profiles> <profile> <id>dev</id> <properties> <profile-id>dev</profile-id> <spring.profiles.active>dev</spring.profiles.active> </properties> </profile> <profile> <id>prod</id> <properties> <profile-id>prod</profile-id> <spring.profiles.active>prod</spring.profiles.active> </properties> <activation> <activeByDefault>true</activeByDefault> </activation> </profile> </profiles> <build> <finalName>eform</finalName> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.8.1</version> <configuration> <source>${java.version}</source> <target>${java.version}</target> <annotationProcessorPaths> <path> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>${lombok.version}</version> </path> <path> <groupId>org.projectlombok</groupId> <artifactId>lombok-mapstruct-binding</artifactId> <version>0.2.0</version> </path> <path> <groupId>org.mapstruct</groupId> <artifactId>mapstruct-processor</artifactId> <version>${org.mapstruct.version}</version> </path> </annotationProcessorPaths> <compilerArgs> <compilerArg> -Amapstruct.unmappedTargetPolicy=ERROR </compilerArg> <compilerArg> -Amapstruct.nullValueIterableMappingStrategy=RETURN_DEFAULT </compilerArg> </compilerArgs> </configuration> </plugin> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <dependencies> <dependency> <groupId>org.codehaus.plexus</groupId> <artifactId>plexus-utils</artifactId> <version>3.4.2</version> </dependency> <dependency> <groupId>org.vafer</groupId> <artifactId>jdependency</artifactId> <version>2.10</version> </dependency> </dependencies> <executions> <execution> <id>build-info</id> <goals> <goal>build-info</goal> </goals> </execution> </executions> <configuration> <excludes> <exclude> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </exclude> <exclusion> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> </exclusion> </excludes> </configuration> </plugin> <plugin> <artifactId>maven-clean-plugin</artifactId> <configuration> <filesets> <fileset> <directory>${basedir}</directory> <includes> <include>**/resources/static/**</include> </includes> <followSymlinks>false</followSymlinks> </fileset> </filesets> </configuration> </plugin> <!--<plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>exec-maven-plugin</artifactId> <version>3.0.0</version> <executions> <execution> <id>run-npm-install</id> <phase>generate-sources</phase> <goals> <goal>exec</goal> </goals> <configuration> <workingDirectory>../eform-fe</workingDirectory> <executable>npm</executable> <arguments> <argument>install</argument> </arguments> </configuration> </execution> <execution> <id>exec npm build</id> <phase>generate-sources</phase> <configuration> <workingDirectory>../eform-fe</workingDirectory> <executable>npm</executable> <arguments> <argument>run</argument> <argument>build:${profile-id}</argument> </arguments> </configuration> <goals> <goal>exec</goal> </goals> </execution> </executions> </plugin>--> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-resources-plugin</artifactId> <configuration> <encoding>${project.build.sourceEncoding}</encoding> </configuration> <executions> <execution> <id>copy-resources</id> <phase>generate-resources</phase> <goals> <goal>copy-resources</goal> </goals> <configuration> <outputDirectory>${basedir}/src/main/resources/static</outputDirectory> <resources> <resource> <directory>../eform-fe/dist/eform-fe</directory> <filtering>false</filtering> </resource> </resources> </configuration> </execution> </executions> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war-plugin</artifactId> <dependencies> <dependency> <groupId>org.codehaus.plexus</groupId> <artifactId>plexus-archiver</artifactId> <version>4.8.0</version> </dependency> </dependencies> <configuration> <archive> <manifest> <addClasspath>true</addClasspath> </manifest> <!-- <manifestEntries> <Implementation-Build-Date>${fixitBuildNumberDateVariable}</Implementation-Build-Date> <Implementation-Build-Version>${buildNumber}</Implementation-Build-Version> </manifestEntries> --> </archive> <warSourceExcludes> META-INF/context.xml </warSourceExcludes> <packagingExcludes> %regex[WEB-INF/classes/application-(?:(?!${profile-id}).)*.properties], WEB-INF/classes/keystore/ </packagingExcludes> <!-- <failOnMissingWebXml>false</failOnMissingWebXml> --> </configuration> </plugin> </plugins> </build> </project> 配置Mybatis-Plus 多数据源 报错：Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine a suitable driver class Action: Consider the following: If you want an embedded database (H2, HSQL or Derby), please put it on the classpath. If you have database settings to be loaded from a particular profile you may need to activate it (the profiles dev are currently active). Disconnected from the target VM, address: '127.0.0.1:60791', transport: 'socket' Process finished with exit code 0
07-25
<artifactId>mysql-connector-java</artifactId> <version>8.0.30</version> </dependency> ``` 5. **激活配置文件（可选）** 如果数据源配置在特定的 Spring Profile 中（如 `application-dev.yml`），请...
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.example</groupId> <artifactId>mytest1</artifactId> <version>1.0-SNAPSHOT</version> <packaging>war</packaging> <!-- 确保这里设置为war --> <properties> <maven.compiler.source>8</maven.compiler.source> <maven.compiler.target>8</maven.compiler.target> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.1.7.RELEASE</version> </dependency> <!-- Spring Core --> <dependency> <groupId>org.springframework</groupId>
04-30
<include>**/*.xml</include> </includes> </resource> </resources> </build> ``` #### 3. 核对 Spring 配置 对于 Spring Boot 项目，需确保 `application.yml` 正确配置了 Mapper XML 文件路径。例如： ```...
一键替换SQL中&gt；或&lt；为＜＞大于小于符号或一键转换＜或＞为&gt；&lt；
gongjin28_csdn的博客
01-12 2104
1、在日常开发中，处理大量的SQL数据时，经常会遇到需要将转义字符&ampgt;或&amplt;替换为正常的大于小于符号的情况；为解决此问题，制作了【一键替换&ampgt;&amplt;】 和 【一键替换】 方法； 2、一键替换SQL中&ampgt;或&amplt;为大于小于符号或一键转换为&ampgt;&amplt; 3、一键完成大量文本的替换操作，大大提高了工作效率； 4、轻松地解决SQL中转义字符的问题，提高了代码可读性以及便于测试sql； 5、减少了手动或正则替换的步骤；
IBatis的Mapper配置文件中使用大于号好小于号 :>和<
04-26 1795
当sql配置文件中的元素select/insert/update中，需要使用大于号>和小于号 sql语句 ]]>  来将sql语句括起来，如：                 select t.f1,t.f2         from table t         where t.
<?php $sql = <<<E…
senlin1202的博客
03-04 430
问： php里 $sql = //sql语句 EOF; 运行mysql_query($sql) ?> 答： 这是php的定界符 在 一般用于输出长的html文本或者文本赋值 这样写sql语句, 可以不用对字符型字段两边的单引号进行转义 灵活使用还是挺有用的 有这样的语法，二楼说得不错，我补充两点就是代码中的EOF也可以换成别的字符串，比如你的英文名字或别的，要一一对应， 还有一点
设置ibatis中命名空间属性为true，才能使用！
feihuale的专栏
11-23 1157
1.首先在sql-map-conf.xml文件中设置                //这个很关键，我就是没有加，sql语句不能执行                                                                                          // there is no map named selectByLoginP
Sqlmap参数详解
gao646467783的博客
11-21 1021
sqlmap全参数详解 sqlmap是在sql注入中非常常用的一款工具，由于其开源性，适合从个人到企业，从学习到实战，各领域各阶段的应用，我们还可以将它改造成我们自己独有的渗透利器。这款工具中，大大小小191个参数，在这篇文章中，我将一一介绍，其实很多参数我也没有使用过，所以有一些...
iBatis的Settings节点参数详解[转]
weixin_30402085的博客
08-14 224
(1) cacheModelsEnabled: 是否启用SqlMapClient上的缓存机制。建议设为"true"。默认值为“true”。 (2) enhancementEnabled: 是否针对POJO启用字节码增强机制以提升getter/setter的调用效能，避免使用JavaReflect所带来的性能开销。同时，这也为 Lazy Loading带来了极大的性能提升。建议设为...
iBatis动态SQL标签用法
dan
09-07 303
      iBatis动态SQL标签用法     1、动态SQL片段 通过SQL片段达到代码复用         &lt;!-- 动态条件分页查询 --&gt;          &lt;sql id="sql_count"&gt;                  select count(*)          &lt;/sql&gt;          &lt;sql...
IBATIS动态SQL标签用法
浮生若梦
08-26 257
1、动态SQL片段通过SQL片段达到代码复用&lt;!-- 动态条件分页查询 --&gt;         &lt;sqlid="sql_count"&gt;                select count(*)         &lt;/sql&gt;        &lt;sqlid="sql_select"&gt;                select *         &l
MyBatis sql中&lt； 和 &gt； 转义操作符的用法
qq_37855368的博客
08-30 1万+
Mybatis中的sql语句中的 “” 要用转义字符 “&lt” 和 “&gt” @Param注解用于给参数取别名，当这个方法中只有一个参数时并且这个参数在mapper.xml文件中被使用在标签中时，就必须要使用@Param注解来给这个参数取个别名...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值