public void doPreparedStatement(PreparedStatement prepStatement, Object param, int index) throws SQLException {
        if (param instanceof Integer) {
            int value = ((Integer) param).intValue();
            prepStatement.setInt(index, value);
        } else if (param instanceof String) {
            String s = (String) param;
            prepStatement.setString(index, s);
        } else if (param instanceof Double) {
            double d = ((Double) param).doubleValue();
            prepStatement.setDouble(index, d);
        } else if (param instanceof Float) {
            float f = ((Float) param).floatValue();
            prepStatement.setFloat(index, f);
        } else if (param instanceof Long) {
            long l = ((Long) param).longValue();
            prepStatement.setLong(index, l);
        } else if (param instanceof Boolean) {
            boolean b = ((Boolean) param).booleanValue();
            prepStatement.setBoolean(index, b);
        } else if (param instanceof Date) {
            Date d = (Date) param;
            prepStatement.setDate(index, d);
        }
    }