检验身份证号的唯一性
protected void card ( HttpServletRequest request, HttpServletResponse response) throws ServletException , IOException {
boolean success = false ;
String card = request. getParameter ( "card" ) ;
if ( Validator . isNotEmpty ( card) && card. trim ( ) . length ( ) == 18 ) {
success = personnelService. queryByCard ( card) ;
}
PrintWriter writer = response. getWriter ( ) ;
writer. write ( success + "" ) ;
writer. flush ( ) ;
writer. close ( ) ;
}
boolean queryByCard ( String card) ;
@Override
public boolean queryByCard ( String card) {
return personnelDao. queryByCard ( card) == 0 ;
}
int queryByCard ( String card) ;
public int queryByCard ( String card) {
SqlSession session = MybatisUtils . openSession ( true ) ;
int count = session. selectOne ( "personnel.queryByCard" , card) ;
session. close ( ) ;
return count;
}
< select id = " queryByCard" parameterType = " string" resultType = " int" >
select count(1)
from rms_personnel
where card = #{card}
</ select>