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;
}
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
修改如下:
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;
}
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;
}
}