String sql= "select * from CHECKINOUT where USERID =? and convert(varchar,CHECKTIME,120) like ?";
pstm=con.prepareStatement(sql);
pstm.setInt(1,id);
pstm.setString(2, Datetime+"%");
//执行SQL语句
ResultSet rs = pstm.executeQuery();