自己写了一个通用查询方法

package com.softfz.Test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
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 java.util.Map;

public class Test1 {
	
	public static Connection getCon(){
		Connection con = null;
		try {
			String url = "jdbc:oracle:thin:@localhost:1521:oracle";
			String user = "ddd";
			String psd = "ddd";
			Class.forName("oracle.jdbc.driver.OracleDriver");			
			con = DriverManager.getConnection(url,user,psd);
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println("con:"+con);
		return con;
	}
	
	public List select(List<Map> slist){		
		List list = new ArrayList();
		Connection conn = this.getCon();
		PreparedStatement psmt = null;
		ResultSetMetaData rsmd = null;
		int columnCount = -1;
		ResultSet rs = null;
		
		try {
			for(Object oj :slist){
				Map smap = (Map)oj;
				String sql = (String)smap.get("sql");
				psmt= conn.prepareStatement(sql);
				List mlist = (List)smap.get("list");
				for(int i =0;i<mlist.size();i++){
					psmt.setObject(i+1, mlist.get(i));						
				}
				 rs = psmt.executeQuery();
					
				 while(rs.next()){
					 Map map = new HashMap();
					 rsmd = rs.getMetaData();				
					 columnCount = rsmd.getColumnCount();
					 for(int j=1;j<columnCount;j++){						
						 map.put(rsmd.getColumnName(j), rs.getObject(rsmd.getColumnName(j)));
					 }				
					 list.add(map);				 
				 }	
			} 
					 
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub		
		Test1 test = new Test1();
		Map mmap = new HashMap();
		List mlist = new ArrayList();
		List seList = new ArrayList();
		mlist.add("888888");
		mmap.put("sql", "select * from sys_user where v_password=?");
		mmap.put("list", mlist);
		seList.add(mmap);
		
		for(Object oc:test.select(seList)){
			
			System.out.println(oc);
		}
		
	}

}