domain类如下:
package com.lt
class Book {
String bookName
double bookPrice
static constraints = {
}
}
service类如下:
package com.lt
import com.lt.Book
import java.sql.DriverManager
class LtSqlService {
static transactional = false //关闭service的事务
def addBook(){
//获得数据库连接
def con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root")
def db = new groovy.sql.Sql(con)
con.autoCommit=false //关闭连接的自动提交
try{
def bookName='JAVA'
def bookPrice=22.1
def sql="INSERT INTO book VALUES(NULL,0,'${bookName}',${bookPrice})"
db.execute(sql)
con.commit() //提交事务
}catch(Exception ex){
println "出现异常"
con.rollback() //回滚事务
}
}
}
用控制器调用会在数据库插入成功,如果把
def bookPrice='cc'
就会报错,事务回滚。
package com.lt
class Book {
String bookName
double bookPrice
static constraints = {
}
}
service类如下:
package com.lt
import com.lt.Book
import java.sql.DriverManager
class LtSqlService {
static transactional = false //关闭service的事务
def addBook(){
//获得数据库连接
def con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root")
def db = new groovy.sql.Sql(con)
con.autoCommit=false //关闭连接的自动提交
try{
def bookName='JAVA'
def bookPrice=22.1
def sql="INSERT INTO book VALUES(NULL,0,'${bookName}',${bookPrice})"
db.execute(sql)
con.commit() //提交事务
}catch(Exception ex){
println "出现异常"
con.rollback() //回滚事务
}
}
}
用控制器调用会在数据库插入成功,如果把
def bookPrice='cc'
就会报错,事务回滚。