java中执行存储过程

java中执行存储过程
package com.etong.util;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
public class T3 {

public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   
     // DriverManager.registerDriver(new net.sourceforge.jtds.jdbc.Driver());
     String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;Databasename=rhsys";     
     Connection conn = java.sql.DriverManager.getConnection(dbUrl,"sa","sa");
    
     String   sql="{call testProc(?)}";  
     CallableStatement  cs=conn.prepareCall(sql);     
    
     cs.setString(1,"1039");  
     //cs.registerOutParameter(2,Types.INTEGER);
     ResultSet rs = cs.executeQuery();
     int k= rs.getMetaData().getColumnCount();
//     System.out.println(cs.getObject(2));
//     ResultSet rs = (ResultSet)cs.getObject(2);
     while (rs.next()){
      for (int i=1;i<k+1;i++){
       System.out.print(rs.getObject(i)+"|");
      }
      System.out.println();
     
     }
     cs.close();  
     conn.close();
}
}

评论

3 楼 zzc_zj 2008-04-01  

恩
是比较easy,不过本人学这个没多长时间,感觉这个或许对刚入门的有帮助,所以就贴上来了...

2 楼 LinuxFans 2008-03-31  

有点easy啦，呵呵。

1 楼 LinuxFans 2008-03-31  

楼主没有具体分析啊.