原生sql操作

方便开发可能需要用sql 直接操作的行为;mapper都带有操作native sql的方法

1.单个查询

SysUser user = sysUserMapper.select(SysUser.class, "select * from t_sys_user where id =?", 1);

2.列表查询

List<SysUser> list = sysUserMapper.selectList(SysUser.class, "select * from t_sys_user where id in(?,?) order by id asc", 1, 2);

3.修改或删除

int cnt = sysUserMapper.execute("update t_sys_user set role_id=1 where id=1");

4.修改或删除,支持RETURNING 返回单个操作

List<String> user_names = sysUserMapper.executeAndReturningList(String.class, "update t_sys_user set user_name=? where id in (1,2) RETURNING user_name", "xxx");

5.修改或删除,支持RETURNING 返回多个操作

String user_name = sysUserMapper.executeAndReturning(String.class, "update t_sys_user set user_name=? where id=1 RETURNING user_name", "xxx");

1.原生sql + 动态where

SysUser user = sysUserMapper.select(SysUser.class, "select * from t_sys_user t where ? ", WhereUtil.create().eq(SysUser::getId, 1));

List<Map> list = sysUserMapper.selectList(Map.class, "select * from t_sys_user t where ? and ?", WhereUtil.create(), WhereUtil.create().eq(SysUser::getId, 1));

注意 where 需自己加上; 其他有框架保证 条件正确

1.原生sql + 动态query

SysUser user = sysUserMapper.select(SysUser.class, "select * from t_sys_user t ?", Query.create().eq(SysUser::getId, 1));

List<Map> list = sysUserMapper.selectList(Map.class, "select * from t_sys_user t ?", Query.create().eq(SysUser::getId, 1));