daodb7.java

一套DB2 7到8版本的程序。内附创建ZIP的JAVA类

package com.highsoft.dao;

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

import com.highsoft.database.DB7Manager;

public class DaoDB7 {
	/**
	 * 
	 * @param sql
	 * @return 返回包含hashmap的list
	 */
	public  List select(String sql){
		DB7Manager dbm=new DB7Manager();
		List<HashMap> l=new ArrayList<HashMap>();
		ResultSet rs=dbm.queryDB(sql);
		List<String> list=new ArrayList<String>();
		try {
			ResultSetMetaData rsm=rs.getMetaData();
			for (int i = 1; i <= rsm.getColumnCount(); i++) {
				list.add(rsm.getColumnName(i));
			}
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			System.out.println(e1.getMessage());
		}
		try {
			while(rs.next()){
				HashMap<String,String> hash=new HashMap<String,String>();
				for (String map : list) {
					hash.put(map,rs.getObject(map)+"");
				}
				l.add(hash);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println(e.getMessage());
		}finally{
			dbm.close();
		}
		return l;
	}
}