如何通过添加注释来优化SQL的增删改查操作？

本文共计144个文字，预计阅读时间需要1分钟。

javapackage org.jxnd.mapper;

import java.util.List;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;import org.jxnd.bean.Users;

public interface UsersMapper { // 根据系统ID查询用户列表 List selectUsersBySystemId(@Param(systemId) int systemId);}

UsersMapper.java

package org.jxnd.mapper; import java.util.List; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import org.jxnd.bean.Systems; import org.jxnd.bean.Users; public interface UsersMapper { //根据用户名和密码查询用户信息 @Select("select * from users where uname=#{uname} and upassword=#{upassword}") Users getUserByNameAndPwd(@Param("uname")String uname,@Param("upassword")String upassword); //查询角色所有权限 @Select("select * from systems where id in(select sid from rolesystems where rid=#{rid})") List getSystemsByRid(int rid); }