Examples of org.tmatesoft.sqljet.core.table.ISqlJetTable.insertByFieldNames()

org.tmatesoft.sqljet.core.table.ISqlJetTable.insertByFieldNames()

Insert record by values by names of fields.

If table have INTEGER PRIMARY KEY column then this column could be null or even not specified and in this case it value will be defined automatically.

The ROWID of record could be passed by any of this names: ROWID, _ROWID_, OID. ROWID could be specified even if table haven't INTEGER PRIMARY KEY column.

All relevant indexes are updated automatically.

Returns ROWID of inserted record.

Can be used without of active transaction, in this case method begins and ends own internal transaction.

@param values map of field names with values. @return ROWID of inserted record. @throws SqlJetException

      final ISqlJetTable testTable = db.getTable("test");
      for (int i = 0; i < rowCount; i++) {
        final Map<String, Object> values = new HashMap<String, Object>();
        values.put("preview", createByte());


        final long pkTestTable = testTable.insertByFieldNames(values);
        System.out.println("PK : " + pkTestTable);
      }


      // Commit & Close
      db.commit();

            
            long rowid;
            if( insertOnly==true )
            {
                fields.put("new_entry", Boolean.TRUE.toString());
                rowid = table.insertByFieldNames(fields);
            }
            else
            {
                fields.put("new_entry", Boolean.FALSE.toString());
                rowid = table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, fields);

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.