JAVA调用数据库存储过程

 
 

  
  import
  
   java.sql.Connection;

  
  import
  
   java.sql.DriverManager;

  
  import
  
   java.sql.ResultSet;

  
  import
  
   java.sql.SQLException;

  
  import
  
   java.sql.Statement;


  
  /**
  
  
 * 连接工具类
 * 
 * ConnUtils类声明为final类说明此类不可以被继承
 * 
 * 
  
  @author
  
   jiqinlin
 * 
 
  
  */
  
  

  
  public
  
   
  
  final
  
   
  
  class
  
   ConnUtils {
    
  
  private
  
   
  
  static
  
   String url 
  
  =
  
   
  
  "
  
  jdbc:oracle:thin:@localhost:1521:orcl
  
  "
  
  ;
    
  
  private
  
   
  
  static
  
   String user 
  
  =
  
   
  
  "
  
  test
  
  "
  
  ;
    
  
  private
  
   
  
  static
  
   String password 
  
  =
  
   
  
  "
  
  test
  
  "
  
  ;

    
  
  /**
  
  
     * 说明要访问此类只能通过static或单例模式
     
  
  */
  
  
    
  
  private
  
   ConnUtils() {
    }

    
  
  //
  
   注册驱动 (只做一次)
  
  

  
      
  
  static
  
   {
        
  
  try
  
   {
            Class.forName(
  
  "
  
  oracle.jdbc.driver.OracleDriver
  
  "
  
  );
        } 
  
  catch
  
   (ClassNotFoundException e) {
            
  
  throw
  
   
  
  new
  
   ExceptionInInitializerError(e);
        }
    }

    
  
  /**
  
  
     * 获取Connection对象
     * 
     * 
  
  @return
  
  
     * 
  
  @throws
  
   SQLException
     
  
  */
  
  
    
  
  public
  
   
  
  static
  
   Connection getConnection() 
  
  throws
  
   SQLException {
        
  
  return
  
   DriverManager.getConnection(url, user, password);
    }

    
  
  /**
  
  
     * 释放资源
     * 
     * 
  
  @param
  
   rs
     * 
  
  @param
  
   st
     * 
  
  @param
  
   conn
     
  
  */
  
  
    
  
  public
  
   
  
  static
  
   
  
  void
  
   free(ResultSet rs, Statement st, Connection conn) {
        
  
  try
  
   {
            
  
  if
  
   (rs 
  
  !=
  
   
  
  null
  
  )
                rs.close();
        } 
  
  catch
  
   (SQLException e) {
            e.printStackTrace();
        } 
  
  finally
  
   {
            
  
  try
  
   {
                
  
  if
  
   (st 
  
  !=
  
   
  
  null
  
  )
                    st.close();
            } 
  
  catch
  
   (SQLException e) {
                e.printStackTrace();
            } 
  
  finally
  
   {
                
  
  if
  
   (conn 
  
  !=
  
   
  
  null
  
  )
                    
  
  try
  
   {
                        conn.close();
                    } 
  
  catch
  
   (SQLException e) {
                        e.printStackTrace();
                    }
            }
        }
    }
}
 
 

调用：

Connection conn = null;
Connection conn = null;
CallableStatement statement = null;
String sql = "{call p_ks_ds_7(?,?,?,?,?,?,?,?,?)}";
try {
conn = ConnUtils.getConnection();
statement = conn.prepareCall(sql);

statement.registerOutParameter(5, Types.VARCHAR);
statement.registerOutParameter(6, Types.VARCHAR);
statement.registerOutParameter(7, Types.VARCHAR);
statement.registerOutParameter(8, Types.VARCHAR);
statement.registerOutParameter(9, Types.VARCHAR);

statement.setString(1, SWRYDM);
statement.setDate(2, QSSJ);
statement.setDate(3, JSSJ);
statement.setString(4, DS_DJXH);

statement.executeUpdate();

for(int i=5;i<=9;i++) {
System.out.println(statement.getString(i) + "=====");
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
ConnUtils.free(null, statement, conn);
}