我有一条SQL语句:
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数据库
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数据库
ps.set(3,int[])
angle_dispatchemployee d INNER JOIN
angle_comtract c ON
d.deid=c.dispatchemployee_deid WHERE
c.rstate=? AND d.state=? AND c.company_acid =?这样,用ps.setArray?还是ps.setString?
SELECT COUNT(*) FROM angle_dispatchemployee d INNER JOIN angle_comtract c ON d.deid=c.dispatchemployee_deid WHERE c.rstate=0 AND d.state=0 AND c.company_acid IN(1,2,3,4)这样是没问题的:找出公司ID为1,2,3,4的所有在职的员工