spring+springMVC+mybatis的框架项目基础环
一、 搭建目标：
实现标准的后台controller、service、dao三层结构；
使用mapper.xml配置文件实现dao层和数据库的交互；
数据库连接信息、基础配置文件存在config.properties文件中；
配置日志打印相关的信息；
配置数据库连接池；
使用注解；
配置json数据前后台交互；
使用junit测试；
二、环境基础：
eclipe4.4.1;
maven3.2.5;
spring4.0.3;
mysql5.6;
jdk1.7;
tomcat7;
Angularjs1.4.0；
注：为了确定后台环境是真的没有问题，自然也需要简单搭一下前台的环境，起码要能保证前后台交互没有问题。因此我前台也简单的弄了一下angularjs，实际上我们项目中前端环境已经不这么搭里 ，只是新的搭法我还不会。
三、项目整体结构如下：
1、 后端：
2、 前端：
四、maven导包及基础配置pom.xml代码：
[html] view plain copy
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
4.0.0
frameTest
frameTest
war
0.0.1-SNAPSHOT
frameTest Maven Webapp
http://maven.apache.org
maven-compiler-plugin
2.3.2
1.7
1.7
UTF-8
${java.home}\lib\rt.jar
src/main/java
**/*.xml
src/main/resources
**/*.*
frameTest
4.0.3.RELEASE
org.springframework
spring-test
${spring-version}
org.springframework
spring-webmvc
${spring-version}
org.springframework
spring-core
${spring-version}
org.springframework
spring-context
${spring-version}
org.springframework
spring-context-support
${spring-version}
org.springframework
spring-beans
${spring-version}
org.springframework
spring-orm
${spring-version}
org.springframework.amqp
spring-amqp
1.2.0.RELEASE
org.aspectj
aspectjweaver
1.7.1
org.mybatis
mybatis
3.2.7
org.mybatis
mybatis-spring
1.2.2
com.alibaba
druid
1.0.2
mysql
mysql-connector-java
5.1.34
junit
junit
4.11
test
org.codehaus.jackson
jackson-mapper-asl
1.9.7
com.alibaba
fastjson
1.1.26
org.codehaus.jackson
jackson-core-asl
1.9.7
javax.servlet
servlet-api
3.0-alpha-1
provided
org.apache.geronimo.specs
geronimo-servlet_3.0_spec
1.0
test
cglib
cglib
2.2
ch.qos.logback
logback-classic
1.0.9
commons-io
commons-io
2.4
com.github.snakerflow
snaker-core
2.5.1
org.apache.commons
commons-lang3
3.3.1
五、web项目基础配置文件web.xml:
[html] view plain copy
appversion
contextConfigLocation
classpath:spring.xml
字符集过滤器
encodingFilter
org.springframework.web.filter.CharacterEncodingFilter
字符集编码
encoding
UTF-8
encodingFilter
/*
spring监听器
org.springframework.web.context.ContextLoaderListener
org.springframework.web.util.IntrospectorCleanupListener
dispatcher
org.springframework.web.servlet.DispatcherServlet
contextConfigLocation
classpath:spring-mvc.xml
1
dispatcher
/
15
六、spring基础篇日志文件spring.xml：
[html] view plain copy
xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/task
http://www.springframework.org/schema/task/spring-task-3.1.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
七、mybatis基础配置文件spring-MybatisConfig.xml：
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">
value="classpath*:merDao/mapper/*Mapper.xml">
七、mybatis基础配置文件MybatisConf.xml:
[html] view plain copy
八、springMVC基础配置文件spring-mvc.xml:
[html] view plain copy
http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
text/html;charset=UTF-8
class = "org.springframework.http.converter.StringHttpMessageConverter"/>
九、日志打印相关配置logback.xml:
[html] view plain copy
%d{yyyy-MM-dd HH:mm:ss:SSS}[%p]: %m%n
${LOG_HOME}//merchant.%d{yyyy-MM-dd}.log
30
%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} -%msg%n
十、属性文件config.properties:
[html] view plain copy
#mysql
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/merchant?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
#c3p0
c3p0.minPoolSize=5
c3p0.initialPoolSize=10
c3p0.maxIdleTime=60
c3p0.acquireIncrement=5
c3p0.idleConnectionTestPeriod=60
c3p0.acquireRetryAttempts=30
c3p0.acquireRetryDelay=1000
c3p0.numHelperThreads=3
c3p0.breakAfterAcquireFailure=true
c3p0.testConnectionOnCheckout=false
c3p0.maxStatements=0
c3p0.maxStatementsPerConnection=0
#druid 阿里巴巴提供的JDBC连接池、监控组件
druid.minPoolSize=5
druid.maxPoolSize=30
druid.initialPoolSize=10
druid.maxIdleTime=60
druid.acquireIncrement=5
druid.idleConnectionTestPeriod=60
druid.acquireRetryAttempts=30
druid.acquireRetryDelay=1000
druid.numHelperThreads=3
druid.breakAfterAcquireFailure=true
druid.testConnectionOnCheckout=false
druid.maxStatements=0
druid.maxStatementsPerConnection=0
druid.maxWait=60000
druid.timeBetweenEvictionRunsMillis=3000
druid.minEvictableIdleTimeMillis=300000
druid.maxPoolPreparedStatementPerConnectionSize=20
druid.validationQuery=SELECT 'x'
druid.testWhileIdle=true
druid.testOnBorrow=false
druid.testOnReturn=false
druid.poolPreparedStatements=false
十一、为了验证这些配置是否可行，我写了一个简单的增加用户信息的操作，代码分别如下：
后台实体类userModel:
[java] view plain copy
package merModel;
import java.io.Serializable;
public class UserModel implements Serializable {
private static final long serialVersionUID = -3291196087479862240L;
private int id;
/**
* 用户账号
*/
private String account;
/**
* 用户姓名
*/
private String userName;
/**
* 用户密码
*/
private String password;
/**
* 手机
*/
private String mobile;
/**
* 邮箱
*/
private String email;
public String getAccount() {
return account;
}
public void setAccount(String account) {
this.account = account;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Override
public String toString() {
return "UserModel [id=" + id + ", account=" + account + ", userName="
+ userName +", password=" + password + ", modile=" + mobile
+", email=" + email + "]";
}
}
对应的前台UserCommand类：
[java] view plain copy
package merCommand;
public class UserCommand {
private int id;
/**
* 用户账号
*/
private String account;
/**
* 用户姓名
*/
private String userName;
/**
* 用户密码
*/
private String password;
/**
* 手机
*/
private String mobile;
/**
* 邮箱
*/
private String email;
public String getAccount() {
return account;
}
public void setAccount(String account) {
this.account = account;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Override
public String toString() {
return "UserCommand [id=" + id + ", account=" + account + ", userName="
+ userName +", password=" + password + ", modile=" + mobile
+", email=" + email + "]";
}
}
Dao接口UserDao:
[java] view plain copy
package merDao;
import merModel.UserModel;
public interface UserDao {
public void save(UserModel usermodel);
}
Dao实现userDaoMapper.xml:
[html] view plain copy
id,account,userName,password,mobile,email
insert into user()
values(#{id},#{account},#{userName},#{password},#{mobile},#{email})
查询用户-->
SELECT u.* FROM user u
UserService接口：
[java] view plain copy
package merService;
import merModel.UserModel;
public interface UserService {
public void add(UserModel usermodel);
}
userService实现：
[html] view plain copy
package merService.merServiceImp;
import javax.annotation.Resource;
import merDao.UserDao;
import merModel.UserModel;
import merService.UserService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
@Service("UserService")
public class UserServiceImp implements UserService {
privatefinal Loggerlogger = LoggerFactory.getLogger(UserServiceImp.class);
private UserDao userDao;
@Resource(name = "userDao")
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
@Override
public void add(UserModel usermodel) {
userDao.save(usermodel);
}
}
Controller前后台交互：
[java] view plain copy
package merController;
import merCommand.UserCommand;
import merModel.UserModel;
import merService.UserService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class UserController {
@Autowired
private UserService userService;
/**
* 新增用户
*
* @author：tuzongxun
* @Title: addUser
* @param @param userCommand
* @return void
* @date Apr 14, 2016 11:28:47 AM
* @throws
*/
@RequestMapping(value = "addUser", method = RequestMethod.POST)
public void addUser(@RequestBody UserCommand userCommand) {
UserModel userModel =new UserModel();
BeanUtils.copyProperties(userCommand, userModel);
userService.add(userModel);
}
}
前台index.html文件：
[html] view plain copy
交易业务商户服务平台
首页
|
申告管理
|
自助服务
|
意见管理
|
知识库
前台app.js文件代码：
[javascript] view plain copy
var app=angular.module('merchantApp',['ui.router']);
app.config(function($stateProvider,$urlRouterProvider){
$urlRouterProvider.otherwise('/addUser');
$stateProvider
.state('addUser', {
url:"/addUser",
views: {
'view': {
templateUrl:'views/addUser.html',
controller:'addUserCtr'
}
}
});
});
增加用户信息的界面addUser.html：
[html] view plain copy
用户名：
姓 名：
密 码：
手 机：
邮 箱：
增加用户信息的angularjs控制层：
[javascript] view plain copy
angular.module('merchantApp')
.controller('addUserCtr', ['$scope','$http', function($scope,$http){
$scope.addUser=function(user){
//向后台提交数据
$http.post("./addUser",user,{headers:'Content-Type:application/json'}).success(function(){
});
}
}])
相关的css：
[css] view plain copy
body{
margin:0;
}
.button1{
font-size:28px;
}
#addUser input{
font-size:24px;
}
#addUser{
border:2px solid;
border-radius:0.5em;
width:35%;
height:330px;
float:left;
margin-left:400px;
margin-top:100px;
padding:30px;
background-image:url("../images/111.jpg");
background-size:cover;
font-size:26px;
}
#addUser img{
width:100%;
height:100%;
}
#headBack{
width:100%;
height:80px;
background-color:#E0EEF0;
position:relative;
}
#headDiv{
width:75%;
height:5px;
background:#CBE1E4;
float:right;
position:absolute;
right:0;
bottom:0;
}
#navUl{
/*position:relative;*/
position:absolute;
float:right;
top:0;
right:0;
margin:0;
box-sizing:border-box;
/*background-color:red;*/
width:75%;
height:75px;
}
#navUl li{
list-style-type: none;
/*position:absolute;*/
font-size:36px;
display: inline;
/**top:20;*/
margin-top:20px;
left:0;
height:auto;
text-color:#2F2E2E;
/*background-color:#EAE3EA;*/
text-align:center;
/**padding:5px;
margin-top:3px;*/
}
a:link{
text-decoration:none;
color:black;
}
a:visited{
color:blue;
}
a:hover{
color:red;
}
a:active{
color:orange;
}
浏览器访问界面如下：
点击注册以后，数据库信息如下：
至此，基础搭建成功。
