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

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

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

    探索與發現

    研究java技術

      BlogJava :: 首頁 :: 新隨筆 :: 聯系 :: 聚合  :: 管理 ::
      83 隨筆 :: 0 文章 :: 109 評論 :: 0 Trackbacks
    ?MySQL Connector/J下載地址
    http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.12.zip/
    主要新增功能是:
    The driver now also supports "streaming" result sets, which allows users to retrieve large numbers of rows without using a large memory buffer. With newly added large-packet protocol support, the driver can send rows and BLOBs up to 2 gigabytes in size.

    New features from the JDBC-3.0 API in the latest production version of MySQL Connector/J include getGeneratedKeys which allows users to retrieve auto-increment fields in a non-database-specific way. Auto-increment fields now work with object-relational mapping tools, as well as Enterprise Java Beans (EJB) servers with Container Managed Persistence (CMP) that support JDBC-3.0.

    The development version is being refactored to support new features in conjunction with version 4.1 of the MySQL database server, including server-side prepared statements and improved handling of multiple simultaneous character sets, including Unicode in the UCS2 and UTF8 encodings.

    Retrieval of Auto Generated Keys:
    主要針對自動增長類型的數據取值的問題:
    比如我們插入一條數據:
    像原來jdbc2.0時我們這樣干的:
    Int rowcount = stmt.executeUpdate (
    "insert into LocalGeniusList (name) values ('Karen')"); // insert row
    
    // now get the disk address – rowid – for the newly inserted row
    ResultSet rs = stmt.executeQuery (
    
    "select rowid from LocalGeniusList where name = 'Karen'");
    jdbc3.0時我們可以在插入一條記錄時同時得到行數,
    還可以訪問到自動增長的數據如:
    Int rowcount = stmt.executeUpdate (
    
    "insert into LocalGeniusList (name) values ('Karen'),
    Statement.RETURN_GENERATED_KEYS); // insert row AND return key
    
    ResultSet rs = stmt.getGeneratedKeys (); // key is automatically available
    而有些數據庫不支持自動增長類型的數據,jdbc3.0也給出相應的支持:
    // insert the row and specify that you want the employee ID returned as the key Int rowcount = stmt.executeUpdate ( "insert into LocalGeniusList (name) values ('Karen'), "employeeID");
    ResultSet rs = stmt.getGeneratedKeys (); // Karen's employeeID value is now available
    要想了解更多的jdbc3.0可以參考下面的網站:
    http://www.datadirect.com/developer/jdbc/topics/jdbc30/index.ssp
    http://www-128.ibm.com/developerworks/java/library/j-jdbcnew/
    http://www.onjava.com/pub/a/onjava/synd/2001/08/21/jdbc.html?page=3
    jdbc4.0參考網站
    http://www.theserverside.com/news/thread.tss?thread_id=34465
    http://weblogs.java.net/blog/lancea/archive/2006/05/jdbc_40_sqlxml.html
    http://java.sys-con.com/read/111252.htm
    下載jdbc4.0規范
    http://192.18.108.135/ECom/EComTicketServlet/BEGIN747810F695946413098EEF45230B1F12/-2147483648/1488530847/1/686798/686786/1488530847/2ts+/westCoastFSEND/jdbc-4.0-pr-spec-oth-JSpec/jdbc-4.0-pr-spec-oth-JSpec:2/jdbc4.0-pd-spec.pdf
    posted on 2006-05-19 08:33 蜘蛛 閱讀(1548) 評論(1)  編輯  收藏 所屬分類: jdbc

    評論

    # re: jdbc3.0自動增長類型取值方案 2006-05-20 09:53 劍事
    ResultGather rs = new ResultGather("insert into mms.dbo.TBL_RESERVED_MMS(SEND_PHONE,RECV_PHONE,SERVICE_CODE,CONTENT_TYPE,VAS_SUBJECT) values('phone ',' fromphone',' serviceid','M','title') SELECT @@IDENTITY AS 'linkkey'");

    SQLSERVER 可以這樣  回復  更多評論
      


    只有注冊用戶登錄后才能發表評論。


    網站導航:
     
    主站蜘蛛池模板: 18国产精品白浆在线观看免费| 免费无码肉片在线观看| 久久99免费视频| 99热在线精品免费全部my| 亚洲一区二区三区国产精品| 在线免费观看亚洲| 特级毛片爽www免费版| 99精品视频在线视频免费观看| 性感美女视频在线观看免费精品 | 亚洲国产日韩在线一区| 久久水蜜桃亚洲AV无码精品| 久久99免费视频| 精品亚洲aⅴ在线观看| 免费在线观看一区| 最近中文字幕免费mv视频8| 亚洲av女电影网| 成年大片免费高清在线看黄| 亚洲欧洲日产国码高潮αv| 亚洲中文精品久久久久久不卡| 国产一区二区三区免费观看在线 | 亚洲综合精品香蕉久久网| 久久久久久亚洲精品影院| 二区久久国产乱子伦免费精品| 在线免费观看国产视频| 亚洲人配人种jizz| 最新黄色免费网站| 伊人久久综在合线亚洲2019| 国产成人精品免费视频动漫| 亚洲国产一区二区三区青草影视| 久久久WWW成人免费精品| 免费国产成人高清在线观看麻豆 | 日批日出水久久亚洲精品tv| 国产精品亚洲精品青青青| 成在线人永久免费视频播放| 毛片基地看看成人免费| 亚洲精品中文字幕无乱码| 222www免费视频| 羞羞网站在线免费观看| 男人的天堂亚洲一区二区三区 | 曰批免费视频播放在线看片二| 伊人久久大香线蕉亚洲五月天|