try {
conn = LDAPManager.INSTANCE.getConnection();
PreparedStatement pstmt = conn.prepareStatement(this.service
.getMainSql());
ResultSet rs = pstmt.executeQuery();// sql
SearchTransCode stc = new SearchTransCode(null);
List<BOInstance> list = new ArrayList<BOInstance>();
while (rs.next()) {
BOInstance bi = stc.transRSToBOInstance(rs, null);
bi.setBo(this.service.getBo());
String sn = rs.getString("sn");
String tcn = rs.getString("cn");
if (sn != null && !sn.trim().equals("")) {
// bi.putValue("uid", bi.getValue("sn"));