typical_jdbc_insert.groovy

Class.forName(JDBC_DRIVER)
Connection conn = DriverManager.getConnection(url, userName, password)
String insertTableSQL = "INSERT INTO BOOK (ID, TITLE, AUTHOR_ID) VALUES (?,?,?)"

Map insertTest = [(Book.BOOK.ID): 7,
                 (Book.BOOK.AUTHOR_ID): 1,
                 (Book.BOOK.TITLE): "Coding in JDBC"]

PreparedStatement preparedStatement = conn.prepareStatement(insertTableSQL)
preparedStatement.setInt(1, insertTest[(Book.BOOK.ID)])
preparedStatement.setString(2, insertTest[(Book.BOOK.TITLE)])
preparedStatement.setInt(3, insertTest[(Book.BOOK.AUTHOR_ID)])
preparedStatement .executeUpdate()