<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    posts - 431,  comments - 344,  trackbacks - 0
     

    在特殊情況下,grails應用需要調用數據庫的存儲過程,這在grails的官方文檔里邊好像沒有提到過,在jamesblog里介紹如何解決這個問題。
       
    代碼轉貼如下

    Java 代碼

    1. class MainController {  
    2.   
    3.   def dataSource // using the datasource we define in the spring's resources.xml  
    4.   
    5.   def index = {  
    6.       Sql sql = new Sql(dataSource)  
    7.       def row = sql.execute("call create_daily_hours(${new Date()+1})")  
    8.   }  
    9. }  

     需要說明的一些是:grails本身沒有提供訪問存儲過程的便捷方法,而groovyGSQL提供了,因此grails可以直接拿過來用了,當然也可以用springJdbcTemplate
     
    希望對grails用戶有點用。

    原文地址:http://grails.group.javaeye.com/group/blog/86666



    My experience with grails is getting richer the longer I use it for web application developing. It's very nice that grails is built on top of spring framework which we can take advantage of. I am not a spring user before but with a help from the nice people at the grails forum I was able to achieve what I want to do.

    Calling a stored procedure from a MySQL database or any other database is simple. First we need a datasource which spring could provide for us. I have the following code place in the resources.xml found in the spring folder in your grails folder.


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



    I use connection pooling for better performance. In my controller here is how I use the datasource to call a store procedure.


    class MainController {

     def dataSource // using the datasource we define in the spring's resources.xml

     def index = {
          Sql sql = new Sql(dataSource)
          def row = sql.execute("call create_daily_hours(${new Date()+1})")
     }
    }



    That's it! Notice that I am using Groovy SQL instead of Spring JDBCTemplate. It's a lot more friendlier for a beginner.

    Grails really makes everything easy here and provides a lot of flexibility thanks to it's nice integration with spring. From here everything is possible.

    原文地址:http://james-says.blogspot.com/2007/03/grails-little-of-spring-framework.html

    posted on 2008-07-18 09:30 周銳 閱讀(599) 評論(0)  編輯  收藏 所屬分類: Groovy&Grails
    主站蜘蛛池模板: 在线看片韩国免费人成视频| 99re在线视频免费观看| 亚洲人成人无码网www国产| 国产vA免费精品高清在线观看| 亚洲伊人久久大香线蕉综合图片| 最近的2019免费中文字幕| 亚洲中文字幕久久精品无码2021| 国产精品嫩草影院免费| 色www永久免费| 亚洲熟妇无码一区二区三区导航| 久久国产成人亚洲精品影院| 91网站免费观看| 日韩a毛片免费观看| 亚洲欧洲中文日产| 亚洲男女内射在线播放| 无码国产精品一区二区免费虚拟VR| 免费一级做a爰片久久毛片潮| 亚洲综合在线成人一区| 亚洲精品成人a在线观看| 九九精品免费视频| 国产成人无码免费看片软件| 亚洲愉拍一区二区三区| 亚洲A∨无码无在线观看| 免费大黄网站在线观看| 一二三四在线播放免费观看中文版视频 | 97在线观免费视频观看 | www亚洲一级视频com| 精品免费人成视频app| 中文字幕免费在线播放| 亚洲.国产.欧美一区二区三区| 亚洲黄色在线电影| 亚洲综合无码AV一区二区| 免费观看的毛片手机视频| 亚洲黄色免费在线观看| 免费人成在线观看视频高潮| 美女黄色免费网站| 亚洲免费综合色在线视频| 亚洲成人福利网站| 午夜亚洲AV日韩AV无码大全| 区久久AAA片69亚洲| 亚洲第一黄片大全|