2023年8月3日发(作者：)
mybatis更新操作update关于mybatis中update操作遇到了问题解决; 看代码:测试类:@Test public void updatwUser () throws IOException { InputStream is = ourceAsStream(""); //建⽴会话⼯⼚ SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is); SqlSession sqlSession = ssion(); UserMapper mapper = per(); User("帅帅","帅帅",1); (); (); }Mapper接⼝: void updatwUser ( String j, String j1,int i);配置: update user # 后⾯加,重点 name=#{param1}, password=#{param2}, where id=#{param3} 重点:⼀定要在name=#{param1},后⾯加上那个,password=#{param2},建议最后⼀个参数后也加,不加也⾏,mybatis会⾃动去掉最后⼀个,->>>>>>⼀定加 ","不加的话会报错:tenceException:Error updating database. Cause: yntaxErrorException: Youhave an error in your SQL syntax; check the manual that corresponds to your MySQL server versionfor the right syntax to use near 'password=‘帅帅’ where id=1' at line 4The error may involve defaultParameterMapThe error occurred while setting parametersSQL: update user SET name=? password=? where id=?希望帮助⼤家
2023年8月3日发(作者：)
mybatis更新操作update关于mybatis中update操作遇到了问题解决; 看代码:测试类:@Test public void updatwUser () throws IOException { InputStream is = ourceAsStream(""); //建⽴会话⼯⼚ SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is); SqlSession sqlSession = ssion(); UserMapper mapper = per(); User("帅帅","帅帅",1); (); (); }Mapper接⼝: void updatwUser ( String j, String j1,int i);配置: update user # 后⾯加,重点 name=#{param1}, password=#{param2}, where id=#{param3} 重点:⼀定要在name=#{param1},后⾯加上那个,password=#{param2},建议最后⼀个参数后也加,不加也⾏,mybatis会⾃动去掉最后⼀个,->>>>>>⼀定加 ","不加的话会报错:tenceException:Error updating database. Cause: yntaxErrorException: Youhave an error in your SQL syntax; check the manual that corresponds to your MySQL server versionfor the right syntax to use near 'password=‘帅帅’ where id=1' at line 4The error may involve defaultParameterMapThe error occurred while setting parametersSQL: update user SET name=? password=? where id=?希望帮助⼤家
发布评论