开发者社区 问答 正文

springjdbc使用BeanPropertyRowMapper报Mapped class was not specified

private static final String SQL = "SELECT a.appTitle,a.appHost,a.adminEmail,a.appOwner FROM app_configuration a LIMIT 1";
@Autowired private JdbcTemplate jdbc;

public AppConfiguration getConfig() {

AppConfiguration conf = (AppConfiguration) jdbc.query(SQL, new BeanPropertyRowMapper<AppConfiguration>());
return conf;

}

展开
收起
a123456678 2016-03-13 16:24:58 8811 分享 版权
2 条回答
写回答
取消 提交回答
  • 少搬砖,多专研

    修改如下:
    public AppConfiguration getConfig() {
    List confList = jdbc.query(SQL, new Object[]{},new BeanPropertyRowMapper(AppConfiguration.class));
    if(null != confList && !confList .isEmpty){

     return confList.get(0);

    }
    return null;
    }

    2019-07-17 19:02:50
    赞同 1 展开评论
  • public class AppConfiguration implements Serializable {
     
        /**
         * 
         */
        private static final long serialVersionUID = 1L;
         
        public static String KEY_APPTITLE = "appTitle";
        public static String KEY_APPHOST = "appHost";
        public static String KEY_ADMINEMAIL = "adminEmail";
        public static String KEY_APPOWNER = "appOwner";
        public static String KEY_year = "year";
        public static String KEY_staticresourceversion = "staticResourceVersion";
        public static String KEY_staticservepath = "staticServePath";
        public static String KEY_servepath = "servePath";
         
        private String appTitle;
        private String appHost;
        private String adminEmail;
        private String appOwner;
        public AppConfiguration() {
            super();
        }
        public String getAppTitle() {
            return appTitle;
        }
        public void setAppTitle(String appTitle) {
            this.appTitle = appTitle;
        }
        public String getAppHost() {
            return appHost;
        }
        public void setAppHost(String appHost) {
            this.appHost = appHost;
        }
        public String getAdminEmail() {
            return adminEmail;
        }
        public void setAdminEmail(String adminEmail) {
            this.adminEmail = adminEmail;
        }
        public String getAppOwner() {
            return appOwner;
        }
        public void setAppOwner(String appOwner) {
            this.appOwner = appOwner;
        }
    }
    2019-07-17 19:02:50
    赞同 展开评论
问答分类:
问答地址: