SELECT * FROM PERSON WHERe ID = #{id} select CAST(RANDOM()*1000000 as INTEGER) a from SYSIBM.SYSDUMMY1 insert into Author (id, username, password, email,bio, favourite_section) values (#{id}, #{username}, #{password}, #{email}, #{bio}, #{favouriteSection,jdbcType=VARCHAR}) ${alias}.id,${alias}.username,${alias}.password select , from some_table t1 cross join some_table t2 ${prefix}Table from select field1, field2, field3 SELECT * FROM BLOG WHERe state = ‘ACTIVE’ AND title like #{title} SELECT * FROM BLOG WHERe state = ‘ACTIVE’ AND title like #{title} AND author_name like #{author.name} AND featured = 1 SELECT * FROM BLOG state = #{state} AND title like #{title} AND author_name like #{author.name} update Author username=#{username}, password=#{password}, email=#{email}, bio=#{bio} where id=#{id} SELECT * FROM POST P WHERe ID in #{item} SELECT * FROM BLOG WHERe title LIKE #{pattern} select seq_users.nextval from dual select nextval for seq_users from sysibm.sysdummy1" insert into users values (#{id}, #{name})
上一篇 JDK1.8安装Derby数据库
下一篇 软件设计之单例模式(四)
版权所有 (c)2021-2022 MSHXW.COM
ICP备案号:晋ICP备2021003244-6号