spring frame 事務回滾的測試
系統
1567 0
?我的環境配置
Mysql :server version: 5.0.45-Debian_1ubuntu3.1-log Debian etch distribution
Spring frame: 2.0
jdk 1.6
數據庫的配置:
--
?MySQL?Administrator?dump?1.4
--
--
?------------------------------------------------------
--
?Server?version????5.0.45-Debian_1ubuntu3.1-log
/**/
/*
!40101?SET?@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT?
*/
;
/**/
/*
!40101?SET?@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS?
*/
;
/**/
/*
!40101?SET?@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION?
*/
;
/**/
/*
!40101?SET?NAMES?utf8?
*/
;
/**/
/*
!40014?SET?@OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS,?UNIQUE_CHECKS=0?
*/
;
/**/
/*
!40014?SET?@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,?FOREIGN_KEY_CHECKS=0?
*/
;
/**/
/*
!40101?SET?@OLD_SQL_MODE=@@SQL_MODE,?SQL_MODE='NO_AUTO_VALUE_ON_ZERO'?
*/
;
--
--
?Create?schema?SQLMapStudy
--
CREATE
?
DATABASE
?
IF
?
NOT
?
EXISTS
?SQLMapStudy;
USE
?SQLMapStudy;
--
--
?Definition?of?table?`SQLMapStudy`.`ORDER`
--
DROP
?
TABLE
?
IF
?
EXISTS
?`SQLMapStudy`.`
ORDER
`;
CREATE
?
TABLE
??`SQLMapStudy`.`
ORDER
`?(
??`id`?
int
(
11
)?
NOT
?
NULL
?auto_increment,
??`
level
`?
int
(
11
)?
default
?
'
0
'
,
??`name`?
text
,
??
PRIMARY
?
KEY
??(`id`)
)?ENGINE
=
InnoDB?AUTO_INCREMENT
=
42
?
DEFAULT
?CHARSET
=
latin1;
--
--
?Dumping?data?for?table?`SQLMapStudy`.`ORDER`
--
/**/
/*
!40000?ALTER?TABLE?`ORDER`?DISABLE?KEYS?
*/
;
LOCK?TABLES?`
ORDER
`?WRITE;
INSERT
?
INTO
?`SQLMapStudy`.`
ORDER
`?
VALUES
??(
24
,
5
,
'
233571
'
),
?(
25
,
3
,
'
237607
'
),
?(
26
,
4
,
'
951320
'
),
?(
27
,
4
,
'
3981449
'
),
?(
28
,
3
,
'
4201861
'
),
?(
29
,
3
,
'
4286204
'
),
?(
30
,
4
,
'
4467730
'
),
?(
31
,
4
,
'
4577921
'
),
?(
32
,
4
,
'
4644267
'
),
?(
33
,
4
,
'
4676767
'
),
?(
34
,
4
,
'
8718591
'
),
?(
35
,
4
,
'
1200488898355
'
),
?(
36
,
3
,
'
1200489291189
'
),
?(
37
,
3
,
'
1200489506119
'
),
?(
38
,
3
,
'
1200490058635
'
),
?(
41
,
4
,
'
1200490554236
'
);
UNLOCK?TABLES;
/**/
/*
!40000?ALTER?TABLE?`ORDER`?ENABLE?KEYS?
*/
;
/**/
/*
!40101?SET?SQL_MODE=@OLD_SQL_MODE?
*/
;
/**/
/*
!40014?SET?FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS?
*/
;
/**/
/*
!40014?SET?UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS?
*/
;
/**/
/*
!40101?SET?CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT?
*/
;
/**/
/*
!40101?SET?CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS?
*/
;
/**/
/*
!40101?SET?COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION?
*/
;
/**/
/*
!40101?SET?CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT?
*/
;
要注意的問題:ENGINE=InnoDB
數據庫映射對象類Order
/**/
/*
?*?Copyright?(C)?2000-2007?Wang?Pengcheng?<wpc0000@gmail.com>
?*?Licensed?to?the?Wang?Pengcheng?under?one?or?more
?*?contributor?license?agreements.??See?the?NOTICE?file?distributed?with
?*?this?work?for?additional?information?regarding?copyright?ownership.
?*?The?LGPL?licenses?this?file?to?You?under?the?GNU?Lesser?General?Public
?*?Licence,?Version?2.0??(the?"License");?you?may?not?use?this?file?except?in
?*?compliance?with?the?License.??You?may?obtain?a?copy?of?the?License?at
?*
?*?????
http://www.gnu.org/licenses/lgpl.txt
?*
?*?Unless?required?by?applicable?law?or?agreed?to?in?writing,?software
?*?distributed?under?the?License?is?distributed?on?an?"AS?IS"?BASIS,
?*?WITHOUT?WARRANTIES?OR?CONDITIONS?OF?ANY?KIND,?either?express?or?implied.
?*?See?the?License?for?the?specific?language?governing?permissions?and
?*?limitations?under?the?License.
?
*/
//
Edit?15?Jan?2008
package
?com.studyspring.ch5;
public
?
class
?Order?
...
{
????
private
?
int
?id;
????
private
?
int
?level;
????
private
?String?name;
????
public
?
int
?getId()?
...
{
????????
return
?id;
????}
????
public
?
void
?setId(
int
?id)?
...
{
????????
this
.id?
=
?id;
????}
????
public
?
int
?getLevel()?
...
{
????????
return
?level;
????}
????
public
?
void
?setLevel(
int
?level)?
...
{
????????
this
.level?
=
?level;
????}
????
public
?String?getName()?
...
{
????????
return
?name;
????}
????
public
?
void
?setName(String?name)?
...
{
????????
this
.name?
=
?name;
????}
????
}
實現RowMapper:
/**/
/*
?*?Copyright?(C)?2000-2007?Wang?Pengcheng?<wpc0000@gmail.com>
?*?Licensed?to?the?Wang?Pengcheng?under?one?or?more
?*?contributor?license?agreements.??See?the?NOTICE?file?distributed?with
?*?this?work?for?additional?information?regarding?copyright?ownership.
?*?The?LGPL?licenses?this?file?to?You?under?the?GNU?Lesser?General?Public
?*?Licence,?Version?2.0??(the?"License");?you?may?not?use?this?file?except?in
?*?compliance?with?the?License.??You?may?obtain?a?copy?of?the?License?at
?*
?*?????
http://www.gnu.org/licenses/lgpl.txt
?*
?*?Unless?required?by?applicable?law?or?agreed?to?in?writing,?software
?*?distributed?under?the?License?is?distributed?on?an?"AS?IS"?BASIS,
?*?WITHOUT?WARRANTIES?OR?CONDITIONS?OF?ANY?KIND,?either?express?or?implied.
?*?See?the?License?for?the?specific?language?governing?permissions?and
?*?limitations?under?the?License.
?
*/
//
Edit?15?Jan?2008
package
?com.studyspring.ch5;
import
?java.sql.ResultSet;
import
?java.sql.SQLException;
import
?org.springframework.jdbc.core.RowMapper;
public
?
class
?OrderRowMapper?
implements
?RowMapper?
...
{
spring frame 事務回滾的測試
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061
微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元