在oracle-db中插入语句的方法(Node-js)

const oracledb = require('oracledb');

const dbConfig = {
  user: 'your_username',
  password: 'your_password',
  connectString: 'your_connection_string'
};

async function insertData() {
  let connection;

  try {
    // 建立数据库连接
    connection = await oracledb.getConnection(dbConfig);

    // 执行插入语句
    const sql = `INSERT INTO your_table (column1, column2) VALUES (:value1, :value2)`;
    const binds = {
      value1: 'some_value1',
      value2: 'some_value2'
    };
    const options = {
      autoCommit: true
    };
    const result = await connection.execute(sql, binds, options);

    console.log("插入成功");
  } catch (error) {
    console.error("插入失败", error);
  } finally {
    // 关闭数据库连接
    if (connection) {
      try {
        await connection.close();
      } catch (error) {
        console.error("关闭连接失败", error);
      }
    }
  }
}

// 调用插入函数
insertData();