import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
String sql = " {CALL functionName1()}";
String driver = "org.postgresql.Driver";// database driver
String url = "jdbc:postgresql://localhost:5432/dbpp";// database
String user = "database_user"; // database name
String password = "database_user_pwd"; // database Password
Connection conn = null;
CallableStatement proc = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
proc = conn.prepareCall(sql);
proc.execute();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("操作失败", e);
} catch (ClassNotFoundException e) {
e.printStackTrace();
throw new RuntimeException("操作失败", e);
} finally {
try {
if (proc != null) {
proc.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("操作失败", e);
}
}
}