java 访问oracle存储过程

如何在JAVA中调用oracle的存储过程呢，下面是笔者给出的一个例子，大家有兴趣的话可以参考以下，如果程序中有什么不足的地方，恳请大家能够指点，谢谢：

/***//**
*Copyright2008,CSSWEBallrightsreserved.
*@authorhujun
*@dateMar13,2008
*@fileDataHandler.java
*@version1.1
**/

packagecss.web.orc.jdbc;

importjava.sql.CallableStatement;
importjava.sql.Connection;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;

importoracle.jdbc.OracleTypes;
importoracle.jdbc.pool.OracleDataSource;

publicclassDataHandler...{
privateStringjdbcUrl="jdbc:oracle:thin:@localhost";
privateStringuserid="hr";
privateStringpassword="123456";
privateConnectionconn;

privateStatementstmt;
privateResultSetrset;
privateStringquery;
privateStringsqlStr;

publicDataHandler()...{
}

/***//**
*getconnectiontooracledatabase
*@throwsSQLException
*/
publicvoidgetDBConnection()throwsSQLException...{
OracleDataSourceds=newOracleDataSource();
ds.setURL(jdbcUrl);
conn=ds.getConnection(userid,password);
}

/***//**
*select
*@returnrset
*@throwsSQLException
*/
publicResultSetgetAllEmployees()throwsSQLException...{
getDBConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
query="SELECT*FROMEmployeesORDERBYemployee_id";
System.out.println(" Executingquery:"+query);
rset=stmt.executeQuery(query);
returnrset;
}

/***//**
*select
*@paramname
*@returnrset
*@throwsSQLException
*/
publicResultSetgetEmployeesByName(Stringname)throwsSQLException...{
name=name.toUpperCase();
getDBConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
query="SELECT*FROMEmployeesWHEREUPPER(first_name)LIKE'%"+name+"%'"+
"ORUPPER(last_name)LIKE'%"+name+"%'ORDERBYemployee_id";
System.out.println(" Executingquery:"+query);
rset=stmt.executeQuery(query);
returnrset;
}

/***//**
*askprocedure
*@return
*@throwsSQLException
*/
publicResultSetgetJobs()throwsSQLException...{
try...{
getDBConnection();
Stringjobquery="begin?:=get_jobs;end;";
CallableStatementcallStmt=conn.prepareCall(jobquery);
callStmt.registerOutParameter(1,OracleTypes.CURSOR);
callStmt.execute();
rset=(ResultSet)callStmt.getObject(1);
}catch(SQLExceptionex)...{
ex.printStackTrace();
}
returnrset;
}

/***//**
*insert
*@paramfirst_name
*@paramlast_name
*@paramemail
*@paramphone_number
*@paramjob_id
*@paramsalary
*@returnboolean
*@throwsSQLException
*/
publicStringaddEmployeeSP(Stringfirst_name,Stringlast_name,
Stringemail,Stringphone_number,Stringjob_id,
intsalary)throwsSQLException...{
try
...{
getDBConnection();
sqlStr="begininsert_employee(?,?,?,?,?,?);end;";
CallableStatementcallstmt=conn.prepareCall(sqlStr);
callstmt.setString(1,first_name);
callstmt.setString(2,last_name);
callstmt.setString(3,email);
callstmt.setString(4,phone_number);
callstmt.setString(5,job_id);
callstmt.setInt(6,salary);
System.out.println(" Insertingwithstoredprocedure:"+sqlStr);
callstmt.execute();
return"success";
}
catch(SQLExceptionex)...{
ex.printStackTrace();
System.out.println("Possiblesourceoferror:Makesureyouhavecreatedthestoredprocedure");
return"failure";
}
}
}

下面是程序中使用的存储过程：

PROCEDURE"INSERT_EMPLOYEE"(p_first_nameemployees.first_name%type,
p_last_nameemployees.last_name%type,
p_emailemployees.email%type,
p_phone_numberemployees.phone_number%type,
p_job_idemployees.job_id%type,
p_salaryemployees.salary%type
)
AS
BEGIN
INSERTINTOEmployeesVALUES(EMPLOYEES_SEQ.nextval,p_first_name,
p_last_name,p_email,p_phone_number,SYSDATE,p_job_id,
p_salary,.30,100,80);
ENDinsert_employee;