一、搭建开发环境
1.1、使用Maven创建Web项目
执行如下命令:
mvn archetype:create -DgroupId=me.gacl -DartifactId=spring4-mybatis3 -DarchetypeArtifactId=maven-archetype-webapp -DinteractiveMode=false
如下图所示:
创建好的项目如下:
编辑pom.xml文件
1 <</span>project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 2 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> 3 <</span>modelVersion>4.0.0</</span>modelVersion> 4 <</span>groupId>me.gacl</</span>groupId> 5 <</span>artifactId>spring4-mybatis3</</span>artifactId> 6 <</span>packaging>war</</span>packaging> 7 <</span>version>1.0-SNAPSHOT</</span>version> 8 <</span>name>spring4-mybatis3 Maven Webapp</</span>name> 9 <</span>url>http://maven.apache.org</</span>url> 10 <</span>dependencies> 11 <</span>dependency> 12 <</span>groupId>junit</</span>groupId> 13 <</span>artifactId>junit</</span>artifactId> 14 <</span>version>3.8.1</</span>version> 15 <</span>scope>test</</span>scope> 16 </</span>dependency> 17 </</span>dependencies> 18 <</span>build> 19 <</span>finalName>spring4-mybatis3</</span>finalName> 20 </</span>build> 21 </</span>project>
修改
另外,把以下内容删掉:
1 <</span>dependency> 2 <</span>groupId>junit</</span>groupId> 3 <</span>artifactId>junit</</span>artifactId> 4 <</span>version>3.8.1</</span>version> 5 <</span>scope>test</</span>scope> 6 </</span>dependency>
这部分是junit的jar包依赖信息,这个版本太低了,我们不使用这个Junit测试版本,修改过后的pom.xml内容如下:
1 <</span>project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 2 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> 3 <</span>modelVersion>4.0.0</</span>modelVersion> 4 <</span>groupId>me.gacl</</span>groupId> 5 <</span>artifactId>spring4-mybatis3</</span>artifactId> 6 <</span>packaging>war</</span>packaging> 7 <</span>version>1.0-SNAPSHOT</</span>version> 8 <</span>name>spring4-mybatis3</</span>name> 9 <</span>url>http://maven.apache.org</</span>url> 10 <</span>dependencies> 11 12 </</span>dependencies> 13 <</span>build> 14 <</span>finalName>spring4-mybatis3</</span>finalName> 15 </</span>build> 16 </</span>project>
1.2、将创建好的项目导入MyEclipse中
具体操作步骤如下图所示:
手动创建【src/main/java】、【src/test/resources】、【src/test/java】这三个source folder,如下图所示:
到此,项目搭建的工作就算是全部完成了。
二、创建数据库和表(针对MySQL)
SQL脚本如下:
Create DATABASE spring4_mybatis3; USE spring4_mybatis3; DROP TABLE IF EXISTS t_user; CREATE TABLE t_user ( user_id char(32) NOT NULL, user_name varchar(30) DEFAULT NULL, user_birthday date DEFAULT NULL, user_salary double DEFAULT NULL, PRIMARY KEY (user_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
创建好的数据库和表如下:
三、使用generator工具生成代码
在网上找到了一个generator工具可以根据创建好的数据库表生成MyBatis的表对应的实体类,SQL映射文件和dao,找到generator工具根目录下的generator.xml文件,这个文件是用来配置代码生成规则的,如下图所示:
编辑generator.xml文件,内容如下: