settleprojectcmdinfodaoimpl.java

自动导入文件到数据库,用于那些无法实时入库,定点时间入库的需求

package com.onet.autobill.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.onet.autobill.dao.SettleProjectCmdInfoDao;
import com.onet.autobill.model.SettleProjectCmdInfo;

public class SettleProjectCmdInfoDaoImpl extends JdbcDaoSupport implements
		SettleProjectCmdInfoDao {

	@Override
	public List<SettleProjectCmdInfo> getSettleProjectCmdInfo() {
		final List<SettleProjectCmdInfo> settleProjectCmdInfoList = new ArrayList<SettleProjectCmdInfo>();

		String sql = "SELECT cmdId,projId,gatewayId,serviceId,routeCmdId,cmdContent,destermNum,divideMode,settleRate,status,memo FROM ONET_TSettleProjectCmdInfo where status in(0,2)";
		try {
			getJdbcTemplate().query(sql, new RowCallbackHandler() {
				public void processRow(ResultSet rs) throws SQLException {
					do {
						SettleProjectCmdInfo settleProjectCmdInfo = new SettleProjectCmdInfo();
						settleProjectCmdInfo.setCmdId(rs.getInt("cmdId"));
						settleProjectCmdInfo.setProjId(rs.getInt("projId"));
						settleProjectCmdInfo.setGatewayId(rs
								.getInt("gatewayId"));
						settleProjectCmdInfo.setServiceId(rs
								.getString("serviceId"));
						settleProjectCmdInfo.setRouteCmdId(rs
								.getInt("routeCmdId"));
						settleProjectCmdInfo.setCmdContent(rs
								.getString("cmdContent"));
						settleProjectCmdInfo.setDestermNum(rs
								.getString("destermNum"));
						settleProjectCmdInfo.setDivideMode(rs
								.getInt("divideMode"));
						settleProjectCmdInfo.setSettleRate(rs
								.getFloat("settleRate"));
						settleProjectCmdInfo.setStatus(rs.getInt("status"));
						settleProjectCmdInfo.setMemo(rs.getString("memo"));
						settleProjectCmdInfoList.add(settleProjectCmdInfo);
					} while (rs.next());
				}
			});
		} catch (Exception e) {
			logger.error("", e);
		}
		return settleProjectCmdInfoList;
	}

}