<?xml version="1.0" encoding="UTF-8"?>
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
classpath:/datasource/jdbc.properties
<?xml version="1.0" encoding="UTF-8"?>
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean id="aisBusBIZ" class="com.huawei.bus.biz.impl.AisBusBizImpl">
<property name="aisBusDAO" ref="aisBusDAO"/>
</bean>
<bean id="aisBusDAO" class="com.huawei.bus.dao.impl.AisBusDAOImpl"/>
<bean id="getSqlValue" class="com.huawei.bus.util.GetSqlValue">
<property name="map">
<map>
<entry key="query_subscriber" value="SELECT SUBSCRIBERKEY,APPLYTIME,EXPIRETIME FROM CBE_SUBSCRIBER"/>
</map>
</property>
</bean>
---------AbstractSupperDao.java文件
public class AbstractSupperDao {
public JdbcTemplate jdbctemplate;
public JdbcTemplate getJdbctemplate() {
return jdbctemplate;
}
public void setJdbctemplate(JdbcTemplate jdbctemplate) {
this.jdbctemplate = jdbctemplate;
}
}
--------AisBusDAOImpl.java文件
public class AisBusDAOImpl extends AbstractSupperDao implements IAisBusDAO {
@SuppressWarnings("unchecked")
public List querySubscriber() {
GetSqlValue getSqlValue = (GetSqlValue)PubUtilServiceLocator.getInstance().getService("getSqlValue");
String sql = getSqlValue.getMap().get(SqlKeyUtils.QUERY_SUBSCRIBER);
List list = this.jdbctemplate.queryForList(sql);
for(Object obj : list){
Map map = (Map)obj;
Integer sbuscriberkey = Integer.valueOf(String.valueOf((map.get("sbuscriberkey"))));
String applytime = String.valueOf(map.get("applytime"));
String expiretime = String.valueOf(map.get("expiretime"));
System.out.println("用户键值:" + sbuscriberkey + ";应用时间:" + applytime +
";有限期:" + expiretime);
}
return list;
}
}