title may not be very clear, I want to achieve the effect is:
in the operation of the same table, the basic addition, deletion and query using mybatis-generator automatically generated xml file, and then write a xml file to put their own handwritten sql.
in this way, if new fields are added to the database, generating a new xml, using mybatis-generator will not overwrite the custom sql file, and your own handwritten sql may return a BaseResultMap type. How can this function be realized?
in addition, your handwritten < resultMap > can inherit the automatically generated xml < BaseResultMap >,
so that even if you overwrite the automatically generated mapper.xml, your manually written < resultMap > does not have to be changed.
<resultMap id="BaseResultMap" type="com.mshu.vip.entity.SysUser"
extends="com.mshu.vip.mapper.original.SysUserMapper.BaseResultMap">
</resultMap>Note that the path to extends is "the path to the interface. BaseResultMap" is abstract.
sql file is placed in 2 directories, and then @ MapperScan (basePackages = {"cn.com.XX.mapper", "cn.com.XX.dao"} scan the interfaces in these two directories
then configure these
< mapper resource= "mysql/cn/com/XXX/Mapper.xml" / > on the configuration file
<mapper resource="mysql/cn/com/XXX/Dao.xml"/>refer to resultmap sql fragments and the like directly in your own files
when using Mybatise, I use the following code to operate on the database. No error is reported, and it executes successfully, but the database does not find data @Test public void testInsertUser(){ SqlSession sqlSession = sessionFactory.o...
using JDBCDataSouce is normal, startup and stop are normal, and no error is reported. when switching to C3P0 configuration in C3P0 XML: <!-- --> <bean id="dataSource_c3p0_properties" class="com.mchange.v2.c3p0.ComboPooledD...
mybatis input parameter is a list of type integer if there is only a 0 in the list, do not Filter this property otherwise, this field in list ...
<?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....
see the use of the PageHelper paging plug-in in a project ...
can mybatis use column annotations on the attributes of the entity class to map the result set to the entity class as jpa does? ...
@ Select ( "SELECT FROM users ") @ Results ({@ Result (property = "userSex ", column = "user_sex ", javaType = UserSexEnum.class), @ Result (property = "nickName ", column = "nick_name ")} List < UserEntity > getAll (); @ Select ( "SELECT FROM use...
Design the rest interface. For the update,add,delete operation, it is said on the Internet that the modified result should be returned to the caller, and the caller can directly take advantage of the modified result. So whether the return result returns...
this is xml <resultMap id="result_report_QDHW_05" class="com.sunyard.csr.vo.Report_QDHW_05"> <result property="TIME_KEY" column="TIME_KEY" > <result property="...
there was a character type problem when using mybatisGenerator to map oracle database tables. the fields represented by number (122.3) in oracle may be converted to bigDecimal , or to Short . In theory, should all be bigDecimal ? oracle (table i...
problem description 1.mysql in collection query is too inefficient and takes too long. the environmental background of the problems and what methods you have tried user_id and physicion are the user fields associated with this table. Because the s...
write as follows: select * from t_user t where 1 = 1 <if test="id != null and id != "> and t.id = -sharp{id} < if> if id is empty, all users will be found. What should I do? if the id non-null judgment is made before t...
how mybatis plus saves string arrays, arrays like [xxx,xxx] to the database. currently using < result column= "department " jdbcType= "VARCHAR " property= "department " in xml typeHandler="com.springboot.config.JsonStringArrayTyp...
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: Could not set property truckType of class com.cargopm.order.dto.OrderMainDto with value Cause: org.apache.ibatis.reflection.Refl...
1) is it better for repository to return entity or dto? 2) is the design in entity as good as the table structure in the database? Is it better to use associated objects? example: define Entity entities method 1: @Entity class Duty { private L...
This method is provided in the crud interface of mybatis-plus ** * * entity * * * @param queryWrapper null * @return * List<T> selectList(@Param(Constants.WRAPPER) Wrapper<T> queryWrapper); by using the wrapper object, it is...