provnamedaoimpl.java

来自「自动导入文件到数据库,用于无法实时入库,需要在特定时间大批量入库的程序」· Java 代码 · 共 37 行

package com.onet.autobill.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

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

import com.onet.autobill.dao.ProvNameDao;

public class ProvNameDaoImpl extends JdbcDaoSupport implements ProvNameDao {

	@Override
	public Map<String, String> getProvNameMap() {
		
			final Map<String,String> mobileSectionMap = new HashMap<String,String>();

			String sql = "select ProvinceId,ProvinceNm from ProvinceSection";
			
			try {
				getJdbcTemplate().query(sql, new RowCallbackHandler() {
					public void processRow(ResultSet rs) throws SQLException {
						do {
							mobileSectionMap.put(rs.getString("ProvinceId"), rs.getString("ProvinceNm"));
						} while (rs.next());
					}
				});
			} catch (Exception e) {
				logger.error("", e);
			}
			return mobileSectionMap;
	}

}