Код IT
← Каталог

Работа с базами данных из Groovy — Сквозной кейс — сохранение активных книг

Фрагмент из «Работа с базами данных из Groovy»: Сквозной кейс — сохранение активных книг.

groovy groovyencyclopedia19 embed URL статья в энциклопедии
Groovy main.groovy 

import groovy.sql.Sql

def sql = Sql.newInstance(url, user, pass, driver)
def books = [
    [title: "Groovy in Action", author: "D. Konig", price: 50G, active: true],
    [title: "Legacy Java",      author: "Team",     price: 35G, active: false]
]

sql.withTransaction {
    books.findAll { it.active }.each { b ->
        sql.executeInsert(
            "INSERT INTO books(title, author, price) VALUES (?, ?, ?)",
            [b.title, b.author, b.price]
        )
    }
}
sql.close()

import groovy.sql.Sql

def sql = Sql.newInstance(url, user, pass, driver)
def books = [
    [title: "Groovy in Action", author: "D. Konig", price: 50G, active: true],
    [title: "Legacy Java",      author: "Team",     price: 35G, active: false]
]

sql.withTransaction {
    books.findAll { it.active }.each { b ->
        sql.executeInsert(
            "INSERT INTO books(title, author, price) VALUES (?, ?, ?)",
            [b.title, b.author, b.price]
        )
    }
}
sql.close()