一 开发前准备
1.1 开发环境
Jdk1.6
MyEclipse 10
Tomcat7
MySQL5
1.2 创建表
CREATE TABLE `user` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` char(30) NOT NULL,
`PASSWORD` char(30) NOT NULL,
PRIMARY KEY (`ID`),
KEY `IDX_NAME` (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1.3 插入测试数据
INSERT INTO user (ID, NAME, PASSWORD) VALUES (1, 'admin', '123456');
INSERT INTO user (ID, NAME, PASSWORD) VALUES (2, '张三', '88888');
INSERT INTO user (ID, NAME, PASSWORD) VALUES (3, '李四', 'asdf@qq.com');
二 创建项目
File->New->Other
添加文件夹
src/main/java
src/main/resources
src/test/java
src/test/resources
检查以下3处的jdk版本,保持一致
三 配置POM文件
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.kitty</groupId>
<artifactId>test</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<properties>
<!-- spring版本号 -->
<spring.version>3.2.8.RELEASE</spring.version>
<!-- log4j日志文件管理包版本 -->
<slf4j.version>1.6.6</slf4j.version>
<log4j.version>1.2.12</log4j.version>
<!-- junit版本号 -->
<junit.version>4.10</junit.version>
<!-- mybatis版本号 -->
<mybatis.version>3.2.1</mybatis.version>
</properties>
<dependencies>
<!-- 添加Spring依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<