Spring+Mybatis+Maven+MySql搭建实例

林炳文Evankaka原创作品。转载请注明出处

摘要:本文主要讲了如何使用Maven来搭建Spring+Mybatis+MySql的的搭建实例,文章写得很详细,有代码有图片,最后也带有运行的效果。

一、准备工作

1. 首先创建一个表:

CREATE TABLE `t_user` ( `USER_ID` int(11) NOT NULL AUTO_INCREMENT, `USER_NAME` char(30) NOT NULL, `USER_PASSWORD` char(10) NOT NULL, `USER_EMAIL` char(30) NOT NULL, PRIMARY KEY (`USER_ID`), KEY `IDX_NAME` (`USER_NAME`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8随便插入一些数据:INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (1, ‘林炳文’, ‘1234567@’, ‘ling20081005@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (2, ‘evan’, ‘123’, ‘fff@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (3, ‘kaka’, ‘cadg’, ‘fwsfg@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (4, ‘simle’, ‘cscs’, ‘fsaf@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (5, ‘arthur’, ‘csas’, ‘fsaff@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (6, ‘小德’, ‘yuh78’, ‘fdfas@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (7, ‘小小’, ‘cvff’, ‘fsaf@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (8, ‘林林之家’, ‘gvv’, ‘lin@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (9, ‘林炳文Evankaka’, ‘dfsc’, ‘ling2008@126.com’);INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (10, ‘apple’, ‘uih6’, ‘ff@qq.com’);二、工程创建

1、Maven工程创建

(1)新建

(2)选择快速框架

(3)输出项目名,包,记得选war(表示web项目,以后可以spingMVC连起来用)

(4)创建好之后

目录如下:

(5)检查下

这三个地方JDK的版本一定要一样!!!!

三、sping+mybatis配置

1、整个工程目录如下:

2、POM文件

<project xmlns="" xmlns:xsi=""xsi:schemaLocation=" http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.lin</groupId><artifactId>ssm_project</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><groupId>org.springframework</groupId><artifactId>spring-web</artifactId><version>${spring.version}</version></dependency><!–单元测试依赖 –><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>${junit.version}</version><scope>test</scope></dependency><!– 日志文件管理包 –><!– log start –><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><!– log end –><!–spring单元测试依赖 –><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包 –><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.2.0</version></dependency><!– mysql驱动包 –><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.29</version></dependency></dependencies></project>3、java代码——-src/main/java

目录如下:

(1)User.java

陪我们走过一段别人无法替代的记忆。在那里,

Spring+Mybatis+Maven+MySql搭建实例

相关文章:

你感兴趣的文章:

标签云: