Method insert

CodenameOne/src/com/codename1/properties/SQLMap.java:329–365

(PropertyBusinessObject cmp)

    ///
    /// - `cmp`: the business component
    public void insert(PropertyBusinessObject cmp) throws IOException {
        String tableName = getTableName(cmp);
        StringBuilder createStatement = new StringBuilder("INSERT INTO ");
        createStatement.append(tableName);
        createStatement.append(" (");

        int count = 0;
        ArrayList<Object> values = new ArrayList<Object>();
        for (PropertyBase p : cmp.getPropertyIndex()) {
            SqlType tp = getSqlType(p);
            if (tp == SqlType.SQL_EXCLUDE) {
                continue;
            }
            if (count > 0) {
                createStatement.append(",");
            }
            if (p instanceof Property) {
                values.add(tp.asUpdateInsertValue(p.get(), (Property) p));
            } else {
                // TODO
                values.add(null);
            }
            count++;
            String columnName = getColumnName(p);
            createStatement.append(columnName);
        }

        createStatement.append(") VALUES (?");

        for (int iter = 1; iter < values.size(); iter++) {
            createStatement.append(",?");
        }

        createStatement.append(")");

        execute(createStatement.toString(), values.toArray());
    }

    /// The equivalent of an SQL update assumes that the object is already in the database
    ///