npm init -y
npm install pg

import { Pool } from 'pg'

const pool = new Pool({
    host: 'localhost',
    port: 5432,
    database: 'demo',
    user: 'postgres',
    password: '123456',
})

// 查詢所有用戶
const res = await client.query('select * from "user"')
const list = res.rows
console.log('查詢結(jié)果', list)

// 插入新用戶
await client.query(
  'insert into "user" (user_id, username, password, status) values ($1, $2, $3, $4)',
  [2, '張三', '123456', false]
)

// 更新用戶信息
await client.query(
  'update "user" set username = $1 where user_id = $2', 
  ['張三2', 2]
)

// 刪除用戶
await client.query(
  'delete from "user" where user_id = $1', 
  [2]
)

import { Pool } from 'pg'

const pool = new Pool({
    host: 'localhost',
    port: 5432,
    database: 'demo',
    user: 'postgres',
    password: 'your_secure_password', // 實(shí)際應(yīng)用中應(yīng)從環(huán)境變量讀取
})

let client = null

const run = async () => {
    try {
        // 從連接池獲取客戶端
        client = await pool.connect()

        // 執(zhí)行各種數(shù)據(jù)庫操作
        // 查詢示例
        const res = await client.query('SELECT * FROM "user"')
        console.log('查詢結(jié)果:', res.rows)
        
        // 在實(shí)際應(yīng)用中，可以在這里添加更多操作
        
    } catch (err) {
        console.error('數(shù)據(jù)庫操作失敗', err)
    } finally {
        // 釋放客戶端回連接池
        if (client) {
            client.release()
        }
        // 關(guān)閉連接池
        await pool.end()
    }
}

run()