jdbc sql ÎÊÌâ

ÎÒÓÐÒ»ÌõSQLÓï¾ä:
SQL code:
SELECT COUNT(*) from angle_dispatchemployee d INNER JOIN angle_comtract c ON d.deid=c.dispatchemployee_deid WHERE c.rstate=? AND d.state=? AND c.company_acid IN(?)

c.rstate=0(»ò1) //³£Á¿
d.state=0(»ò1) //³£Á¿
c.company_acid ʹÓ÷½·¨(getSpecialDispatch)µÄ²ÎÊý: int[] clientIDs.ÎÒÏëÖªµÀʹÓÃjava.sql.PreparedStatement.Ôõôдps.set(3,???) //¼ÙÉèint[] clientIDs=[1,2,3,4]

ÎÒʹÓõÄÊÇmssql2000Êý¾Ý¿â

---

int[] clientIDs=[1,2,3,4]  д³É String str=£¨1,2,3,4£©  ps.set(3,str)

---

ÄãÊÔ¹ýô£¿ÔÚjdbcת»»Ê±»á°ÑËüµ±³É×Ö·û´®.Ö´ÐеÄSQL¾Í³ÉÁËÕâÑù:... in('1,2.3.4')

---

ÒýÓÃ

int[] clientIDs=[1,2,3,4]  д³É String str=£¨1,2,3,4£©  ps.set(3,str)

ÄãµÄÒâ˼ÊÇps.setString(3,str)?

---

ÎÒ¾õµÃÓ¦¸ÃÊÇINT[]
ps.set(3,int[])

---

ÓÃobject[]×°

---

Ö±½ÓÆ´½Ósql¡£

---

ps.setArray  ÊÔÏÂ

---

ÒýÓÃ

ps.setArray  ÊÔÏÂ

ÎÒ¾õµÃÒ²Ó¦¸ÃÊÇTypes.ARRAY,¿É¿´Ò»ÏÂÇý¶¯µÄÊֲ᲻֧³ÖsetArray

---

c.company_acid = £¿  ÕâÀïÓà =

ps.set(3,clientIDs);  clientIDs Äã֮ǰµÄÊý×é

---

SQL code:
SELECT COUNT(*) from
a