探索与发现

研究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 蜘蛛 阅读(1468) 评论(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 可以这样  回复  更多评论
  


只有注册用户登录后才能发表评论。


网站导航: