Spring Boot+mybatis(三)

不念不忘少年蓝@ 2024-02-18 19:18 85阅读 0赞

***SpringBoot与Mybatis整合步骤:***

**pom.xml中**必须加载spring+mybatis的包,mysql的包!

<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.5.1.RELEASE</version>
    	</parent>
    	<dependencies>
    
    		
    		<dependency>
    			<groupId>junit</groupId>
    			<artifactId>junit</artifactId>
    			<version>4.12</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.3.0</version>
    		</dependency>
    		 
    		 <dependency>
    		 	<groupId>mysql</groupId>
    		 	<artifactId>mysql-connector-java</artifactId>
    		 	<version>5.1.42</version>
    		 </dependency>

![Center][]

1> Mysql数据

DROP TABLE IF EXISTS `city`;
    CREATE TABLE `city` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '城市编号',
      `province_id` int(10) unsigned NOT NULL COMMENT '省份编号',
      `city_name` varchar(25) DEFAULT NULL COMMENT '城市名称',
      `description` varchar(25) DEFAULT NULL COMMENT '描述',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of city
    -- ----------------------------
    INSERT INTO `city` VALUES ('1', '1', '杭州市', '刘飞的家在杭州市');
    INSERT INTO `city` VALUES ('2', '1', '海宁市', '张三的家在海宁市');

2>各个层次

(2.1) 实体类Entity  org.spring.springboot.entity (忽略)

(2.2) 数据层Dao org.spring.springboot.dao

public interface CityDao {
    
    	/**
    	 * 根据城市名称，查询城市信息
    	 * 
    	 * @param cityName
    	 *            城市名
    	 */
    	public City findCity(@Param("cityName") String cityName);
    	
    	//查询所有的数据
    	public List<City> all();
    }

(2.3)  业务逻辑层Service org.spring.springboot.service

public interface CityService {
    	/**
    	 * 根据城市名查找城市
    	 * 
    	 * @param cityName
    	 * @return
    	 */
    	public City findCityName(String cityName);
    	/**
    	 * 查询所有的城市
    	 * @return
    	 */
    	public List<City> list();
    }

(2.4) 业务逻辑层实现类 org.spring.springboot.service.impl

@Service
    public class CityServiceImpl implements CityService {
    	
    	//注入dao
    	@Autowired
    	private CityDao cityDao;
    
    	@Override
    	public City findCityName(String cityName) {
    		// TODO Auto-generated method stub
    		return cityDao.findCity(cityName);
    	}
    
    	@Override
    	public List<City> list() {
    		// TODO Auto-generated method stub
    		return cityDao.all();
    	}
    
    }

(2.5)  控制层Controller  org.spring.springboot.controller

@RestController
    public class CityRestController {
    
    	//注入业务
    	@Autowired
    	private CityService cityService;
    
    	/**
    	 * 返回JSON
    	 * @param cityName
    	 * @return
    	 */
    	@RequestMapping("/my/citylist")
    	public List<City> allCity() {
    		return cityService.list();
    	}
    	
    	/**
    	 * 返回JSON
    	 * @param cityName
    	 * @return
    	 */
    	@RequestMapping(value="/my/city",method=RequestMethod.GET)
    	public City findCity(
    			@RequestParam(value = "cityName", required = true) String cityName) {
    		return cityService.findCityName(cityName);
    	}
    
    }

(2.6)配置文件 CityMapper.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.hlx.springboot.dao.CityDao">
    
    	
    	
    	<resultMap type="com.hlx.springboot.entity.City" id="BaseResultMap">
    		<id column="id" property="id" />
    		<result column="province_id" property="provinceId" />
    		<result column="city_name" property="cityName" />
    		<result column="description" property="description" />
    	</resultMap>
    
    	
    	<sql id="sqlModel">
    		id,province_id,city_name, description
    	</sql>
    
    
    	<select id="all" resultMap="BaseResultMap">
    		select
    		<include refid="sqlModel" />
    		from city
    	</select>
    
    
    	
    	<select id="findCity" resultMap="BaseResultMap" parameterType="java.lang.String">
    		select
    		<include refid="sqlModel" />
    		from city where city_name=#{cityName}
    	</select>
    </mapper>

(2.7) 应用启动会自动读取配置: application.properties

## 数据源
    spring.datasource.url=jdbc:mysql://localhost:3306/springbootdb?useUnicode=true&characterEncoding=utf8
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    
    ## Mybatis 配置
    mybatis.typeAliasesPackage=com.hlx.springboot.entity
    mybatis.mapperLocations=classpath\:mapper/*.xml

(2.7)  应用启动类: Application

/**
     * Spring Boot 应用启动类
     * 
     * @author Administrator
     * 
     */
    @SpringBootApplication
    // Spring Boot 应用的标识
    @MapperScan("com.hlx.springboot.dao")
    // 接口类扫描包配置
    public class Application {
    	public static void main(String[] args) {
    		// 程序启动入口
    		// 启动嵌入式的 Tomcat 并初始化 Spring 环境及其各 Spring 组件
    		SpringApplication.run(Application.class, args);
    	}
    }

注意:先在Firefox下安装插件JSONView

![Center 1][]

运行效果:( 不能写工程名哦!,直接写路径ok)

![Center 2][]

![Center 3][]

[Center]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/99a846a9aa0c4a02a3d6680d313879d9.png
[Center 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/5c4ebca6345c4208a0c3191b9300153f.png
[Center 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/a0dc4ccba3d34ce8af9155e7685b268e.png
[Center 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/cb1c98cd79004d679a2d2f301eec8cf9.png