配置文件完成修改全部字段
1、编写接口方法:Mapper接口
观察参数
返回结果
2、编写SQL语句:SQL映射文件;
3:执行方法,测试
//添加 @Test public void testUpdate() throws IOException { int id = 10; int status =1; String companyName = "波导手机"; String brandName = "波导"; String description = "asdawasdw手机中的战斗机"; String ordered = "21000"; Brand brand = new Brand(); brand.setStatus(status); brand.setBrandName(brandName); brand.setCompanyName(companyName); brand.setDescription(description); brand.setOrdered(ordered); brand.setId(id); //1获取sqlSessionFactory String resource = "mybatis-config.xml"; //配置文件 InputStream inputStream = Resources.getResourceAsStream(resource); //传入流 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); //返回对象 //2 获取sqlSession 对象 SqlSession sqlSession = sqlSessionFactory.openSession(true); //3 获取Mapper接口的代理对象 BrandMapper brandMapper = sqlSession.getMapper(BrandMapper.class); //4 执行方法 int count = brandMapper.update(brand); System.out.println(count); //5 释放资源 sqlSession.close(); }
配置文件完成修改动态字段
只需要修改SQL语句即可
<!-- 修改--> <update id="update"> update tb_brand <set> <if test="brandName != null and brandName != ''"> brand_name = #{brandName}, </if> <if test="companyName != null and companyName != ''"> company_name = #{companyName}, </if> <if test="ordered != null and ordered !=''"> ordered = #{ordered}, </if> <if test="description != null and description != ''"> description = #{description}, </if> <if test="status != null "> status = #{status} </if> </set> where id = #{id} </update>
![](/i/l/?n=22&i=blog/2442524/202209/2442524-20220905203020312-575262727.png)
标签:status,ordered,String,brand,修改,sqlSession,MyBatis,动态,id From: https://www.cnblogs.com/zhaolei0419/p/16659527.html