| | |
|---|
| | | try { |
|---|
| | | while (rs.next()) { |
|---|
| | | User_inf userinf = new User_inf(); |
|---|
| | | userinf.setUSnId(rs.getString("uSnId")); |
|---|
| | | userinf.setUId(rs.getInt("uId")); |
|---|
| | | userinf.setUName(rs.getString("uName")); |
|---|
| | | userinf.setUShenFenId(rs.getString("uShenFenId")); |
|---|
| | | userinf.setUEmployeeId(rs.getString("uEmployeeId")); |
|---|
| | | userinf.setUTelephone(rs.getString("uTelephone")); |
|---|
| | | userinf.setUMobilephone(rs.getString("uMobilephone")); |
|---|
| | | userinf.setUEmail(rs.getString("uEmail")); |
|---|
| | | userinf.setUAddr(rs.getString("uAddr")); |
|---|
| | | userinf.setUBirthDay(rs.getTimestamp("uBirthDay")); |
|---|
| | | userinf.setUAccessionDay(rs.getTimestamp("uAccessionDay")); |
|---|
| | | userinf.setUSex(rs.getString("uSex")); |
|---|
| | | userinf.setUDepartment(rs.getString("uDepartment")); |
|---|
| | | userinf.setUProTitle(rs.getString("uProTitle")); |
|---|
| | | userinf.setUAuthority(rs.getString("uAuthority")); |
|---|
| | | userinf.setUJobGroup(rs.getString("uJobGroup")); |
|---|
| | | userinf.setUDuties(rs.getString("uDuties")); |
|---|
| | | userinf.setUTasks(rs.getString("uTasks")); |
|---|
| | | userinf.setUBaojiusr(Integer.parseInt(rs.getString("uBaojiUsr"))); |
|---|
| | | userinf.setUNote(rs.getString("uNote")); |
|---|
| | | |
|---|
| | | list.add(userinf); |
|---|
| | | } |
|---|
| | | } catch (SQLException e) { |
|---|
