当前位置:文档之家› java调用存储过程返回结果集,返回字符串

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

importjava.util.ArrayList;
importjava.util.Arrays;
importjava.util.List;
import com.sun.xml.internal.bind.v2.runtime.unmarshaller.XsiNilLoader.Array;
/**
* java调用存储过程
*
* @author Administrator
*
*/
public classJavaCallPro{
/**
* @paramargs
* @throws Exception
*/
public static void main(String[]args) throws Exception {
// TODO Auto-generated method stub
ResultSetMetaDatarm=rs.getMetaData();
intcolumnNums=rm.getColumnCount();
String[] t = null;
while (rs.next()) {
list.add(t = new String[columnNums]);
for (inti= 1;i<=columnNums;i++) {
packagecom.utour.util;
importjava.sql.CallableStatement;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.ResultSetMetaData;
t[i- 1] =rs.getString(i);
}
}
ct.close();
return list;
}
private static StringtestOutParams() throws Exception {
// TODO Auto-generated method stub
Connection ct = null;
// TODO Auto-generated method stub
List<String[]> list = newArrayList<String[]>();
Connection ct = null;
StringdbURL= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ADMIN";
c.setString(2, "2001");
c.execute();
Stringsss=c.getString(1);
ct.close();
returnsss;
}
}
String s =testOutParams();
System.out.p<String[]> list = test();
//
//for(inti=0;i<list.size();i++){
//String[]dd=list.get(i);
//String aa1 =dd[0];
Class.forName(drv);
ct =DriverManager.getConnection(dbURL, user,pwd);
CallableStatementc =ct.prepareCall("{callADMIN.DBO.test_pro(?,?)}");
c.registerOutParameter(1,java.sql.Types.VARCHAR);
StringdbURL= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ADMIN";
String user = "admin";
Stringpwd= "Admin";
Stringdrv= "com.microsoft.sqlserver.jdbc.SQLServerDriver";
CallableStatementc =ct.prepareCall("{call UTRDW.DBO.SP_TEST_SELECTTABLE(?,?)}");
c.setString(1, "U1003");
c.setString(2, "20140521");
ResultSetrs=c.executeQuery();
String user = "admin";
Stringpwd= "Admin";
Stringdrv= "com.microsoft.sqlserver.jdbc.SQLServerDriver";
Class.forName(drv);
ct =DriverManager.getConnection(dbURL, user,pwd);
//String aa2 =dd[1];
//String aa3 =dd[2];
//
//System.out.println("aa1====="+aa1+"-----aa2====="+aa2+"----aa3====="+aa3);
//
//}
}
private static List<String[]> test() throws Exception {
相关主题