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" />

在网站的web.xml配置

	 <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>

jsp 示例：

<%@ 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();

%>

Groovy 连接示例

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();