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

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 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

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

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);

}

}}