Shulou(Shulou.com)06/01 Report--

Configuration file (Oracle):

Insert into ce_tempPhone_info (phone)

(

Select # {item,jdbcType=VARCHAR} from dual

)

Insert intoce_tempPhone_info (phone) (select xxx from dual union select yyy from dual … .)

Parsing:

ParameterType:

The type of parameter can be java.util.HashMap or java.util.List

If the type passed in is List, you can use both, and the List will be encapsulated as a Map

Collection:

If you pass in a list collection, write list here

Array type, where array

Item:

Variables in the loop

If list or array is passed in, you can use # {item,jdbcType=VARCHAR} directly when using it.

If generics are objects in list, you must use a similar form # {item.phone,jdbcType=VARCHAR}

Index:

Index

Open:

What does the query start with?

For example: open= "(", the foreach will start with "("

Close:

What symbol does it end with?

Separator:

Connectors, connectors for each loop

Java class:

Ce_sample_info info = new Ce_sample_info ()

Info.setProject_id (project_id)

For (int iTuno Bandi)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.