package test;
import java.sql.ResultSet;
import java.sql.SQLException;
public class OracleFunctionTest {
/**
* @param args
*/
public static void main(String[] args) {
String sql = "select mypackage1.fun1('MILLER') from dual"; //调用包体里面的函数fun1
ResultSet rs = SQLHelper.executeQuery(sql, null);
try {
if(rs.next()){
System.out.println(rs.getString(1));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
rs.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
java调用oracle中的函数
最新推荐文章于 2021-05-30 21:57:05 发布