add entity dao model in spring transactional sample · devilRNA/JavaSpringBootSamples@c1e2214 · GitHub
Skip to content

Commit c1e2214

Browse files
ipipmanipipman
committed
add entity dao model in spring transactional sample
1 parent 4147c0c commit c1e2214

7 files changed

Lines changed: 259 additions & 0 deletions

File tree

‎springboot-transactional-sample/src/main/java/com/ipman/springboot/transactional/sample/common/domain/model/User1.java‎

Lines changed: 23 additions & 0 deletions

‎springboot-transactional-sample/src/main/java/com/ipman/springboot/transactional/sample/common/domain/model/User2.java‎

Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
package com.ipman.springboot.transactional.sample.common.domain.model;
2+
3+
public class User2 {
4+
private Integer id;
5+
6+
private String name;
7+
8+
public Integer getId() {
9+
return id;
10+
}
11+
12+
public void setId(Integer id) {
13+
this.id = id;
14+
}
15+
16+
public String getName() {
17+
return name;
18+
}
19+
20+
public void setName(String name) {
21+
this.name = name == null ? null : name.trim();
22+
}
23+
}

‎springboot-transactional-sample/src/main/java/com/ipman/springboot/transactional/sample/core/dao/User1Mapper.java‎

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
package com.ipman.springboot.transactional.sample.core.dao;
2+
3+
import com.ipman.springboot.transactional.sample.common.domain.model.User1;
4+
5+
public interface User1Mapper {
6+
int deleteByPrimaryKey(Integer id);
7+
8+
int insert(User1 record);
9+
10+
int insertSelective(User1 record);
11+
12+
User1 selectByPrimaryKey(Integer id);
13+
14+
int updateByPrimaryKeySelective(User1 record);
15+
16+
int updateByPrimaryKey(User1 record);
17+
}

‎springboot-transactional-sample/src/main/java/com/ipman/springboot/transactional/sample/core/dao/User2Mapper.java‎

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
package com.ipman.springboot.transactional.sample.core.dao;
2+
3+
import com.ipman.springboot.transactional.sample.common.domain.model.User2;
4+
5+
public interface User2Mapper {
6+
int deleteByPrimaryKey(Integer id);
7+
8+
int insert(User2 record);
9+
10+
int insertSelective(User2 record);
11+
12+
User2 selectByPrimaryKey(Integer id);
13+
14+
int updateByPrimaryKeySelective(User2 record);
15+
16+
int updateByPrimaryKey(User2 record);
17+
}

‎springboot-transactional-sample/src/main/resources/generatorConfig.xml‎

Lines changed: 59 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,59 @@
1+
<?xml version="1.0" encoding="UTF-8"?>
2+
<!DOCTYPE generatorConfiguration
3+
PUBLIC " -//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
4+
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
5+
<generatorConfiguration>
6+
7+
<classPathEntry
8+
location="/Users/huangyan110110114/.m2/repository/mysql/mysql-connector-java/5.1.48/mysql-connector-java-5.1.48.jar"/>
9+
10+
<context id="default" targetRuntime="MyBatis3" defaultModelType="flat">
11+
12+
<property name="autoDelimitKeywords" value="true"/>
13+
<property name="beginningDelimiter" value="`"/>
14+
<property name="endingDelimiter" value="`"/>
15+
16+
<commentGenerator>
17+
<property name="suppressDate" value="false"/>
18+
<property name="suppressAllComments" value="true"/>
19+
</commentGenerator>
20+
21+
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
22+
connectionURL="jdbc:mysql://127.0.0.1:3306/stx"
23+
userId="root"
24+
password=""/>
25+
26+
<javaTypeResolver>
27+
<property name="forceBigDecimals" value="false"/>
28+
</javaTypeResolver>
29+
30+
<javaModelGenerator targetPackage="com.ipman.springboot.transactional.sample.common.domain.model"
31+
targetProject="/Users/huangyan110110114/JavaSpringBootSamples/springboot-transactional-sample/src/main/java">
32+
<property name="enableSubPackages" value="true"/>
33+
<property name="trimStrings" value="true"/>
34+
</javaModelGenerator>
35+
36+
<sqlMapGenerator targetPackage="mapper"
37+
targetProject="/Users/huangyan110110114/JavaSpringBootSamples/springboot-transactional-sample/src/main/resources">
38+
<property name="enableSubPackages" value="true"/>
39+
</sqlMapGenerator>
40+
41+
<javaClientGenerator targetPackage="com.ipman.springboot.transactional.sample.core.dao"
42+
targetProject="/Users/huangyan110110114/JavaSpringBootSamples/springboot-transactional-sample/src/main/java"
43+
type="XMLMAPPER">
44+
<property name="enableSubPackages" value="true"/>
45+
</javaClientGenerator>
46+
47+
48+
<table tableName="user1" enableCountByExample="false" enableUpdateByExample="false"
49+
enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
50+
<generatedKey column="id" sqlStatement="Mysql"/>
51+
</table>
52+
53+
<table tableName="user2" enableCountByExample="false" enableUpdateByExample="false"
54+
enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
55+
<generatedKey column="id" sqlStatement="Mysql"/>
56+
</table>
57+
58+
</context>
59+
</generatorConfiguration>

‎springboot-transactional-sample/src/main/resources/mapper/User1Mapper.xml‎

Lines changed: 60 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,60 @@
1+
<?xml version="1.0" encoding="UTF-8" ?>
2+
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
3+
<mapper namespace="com.ipman.springboot.transactional.sample.core.dao.User1Mapper" >
4+
<resultMap id="BaseResultMap" type="com.ipman.springboot.transactional.sample.common.domain.model.User1" >
5+
<id column="id" property="id" jdbcType="INTEGER" />
6+
<result column="name" property="name" jdbcType="VARCHAR" />
7+
</resultMap>
8+
<sql id="Base_Column_List" >
9+
id, `name`
10+
</sql>
11+
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
12+
select
13+
<include refid="Base_Column_List" />
14+
from user1
15+
where id = #{id,jdbcType=INTEGER}
16+
</select>
17+
<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
18+
delete from user1
19+
where id = #{id,jdbcType=INTEGER}
20+
</delete>
21+
<insert id="insert" parameterType="com.ipman.springboot.transactional.sample.common.domain.model.User1" >
22+
<selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" >
23+
SELECT LAST_INSERT_ID()
24+
</selectKey>
25+
insert into user1 (id, `name`)
26+
values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR})
27+
</insert>
28+
<insert id="insertSelective" parameterType="com.ipman.springboot.transactional.sample.common.domain.model.User1" >
29+
<selectKey resultType="java.lang.Integer" keyProperty="id" order="BEFORE" >
30+
SELECT LAST_INSERT_ID()
31+
</selectKey>
32+
insert into user1
33+
<trim prefix="(" suffix=")" suffixOverrides="," >
34+
id,
35+
<if test="name != null" >
36+
`name`,
37+
</if>
38+
</trim>
39+
<trim prefix="values (" suffix=")" suffixOverrides="," >
40+
#{id,jdbcType=INTEGER},
41+
<if test="name != null" >
42+
#{name,jdbcType=VARCHAR},
43+
</if>
44+
</trim>
45+
</insert>
46+
<update id="updateByPrimaryKeySelective" parameterType="com.ipman.springboot.transactional.sample.common.domain.model.User1" >
47+
update user1
48+
<set >
49+
<if test="name != null" >
50+
`name` = #{name,jdbcType=VARCHAR},
51+
</if>
52+
</set>
53+
where id = #{id,jdbcType=INTEGER}
54+
</update>
55+
<update id="updateByPrimaryKey" parameterType="com.ipman.springboot.transactional.sample.common.domain.model.User1" >
56+
update user1
57+
set `name` = #{name,jdbcType=VARCHAR}
58+
where id = #{id,jdbcType=INTEGER}
59+
</update>
60+
</mapper>

‎springboot-transactional-sample/src/main/resources/mapper/User2Mapper.xml‎

Lines changed: 60 additions & 0 deletions

0 commit comments

Comments
 (0)