Grails 执行原始SQL语句配置

1.使用spring加载dataSource到Controller中。

      a.将apache的dbcp包放入grail的lib目录

      b.在conf/spring目录下resources中.配置bean：dataSourc

        注意：以前是xml的，现在是直接用groovy了

        代码如下：

groovy版：

            import org.apache.commons.dbcp.BasicDataSource
            beans = {
               dataSource(BasicDataSource) {
                driverClassName = "org.hsqldb.jdbcDriver"
               url = "jdbc:hsqldb:mem:devDB"
               username = "sa"
               password = ""
              }

xml版：

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<bean id="dataSource" class=" org.apache.commons.dbcp.BasicDataSource ">
     <property name="driverClassName">    <value>org.hsqldb.jdbcDriver</value></property>
     <property name="url">    <value>jdbc:hsqldb:hsql://localhost</value></property>
     <property name="username">    <value>sa</value></property>
     <property name="password">    <value></value></property>
</bean>
</beans>

      c.在Controller中定义dataSource，代码如下：

             def dataSource

2.获取连接，代码如下：

    def conn = dataSource.getConnection()

3.执行sql语句，代码如下：

        PreparedStatement ps = conn.prepareStatement("select * from user");
        ResultSet rs = ps.executeQuery();

        while (rs.next()) {

         println(rs.getString("cus_name") )

         }

   ok！这样就搞定了.

 

 

转自:http://raodun.javaeye.com/blog/255018