Class:
package com.jdsy.crscal.oper.service;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCallback;
import org.springframework.jdbc.core.RowMapper;
public class OperTicketService {
public List getFileName(){
List list = new ArrayList();
String sql = "select filename, " +
"operateman," +
"operatetime, " +
"count(0) total," +
"sum(decode(sendflag, 1, 1, 0)) cls," +
"sum(decode(sendflag, 1, 0, 1)) wcls " +
"from oper_ticket where sendflag = 0 group by filename, operateman, operatetime";
list = (List) getJdbcTemplate().query(sql, new RowMapper(){
public Object mapRow(ResultSet rs, int index) throws SQLException {
// TODO Auto-generated method stub
Map map = new HashMap();
map.put("fileName", rs.getString(1));
map.put("operateMan", rs.getString(2));
map.put("operateTime", rs.getString(3));
map.put("total", rs.getString(4));
map.put("", rs.getString(3));
return map;
}
});
return list;
}
}
Spring配置文件:
<bean id="operTicketService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="target">
<bean class="com.jdsy.crscal.oper.service.OperTicketService">
<property name="operTicketDAO">
<ref bean="OperTicketDAO"/>
</property>
<property name="jdbcTemplate">
<ref bean="jdbcTemplate"/>
</property>
</bean>
</property>
<property name="transactionAttributes">
<props>
<prop key="create*">PROPAGATION_REQUIRED</prop>
<prop key="get*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>