优化语句<update id="updateByPrimaryKey" parameterType="com.example.demo.domain.Permission"> update sys_permission <set> <if test="permission_id!=null"> permission_id = #{permission_id}, </if> <if test="pid!=null"> pid = #{pid}, </if> <if test="name!=null"> name = #{name}, </if> <if test="type!=null"> type = #{type}, </if> <if test="permission_value!=null"> permission_value = #{permission_value}, </if> <if test="uri!=null"> uri = #{uri}, </if> <if test="icon!=null"> icon = #{icon}, </if> <if test="status!=null"> status = #{status}, </if> <if test="ctime!=null"> ctime = #{ctime}, </if> <if test="orders!=null"> orders = #{orders}, </if> <if test="system_id!=null"> system_id = #{system_id} </if> </set> where permission_id = #{permission_id} </update>

update 语句优化update 语句优化update 语句优化

update 语句优化

update语句的优化-oracle

update语句的优化-oracle .pdf

实际项目中遇到的问题总结：数据量百万级，千万级。Oracle中update语句的优化，一共四种方案，工作中遇到该类问题可以参考。

<update id="updateByPrimaryKeySelective" parameterType="com.example.pojo.Admin" > update admin <set > <if test="username != null" > username = #{username,jdbcType=VARCHAR}, </if> <if test="password != null" > password = #{password,jdbcType=VARCHAR}, </if> </set> where id = #{id,jdbcType=INTEGER} </update> <update id="updateByPrimaryKey" parameterType="com.example.pojo.Admin" > update admin set username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} </update>

第二个Update语句的id为updateByPrimaryKey，作用是根据传入的Admin对象更新admin表中对应记录的所有列。两个语句的parameterType属性都为com.example.pojo.Admin，表示传入的参数为一个Admin对象。其中，<if>标签...

update tbl_emp <set> <if test="empName != null"> emp_name = #{empName,jdbcType=VARCHAR}, </if> <if test="gender != null"> gender = #{gender,jdbcType=CHAR}, </if> <if test="email != null"> email = #{email,jdbcType=VARCHAR}, </if> <if test="dId != null"> d_id = #{dId,jdbcType=INTEGER}, </if> </set> where emp_id = #{empId,jdbcType=INTEGER} </update> <update id="updateByPrimaryKey" parameterType="com.zhiyou.bean.Employee">

这是一个 MyBatis 的 XML 映射文件中...其中，<if> 标签用于判断参数是否为 null，如果不为 null，则更新对应的列。这个 SQL 语句还定义了两个 update 操作，一个是根据 emp_id 更新数据，另一个是根据主键更新数据。

<?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.de.debook.mapper.CategoryMapper"> <resultMap id="BaseResultMap" type="com.de.debook.entity.Category"> <id column="id" jdbcType="INTEGER" property="id"/> <result column="name" jdbcType="VARCHAR" property="name"/> </resultMap> <resultMap id="StatisticsResultMap" type="com.de.debook.entity.Statistics"> <result column="name" jdbcType="VARCHAR" property="name"/> <result column="value" jdbcType="VARCHAR" property="value"/> </resultMap> <sql id="Base_Column_List"> id, name </sql> <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> select <include refid="Base_Column_List"/> from category where id = #{id,jdbcType=INTEGER} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> delete from category where id = #{id,jdbcType=INTEGER} </delete> <insert id="insert" parameterType="com.de.debook.entity.Category"> insert into category (id, name) values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}) </insert> <insert id="insertSelective" parameterType="com.de.debook.entity.Category"> insert into category <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id != null"> id, </if> <if test="name != null"> name, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="id != null"> #{id,jdbcType=INTEGER}, </if> <if test="name != null"> #{name,jdbcType=VARCHAR}, </if> </trim> </insert> <update id="updateByPrimaryKeySelective" parameterType="com.de.debook.entity.Category"> update category <set> <if test="name != null"> name = #{name,jdbcType=VARCHAR}, </if> </set> where id = #{id,jdbcType=INTEGER} </update> <update id="updateByPrimaryKey" parameterType="com.de.debook.entity.Category"> update category set name = #{name,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} </update> <select id="selectAll" resultMap="BaseResultMap"> select <include refid="Base_Column_List"/> from category order by id asc </select> <select id="selectStatistics" resultMap="StatisticsResultMap"> SELECT t1.name as name, COUNT(*) as value FROM category t1, debook t2 WHERE t1.id = t2.category_id GROUP BY t1.id order by t1.id asc </select> </mapper>

其中包括了一些 SQL 语句，如 selectByPrimaryKey、deleteByPrimaryKey、insert、updateByPrimaryKeySelective 等，用于对数据表进行增删改查操作。还定义了两个结果映射 resultMap，用于将查询结果映射到实体类或...

<update id="delete" parameterType="com.anan.entity.pojo.LiabilitiesSpecifics"> update liabilities_specifics set state =0 <where> <if test="query.id!=null"> id = #{query.id}, </if> <if test="query.liabilitiesId!=null"> and liabilities_id = #{query.liabilitiesId}, </if> </where> </update>

其中，<if> 标签用于判断传入的参数是否为空，如果不为空则将对应的条件添加到 SQL 语句中。#{} 是占位符，用于接收参数值。在这个例子中，query 是一个对象，包含了 id 和 liabilitiesId 两个属性。如果 ...

<update id="updateByPrimaryKey" parameterType="com.example.pojo.Admin" > update admin set username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} </update>

这是Mybatis XML配置文件中的一个Update语句，它的id为updateByPrimaryKey，作用是根据传入的Admin对象更新admin表中对应记录的所有列。其中，parameterType属性为com.example.pojo.Admin，表示传入的参数为一个...

<update id="updateOne" parameterType="category"> UPDATE category <set> <if test="category.category_name != null">category_name = #{category.category_name},</if> <if test="category.category_image_src != null">category_image_src = #{category.category_image_src}</if> </set> <where> category_id = #{category.category_id} </where> </update>写出删除

这是一个 Mybatis 的 Mapper XML 文件中的更新操作，如果要写一个删除操作，可以直接将 <update> 标签替换为 <delete> 标签，并将 SQL 语句中的 UPDATE 改为 DELETE，例如： xml <delete id="deleteOne...

<?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.phonemarket.mapper.BannerMapper"> <resultMap type="Banner" id="BaseResultMap"> <id property="bannerId" column="banner_id" /> <result property="bannerName" column="banner_name" /> <result property="bannerUrl" column="banner_url" /> <result property="bannerImg" column="banner_img" /> <result property="bannerState" column="banner_state" /> </resultMap> <insert id="addBanner" parameterType="Banner"> insert into banner(banner_name,banner_url,banner_img) values(#{bannerName},#{bannerUrl},#{bannerImg}) </insert> <update id="deleteBanner" parameterType="java.lang.Integer"> update banner set banner_state=-1 where banner_id=#{id} </update> <update id="changeBannerState" parameterType="java.lang.Integer"> update banner set banner_state=#{0} where banner_id=#{1} </update> <update id="updateBanner" parameterType="Banner"> update banner <set> <if test="bannerName!=null"> banner_name=#{bannerName}, </if> <if test="bannerUrl!=null"> banner_url=#{bannerUrl}, </if> <if test="bannerImg!=null"> banner_img=#{bannerImg} </if> </set> where banner_id=#{bannerId} </update> <select id="findBannerById" parameterType="java.lang.Integer" resultMap="BaseResultMap"> select * from banner where banner_id=#{id} </select> <select id="findAllBanner" resultMap="BaseResultMap"> select * from banner where banner_state > 0 </select> <select id="findAllBannerByLikeName" parameterType="java.lang.String" resultMap="BaseResultMap"> select * from banner where banner_state > 0 and banner_name like '%${value}%' </select> <select id="findAllShowBanner" resultMap="BaseResultMap"> select * from banner where banner_state=1 </select> </mapper>

括号中的参数类型表示 SQL 语句中的参数类型，resultMap 定义了查询结果与 Banner 对象之间的映射关系。其中BaseResultMap是一个标识符，表示基本的结果映射，对应了Banner类中的属性名称。在 SQL 语句中，#{param} ...

下面代码中的user是什么？在IDEA环境下，如何创造这样一个“user”？代码：<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.example.demo.mapper.UserMapper"> <resultMap id="userMap" type="com.example.demo.entity.User"> <id column="id" property="id"/> <result column="name" property="name"/> <result column="age" property="age"/> <result column="gender" property="gender"/> </resultMap> <select id="selectById" resultMap="userMap"> select * from user where id = #{id} </select> <select id="selectAll" resultMap="userMap"> select * from user </select> <insert id="insert" parameterType="com.example.demo.entity.User"> insert into user(name, age, gender) values(#{name}, #{age}, #{gender}) </insert> <update id="update" parameterType="com.example.demo.entity.User"> update user set name = #{name}, age = #{age}, gender = #{gender} where id = #{id} </update> <delete id="deleteById"> delete from user where id = #{id} </delete></mapper>

在这个XML文件中，"user"是一个数据库表的实体类，包含了id、name、age、gender等字段。这里的"user"并不是IDEA环境下创建的对象，而是代表了数据库表的实体类，需要在Java代码中创建对应的实体类。在IDEA环境下...

<update id="updateCustomer" parameterType="com.wqr.pojo.Customer"> update customer <set> <if test="username !=null and username !=''"> username=#{username}, </if> <if test="jobs !=null and jobs !=''"> jobs=#{jobs}, </if> <if test="phone !=null and phone !=''"> phone=#{phone}, </if> </set> where id=#{id} </update>参照以上客户信息更新功能的代码，仿照写出删除客户功能的代码。

<delete id="deleteCustomer" parameterType="int"> delete from customer where id=#{id} </delete> 其中，deleteCustomer() 方法接收一个客户的 ID，使用 id 参数来删除客户信息。在 SQL 语句中使用 ...

解释一下这段代码：<?xml version = "1.0" encoding = "UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD com.example.Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.example.demo.mapper.UserMapper"> <resultMap id="result" type="com.example.demo.entity.User"> <result property="userId" column="userId" /> <result property="userDate" column="userDate" /> <result property="userName" column="userName" /> <result property="userAddress" column="userAddress"/> </resultMap> <select id="ListUser" resultMap="result"> SELECT * FROM user </select> <select id="findUserByName" resultMap="result" parameterType="String"> SELECT * FROM user where userName like concat(concat('%',#{userName}),'%') order by userId desc </select> <select id="queryPage" resultMap="result" parameterType="Integer"> select * from user order by userId desc limit #{startRows},5 </select> <select id="getRowCount" resultType="Integer"> select count(*) from user </select> <insert id="insertUser" parameterType="com.example.demo.entity.User"> INSERT INTO user ( userId,userDate,userName,userAddress ) VALUES ( #{userId}, #{userDate, jdbcType=VARCHAR}, #{userName, jdbcType=VARCHAR}, #{userAddress, jdbcType=VARCHAR} ) </insert> <delete id="delete" parameterType="int"> delete from user where userId=#{userId} </delete> <update id="Update" parameterType="com.example.demo.entity.User"> update user set user.userDate=#{userDate},user.userName=#{userName},user.userAddress=# {userAddress} where user.userId=#{userId} </update> </mapper>

- <mapper namespace="com.example.demo.mapper.UserMapper">：指定了映射文件的命名空间，即该文件中定义的SQL语句与Java方法的映射关系将归属于com.example.demo.mapper.UserMapper这个命名空间。 - <resultMap>：...

解释代码<?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.synu.sx.demo.mapper.StudentMapper"> <select id="list" parameterType="java.util.Map" resultType="com.synu.sx.demo.entity.Student"> select * from student <where> <if test="param.id != null and param.id != ''"> id = #{param.id} </if> </where> </select> <select id="listQuery" parameterType="java.util.Map" resultType="com.synu.sx.demo.entity.Student"> select * from student <where> <if test="param.name != null and param.name != ''"> and name like concat('%', #{param.name} ,'%') </if> <if test="param.id != null and param.id != ''"> and id like concat('%', #{param.id} ,'%') </if> </where> limit #{param.start}, #{param.limit} </select> <select id="listQueryCount" parameterType="java.util.Map" resultType="java.lang.Integer"> select count(*) from student <where> <if test="param.name != null and param.name != ''"> and name like concat('%', #{param.name} ,'%') </if> <if test="param.id != null and param.id != ''"> and id like concat('%', #{param.id} ,'%') </if> </where> </select> </mapper>

在<if>标签中，如果param的id属性不为空，则添加了一个id = #{param.id}的条件。第二个查询语句的id是"listQuery"，与第一个查询语句类似，不同之处在于它添加了更多的条件筛选和分页功能。除了id之外，它还检查了...

为什么以下代码会导致上述错误 <select id="selectList" resultMap="BaseResultMap" parameterType="com.wego.entity.query.CartItemQuery"> select <include refid="Base_Column_List"/> from tb_cart_item <where> <if test="id != null"> and id = #{id} </if> <if test="goodsId != null"> and goodsId= #{goodsId} </if> <if test="amount != null"> and amount= #{amount} </if> <if test="money != null"> and money= #{money} </if> </where> order by update_time desc </select>

<if test="id != null"> and id = #{id} </if> xml <if test="goodsId != null"> and goodsId = #{goodsId} </if> xml <if test="amount != null"> and amount = #{amount} </if> xml ...

结合下如下sql语句分析下：<update id="updateUser" parameterType="User"> update user <set> <if test="username != null">username = #{username},</if> <if test="password != null">password = #{password},</if> <if test="email != null">email = #{email},</if> <if test="phone != null">phone = #{phone}</if> </set> where id = #{id} </update>

- <set> 标签表示要更新的字段列表，内部使用了多个 <if> 标签进行判断，如果参数中对应的字段不为 null，则进行更新。 - #{username}、#{password}、#{email}、#{phone} 是占位符，表示要更新的字段的值，MyBatis ...

<sql id="wherePrimaryKey"> <if test="mainId != null "> and main_id = #{mainId} </if> <if test="serialNo != null "> and serial_no = #{serialNo} </if> </sql> 无法解析 <delete id="delete" parameterType="sinosoft.services.products.ecargo.protocolManage.prpCargo.model.po.domain.PrpCargoPo"> delete from prp_cargo <where> <include refid="wherePrimaryKey"/> </where> </delete> 中的"wherePrimaryKey"

<delete id="delete" parameterType="sinosoft.services.products.ecargo.protocolManage.prpCargo.model.po.domain.PrpCargoPo"> delete from prp_cargo <where> <include refid="wherePrimaryKey"/> </where>...

相关推荐

update 语句优化update 语句优化update 语句优化

update语句的优化-oracle

update语句的优化-oracle .pdf

<update id="delete" parameterType="com.anan.entity.pojo.LiabilitiesSpecifics"> update liabilities_specifics set state =0 <where> <if test="query.id!=null"> id = #{query.id}, </if> <if test="query.liabilitiesId!=null"> and liabilities_id = #{query.liabilitiesId}, </if> </where> </update>

<update id="updateByPrimaryKey" parameterType="com.example.pojo.Admin" > update admin set username = #{username,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} </update>

【9493】基于springboot+vue的美食信息推荐系统的设计与实现.zip

(源码)基于Spring、Struts和Hibernate的OA系统.zip

基于MySQL、express框架、Vue3的光谷智慧交通系统源码+数据库+文档说明（高分项目）

最新推荐

【9493】基于springboot+vue的美食信息推荐系统的设计与实现.zip

(源码)基于Spring、Struts和Hibernate的OA系统.zip

基于MySQL、express框架、Vue3的光谷智慧交通系统源码+数据库+文档说明（高分项目）

open3d python 给点云每个点设置不同的颜色

【电磁】基于matlab具有Mur吸收边界的区域的二维FDTD【含Matlab源码 9136期】.mp4

黑板风格计算机毕业答辩PPT模板下载

管理建模和仿真的文件

提升点阵式液晶显示屏效率技术

在SoC芯片的射频测试中，ATE设备通常如何执行系统级测试以保证芯片量产的质量和性能一致？

CodeSandbox实现ListView快速创建指南