//原创作者:bishen
//转载注明:http://www.bishen.org
貌似在网上还没有用groovy连接池的文章
[b]首先在tomcat/lib放入数据库驱动[/b]
[b]tomcat/config/content.xml 配置连接池名为jdbc/admin[/b]
[b]在网站的web.xml配置[/b]
[b]jsp 示例:[/b]
[b]Groovy 连接示例[/b]
//转载注明:http://www.bishen.org
貌似在网上还没有用groovy连接池的文章
[b]首先在tomcat/lib放入数据库驱动[/b]
[b]tomcat/config/content.xml 配置连接池名为jdbc/admin[/b]
<Resource name="jdbc/admin" type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
username="root"
password="密码"
url="jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=gbk"
maxActive="100"
maxIdle="30"
maxWait="5000" />
[b]在网站的web.xml配置[/b]
<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>
[b]jsp 示例:[/b]
<%@ 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();
%>
[b]Groovy 连接示例[/b]
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();