JAVA存储过程的调用

创建一个JDBC数据库连接工具类：

package com.test.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCUtils {

private static String driver = “oracle.jdbc.OracleDriver”;
private static String url = “jdbc:oracle:…”;//jdbc:odbc:mydata
private static String user = “数据库连接名称”;
private static String password = “数据库连接密码”;

//注册数据库驱动

//加载驱动

//DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());

static{
try {
Class.forName(driver);
} catch (Exception e) {
throw new ExceptionInInitializerError(e);
}
}

/**

• 获取数据库连接
• @return
  */
  public static Connection getConnection(){
  try {
  return DriverManager.getConnection(url,user,password);
  } catch (SQLException e) {
  e.printStackTrace();
  }
  return null;
  }

/**

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

if (st!=null) {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
st = null;
}
}

if (conn!=null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}
}
}

存储过程的调用：

package com.test.demo;

import java.sql.CallableStatement;
import java.sql.Connection;

import org.junit.Test;

import oracle.jdbc.internal.OracleTypes;
import oracle.jdbc.oracore.OracleType;

import com.hwb.db.JDBCUtils;

/**

• 调用存储过程 （查询）
• @author Administrator

*/

public void test(){

String sql = “{call selectUserById(?,?,?,?)}”;

Connection conn = null;
CallableStatement call = null;
try {
//获取数据库连接
conn = JDBCUtils.getConnection();
//通过连接创建出statement
call = conn.prepareCall(sql);
//对于in参数，赋值
call.setInt(1, 2); // (第几个问号,要赋的值)
//对out参数，声明
call.registerOutParameter(2, OracleTypes.VARCHAR); //(第几个问号，声明的类型)
call.registerOutParameter(3, OracleTypes.NUMBER);
call.registerOutParameter(4, OracleTypes.CHAR);

//执行调用
call.execute();

//ResultSet rs=c.executeQuery();

//while(rs.next()) {

//String cust=rs.getString(“id”);

//System.out.println (cust);

//}

//取出结果
String userName = call.getString(2);
int userAge = call.getInt(3);
String userSex = call.getString(4);

System.out.println(“用户姓名：”+userName+"\n\t年龄:"+userAge+"\n\t性别："+userSex);

} catch (Exception e) {
e.printStackTrace();
}finally{
//关闭连接，释放资源
JDBCUtils.release(conn, call, null);
}

}
}