MyBatis中实体类和数据库字段关系映射_mybatis 在insert的时候数据的时候指定字段跟数据库字段映射关系

MyBatis中实体类和数据库字段关系映射

<mapper namespace="com.project.main.excel.out.mapper.WorkersOutMapper">

	<resultMap type="com.project.main.excel.out.entity.WorkersVO" id="WorkersVOResultMap">		
		<result property="cardNum" column="card_num"/>
		<result property="workerName" column="worker_name"/>
		<result property="age" column="age"/>
		<result property="sex" column="sex"/>
		<result property="address" column="address"/>
		<result property="position" column="position"/>
		<result property="workDate" column="work_date"/>
	</resultMap>
	
    <select id="getWorkersToExcelOut" resultMap="WorkersVOResultMap">
    	SELECT card_num,worker_name,age,sex,address,position,work_date FROM data.workers_data_df
    </select>
</mapper>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17