spring mvc maven mysql_Spring+Mybatis+SpringMVC+Maven+MySql项目搭建实例

搭建Spring+Mybatis+SpringMVC+MySql的搭建实例源码

1、Maven配置，实例采用了最流行的最新版本搭建

2、数据建表

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, '123', '[email protected]', '[email protected]');

INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (2, 'eva234n', '1323', '[email protected]');

INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (3, '1231', 'cadg', '[email protected]');

INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (4, 'si234mle', 'cscs', '[email protected]');

INSERT INTO t_user (USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL) VALUES (5, '123', 'csas', '[email protected]');

3、运行截图