spring frame 事务回滚的测试
我的环境配置Mysql :server version: 5.0.45-Debian_1ubuntu3.1-log Debian etch distribution
Spring frame: 2.0
jdk 1.6
数据库的配置：
<div style="padding: 4px 5.4pt; width: 95%;">http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif-- MySQL Administrator dump 1.4
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif-- ------------------------------------------------------
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif-- Server version 5.0.45-Debian_1ubuntu3.1-log
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET NAMES utf8 */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif-- Create schema SQLMapStudy
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifCREATE DATABASE IF NOT EXISTS SQLMapStudy;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifUSE SQLMapStudy;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif-- Definition of table `SQLMapStudy`.`ORDER`
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifDROP TABLE IF EXISTS `SQLMapStudy`.`ORDER`;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifCREATE TABLE `SQLMapStudy`.`ORDER` (
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif `id` int(11) NOT NULL auto_increment,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif `level` int(11) default '0',
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif `name` text,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif PRIMARY KEY (`id`)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif-- Dumping data for table `SQLMapStudy`.`ORDER`
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40000 ALTER TABLE `ORDER` DISABLE KEYS */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifLOCK TABLES `ORDER` WRITE;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifINSERT INTO `SQLMapStudy`.`ORDER` VALUES (24,5,'233571'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (25,3,'237607'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (26,4,'951320'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (27,4,'3981449'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (28,3,'4201861'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (29,3,'4286204'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (30,4,'4467730'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (31,4,'4577921'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (32,4,'4644267'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (33,4,'4676767'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (34,4,'8718591'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (35,4,'1200488898355'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (36,3,'1200489291189'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (37,3,'1200489506119'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (38,3,'1200490058635'),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (41,4,'1200490554236');
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifUNLOCK TABLES;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40000 ALTER TABLE `ORDER` ENABLE KEYS */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
页:
[1]