java调用存储过程返回结果集,返回字符串

package com.utour.util;

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

import com.sun.xml.internal.bind.v2.runtime.unmarshaller.XsiNilLoader.Array;

/**

* java调用存储过程

*

* @author Administrator

*

*/

public class JavaCallPro {

/**

* @param args

* @throws Exception

*/

public static void main(String[] args) throws Exception {

// TODO Auto-generated method stub

String s = testOutParams();

System.out.println(s);

//

// List list = test();

//

// for(int i=0;i

// String[] dd = list.get(i);

// String aa1 = dd[0];

// String aa2 = dd[1];

// String aa3 = dd[2];

//

//

System.out.println("aa1====="+aa1+"-----aa2====="+aa2+"----aa3====="+aa3); //

// }

}

private static List test() throws Exception {

// TODO Auto-generated method stub

List list = new ArrayList();

Connection ct = null;

String dbURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ADMIN";

String user = "admin";

String pwd = "Admin";

String drv = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

Class.forName(drv);

ct = DriverManager.getConnection(dbURL, user, pwd);

CallableStatement c = ct.prepareCall("{call UTRDW.DBO.SP_TEST_SELECTTABLE(?,?)}");

c.setString(1, "U1003");

c.setString(2, "20140521");

ResultSet rs = c.executeQuery();

ResultSetMetaData rm = rs.getMetaData();

int columnNums = rm.getColumnCount();

String[] t = null;

while (rs.next()) {

list.add(t = new String[columnNums]);

for (int i = 1; i <= columnNums; i++) {

t[i - 1] = rs.getString(i);

}

}

ct.close();

return list;

}

private static String testOutParams() throws Exception {

// TODO Auto-generated method stub

Connection ct = null;

String dbURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ADMIN";

String user = "admin";

String pwd = "Admin";

String drv = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

Class.forName(drv);

ct = DriverManager.getConnection(dbURL, user, pwd);

CallableStatement c = ct.prepareCall("{call ADMIN.DBO.test_pro(?,?)}");

c.registerOutParameter(1, java.sql.Types.VARCHAR);

c.setString(2, "2001");

c.execute();

String sss = c.getString(1);

ct.close();

return sss;

}

}