其他
GBase JDBC应用示例
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区使用JDBC调用存储过程
该用例分为4部分，分别实现了如下功能：
callProcedureWhitNoParamByCallableStatement 调用没有参数的存储过程；
callProcedureWhitINParamByCallableStatement 调用只有IN参数的存储过程；
callProcedureWhitOUTParamByCallableStatement 调用只有OUT参数的存储过程；
callProcedureWhitInOutParamByCallableStatement 调用有IN、OUT参数的存储过程。
示例如下：
package com.gbase.jdbc.simple;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
public class CallProcByJdbc {
private static final String URL =
"jdbc:gbase://192.168.XXX.XX:5258/test?user=sysdba&password=";
/**
* @param args
*/
public static void main(String[] args) {
//创建存储过程
prepareProc();
CallProcByJdbc callProcByJdbc = new CallProcByJdbc();
//调用没有参数的存储过程
callProcByJdbc.callProcedureWhitNoParamByCallableStatement();
//调用只有 IN 参数的存储过程
callProcByJdbc.callProcedureWhitINParamByCallableStatement();
//调用只有 OUT 参数的存储过程
callProcByJdbc.callProcedureWhitOUTParamByCallableStatement();
//调用有 IN/OUT 参数的存储过程
callProcByJdbc.callProcedureWhitInOutParamByCallableStatement();
}
/**
* 通过 CallableStatement 调用没有参数的
* 存储过程。
*/
public void callProcedureWhitNoParamByCallableStatement() {
Connection conn = null;
CallableStatement cstm = null;
ResultSet rs = null;
try {
Class.forName("com.gbase.jdbc.Driver");
conn = DriverManager.getConnection(URL);
cstm = conn.prepareCall("call procNoParam()");
rs = cstm.executeQuery();
rs.next();
System.out.println(rs.getString(1));
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace(); } finally {
try {
rs.close();
}catch (NullPointerException e) {
} catch (Exception e) {
cstm = null;
}
try {
cstm.close();
} catch (NullPointerException e) {
} catch (Exception e) {
cstm = null;
}
try {
conn.close();
} catch (NullPointerException e) {
} catch (Exception e) {
conn = null;
}}}
/**
* 通过 CallableStatement 调用 IN 参数的
* 存储过程。
*/
public void callProcedureWhitINParamByCallableStatement() {
Connection conn = null;
CallableStatement cstm = null;
ResultSet rs = null;
try {
Class.forName("com.gbase.jdbc.Driver");
conn = DriverManager.getConnection(URL);
cstm = conn.prepareCall("{call procInParam(?)}");
cstm.setString(1, "InParam Call Works!");
rs = cstm.executeQuery();
rs.next();
System.out.println(rs.getString(1));
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
}catch (NullPointerException e) {
} catch (Exception e) {
cstm = null;
}
try {
cstm.close();
} catch (NullPointerException e) {
} catch (Exception e) {
cstm = null;
}
try {
conn.close();
} catch (NullPointerException e) {
} catch (Exception e) {
conn = null;
}}}
/**
* 通过 CallableStatement 调用 OUT 参数的
* 存储过程。
*/
public void callProcedureWhitOUTParamByCallableStatement() {
Connection conn = null;
CallableStatement cstm = null;
try {
Class.forName("com.gbase.jdbc.Driver");
conn = DriverManager.getConnection(URL);
cstm = conn.prepareCall("call procOutParam(?)");
cstm.setString(1, "@outParam");
cstm.registerOutParameter(1, Types.VARCHAR);
cstm.execute();
System.out.println(cstm.getString(1));
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
cstm.close();
} catch (NullPointerException e) {
} catch (Exception e) {
cstm = null;
}
try {
conn.close();
} catch (NullPointerException e) {
} catch (Exception e) {
conn = null;
}}}
/**
* 通过 CallableStatement 调用 IN/OUT 参数的
* 存储过程。
*/
public void callProcedureWhitInOutParamByCallableStatement() {
Connection conn = null;
CallableStatement cstm = null;
try {
Class.forName("com.gbase.jdbc.Driver");
conn = DriverManager.getConnection(URL);
cstm = conn.prepareCall("{call procInOutParam(?,?)}");
cstm.setString(1, "aaaaa");
cstm.setString(2, "@outParam");
cstm.registerOutParameter(2, Types.VARCHAR);
cstm.execute();
System.out.println(cstm.getString(2));
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
cstm.close();
} catch (NullPointerException e) {
} catch (Exception e) {
cstm = null;
}
try {
conn.close();
} catch (NullPointerException e) {
} catch (Exception e) {
conn = null;
}}}
/**
* 创建 4 个存储过程；
* 1、没有参数
* 2、只有 IN 参数
* 3、只有 OUT 参数
* 4、有 IN、OUT 参数
*/
private static void prepareProc() {
Connection conn = null;
Statement stm = null;
try {
Class.forName("com.gbase.jdbc.Driver");
conn = DriverManager.getConnection(URL);
stm = conn.createStatement();
stm.executeUpdate("DROP PROCEDURE IF EXISTS `test`.`procNoParam`");
stm.executeUpdate("DROP PROCEDURE IF EXISTS `test`.`procInParam`");
stm.executeUpdate("DROP PROCEDURE IF EXISTS `test`.`procOutParam`");
stm.executeUpdate("DROP PROCEDURE IF EXISTS `test`.`procInOutParam`");
stm.executeUpdate("CREATE PROCEDURE `test`.`procNoParam` () begin select 'procNoParamTest works'; end");
stm.executeUpdate("CREATE PROCEDURE `test`.`procInParam` (IN inParam Varchar(100)) begin select inParam;
end");
stm.executeUpdate("CREATE PROCEDURE `test`.`procOutParam` (OUT outParam Varchar(100)) begin SET outParam = 'outParamTest works'; end");
stm.executeUpdate("CREATE PROCEDURE `test`.`procInOutParam` (IN inParam Varchar(100), OUT outParam Varchar(200)) begin set outParam = CONCAT(\'InOutParam \',inParam,\ '
works!\ '); end");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
stm.close();
} catch (NullPointerException e) {
} catch (Exception e) {
stm = null;
}
try {
conn.close();
} catch (NullPointerException e) {
} catch (Exception e) {
conn = null;
}}}}
相关推荐
jdbc链接gbase数据库的驱动包
在上述示例中，我们没有显示关闭连接的代码，实际应用中应当添加适当的异常处理和关闭逻辑。
GBase8a数据库安装包,文档，驱动包.rar
**GBase JDBC驱动**：“gbase-connector-java-8.3.81.53-build52.8-bin”是GBase 8a的Java数据库连接器，它允许Java应用程序通过JDBC
gbase-jdbc驱动gbase-connector-8.3.81.51和infomix驱动ifxjdbc.jar
`gbase-connector` 是一个Java实现的JDBC驱动程序，它使得Java应用程序能够通过标准的JDBC API连接到GBase数据库，执行SQL查询，进行数据插入、更新和删除等操作。
gbase jdbc 驱动下载 gbase-connector-java
GBase JDBC驱动是连接GBase数据库的重要工具，它允许Java应用程序通过JDBC接口与GBase数据库进行交互。
南大通用Gbase-jdbc-drvier驱动
**南大通用Gbase-jdbc-driver驱动详解**Gbase-jdbc-driver是由南大通用数据技术股份有限公司开发的一款数据库连接驱动，主要用于Java应用程序与Gbase 8系列数据库之间的通信
