Index: ssts-datasync/src/main/java/com/forgon/disinfectsystem/verification/action/VerificationCodeAction.java =================================================================== diff -u -r34034 -r36128 --- ssts-datasync/src/main/java/com/forgon/disinfectsystem/verification/action/VerificationCodeAction.java (.../VerificationCodeAction.java) (revision 34034) +++ ssts-datasync/src/main/java/com/forgon/disinfectsystem/verification/action/VerificationCodeAction.java (.../VerificationCodeAction.java) (revision 36128) @@ -9,6 +9,8 @@ import org.apache.struts2.convention.annotation.Action; import org.apache.struts2.convention.annotation.Namespace; import org.apache.struts2.convention.annotation.ParentPackage; +import org.springframework.jdbc.core.BeanPropertyRowMapper; +import org.springframework.jdbc.core.JdbcTemplate; import com.forgon.disinfectsystem.verification.service.VerificationCodeManager; import com.forgon.exception.SystemException; @@ -33,6 +35,12 @@ private UserManager userManager; + private JdbcTemplate jdbcTemplate; + + public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { + this.jdbcTemplate = jdbcTemplate; + } + public void setUserManager(UserManager userManager) { this.userManager = userManager; } @@ -62,11 +70,13 @@ /** * 获取用户联系电话 */ + @SuppressWarnings("unchecked") public void getPhoneNumberByLoginName(){ JSONObject result = JSONUtil.buildJsonObject(true); String loginName = StrutsParamUtils.getPraramValue("loginName", ""); try { - List userList = userManager.getByProperty("name", loginName); + String sql = "select smsMumber from SS_USERS where name = ?"; + List userList = jdbcTemplate.query(sql, new Object[]{loginName}, new BeanPropertyRowMapper(User.class)); if(CollectionUtils.isEmpty(userList)){ throw new SystemException("用户不存在!"); }