Groovy 运用连续池

Groovy 使用连续池
//原创作者：bishen
//转载注明：http://www.bishen.org
貌似在网上还没有用groovy连接池的文章
首先在tomcat/lib放入数据库驱动
tomcat/config/content.xml 配置连接池名为jdbc/admin

<Resource name="jdbc/admin" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" username="root" password="密码" url="jdbc:mysql://localhost:3306/数据库名?useUnicode=true&amp;characterEncoding=gbk" maxActive="100" maxIdle="30" maxWait="5000" />

 <resource-ref>     <description>DB Connection</description>     <res-ref-name>jdbc/admin</res-ref-name>     <res-type>javax.sql.DataSource</res-type>     <res-auth>Container</res-auth> </resource-ref>

<%@ page contentType="text/html; charset=GBK"%><%@ page import="java.sql.*,javax.sql.DataSource,javax.naming.*"%><%Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/admin"); Connection con = ds.getConnection();out.println("data from database:<br>");Statement stmt = con.createStatement();ResultSet rs = stmt.executeQuery("select id,account,username from x_user");while (rs.next()) {out.println(rs.getInt(1));out.println(rs.getString(2));out.println(rs.getString(3));}rs.close();stmt.close();%>

import groovy.sql.Sql;import java.sql.*;import javax.sql.DataSource;import javax.naming.*;Context ctx    = new InitialContext();DataSource ds  = (DataSource) ctx.lookup("java:comp/env/jdbc/admin");Connection conn= ds.getConnection();def sql = Sql.newInstance(conn);def row = sql.eachRow("select id,account,username from x_user"){println it.username; }sql.close();conn.close();