【Apache Groovy】Apache Groovy Tutorial

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

本帖隐藏的内容

Apache Groovy Tutorial.pdf (2.83 MB)

2017-3-12 10:28:29 上传

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Tutorial apache tutor Tori APA

1. The Sql class has a newInstance factory method which takes these parameters. You would typically use it as follows:
   
2. 
   
3. Connecting to HSQLDB
   
4. import groovy.sql.Sql
   
5. 
   
6. def url = 'jdbc:hsqldb:mem:yourDB'
   
7. def user = 'sa'
   
8. def password = ''
   
9. def driver = 'org.hsqldb.jdbcDriver'
   
10. def sql = Sql.newInstance(url, user, password, driver)
    
11. 
    
12. // use 'sql' instance ...
    
13. 
    
14. sql.close()
    
15. If you don’t want to have to handle resource handling yourself (i.e. call close() manually) then you can use the withInstance variation as shown here:
    
16. 
    
17. Connecting to HSQLDB (withInstance variation)
    
18. Sql.withInstance(url, user, password, driver) { sql ->
    
19.   // use 'sql' instance ...
    
20. }

复制代码

1. Connecting with a DataSource
   
2. 
   
3. It is often preferred to use a DataSource. You may have one available to you from a connection pool. Here we’ll use the one provided as part of the HSQLDB driver jar as shown here:
   
4. 
   
5. Connecting to HSQLDB with a DataSource
   
6. import groovy.sql.Sql
   
7. import org.hsqldb.jdbc.JDBCDataSource
   
8. 
   
9. def dataSource = new JDBCDataSource(
   
10.     database: 'jdbc:hsqldb:mem:yourDB', user: 'sa', password: '')
    
11. def sql = new Sql(dataSource)
    
12. 
    
13. // use then close 'sql' instance ...
    
14. If you have your own connection pooling, the details will be different, e.g. for Apache Commons DBCP:
    
15. 
    
16. Connecting to HSQLDB with a DataSource using Apache Commons DBCP
    
17. @Grab('commons-dbcp:commons-dbcp:1.4')
    
18. import groovy.sql.Sql
    
19. import org.apache.commons.dbcp.BasicDataSource
    
20. 
    
21. def ds = new BasicDataSource(driverClassName: "org.hsqldb.jdbcDriver",
    
22.     url: 'jdbc:hsqldb:mem:yourDB', username: 'sa', password: '')
    
23. def sql = new Sql(ds)
    
24. // use then close 'sql' instance ...

复制代码

1. Connecting using @Grab
   
2. 
   
3. For a self-contained script you can add @Grab statements to the top of the script to automatically download the necessary jar as shown here:
   
4. 
   
5. Connecting to HSQLDB using @Grab
   
6. @Grab('org.hsqldb:hsqldb:2.3.2')
   
7. @GrabConfig(systemClassLoader=true)
   
8. // create, use, and then close sql instance ...
   
9. The @GrabConfig statement is necessary to make sure the system classloader is used. This ensures that the driver classes and system classes like java.sql.DriverManager are in the same classloader.

复制代码