如何在Android应用中使用Oracle存储过程

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Types;

public class OracleProcedureExample {
    public static void main(String[] args) {
        try {
            // 配置数据库连接
            String url = "jdbc:oracle:thin:@localhost:1521:xe";
            String username = "your_username";
            String password = "your_password";
            
            // 建立数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);
            
            // 调用存储过程
            String sql = "{call your_procedure_name(?, ?)}";
            CallableStatement stmt = conn.prepareCall(sql);
            
            // 设置输入参数
            stmt.setString(1, "input_value");
            
            // 注册输出参数
            stmt.registerOutParameter(2, Types.VARCHAR);
            
            // 执行存储过程
            stmt.execute();
            
            // 获取输出参数的值
            String outputValue = stmt.getString(2);
            
            // 关闭连接
            stmt.close();
            conn.close();
            
            // 输出结果
            System.out.println("Output value: " + outputValue);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}