Build a Web project based on Springmvc+mybatis+maven __web

Preparation before development 1.1 Development Environment

Jdk1.6

MyEclipse 10

Tomcat7

MySQL5 1.2 Create a table

CREATE TABLE ' user ' (

' ID ' int (one) not NULL auto_increment,

' NAME ' char (not NULL),

' PASSWORD ' char (not NULL),

PRIMARY KEY (' ID '),

KEY ' Idx_name ' (' NAME ')

) Engine=innodb DEFAULT Charset=utf8 1.3 Insert test Data

INSERT into User (ID, NAME, PASSWORD) VALUES (1, ' admin ', ' 123456 ');

INSERT into User (ID, NAME, PASSWORD) VALUES (2, ' John ', ' 88888 ');

INSERT into User (ID, NAME, PASSWORD) VALUES (3, ' Dick ', ' asdf@qq.com '); two creating a project

File->new->other

Add Folder

Src/main/java

Src/main/resources

Src/test/java

Src/test/resources

Check the following 3 JDK versions to stay consistent

Three configuration pom file

<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 version number-->

<spring.version>3.2.8.RELEASE</spring.version>

<!--log4j log file Management Pack version-->

<slf4j.version>1.6.6</slf4j.version>

<log4j.version>1.2.12</log4j.version>

<!--junit version number-->

<junit.version>4.10</junit.version>

<!--mybatis version number-->

<mybatis.version>3.2.1</mybatis.version>

</properties>

<dependencies>

<!--add Spring dependency-->

<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>

<groupId>org.springframework</groupId>

<artifactId>spring-web</artifactId>

<version>${spring.version}</version>

</dependency>

<!--unit testing relies on-->

<dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

<version>${junit.version}</version>

<scope>test</scope>

</dependency>

<!--log4j-->

<dependency>

<groupId>log4j</groupId>

<artifactId>log4j</artifactId>

<version>${log4j.version}</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-api</artifactId>

<version>${slf4j.version}</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-log4j12</artifactId>

<version>${slf4j.version}</version>

</dependency>

<!--spring Unit test Dependencies-->

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-test</artifactId>

<version>${spring.version}</version>

<scope>test</scope>

</dependency>

<!--MyBatis-->

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

<version>${mybatis.version}</version>

</dependency>

<!--mybatis/spring Package-->

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis-spring</artifactId>

<version>1.2.0</version>

</dependency>

<!--mysql driver package-->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.29</version>

</dependency>

<!--DBCP database connection pool-->

<dependency>

<groupId>commons-dbcp</groupId>

<