Spring-boot如何集成mybatis
1、在Maven工程中增加mybatis依赖<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.4</version></dependency>
3、创建数据表的mybatis映射文件：ideaMapper.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="fantasy.IdeaMapper"> <select id="selectIdea" resultType="fantasy.Idea"> select * from idea where id = #{id} </select></mapper>
5、创建DAO数据库操作类：IdeaController.javapackage fanta衡痕贤伎sy;/** * Created by Admi荏鱿胫协nistrator on 2017/8/8 0008. */import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.springframework.boot.*;import org.springframework.boot.autoconfigure.*;import org.springframework.format.datetime.DateFormatter;import org.springframework.stereotype.*;import org.springframework.web.bind.annotation.*;import java.io.IOException;import java.io.InputStream;import java.text.DateFormat;import java.text.ParseException;import java.util.Map.Entry;import java.util.Date;import java.util.Locale;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;@Controller@EnableAutoConfiguration@RestController@RequestMapping("/idea")public class IdeaController { @Autowired private JdbcTemplate jdbcTemplate; @RequestMapping("/get") @ResponseBody String get(@RequestParam("id") String id) throws IOException { Idea idea= new Idea(); String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession session = sqlSessionFactory.openSession(); try { idea = (Idea) session.selectOne("fantasy.IdeaMapper.selectIdea", id); } finally { session.close(); } if(idea!=null) return idea.toString(); else return "查询不到记录!"; } public static void main(String[] args) throws Exception { SpringApplication.run(IdeaController.class, args); }}
