Oracle12c支持JDK6和JDK7
oracle.jdbc,oracle.sql包
jdbc:oracle:thin:hr/hr@localhost:1521:oracle
默认一个Statement对象同时只能有一个ResultSet对象能被读取
因此要读取多个ResultSet要用多个Statement
ResultSet会被自动关闭,在那个Statement被关闭,被重新运行或多个结果集中查看下一个ResultSet时
SELECT * FROM Employees WHERE ID=xyz;//每次后面的字串改变时,都会重新编译一次Statement
// JDBC syntax CallableStatement cs1 = conn.prepareCall ( "{call proc (?,?)}" ) ; // stored proc CallableStatement cs2 = conn.prepareCall ( "{? = call func (?,?)}" ) ; // stored func // Oracle PL/SQL block syntax CallableStatement cs3 = conn.prepareCall ( "begin proc (?,?); end;" ) ; // stored proc CallableStatement cs4 = conn.prepareCall ( "begin ? := func(?,?); end;" ) ; // stored func
create or replace function foo (val1 char) return char as begin return val1 || 'suffix'; end;
CallableStatement cs = conn.prepareCall ("begin ? := foo(?); end;"); cs.registerOutParameter(1,Types.CHAR); cs.setString(2, "aa"); cs.executeUpdate(); String result = cs.getString(1);
CREATE OR REPLACE PROCEDURE INSERT_EMPLOYEE (p_first_name employees.first_ name%type, p_last_name employees.last_name%type, p_email employees.email%type, p_phone_number employees.phone_number%type, p_job_id employees.job_id%type, p_salary employees.salary%type ) AS BEGIN INSERT INTO Employees VALUES (EMPLOYEES_SEQ.nextval, p_first_name , p_last_name , p_email , p_phone_number, SYSDATE, p_job_id, p_salary,.30,100,80); END insert_employee;
public String addEmployeeSP(String first_name, String last_name, String email, String phone_number, String job_id, int salary) throws SQLException { try { getDBConnection(); sqlString = "begin hr.insert_employee(?,?,?,?,?,?); end;"; CallableStatement callstmt = conn.prepareCall(sqlString); 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("\nInserting with stored procedure: " + sqlString); callstmt.execute(); return "success"; } catch ( SQLException ex ) { System.out.println("Possible source of error: Make sure you have created the stored procedure"); logException( ex ); return "failure"; } }
相关推荐
Navicat_12.1.0.2.0版本_Oracle_OCI.dll 解决Navicat无法连接Oracle的问题
这个文档是我自己在本地虚拟机上面搭建的oracle12c数据库,完全可用的。OracleLinux5.6版本64bit 系统介质、Oracle12c_12.1.0.2.0数据库版本
oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
instantclient-basic-windows.x64-12.1.0.2.0
weblogic下转换oracle 的clob类型经常报转型错误,本例子通过反射解决weblogic.jdbc.wrapper.Clob_oracle_sql_CLOB转型成oracle.sql.CLOB问题
oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-basiclite-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-jdbc-...
oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
ojdbc6-12.1.0.2.0.jar,ojdbc6-12.1.0.2.0.jar,ojdbc6-12.1.0.2.0.jar驱动包文件
Oracle Database 12.1.0.1 JDBC Driver jar包及示例
Oracle公司(sun)64位版本java1.9下载软件提示下载最新版,不太好下载该版本,因此我下载后放到这里供各位下载。
oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
ojdbc6-12.1.0.2.jar
oracle-instantclient12.1-jdbc-12.1.0.2.0-1.x86_64.rpm
oracle_10g提示java.lang.Exception_Exception_in_sending_Request__null解决方案
ORACLE_error.rar ORACLE_error.rar ORACLE_error.rar ORACLE_error.rar
Toad_for_Oracle_2018_Edition_13.1.0.78_x86_Downloadly.ir.rar
下载到本地后,使用cmd安装,命令:mvn install:install-file -Dfile=你这个jar包的本地路径\ojdbc8-12.1.0.1.jar -DgroupId=com.oracle -DartifactId=ojdbc8 -Dversion=12.1.0.1 -Dpackaging=jar