caideb的博客

1.pom文件 <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.5</version>...

1.存储过程declarestatus varchar2(100);message varchar2(100);begintest_func(1,status,message );dbms_output.put_line(status);dbms_output.put_line(message );end;2.配置文件<select id="te...

1.静态函数package com.testspringboot2.util;public class CustomerUtil { public static int AGE = 20; public static String getName(String name) { return "pre_"+name; } }2.配置文件<insert ...

1.需要jar包 &lt;dependency&gt; &lt;groupId&gt;mysql&lt;/groupId&gt; &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt; &lt;version&gt;8.0.15&lt;/version&gt; &lt;/dependenc

1.测试代码package com.testmybatis;import java.io.IOException;import java.io.InputStream;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;i...

&lt;insert id="save" useGeneratedKeys="true" keyColumn="id" keyProperty="id"&gt; INSERT INTO `a` (`name`) VALUES (#{name}) &lt;/insert&gt; 

1.pom文件&lt;parent&gt; &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt; &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt; &lt;version&gt;1.5.2.RELEASE&lt;/version&gt; &am

 1.pom文件&lt;dependencies&gt; &lt;dependency&gt; &lt;groupId&gt;org.mybatis&lt;/groupId&gt; &lt;artifactId&gt;mybatis&lt;/artifactId&gt; &lt;version&gt;3.4.1&lt;/version&gt; &

1.pom文件&lt;parent&gt; &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt; &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt; &lt;version&gt;1.5.2.RELEASE&lt;/version&gt; &am

1.单个参数public List&lt;Article&gt; getInIds(List&lt;String&gt; ids);&lt;select id="getInIds" resultType="com.testmybatis.model.Article"&gt; select * from article where type = 1 &lt;if t...

1.表结构CREATE TABLE `a` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;CREATE TABLE `b` ( ...

1.拦截器类package com.testmybatis.interceptor;import java.util.Properties;import org.apache.ibatis.executor.Executor;import org.apache.ibatis.mapping.BoundSql;import org.apache.ibatis.mapping.Map...

1.# 自动包裹""&lt;select id="find2" resultType="com.testmybatis.model.Test"&gt; select * from test where name=#{name};&lt;/select&gt;2018-08-07 12:54:39 DEBUG [com.testmybatis.dao.TestMapper.find...

1.pom文件&lt;dependency&gt; &lt;groupId&gt;org.mybatis&lt;/groupId&gt; &lt;artifactId&gt;mybatis&lt;/artifactId&gt; &lt;version&gt;3.4.1&lt;/version&gt; &lt;/dependency&gt; &amp