在NodeJS中将数据插入到oracle数据库表中

const oracledb = require('oracledb');

async function insertData() {
  let connection;

  try {
    connection = await oracledb.getConnection({
      user: 'your_username',
      password: 'your_password',
      connectString: 'your_connect_string'
    });

    const sql = `INSERT INTO your_table (column1, column2) VALUES (:value1, :value2)`;
    const binds = {
      value1: 'some_value',
      value2: 'another_value'
    };

    const result = await connection.execute(sql, binds);
    console.log('Data inserted successfully');
  } catch (error) {
    console.error('Error inserting data:', error);
  } finally {
    if (connection) {
      try {
        await connection.close();
      } catch (error) {
        console.error('Error closing connection:', error);
      }
    }
  }
}

insertData();