java.sql.Connection connection = null;
CallableStatement proc = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:SID";
connection = DriverManager.getConnection(url, username, password);
proc = connection.prepareCall("{ call sp_check_bank_by_bankid(?,?,?)} ");
proc.setString(1, bankAcct);
proc.setString(2, bankId);
proc.registerOutParameter(3,java.sql.Types.CHAR);
proc.execute(); String retStr=proc.getString(3); }
catch (Exception e1) {
e1.printStackTrace();
}
finally{
try {
if(proc!=null)
proc.close();
if(connection!=null)
connection.close();
}
catch (SQLException e2) {
e2.printStackTrace();
}
}
CallableStatement proc = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:SID";
connection = DriverManager.getConnection(url, username, password);
proc = connection.prepareCall("{ call sp_check_bank_by_bankid(?,?,?)} ");
proc.setString(1, bankAcct);
proc.setString(2, bankId);
proc.registerOutParameter(3,java.sql.Types.CHAR);
proc.execute(); String retStr=proc.getString(3); }
catch (Exception e1) {
e1.printStackTrace();
}
finally{
try {
if(proc!=null)
proc.close();
if(connection!=null)
connection.close();
}
catch (SQLException e2) {
e2.printStackTrace();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货