How to use it in ibatis Pass the String parameter into in

Can't be quoted outside the house, -sql:select biz id, biz code, detail id, is cus url, biz client version, biz status, share url, share type

from tbl_bcs_share

where biz_code in ('one,two,three')

For example, parameterclass is a parameter of type string.

First, the input parameters are only arrays.

select *

from mailinfo with (nolock)where id in call.

Second, the input parameter has an array and other data.

select top(#count#

from mailinfo with (nolock)where id in

#arrvalue#

Invoke. testin ti = new testin();

strvalue;

Entity class: public class testinsetprivate string arrvalue;

Public String ArrValueSet The third type: the data after in is determined, and the string is passed.

select *

from mailinfo with (nolock)where id in

strvalue$)

param or'$param$'Can.. The input parameter is the hashmap, and this param is the key in the hashmap, you can set it.

The function in your system, this is the one used to save the student.

Write a new stored procedure.

1.It is to treat the incoming data as a string, such as field is passed in the id, then the SQL statement is generated like this, order by"id", of course, will report an error

2.$The incoming data is directly generated in the SQL, for example, the field is passed in with the ID, then the SQL statement is generated like this, Order by ID, which is right

This method is generally used to pass in database objects, such as table names.

This is typically used to insert an updated value or query a deleted where condition.

That is to say, output a parameter with a key of aaa, which can be a member aaa (attribute) or an item in the hashtable.

The aaa$ output parameter is a string that outputs 123 directly

The aaa output parameter is a parameter@aaa

Post an error message, ibatis can pass a SQL statement as a parameter.