因为mysql存在没有区分字符串大小写的情况,所以我这边的策略是把账号统一转成大写
service层调用
int count = userDao.getUser(username.toUpperCase())
dao层接口
private int getUser(String username)
xml层查询
select count(1) from user where upper(username)=#{username}
因为mysql存在没有区分字符串大小写的情况,所以我这边的策略是把账号统一转成大写
service层调用
int count = userDao.getUser(username.toUpperCase())
dao层接口
private int getUser(String username)
xml层查询
select count(1) from user where upper(username)=#{username}