![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mybatis
老杨和他的朋友们有限公司
这个作者很懒,什么都没留下…
展开
-
MyBatis Generator生成代码
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration.原创 2021-12-26 16:48:40 · 108 阅读 · 0 评论 -
mysql自带函数st_distance查询两个经纬度点的距离
SELECT s.id,s.name,s.lng,s.lat, (st_distance (point (lng, lat),point(115.067,34.76) ) / 0.0111) AS distanceFROM road_servicearea sHAVING distance<30ORDER BY distance原创 2021-06-09 23:08:05 · 2614 阅读 · 0 评论 -
mybatis框架的bug,当参数传值为0
1、mapper文件2、实体类中3、当传值为04、mybatis的插件会将0转换为''空字符串原创 2020-04-10 15:36:03 · 192 阅读 · 0 评论 -
Caused by: org.apache.ibatis.binding.BindingException: Parameter 'userId' not found. Available param
1、dao层修改前 userWorkMappingDao.addUserWork(userId,workId);2、xml文件前 <insert id = "addUserWork" parameterType="String"> INSERT INTO `user_work_mapping`(user_id,work_id) VALUES ( #{userId}, #{...原创 2020-02-26 16:53:42 · 2175 阅读 · 0 评论 -
Caused by: java.lang.IllegalArgumentException: argument type mismatch
Caused by: org.apache.ibatis.reflection.ReflectionException: Could not set property 'workQueryMenus' of 'class csg.ios.zzfw.entity.work.UserWorkMapping' with value 'csg.ios.zzfw.entity.WorkQueryMenu@5...原创 2020-02-25 23:08:18 · 1488 阅读 · 0 评论 -
myBatis中使用like进行查询
1.使用mybatis中提供的方法(oracle与mysql通用)select * from t_userwhere 1 = 1<bind name="word" value='"%"+keyword +"%"'/>and name like #{word}2.如果是mysql,则使用mysql自身的方法(concat关键字是 将多个字符串进行拼接)select * f...转载 2020-02-18 21:39:24 · 1081 阅读 · 0 评论