java - PreparedStatement 类型中的方法 setArray(int, Array) 不适用于参数 (String, String[])

Question

Guys i am new to java i am getting this error please help me out what i am trying to do is get result in array

        public List<DeviceDetail> list(String[] deviceIds) throws Exception {
        List<DeviceDetail> appList = new ArrayList<>(); 
        Connection conn =null;
        CallableStatement statement = conn.prepareCall("{call 
        Application_List(?)}");
        statement.setArray("Deviceid",deviceIds);
        boolean isResultSet = statement.execute();
        if (isResultSet) {
            try (ResultSet rs = statement.getResultSet()) {
                    while (rs.next()) {
                        DeviceDetail dd = new DeviceDetail();
                        dd.setDeviceId(rs.getString("DeviceId"));
                        dd.setToken(rs.getString("Token"));
                        dd.setDeviceType(rs.getString("DeviceType"));
                        dd.setCreatedBy(rs.getString("CreatedBy"));
                        dd.setCreatedTime(rs.getTimestamp("CreatedTime"));
                        dd.setStatus(rs.getBoolean("Status"));
                        appList.add(dd);
                    }
                }
            }
        return appList;
}

Answer 1

试试这个

statement.setArray(1, array);

您需要将通配符位置指定为Integer而不是String。

编辑

使用以下方法创建java.sql.Array。

Array array = conn.createArrayOf("VARCHAR", deviceIds);