Jak skonfigurować fasolę wiosenną z właściwościami przechowywanymi w tabeli bazy danych

FactoryBean

& < Properties & >

JdbcTemplate

Properties

<context:property-placeholder>

public class JdbcPropertiesFactoryBean

 extends AbstractFactoryBean<Properties>{ @Required

 public void setJdbcTemplate(final JdbcTemplate jdbcTemplate){

 this.jdbcTemplate = jdbcTemplate;

 }

 private JdbcTemplate jdbcTemplate; @Required

 public void setTableName(final String tableName){

 this.tableName = tableName;

 }

 private String tableName; @Required

 public void setKeyColumn(final String keyColumn){

 this.keyColumn = keyColumn;

 }

 private String keyColumn; @Required

 public void setValueColumn(final String valueColumn){

 this.valueColumn = valueColumn;

 }

 private String valueColumn; @Override

 public Class<?> getObjectType(){

 return Properties.class;

 } @Override

 protected Properties createInstance() throws Exception{

 final Properties props = new Properties();

 jdbcTemplate.query("Select " + keyColumn + ", " + valueColumn

 + " from " + tableName, new RowCallbackHandler(){ @Override

 public void processRow(final ResultSet rs) throws SQLException{

 props.put(rs.getString(1), rs.getString(2));

 } });

 return props;

 }

}

<bean id="props" class="foo.bar.JdbcPropertiesFactoryBean">

 <property name="jdbcTemplate">

 <bean class="org.springframework.jdbc.core.JdbcTemplate">

 <!-- reference to a defined data source -->

 <constructor-arg ref="dataSource"/>

 </bean>

 </property>

 <property name="tableName" value="TBL_PROPERTIES"/>

 <property name="keyColumn" value="COL_KEY"/>

 <property name="valueColumn" value="COL_VAL"/>

</bean><context:property-placeholder properties-ref="props"/>

PropertyPlaceholderConfigurer

PreferencesX

ServletContextX

XmlBeanFactory factory = new XmlBeanFactory(new FileSystemResource("beans.xml"));

PropertyPlaceholderConfigurer cfg = new PropertyPlaceholderConfigurer();

cfg.setProperties(yourProperties);

cfg.postProcessBeanFactory(factory);