使用框架的版本:
Spring 5.0.8 RELEASE
Spring MVC 5.0.8 RELEASE
MyBatis 3.4.6
mysql
创建一个maven web工程
1、pom.xml中引入依赖:
org.springframework
spring-context
5.0.8.RELEASE
org.springframework
spring-web
5.0.8.RELEASE
org.springframework
spring-webmvc
5.0.8.RELEASE
org.springframework
spring-tx
5.0.8.RELEASE
org.springframework
spring-aspects
5.0.8.RELEASE
org.springframework
spring-orm
5.0.8.RELEASE
org.springframework
spring-jdbc
5.0.8.RELEASE
javax.servlet
javax.servlet-api
3.1.0
provided
javax.servlet.jsp
jsp-api
2.2
provided
log4j
log4j
1.2.17
commons-logging
commons-logging
1.2
org.slf4j
slf4j-log4j12
1.7.25
org.apache.taglibs
taglibs-standard-spec
1.2.5
bundle
org.apache.taglibs
taglibs-standard-impl
1.2.5
bundle
org.mybatis
mybatis
3.4.6
org.mybatis
mybatis-spring
1.3.2
org.mybatis.generator
mybatis-generator-core
1.3.7
com.github.pagehelper
pagehelper
5.1.4
org.mybatis.caches
mybatis-ehcache
1.1.0
mysql
mysql-connector-java
5.1.46
com.oracle
ojdbc6
12.1.0.1-atlassian-hosted
com.mchange
c3p0
0.9.5.2
com.fasterxml.jackson.core
jackson-core
2.9.6
com.fasterxml.jackson.core
jackson-annotations
2.9.6
com.fasterxml.jackson.core
jackson-databind
2.9.6
commons-fileupload
commons-fileupload
1.3.3
junit
junit
4.12
test
org.apache.felix
maven-bundle-plugin
true
2、在 web.xml 里做初始配置spring和springmvc
CharacterEncodingFilter
org.springframework.web.filter.CharacterEncodingFilter
encoding
utf-8
forceEncoding
true
CharacterEncodingFilter
/*
contextConfigLocation
classpath:spring.xml
org.springframework.web.context.ContextLoaderListener
springDispatcherServlet
org.springframework.web.servlet.DispatcherServlet
contextConfigLocation
classpath:springmvc.xml
2
springDispatcherServlet
/
hiddenHttpMethodFilter
org.springframework.web.filter.HiddenHttpMethodFilter
hiddenHttpMethodFilter
/*
3、SpringMVC.xml 配置
4、Spring.xml 配置
mybatis 声明dataSource事务管理器
5、application.properties
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?allowMultiQueries=true&useUnicode=true&characterEncoding=utf8&useSSL=true
jdbc.user=root
jdbc.password=123456
oracle.driverClass=oracle.jdbc.OracleDriver
oracle.url=jdbc:oracle:thin:@localhost:1521:orcl
oracle.user=scott
oracle.password=tiger
c3p0.initialPoolSize=5
c3p0.acquireIncrement=5
c3p0.maxPoolSize=20
c3p0.minPoolSize=5
c3p0.maxStatements=200
c3p0.maxStatementsPerConnection=5
6、log4j.properties
log4j.rootLogger = debug,stdout, D
log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target = System.out
log4j.appender.stdout.Threshold = INFO
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p %m%n
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = ./log4j.log
log4j.appender.D.Append = true
log4j.appender.D.Threshold = DEBUG
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern=%d %p %m%n
7、mybatisConfig.xml
8、mbgconfig.xml :根据表帮我们自动生成接口、pojo类和xml这些文件,更改为自己项目的包名,表名
@Test
public void runmbg() throws Exception {
List warnings = new ArrayList();
boolean overwrite = true;
String path = this.getClass().getClassLoader().getResource("mbgconfig.xml").getPath();
File configFile = new File(path);
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
}
9、ehcache.xml, 根据需要可配也不不配
整合完成 简单测试:
创建service 和 controller, 调用mapper接口的方法
@Service("userService")
public class UserServiceImpl implements UserService{
@Autowired
private UserMapper userMapper;
@Override
public List selectAllUser() {
return userMapper.selectAllUser();
}
}
@Controller
public class IndexController {
@Autowired
private UserService userService;
// http://127.0.0.1:8080/ssm/index
@RequestMapping(value = "/index", method = RequestMethod.GET)
public String index(Model model) {
List userList = userService.selectAllUser();
model.addAttribute("userList", userList);
return "index";
}
}
index.jsp
欢迎进入首页
${userList }
访问:http://127.0.0.1:8080/ssm/index
测试ok, ssm整合 end