如下所示，我用jdbc來創(chuàng)建一個MySQL觸發(fā)器，自己在navicat里面實驗可以成功，但是程序跑起來就會提示創(chuàng)建觸發(fā)器的語句有語法錯誤。求指教scaladefcreatTable(tbname:String):Unit={valconn:Connection=getConnif(conn!=null){valstmt:Statement=conn.createStatementvalctbsql:String="createtableifnotexists"+tbname+"("+"idbigint(20)notnullprimarykey,"+"namevarchar(255)notnull,"+"pricedouble,"+"pricechangetodaydouble,"+"categoryvarchar(20));"valtbtrigger="droptriggerifexists"+tbname+"pricechange"+"createtrigger"+tbname+"pricechangebeforeupdateon"+tbname+"foreachrow"+"begin"+"setnew.pricechangetoday=new.price-old.price;"+"end"stmt.execute(ctbsql)stmt.execute(tbtrigger)}}