Using JDBC/ODBC to pass SQL statements to MS-Access.

The program connects to an existing data base, reads everthing it can find from a table 'TABLE1', then adds a record with INSERT and reads the updated database.

The example uses create_interface/2 to make the JDBC driver available to the MINERVA programmer.

The program is configured as standalone application.

Example output:

'SELECT * FROM table1'
statement_execute('SELECT * FROM table1')
statement_getResultSet
        '1'     '1'     hello
        '2'     '2'     'おはよう'
        '3'     '3'     hey
        '4'     '4'     moin
        '5'     '5'     working
'INSERT INTO TABLE1 VALUES (6, 6,\'more data\')'
statement_execute_failed
'SELECT * FROM TABLE1'
statement_execute('SELECT * FROM TABLE1')
statement_getResultSet
        '1'     '1'     hello
        '2'     '2'     'おはよう'
        '3'     '3'     hey
        '4'     '4'     moin
        '5'     '5'     working
        '6'     '6'     'more data'
'example done'

scroll to top