您好,登錄后才能下訂單哦!
本文小編為大家詳細(xì)介紹“怎么在springboot中集成mybatis xml方式”,內(nèi)容詳細(xì),步驟清晰,細(xì)節(jié)處理妥當(dāng),希望這篇“怎么在springboot中集成mybatis xml方式”文章能幫助大家解決疑惑,下面跟著小編的思路慢慢深入,一起來(lái)學(xué)習(xí)新知識(shí)吧。
springboot集成mybatis
1,添加pom引用
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency>
2 application.properties
mybatis.config-locations=classpath:mybatis/mybatis-config.xml mybatis.mapper-locations=classpath:mybatis/mapper/*.xml mybatis.type-aliases-package=com.kerry.model spring.datasource.driverClassName = com.mysql.jdbc.Driver spring.datasource.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8 spring.datasource.username = root spring.datasource.password = 123456
3 在resource目錄下創(chuàng)建mybatis目錄并創(chuàng)建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> <settings> <setting name="callSettersOnNulls" value="true"/> <setting name="cacheEnabled" value="true"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="aggressiveLazyLoading" value="true"/> <setting name="multipleResultSetsEnabled" value="true"/> <setting name="useColumnLabel" value="true"/> <setting name="useGeneratedKeys" value="false"/> <setting name="autoMappingBehavior" value="PARTIAL"/> <setting name="defaultExecutorType" value="SIMPLE"/> <setting name="mapUnderscoreToCamelCase" value="true"/> <setting name="localCacheScope" value="SESSION"/> <setting name="jdbcTypeForNull" value="NULL"/> </settings> <typeAliases> <typeAlias alias="Integer" type="java.lang.Integer" /> <typeAlias alias="Long" type="java.lang.Long" /> <typeAlias alias="HashMap" type="java.util.HashMap" /> <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" /> <typeAlias alias="ArrayList" type="java.util.ArrayList" /> <typeAlias alias="LinkedList" type="java.util.LinkedList" /> </typeAliases> </configuration>
mybatis目錄下創(chuàng)建mapper目錄存放mapper類接口文件
package com.kerry.mapper; import java.util.List; import com.kerry.model.User; public interface UserMapper { List<User> getAll(); User getOne(Integer id); void insert(User user); void update(User user); void delete(Integer id); }
model類文件
package com.kerry.mapper; import java.util.List; import com.kerry.model.User; public interface UserMapper { List<User> getAll(); User getOne(Integer id); void insert(User user); void update(User user); void delete(Integer id); }
userMapper.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.kerry.mapper.UserMapper" > <resultMap id="BaseResultMap" type="com.kerry.model.User" > <id column="id" property="id" jdbcType="INTEGER" /> <result column="name" property="name" jdbcType="VARCHAR" /> <result column="age" property="age" jdbcType="VARCHAR" /> <result column="address" property="address" jdbcType="VARCHAR"/> </resultMap> <sql id="Base_Column_List" > id, name, age, address </sql> <select id="getAll" resultMap="BaseResultMap" > SELECT <include refid="Base_Column_List" /> FROM user </select> <select id="getOne" parameterType="java.lang.Integer" resultMap="BaseResultMap" > SELECT <include refid="Base_Column_List" /> FROM user WHERE id = #{id} </select> <insert id="insert" parameterType="com.kerry.model.User" > INSERT INTO user (id,name,age,address) VALUES (#{id},#{name}, #{age}, #{address}) </insert> <update id="update" parameterType="com.kerry.model.User" > UPDATE user SET <if test="name != null">name = #{name},</if> <if test="age != null">age = #{age},</if> address = #{address} WHERE id = #{id} </update> <delete id="delete" parameterType="java.lang.Integer" > DELETE FROM user WHERE id =#{id} </delete> </mapper>
controller:
package com.kerry.web; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.kerry.model.User; import com.kerry.mapper.UserMapper; @RestController public class UserController { @Autowired private UserMapper userMapper; @RequestMapping("/getUsers") public List<User> getUsers() { List<User> users=userMapper.getAll(); return users; } @RequestMapping("/getUser") public User getUser(Integer id) { User user=userMapper.getOne(id); return user; } @RequestMapping("/add") public void save(User user) { userMapper.insert(user); } @RequestMapping(value="update") public void update(User user) { userMapper.update(user); } @RequestMapping(value="/delete/{id}") public void delete(@PathVariable("id") Integer id) { userMapper.delete(id); } }
最后在啟動(dòng)類上加上 掃描maper interface注解
@SpringBootApplication @MapperScan("com.kerry.mapper") public class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); } }
或者在每個(gè)XXMapper類上加上@mapper注解也行 二選一即可
比如
package com.kerry.mapper; import java.util.List; import org.apache.ibatis.annotations.Mapper; import com.kerry.model.User; @Mapper public interface UserMapper { List<User> getAll(); User getOne(Integer id); void insert(User user); void update(User user); void delete(Integer id); }
個(gè)人建議使用直接在啟動(dòng)類上application上@MapperScan方便,一次搞定,不必每寫(xiě)一個(gè)mapper類都加上@mapper注解
附上項(xiàng)目結(jié)構(gòu)目錄 選中的類以及文件
讀到這里,這篇“怎么在springboot中集成mybatis xml方式”文章已經(jīng)介紹完畢,想要掌握這篇文章的知識(shí)點(diǎn)還需要大家自己動(dòng)手實(shí)踐使用過(guò)才能領(lǐng)會(huì),如果想了解更多相關(guān)內(nèi)容的文章,歡迎關(guān)注億速云行業(yè)資訊頻道。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。