How to use parameterType? Summary of parameterType instance usage

There is a parameterType attribute in the select, insert, update, and delete elements in the Mybatis Mapper file, which is used for the parameter type accepted by the corresponding mapper interface method. Acceptable parameter types are basic types and complex types. The mapper interface method generally accepts one parameter, and you can bind multiple parameters to a map as input parameters by using the @Param annotation. Simple data type mapper interface method: 1User selectByPrimaryKey(Integer id);sql mapping:123456 select

1. Detailed explanation of MyBatis incoming parameters and parameterType

##Introduction: select, insert, There is a parameterType attribute in the update and delete elements, which is used for the parameter type accepted by the corresponding mapper interface method. Acceptable parameter types are basic types and complex types. The mapper interface method generally accepts one parameter, and you can bind multiple parameters to a map as input parameters by using the @Param annotation. Simple data type mapper interface method:

2. Details of the incoming parameters of MyBatis

Introduction: The parameterType attribute is mentioned in the select, insert, update, and delete elements of MyBatis. The parameterTypes that MyBatis can now use include basic data types and Java complex data types. Basic data types: including int, String, Date, etc. Basic data types are used as parameters, and only one can be passed in. The passed-in value complex data type can be obtained through #{parameter name}: including JAVA entity class and Map. Through #{property

3. MyBatis method to obtain the auto-incremented primary key when inserting

Introduction: MyBatis 3.2.6 Get when inserting There are two ways to auto-increment the primary key, taking MySQL5.5 as an example: Method 1: lt;insert id=insert parameterType=Person use

4. MyIbatis calls Oracle stored procedure

Introduction: 1. xml filelt;select id=getGroupNum statementType=CALLABLE parameterType=com.guorui.model.ParamSPCgt;{call GYL_C

5. MyBatis +MySQL returns the inserted primary key ID

Introduction: Requirement: After using MyBatis to insert a record into the MySQL database, you need to return the auto-incremented primary key of the record. Method: Specify the keyProperty attribute in the mapper. The example is as follows: insert id=insertAndGetId useGeneratedKeys=true keyProperty=userId parameterType=com.chenzhou.mybatis.Userinsert in

6. Mybatis Add, delete, and update Oracle in batches

Introduction: Recently, I need to use Mybatis to add Oracle databases in batches. The methods I first found on the Internet are all about updating mySQL. Try After a while, I found that it was not suitable for Oracle. Later I found that the correct SQL for Oracle batch addition is: insert id=insertAttractionsBatch parameterType=java.util.List insert into ATTRACTIONS (ID, N

##7 .

mybaits batch operation database

##Introduction: Welcome to the Oracle Community Forum, with 2 million technologies Personnel interactive communication>> Enter the ORACLE database: insert id="batchInsertRoleRMenu" parameterType="java.util.List" INSERT INTO QCMS_PUB_ROLE_R_MENU ( MENU_ID, ROLE_ID ) ( foreach collection="list" item="item" index="in

8.

Mybatis inserts data and returns the self-increasing ID

Introduction: Mybatis inserts data and returns the self-increasing ID id None insert id="insert" parameterType="Spares" useGeneratedKeys="true" keyProperty="id"insert into spares(spares_id,spares_name,spares_type_id,spares_spec)values(#{id},#{name},#{ typeId},#{spec})/insert sparesDa

9. Get the current system time in mysql_MySQL

##Introduction: select id=getFreightEfclInventoryList parameterType=long resultMap=BaseResultMap1 SELECT freight_efcl_inventory_id, freight_efcl_id , closing_date, sailing_date,...

[Related Q&A recommendations]:

java - Mybatis parameter type problem, it should be Map, the result Error report.

Optimization of mysql statement in mapper file

The above is the detailed content of How to use parameterType? Summary of parameterType instance usage. For more information, please follow other related articles on the PHP Chinese website!