我的环境配置
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
{
