mybatis使将输入的java对象中的_如何使用MyBatis将对象的Java列表传递给Oracle存储过程？...

小编典典

我无法确定您是否已经这样做，但是您需要定义Oracle对象。

CREATE OR REPLACE TYPE SCHEMA."YOUR_OBJECT" AS OBJECT

(

field_one varchar2(50),

field_two varchar2(100)

);

/

CREATE OR REPLACE TYPE SCHEMA."YOUR_OBJECT_ARRAY" AS TABLE OF YOUR_OBJECT;

/

然后，您可以编写类型处理程序以将Java对象映射到Oracle对象。

import oracle.sql.ARRAY;

import oracle.sql.ArrayDescriptor;

import oracle.sql.STRUCT;

import oracle.sql.StructDescriptor;

....

public class YourTypeHandler implements TypeHandler

{

....

public void setParameter(PreparedStatement ps, int i, Object parameter, JdbcType jdbcType) throws SQLException

{

List objects = (List) parameter;

StructDescriptor structDescriptor = StructDescriptor.createDescriptor("YOUR_OBJECT", ps.getConnection());

STRUCT[] structs = new STRUCT[objects.size()];

for (int index = 0; index < objects.size(); index++)

{

YourObject pack = packs.get(index);

Object[] params = new Object[2];

params[0] = pack.getFieldOne();

params[1] = pack.getFieldTwo();

STRUCT struct = new STRUCT(structDescriptor, ps.getConnection(), params);

structs[index] = struct;

}

ArrayDescriptor desc = ArrayDescriptor.createDescriptor("YOUR_OBJECT_ARRAY", ps.getConnection());

ARRAY oracleArray = new ARRAY(desc, ps.getConnection(), structs);

ps.setArray(i, oracleArray);

}

}

然后调用该过程，

call your_proc

(

#{yourObjects, javaType=Object, jdbcType=ARRAY, jdbcTypeName=YOUR_OBJECT_ARRAY, mode=IN, typeHandler=YourObjectArrayTypeHandler}

)

2020-11-04