package com.yanshu.util;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
public class ProcMap {
public static Map<String , Object> findProcJM(String procName , String[] args) throws SQLException
{
Connection conn=null;
CallableStatement call=null;
ResultSet rs = null;
//定义Map集合存储存储过程的数据
Map<String, Object> map=new HashMap<String ,Object>();
conn=JdbcUtil.getConn();
//预编译存储过程
String newprocName = ConnSql.storageNameHandle(procName, args.length);
//创建一个预处理存储对象
call=conn.prepareCall("{call "+newprocName+"}");
//参数的占位符
for(int i=0;i<args.length;i++)
{
System.out.println("第"+i+"个,args[i]="+args[i]);
call.setString(i+1, args[i]);
}
//执行sp
rs=call.executeQuery();
//从元数据中获得列数 ResultSetMetaData rsmd
ResultSetMetaData rsmd = rs.getMetaData();
//遍历结果集
while(rs.next())
{
for(int i=1;i<=rsmd.getColumnCount();i++)
{
map.put(rsmd.getColumnName(i) ,rs.getString(i));
}
}
return map;
}
public static void main(String[] args) throws SQLException {
String[] params1 = new String[]{"743524358","22349808348","20170101","20170107","2" };
findProcJM("op_auction_buy_information", params1);
}
}
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
public class ProcMap {
public static Map<String , Object> findProcJM(String procName , String[] args) throws SQLException
{
Connection conn=null;
CallableStatement call=null;
ResultSet rs = null;
//定义Map集合存储存储过程的数据
Map<String, Object> map=new HashMap<String ,Object>();
conn=JdbcUtil.getConn();
//预编译存储过程
String newprocName = ConnSql.storageNameHandle(procName, args.length);
//创建一个预处理存储对象
call=conn.prepareCall("{call "+newprocName+"}");
//参数的占位符
for(int i=0;i<args.length;i++)
{
System.out.println("第"+i+"个,args[i]="+args[i]);
call.setString(i+1, args[i]);
}
//执行sp
rs=call.executeQuery();
//从元数据中获得列数 ResultSetMetaData rsmd
ResultSetMetaData rsmd = rs.getMetaData();
//遍历结果集
while(rs.next())
{
for(int i=1;i<=rsmd.getColumnCount();i++)
{
map.put(rsmd.getColumnName(i) ,rs.getString(i));
}
}
return map;
}
public static void main(String[] args) throws SQLException {
String[] params1 = new String[]{"743524358","22349808348","20170101","20170107","2" };
findProcJM("op_auction_buy_information", params1);
}
}