SQL Server
利用前に情報はりつけ。
Express Editionの容量制限が1Gというのは結構きつい。
Express Edition
- SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Express Edition Service Pack 1
- Microsoft SQL Server Management Studio Express
Connect
Tool
Support
def url = "jdbc:sqlserver://localhost:1433;databaseName=DB01" def username = "sa" def password = "password" def driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver" def sql = Sql.newInstance( url , username , password , driverClassName) def tokuisaki = sql.rows("select * from tokuisaki") tokuisaki.each { rec -> println rec.namae println rec.jusyo }