Mybatis查询记录条数的实例代码

<select id="usernamevalidate" parametertype="string" resulttype="integer"> 
   select count(*) from user where username like #{value} 
</select>   
<select id="nicknamevalidate" parametertype="string" resulttype="integer"> 
  select count(*) from user where nickname like #{value}    
</select> 

// 验证 nickname 是否重复 
public integer nicknamevalidate(@param("value")string value); 
// 验证 username 是否重复 
// 防止查询不到值为空，用integer 
public integer usernamevalidate(@param("value")string value); 

int namevalidate(string name,string value); 

 // 验证是否重名：username、nickname,返回该名字数量,0 没重名,1重名 
ublic int namevalidate(string name,string value) { 
integer validate ; 
system.out.println("impl:"+name +"==="+value); 
if(name.equals("username")) 
  validate = usermapper.usernamevalidate(value); 
else 
  validate = usermapper.nicknamevalidate(value); 
if(validate == null) 
  return 0; 
return validate.intvalue();