Spring Boot+Mybatis+Annotation(四)

￡神魔★判官ぃ 2024-02-18 19:20 35阅读 0赞

上篇(三)是XML配置SQL的形式;也可以用注解形式。尤其一些小系统，快速的 CRUD 轻量级的系统。

(1)Application.properties配置文件

## \u6570\u636E\u6E90\u914D\u7F6E
    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

(2)Dao接口

/**
     * DAO 接口类
     * 
     * @author Administrator
     * 
     */
    @Mapper
    // 这个注解是Mybatis 的 Mapper(无需配置文件)
    public interface CityDao {
    
    	/**
    	 * 根据城市名称，查询城市信息
    	 * 
    	 * @param cityName
    	 *            城市名
    	 */
    	@Select("select * from city where city_name=#{cityName}")
    	// 查询语句
    	// 返回 Map 结果集
    	@Results({ @Result(column = "id", property = "id"),
    			@Result(column = "province_id", property = "provinceId"),
    			@Result(column = "city_name", property = "cityName"),
    			@Result(column = "description", property = "description")
    
    	})
    	public City findCity(@Param("cityName") String cityName);
    
    	/**
    	 * 查询语句
    	 * 
    	 * 注意:属性与数据列名不一致就会显示NUll,那么就必须配置ResultMap一一对应
    	 * @return
    	 */
    	@Select("select * from city")
    	// 返回 Map 结果集
    	@Results({ @Result(column = "id", property = "id"),
    			@Result(column = "province_id", property = "provinceId"),
    			@Result(column = "city_name", property = "cityName"),
    			@Result(column = "description", property = "description")
    
    	})
    	public List<City> all();
    
    	/**
    	 * 根据ID删除数据
    	 * 
    	 * @param id
    	 * @return
    	 */
    	@Delete("delete from city where id=#{id}")
    	int delete(int id);
    
    	/**
    	 * 添加数据
    	 * 
    	 * @param city
    	 * @return
    	 */
    	@Insert("insert into city values(#{id},#{provinceId},#{cityName},#{description})")
    	int save(City city);
    }

(3)Application.java启动Spring Boot;

/**
     * springboot启动
     * 
     * @author Administrator
     * 
     */
    @SpringBootApplication
    public class Application {
    
    	public static void main(String[] args) {
    		SpringApplication.run(Application.class, args);
    	}
    }

(4)Controller控制器

@RestController
    public class CityRestController {
    
    	// 注入业务
    	@Autowired
    	private CityService cityService;
    
    	/**
    	 * 返回JSON
    	 * 
    	 * @param cityName
    	 * @return
    	 */
    	@RequestMapping("/my/add")
    	public int addCity() {
    		City city=new City(4L, 2L, "深圳市", "飞飞的家在深圳市");
    		return cityService.add(city);
    	}
    	
    	/**
    	 * 返回JSON
    	 * 
    	 * @param cityName
    	 * @return
    	 */
    	@RequestMapping("/my/del")
    	public int delCity(@RequestParam(name = "id", required = true) int id) {
    		return cityService.del(id);
    	}
    
    	/**
    	 * 返回JSON
    	 * 
    	 * @param cityName
    	 * @return
    	 */
    	@RequestMapping("/my/all")
    	public List<City> allCity() {
    		return cityService.list();
    	}
    
    	/**
    	 * 返回JSON
    	 * 
    	 * @param cityName
    	 * @return
    	 */
    	@RequestMapping(value = "/my/find", method = RequestMethod.GET)
    	public City findCity(
    			@RequestParam(value = "cityName", required = true) String cityName) {
    		return cityService.findCityName(cityName);
    	}
    
    }

注意:其他的文件与(三)相同(忽略)

运行效果:

![Center][]

![Center 1][]

先执行http://localhost:8080/my/add 添加,再查看http://localhost:8080/my/all

![Center 2][]

删除 http://localhost:8080/my/del?id=4,再查看http://localhost:8080/my/all

![Center 3][]

![Center 4][]

[Center]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/3d8a891b79934d3e81af63a25c05021f.png
[Center 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/355ac0423bd540408648e89865b377fc.png
[Center 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/0b91e8c62386426a90c8a56f3ca29a90.png
[Center 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/65fc68d1555f4cc49ee9b76e632ec406.png
[Center 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/12342e8b23bd4e60b3454984f5b83143.png