67,516
社区成员
发帖
与我相关
我的任务
分享
MySql:
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
Oracle:
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%') 或
SELECT * FROM user WHERE name like '%'||#{name}||'%'
SQLServer:
SELECT * FROM user WHERE name like '%'+#{name}+'%'
DB2:
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%') 或
SELECT * FROM user WHERE name like '%'||#{name}||'%'
<select id="findUsers" resultType="domain.User">
SELECT id, username, password FROM user LIMIT ${offset}, ${count}
</select>
public interface UserMapper {
public User findUserById(int id);
// 使用 @Param 的方式传参数
public List<User> findUsers(@Param("offset") int offset, @Param("count") int count);
}