我的环境配置 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
-- CREATEDATABASEIFNOTEXISTS SQLMapStudy; USE SQLMapStudy; --
-- Definition of table `SQLMapStudy`.`ORDER`
-- DROPTABLEIFEXISTS `SQLMapStudy`.`ORDER`; CREATETABLE `SQLMapStudy`.`ORDER` (
`id` int(11) NOTNULL auto_increment,
`level` int(11) default'0',
`name` text, PRIMARYKEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42DEFAULT CHARSET=latin1; --
-- Dumping data for table `SQLMapStudy`.`ORDER`
-- /**//*!40000 ALTER TABLE `ORDER` DISABLE KEYS */;
LOCK TABLES `ORDER` WRITE; INSERTINTO `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; publicclass Order ...{ privateint id; privateint level; private String name; publicint getId() ...{ return id;
} publicvoid setId(int id) ...{ this.id = id;
} publicint getLevel() ...{ return level;
} publicvoid setLevel(int level) ...{ this.level = level;
} public String getName() ...{ return name;
} publicvoid 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; publicclass OrderRowMapper implements RowMapper ...{