un8.19:SQL语句的使用方法大全。

已于 2022-09-20 09:26:17 修改
阅读量367 收藏 2
点赞数 1
分类专栏： mysql SpringBoot 文章标签： sql 数据库 java
于 2022-08-22 12:20:06 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_64818669/article/details/126428405
版权

在项目中，我们经常会用到sql语句为我们的数据库和前端进行连接，各种繁琐的sql也让很多人有所困惑，今天我就来给大家分享一种超级简单的sql语句的写法。

一、将数据库与实体类一一对应。

<resultMap id="BaseResultMap" type="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		<id column="lawyerInfoId" property="lawyerInfoId" jdbcType="VARCHAR" />
		<result column="lawyerSurname" property="lawyerSurname" jdbcType="VARCHAR" />
		<result column="lawyerName" property="lawyerName" jdbcType="VARCHAR" />
		<result column="lawyerAge" property="lawyerAge" jdbcType="VARCHAR" />
		<result column="projectName" property="projectName" jdbcType="VARCHAR" />
		<result column="locationCodePath" property="locationCodePath" jdbcType="VARCHAR" />
		<result column="projectCountry" property="projectCountry" jdbcType="VARCHAR" />
	</resultMap>

二、查看SQL。

1、将所有字段写出，取名为Base_Column_List。

<sql id="Base_Column_List" >
		lawyerInfoId, lawyerSurname, lawyerName, lawyerAge, projectName, locationCodePath, projectCountry,
		lawyerSex, lawyerPost, languages, mailBox, expert, Telephone, expatriates, modifierId, modifierName, modifyTime,
		createrId, createrName, createTime, isDelete
</sql>

 2、如果isDelete = 0，不删除数据，默认为不删除。

	<sql id="common_where_if">
         isDelete = 0
		<if test="lawyerSurname != null and lawyerSurname != ''">
			AND lawyerSurname LIKE Concat('%', #{lawyerSurname,jdbcType=VARCHAR}, '%')
		</if>
		<if test="lawyerName != null and lawyerName != ''">
			AND lawyerName LIKE Concat('%', #{lawyerName,jdbcType=VARCHAR}, '%')
		</if>
		<if test="lawyerAge != null and lawyerAge != ''">
			AND adminUserNames LIKE Concat('%', #{adminUserNames,jdbcType=VARCHAR}, '%')
		</if>
		<if test="projectName != null and projectName != ''">
			AND projectName = #{projectName,jdbcType=VARCHAR}
		</if>
		<if test="locationCodePath != null and locationCodePath != ''">
			AND locationCodePath = #{locationCodePath,jdbcType=VARCHAR}
		</if>
		<if test="projectCountry != null and projectCountry != ''">
			AND projectCountry = #{projectCountry,jdbcType=VARCHAR}
		</if>
	</sql>

3、查询项目列表。

<!-- 查询项目列表 -->
	<select id="queryProjectBaseInfoList" resultType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" parameterType="java.util.Map" >
		select
		<include refid="Base_Column_List"></include>
		from lrm_lawyer_abroad
		<where>
			<include refid="common_where_if"></include>
		</where>
		order by createTime desc
	</select>

4、获取数据详情。

<!-- 获取数据详情 -->
	<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
		select 
		<include refid="Base_Column_List" />
		from lrm_lawyer_abroad
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
	</select>

三、根据Id删除数据。

<delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
		delete from lrm_lawyer_abroad
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
</delete>

四、新增数据。

1、新增所有。

<insert id="insert" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		insert into lrm_lawyer_abroad (lawyerInfoId, 
			expert, mailBox, Telephone, expatriates,
			modifierId, modifierName, modifyTime,
			createrId, createrName, createTime,
		    isDelete)
		values (#{lawyerInfoId,jdbcType=VARCHAR}, #{lawyerSurname,jdbcType=VARCHAR}, #{lawyerName,jdbcType=VARCHAR}, 
			#{lawyerAge,jdbcType=VARCHAR}, #{projectName,jdbcType=VARCHAR}, #{locationCodePath,jdbcType=VARCHAR}, #{projectCountry,jdbcType=VARCHAR},
			#{lawyerSex,jdbcType=VARCHAR}, #{lawyerPost,jdbcType=VARCHAR}, #{languages,jdbcType=VARCHAR},
			#{expert,jdbcType=VARCHAR},#{mailBox,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR},
		    #{expatriates,jdbcType=VARCHAR},#{modifierId,jdbcType=VARCHAR}, #{modifierName,jdbcType=VARCHAR},
		    #{modifyTime,jdbcType=TIMESTAMP}, #{createrId,jdbcType=VARCHAR}, #{createrName,jdbcType=VARCHAR},
		    #{createTime,jdbcType=TIMESTAMP}, #{isDelete,jdbcType=INTEGER})
	</insert>

2、根据条件新增。

<insert id="insertSelective" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		insert into lrm_lawyer_abroad
		<trim prefix="(" suffix=")" suffixOverrides="," >
			<if test="lawyerInfoId != null" >
				lawyerInfoId,
			</if>
			<if test="languages != null" >
				languages,
			</if>
			<if test="expert != null" >
				expert,
			</if>
			<if test="expatriates != null" >
				expatriates,
			</if>
			<if test="modifierId != null" >
				modifierId,
			</if>
			<if test="modifierName != null" >
				modifierName,
			</if>
			<if test="modifyTime != null" >
				modifyTime,
			</if>
			<if test="createrId != null" >
				createrId,
			</if>
			<if test="createrName != null" >
				createrName,
			</if>
			<if test="createTime != null" >
				createTime,
			</if>
			<if test="isDelete != null" >
				isDelete,
			</if>
		</trim>
		<trim prefix="values (" suffix=")" suffixOverrides="," >
			<if test="lawyerInfoId != null" >
				#{lawyerInfoId,jdbcType=VARCHAR},
			</if>
			<if test="lawyerSurname != null" >
				#{lawyerSurname,jdbcType=VARCHAR},
			</if>
			<if test="lawyerName != null" >
				#{lawyerName,jdbcType=VARCHAR},
			</if>
			<if test="lawyerAge != null" >
				#{lawyerAge,jdbcType=VARCHAR},
			</if>
			<if test="expert != null" >
				#{expert,jdbcType=VARCHAR},
			</if>
			<if test="mailBox != null" >
				#{mailBox,jdbcType=VARCHAR},
			</if>
			<if test="telephone != null" >
				#{telephone,jdbcType=VARCHAR},
			</if>
			<if test="expatriates != null" >
				#{expatriates,jdbcType=VARCHAR},
			</if>
			<if test="modifierId != null" >
				#{modifierId,jdbcType=VARCHAR},
			</if>
			<if test="modifierName != null" >
				#{modifierName,jdbcType=VARCHAR},
			</if>
			<if test="modifyTime != null" >
				#{modifyTime,jdbcType=TIMESTAMP},
			</if>
			<if test="createrId != null" >
				#{createrId,jdbcType=VARCHAR},
			</if>
			<if test="createrName != null" >
				#{createrName,jdbcType=VARCHAR},
			</if>
			<if test="createTime != null" >
				#{createTime,jdbcType=TIMESTAMP},
			</if>
			<if test="isDelete != null" >
				#{isDelete,jdbcType=INTEGER},
			</if>
		</trim>
	</insert>

五、修改数据库数据。

<update id="updateByPrimaryKeySelective" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		update lrm_lawyer_abroad
		<set >
			<if test="lawyerSurname != null" >
				lawyerSurname = #{lawyerSurname,jdbcType=VARCHAR},
			</if>
			<if test="lawyerName != null" >
				lawyerName = #{lawyerName,jdbcType=VARCHAR},
			</if>
			<if test="expert != null" >
				expert = #{expert,jdbcType=VARCHAR},
			</if>
			<if test="modifierId != null" >
				modifierId = #{modifierId,jdbcType=VARCHAR},
			</if>
			<if test="modifierName != null" >
				modifierName = #{modifierName,jdbcType=VARCHAR},
			</if>
			<if test="modifyTime != null" >
				modifyTime = #{modifyTime,jdbcType=TIMESTAMP},
			</if>
			<if test="createrId != null" >
				createrId = #{createrId,jdbcType=VARCHAR},
			</if>
			<if test="createrName != null" >
				createrName = #{createrName,jdbcType=VARCHAR},
			</if>
			<if test="createTime != null" >
				createTime = #{createTime,jdbcType=TIMESTAMP},
			</if>
			<if test="isDelete != null" >
				isDelete = #{isDelete,jdbcType=INTEGER},
			</if>
		</set>
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
	</update>
	<update id="updateByPrimaryKey" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		update lrm_lawyer_abroad
		set lawyerSurname = #{lawyerSurname,jdbcType=VARCHAR},
			lawyerName = #{lawyerName,jdbcType=VARCHAR},
			modifierId = #{modifierId,jdbcType=VARCHAR},
			modifierName = #{modifierName,jdbcType=VARCHAR},
			modifyTime = #{modifyTime,jdbcType=TIMESTAMP},
			createrId = #{createrId,jdbcType=VARCHAR},
			createrName = #{createrName,jdbcType=VARCHAR},
			createTime = #{createTime,jdbcType=TIMESTAMP},
			isDelete = #{isDelete,jdbcType=INTEGER}
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
	</update>

即可实现增删改查功能，最后附上完整代码。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.pcitc.slms.lrm.system.dao.LrmLawyerAbroadDao" >
	<resultMap id="BaseResultMap" type="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		<id column="lawyerInfoId" property="lawyerInfoId" jdbcType="VARCHAR" />
		<result column="lawyerSurname" property="lawyerSurname" jdbcType="VARCHAR" />
		<result column="lawyerName" property="lawyerName" jdbcType="VARCHAR" />
		<result column="lawyerAge" property="lawyerAge" jdbcType="VARCHAR" />
		<result column="projectName" property="projectName" jdbcType="VARCHAR" />
		<result column="locationCodePath" property="locationCodePath" jdbcType="VARCHAR" />
		<result column="projectCountry" property="projectCountry" jdbcType="VARCHAR" />
		<result column="lawyerSex" property="lawyerSex" jdbcType="VARCHAR" />
		<result column="lawyerPost" property="lawyerPost" jdbcType="VARCHAR" />
		<result column="languages" property="languages" jdbcType="VARCHAR" />
		<result column="expert" property="expert" jdbcType="VARCHAR" />
		<result column="mailBox" property="mailBox" jdbcType="VARCHAR" />
		<result column="Telephone" property="telephone" jdbcType="VARCHAR" />
		<result column="expatriates" property="expatriates" jdbcType="VARCHAR" />
		<result column="modifierId" property="modifierId" jdbcType="VARCHAR" />
		<result column="modifierName" property="modifierName" jdbcType="VARCHAR" />
		<result column="modifyTime" property="modifyTime" jdbcType="TIMESTAMP" />
		<result column="createrId" property="createrId" jdbcType="VARCHAR" />
		<result column="createrName" property="createrName" jdbcType="VARCHAR" />
		<result column="createTime" property="createTime" jdbcType="TIMESTAMP" />
		<result column="isDelete" property="isDelete" jdbcType="INTEGER" />
	</resultMap>
	<sql id="Base_Column_List" >
		lawyerInfoId, lawyerSurname, lawyerName, lawyerAge, projectName, locationCodePath, projectCountry,
		lawyerSex, lawyerPost, languages, mailBox, expert, Telephone, expatriates, modifierId, modifierName, modifyTime,
		createrId, createrName, createTime, isDelete
	</sql>

	<sql id="common_where_if">
         isDelete = 0
		<if test="lawyerSurname != null and lawyerSurname != ''">
			AND lawyerSurname LIKE Concat('%', #{lawyerSurname,jdbcType=VARCHAR}, '%')
		</if>
		<if test="lawyerName != null and lawyerName != ''">
			AND lawyerName LIKE Concat('%', #{lawyerName,jdbcType=VARCHAR}, '%')
		</if>
		<if test="lawyerAge != null and lawyerAge != ''">
			AND adminUserNames LIKE Concat('%', #{adminUserNames,jdbcType=VARCHAR}, '%')
		</if>
		<if test="projectName != null and projectName != ''">
			AND projectName = #{projectName,jdbcType=VARCHAR}
		</if>
		<if test="locationCodePath != null and locationCodePath != ''">
			AND locationCodePath = #{locationCodePath,jdbcType=VARCHAR}
		</if>
		<if test="projectCountry != null and projectCountry != ''">
			AND projectCountry = #{projectCountry,jdbcType=VARCHAR}
		</if>
		<if test="lawyerSex != null and lawyerSex != ''">
			AND lawyerSex = #{lawyerSex,jdbcType=VARCHAR}
		</if>
		<if test="lawyerPost != null and lawyerPost != ''">
			AND lawyerPost = #{lawyerPost,jdbcType=VARCHAR}
		</if>
		<if test="languages != null and languages != ''">
			AND languages = #{languages,jdbcType=VARCHAR}
		</if>
	    <if test="expert != null and expert != ''">
			AND expert = #{expert,jdbcType=VARCHAR}
		</if>
		<if test="mailBox != null and mailBox != ''">
			AND mailBox = #{mailBox,jdbcType=VARCHAR}
		</if>
		<if test="Telephone != null and Telephone != ''">
			AND Telephone = #{Telephone,jdbcType=VARCHAR}
		</if>
		<if test="expatriates != null and expatriates != ''">
			AND expatriates = #{expatriates,jdbcType=VARCHAR}
		</if>
		<if test="createrId != null and createrId != ''">
			AND createrId = #{createrId,jdbcType=VARCHAR}
		</if>
		<if test="createrName != null and createrName != ''">
			AND createrName = #{createrName,jdbcType=VARCHAR}
		</if>
		<if test="createTime != null and createTime != ''">
			AND createTime = #{createTime,jdbcType=VARCHAR}
		</if>
		<if test="modifierId != null and modifierId != ''">
			AND modifierId = #{modifierId,jdbcType=VARCHAR}
		</if>
		<if test="modifierName != null and modifierName != ''">
			AND modifierName = #{modifierName,jdbcType=VARCHAR}
		</if>
		<if test="modifyTime != null and modifyTime != ''">
			AND modifyTime = #{modifyTime,jdbcType=VARCHAR}
		</if>
	</sql>

	<!-- 查询项目列表 -->
	<select id="queryProjectBaseInfoList" resultType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" parameterType="java.util.Map" >
		select
		<include refid="Base_Column_List"></include>
		from lrm_lawyer_abroad
		<where>
			<include refid="common_where_if"></include>
		</where>
		order by createTime desc
	</select>
	<!-- 查询基本详情 -->
	<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
		select 
		<include refid="Base_Column_List" />
		from lrm_lawyer_abroad
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
	</select>
	<delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
		delete from lrm_lawyer_abroad
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
	</delete>
	<insert id="insert" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		insert into lrm_lawyer_abroad (lawyerInfoId, lawyerSurname, lawyerName, 
			lawyerAge, projectName, locationCodePath, projectCountry,
			lawyerSex, lawyerPost, languages,
			expert, mailBox, Telephone, expatriates,
			modifierId, modifierName, modifyTime,
			createrId, createrName, createTime,
		    isDelete)
		values (#{lawyerInfoId,jdbcType=VARCHAR}, #{lawyerSurname,jdbcType=VARCHAR}, #{lawyerName,jdbcType=VARCHAR}, 
			#{lawyerAge,jdbcType=VARCHAR}, #{projectName,jdbcType=VARCHAR}, #{locationCodePath,jdbcType=VARCHAR}, #{projectCountry,jdbcType=VARCHAR},
			#{lawyerSex,jdbcType=VARCHAR}, #{lawyerPost,jdbcType=VARCHAR}, #{languages,jdbcType=VARCHAR},
			#{expert,jdbcType=VARCHAR},#{mailBox,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR},
		    #{expatriates,jdbcType=VARCHAR},#{modifierId,jdbcType=VARCHAR}, #{modifierName,jdbcType=VARCHAR},
		    #{modifyTime,jdbcType=TIMESTAMP}, #{createrId,jdbcType=VARCHAR}, #{createrName,jdbcType=VARCHAR},
		    #{createTime,jdbcType=TIMESTAMP}, #{isDelete,jdbcType=INTEGER})
	</insert>
	<insert id="insertSelective" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		insert into lrm_lawyer_abroad
		<trim prefix="(" suffix=")" suffixOverrides="," >
			<if test="lawyerInfoId != null" >
				lawyerInfoId,
			</if>
			<if test="lawyerSurname != null" >
				lawyerSurname,
			</if>
			<if test="lawyerName != null" >
				lawyerName,
			</if>
			<if test="lawyerAge != null" >
				lawyerAge,
			</if>
			<if test="projectName != null" >
				projectName,
			</if>
			<if test="locationCodePath != null" >
				locationCodePath,
			</if>
			<if test="projectCountry != null" >
				projectCountry,
			</if>
			<if test="lawyerSex != null" >
				lawyerSex,
			</if>
			<if test="lawyerPost != null" >
				lawyerPost,
			</if>
			<if test="languages != null" >
				languages,
			</if>
			<if test="expert != null" >
				expert,
			</if>
			<if test="mailBox != null" >
				mailBox,
			</if>
			<if test="telephone != null" >
				Telephone,
			</if>
			<if test="expatriates != null" >
				expatriates,
			</if>
			<if test="modifierId != null" >
				modifierId,
			</if>
			<if test="modifierName != null" >
				modifierName,
			</if>
			<if test="modifyTime != null" >
				modifyTime,
			</if>
			<if test="createrId != null" >
				createrId,
			</if>
			<if test="createrName != null" >
				createrName,
			</if>
			<if test="createTime != null" >
				createTime,
			</if>
			<if test="isDelete != null" >
				isDelete,
			</if>
		</trim>
		<trim prefix="values (" suffix=")" suffixOverrides="," >
			<if test="lawyerInfoId != null" >
				#{lawyerInfoId,jdbcType=VARCHAR},
			</if>
			<if test="lawyerSurname != null" >
				#{lawyerSurname,jdbcType=VARCHAR},
			</if>
			<if test="lawyerName != null" >
				#{lawyerName,jdbcType=VARCHAR},
			</if>
			<if test="lawyerAge != null" >
				#{lawyerAge,jdbcType=VARCHAR},
			</if>
			<if test="projectName != null" >
				#{projectName,jdbcType=VARCHAR},
			</if>
			<if test="locationCodePath != null" >
				#{locationCodePath,jdbcType=VARCHAR},
			</if>
			<if test="projectCountry != null" >
				#{projectCountry,jdbcType=VARCHAR},
			</if>
			<if test="lawyerSex != null" >
				#{lawyerSex,jdbcType=VARCHAR},
			</if>
			<if test="lawyerPost != null" >
				#{lawyerPost,jdbcType=VARCHAR},
			</if>
			<if test="languages != null" >
				#{languages,jdbcType=VARCHAR},
			</if>
			<if test="expert != null" >
				#{expert,jdbcType=VARCHAR},
			</if>
			<if test="mailBox != null" >
				#{mailBox,jdbcType=VARCHAR},
			</if>
			<if test="telephone != null" >
				#{telephone,jdbcType=VARCHAR},
			</if>
			<if test="expatriates != null" >
				#{expatriates,jdbcType=VARCHAR},
			</if>
			<if test="modifierId != null" >
				#{modifierId,jdbcType=VARCHAR},
			</if>
			<if test="modifierName != null" >
				#{modifierName,jdbcType=VARCHAR},
			</if>
			<if test="modifyTime != null" >
				#{modifyTime,jdbcType=TIMESTAMP},
			</if>
			<if test="createrId != null" >
				#{createrId,jdbcType=VARCHAR},
			</if>
			<if test="createrName != null" >
				#{createrName,jdbcType=VARCHAR},
			</if>
			<if test="createTime != null" >
				#{createTime,jdbcType=TIMESTAMP},
			</if>
			<if test="isDelete != null" >
				#{isDelete,jdbcType=INTEGER},
			</if>
		</trim>
	</insert>
	<update id="updateByPrimaryKeySelective" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		update lrm_lawyer_abroad
		<set >
			<if test="lawyerSurname != null" >
				lawyerSurname = #{lawyerSurname,jdbcType=VARCHAR},
			</if>
			<if test="lawyerName != null" >
				lawyerName = #{lawyerName,jdbcType=VARCHAR},
			</if>
			<if test="lawyerAge != null" >
				lawyerAge = #{lawyerAge,jdbcType=VARCHAR},
			</if>
			<if test="projectName != null" >
				projectName = #{projectName,jdbcType=VARCHAR},
			</if>
			<if test="locationCodePath != null" >
				locationCodePath = #{locationCodePath,jdbcType=VARCHAR},
			</if>
			<if test="projectCountry != null" >
				projectCountry = #{projectCountry,jdbcType=VARCHAR},
			</if>
			<if test="lawyerSex != null" >
				lawyerSex = #{lawyerSex,jdbcType=VARCHAR},
			</if>
			<if test="lawyerPost != null" >
				lawyerPost = #{lawyerPost,jdbcType=VARCHAR},
			</if>
			<if test="languages != null" >
				languages = #{languages,jdbcType=VARCHAR},
			</if>
			<if test="expatriates != null" >
				expatriates = #{expatriates,jdbcType=VARCHAR},
			</if>
			<if test="mailBox != null" >
				mailBox = #{mailBox,jdbcType=VARCHAR},
			</if>
			<if test="telephone != null" >
				Telephone = #{telephone,jdbcType=VARCHAR},
			</if>
			<if test="expert != null" >
				expert = #{expert,jdbcType=VARCHAR},
			</if>
			<if test="modifierId != null" >
				modifierId = #{modifierId,jdbcType=VARCHAR},
			</if>
			<if test="modifierName != null" >
				modifierName = #{modifierName,jdbcType=VARCHAR},
			</if>
			<if test="modifyTime != null" >
				modifyTime = #{modifyTime,jdbcType=TIMESTAMP},
			</if>
			<if test="createrId != null" >
				createrId = #{createrId,jdbcType=VARCHAR},
			</if>
			<if test="createrName != null" >
				createrName = #{createrName,jdbcType=VARCHAR},
			</if>
			<if test="createTime != null" >
				createTime = #{createTime,jdbcType=TIMESTAMP},
			</if>
			<if test="isDelete != null" >
				isDelete = #{isDelete,jdbcType=INTEGER},
			</if>
		</set>
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
	</update>
	<update id="updateByPrimaryKey" parameterType="com.pcitc.slms.lrm.system.entity.LrmLawyerAbroad" >
		update lrm_lawyer_abroad
		set lawyerSurname = #{lawyerSurname,jdbcType=VARCHAR},
			lawyerName = #{lawyerName,jdbcType=VARCHAR},
			lawyerAge = #{lawyerAge,jdbcType=VARCHAR},
			projectName = #{projectName,jdbcType=VARCHAR},
			locationCodePath = #{locationCodePath,jdbcType=VARCHAR},
			projectCountry = #{projectCountry,jdbcType=VARCHAR},
			lawyerSex = #{lawyerSex,jdbcType=VARCHAR},
			lawyerPost = #{lawyerPost,jdbcType=VARCHAR},
			languages = #{languages,jdbcType=VARCHAR},
			expert = #{expert,jdbcType=VARCHAR},
			mailBox = #{mailBox,jdbcType=VARCHAR},
			Telephone = #{telephone,jdbcType=VARCHAR},
			expatriates = #{expatriates,jdbcType=VARCHAR},
			modifierId = #{modifierId,jdbcType=VARCHAR},
			modifierName = #{modifierName,jdbcType=VARCHAR},
			modifyTime = #{modifyTime,jdbcType=TIMESTAMP},
			createrId = #{createrId,jdbcType=VARCHAR},
			createrName = #{createrName,jdbcType=VARCHAR},
			createTime = #{createTime,jdbcType=TIMESTAMP},
			isDelete = #{isDelete,jdbcType=INTEGER}
		where lawyerInfoId = #{lawyerInfoId,jdbcType=VARCHAR}
	</update>
</mapper>

小格子衬衫
关注
  • 1
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
Mybatis开发中遇到的问题
javalingyu的博客
05-05 1426
最近在使用Mybatis的过程中遇到了一些问题，感觉有必要总结一下。前面一段时间简单的看了一点Mybatis的源码，对Mybatis在项目启动过程中以及启动后执行查询的工作流程有了一个大概的了解。这周开始我又到另一个项目，这是一个微服务项目，不过我只参与了一个服务的开发，项目使用的是Mybatis，但是并不是使用xml的方式，而是注解的方式，这也是我第一次在项目中使用注解的方式开发，中间也遇到了一些问题，这里做一个总结。 其实在前面Mybatis源码分析（一）的过程中有提到过Mybatis的注解，但是我一直
Sql for mysql
08-22
3.5 Downloading SQL Statements from the Web Site . . . . . . . . . . 38 3.6 Ready? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 CHAPTER 4 SQL in a Nutshell ...
20.mybatis常用标签
郑学炜的技术博客
03-07 723
mybatis中refid是什么意思1、首先定义一个sql标签，一定要定义唯一id&lt;sqlid="Base_Column_List" &gt;name,age&lt;/sql&gt;2、然后通过id引用&lt;select id="selectAll"&gt;select &lt;include refid="Base_Column_List" /&gt;    from stu
mysql--常用基本语法
weisian的博客
07-13 2503
常用mysql用到语法积累 mybatis--mysql常用语法 1、包含指定sql，需要外部定义 使用 <include refid="Base_Column_List" /> 定义： <sql id="Base_Column_List"> id, book_id,name,parent_id </sql> 2、like用法 name like concat('%',concat(#{name},'%')) 3、判断字符串不为空，添加sql <if t
Mybatis之动态SQL（带你了解动态SQL的魅力）
weixin_74352229的博客
08-23 1209
MyBatis中的动态SQL是一种在SQL语句中根据条件动态生成不同部分的技术。它允许我们根据不同的条件来构建不同的SQL语句，从而实现更灵活的查询和更新操作。在MyBatis中，我们可以使用动态SQL来处理各种情况，例如根据不同的条件拼接WHERE子句、根据条件选择不同的列、根据条件判断是否包含某个元素等等。MyBatis提供了一些标签和函数来实现动态SQL，其中最常用的是if、choose、when、otherwise和foreach标签。
Mapper.xml中sql常用技巧
永远热血的少年
03-18 669
mybatis写sql语句的一些常用技巧
大兵插件8.19.0105
最新发布
09-21
本文将深入探讨这款插件的特性、功能以及使用方法，帮助读者全面了解并有效利用这个强大的工具。 一、大兵插件概述 大兵插件是一款专为提高软件开发效率而设计的辅助工具，它集成了多种实用功能，如代码自动补全、...
Thunder5.6.8.19破解版
02-17
Thunder5.6.8.19破解版，绿色无毒，可以下载限制资源，
SQL Server2005基础教程
07-10
　5.13　使用SQL语句ALTER TABLE 　5.14　小结　 第6章　创建索引和数据库关系图 　6.1　什么是索引 　6.2　确定是什么导致了好的索引　 　6.3　确定是什么导致了坏的索引　 　6.4　针对性能对索引进行回顾　 　6.5...
随机森林8.19.py
09-14
随机森林8.19.py
Mybatis源码分析(六) - sql元素和参数
日薪灬越亿的博客
06-08 303
sql元素： 用来定义可重用的 SQL 代码段，可以包含在其他语句中； <sql id="Base_Column_List"> id, user_name, real_name, sex, mobile, email, note, position_id </sql> 参数：向sql语句中传递的可变参数 预编译 #{}：将传入的数据都当成一个字符串，会对自动...
如何通过include标签重用mybatis的代码段
anfei3692的博客
05-23 495
1、首先定义一个sql标签，一定要定义唯一id<sql id="Base_Column_List" >name,age</sql>2、然后通过id引用<select id="selectAll">select <include refid="Base_Column_List" /> from student</select&gt...
详解mysql中的refid =“base_column_list“
a1782519342的博客
05-31 5213
1.问题来源 在之前查询数据库的时候基本都是使用 select * from student; SELECT name, prod_price FROM products; 但是很多时候我们并不需要查询数据库中的全部字段，直接查全部字段会降低效率，同时很多字段的组合是经常被使用到的，每次都单独写出来很麻烦 2.Mybatis解决 对于上述问题，Mybatis的映射文件中为我们引入了<include refid="Base_Column_List" /> ，意思就是固定几个需要查询的字
sql与include标签＜include refid=“baseColumnList“/＞
努力努力，努力努力的博客
09-21 2328
sql与include标签
MyBatis动态sql和分页
zhangchang0516的博客
03-27 578
动态SQL语句标签包括以下标签： 1、If标签 条件判断标签，通过判断参数取值来决定是否使用某个查询条件，基本用法如下： <select id="queryBookIf" resultType="mybatis01.model.Book"> select <include refid="Base_Column_List"/> from t_book where 1=1 <if test="null!=bookType and ''!=bookType"> ...
Mybatis中的动态sql与常用的语法
wishcloud的博客
09-20 552
动态sql 动态sql常用的主要有以下几种： 1、if动态SQL语句 使用if动态语句进行空值判断，可以应用于多条件查询，不确定会有哪些查询条件的时候。 <if test="isCheck != null"> isCheck = #{isCheck}, </if> 2、foreach动态SQL语句 主要用于当要查询...
动态sql片段
mimsmile的博客
11-17 563
（1）定义​ <sql id="Base_Column_List"> patient_id, real_name, id_card, gender, getItemName('gender', gender) genderText, mobile_phone, phone, email, patient_card, province, city, district, stre
Mybatis在映射文件中 sql标签和include标签的使用 ＜include refid=“Base_Column_List“ /＞
qq_52986363的博客
04-04 4391
最近在使用springboot来写项目，用到了这两个标签，不是很理解于是就去查阅了资料，下面说一下自己的见解 <sql>用来封装SQL语句 <include>来调用 如果用了refid="base_column_list"则： 1.首先定义一个sql标签，在这个标签中一定要定义唯一id <sql id="Base_Column_List" > 字段名1,字段名2 </sql> 2、然后通过id引用 <select id="selectAl
Mybatis之sql语句
standonthetop的博客
07-15 121
引用sql定义： 前置sql语句： <sql id = "xxxYYY"> 字段1，字段2， f_staffname_byid(a.staff_id) staffName, f_managername_byid('传参名称',a.manager_id) managerName </sql> <sql id="Base_Column_List"> ...
centos7安装mysql8.19
08-23
要在CentOS 7上安装MySQL 8.19，您可以按照以下步骤操作： 1. 首先，您需要下载MySQL 8.19的压缩包，并将其解压缩到/usr/local/目录下。您可以使用以下命令将解压得到的文件移动到/usr/local/目录，并重新命名为...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

小格子衬衫

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值