3. 在maven中添加依赖
org.mybatis
mybatis-spring
2.0.7
org.springframework
spring-jdbc
5.3.2
org.mybatis
mybatis
3.5.9
mysql
mysql-connector-java
8.0.20
org.projectlombok
lombok
1.18.16
com.fasterxml.jackson.core
jackson-databind
2.13.3
com.alibaba
fastjson
2.0.10
javax.servlet
javax.servlet-api
4.0.1
provided
javax.servlet.jsp
jsp-api
2.2.1-b03
javax.servlet
jstl
1.2
taglibs
standard
1.1.2
org.springframework
spring-webmvc
5.3.9
junit
junit
4.12
org.aspectj
aspectjweaver
1.6.8
6. 配置基本的Spring配置文件以及Mybatis配置文件 applicationContext.xml
mybatis-config.xml
- 编写数据库资源文件,在resource包下创建db.properties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
jdbc.username=root
jdbc.password=18227022334a
- 创建实体类
//使用Lombok插件
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Account {
private int id;
private String name;
private double money;
}
- 编写接口
import com.xiaoye.pojo.Account;
import java.util.List;
public interface AccountMapper {
public List queryAll();
}
- 在resource目录下的dao包下创建并且编写AccountMapper.xml配置文件
select * from account
- 在mybatis中定义别名以及注册mapper文件
- 编写业务层
package com.xiaoye.service;
import com.xiaoye.pojo.Account;
import java.util.List;
public interface AccountService {
public List queryAll();
}
- 编写业务层实现类
package com.xiaoye.service;
import com.xiaoye.dao.AccountMapper;
import com.xiaoye.pojo.Account;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service("accountServiceImpl")
public class AccountServiceImpl implements AccountService{
@Autowired
private AccountMapper accountMapper;
@Override
public List queryAll() {
return accountMapper.queryAll();
}
}
- 在resource下创建spring-dao.xml配置文件
- 在resource下创建spring-service.xml配置文件
- 在applicationContext.xml引入spring-dao.xml和spring.service.xml
2. 配置web.xml文件
dispatcherServlet
org.springframework.web.servlet.DispatcherServlet
contextConfigLocation
classpath:applicationContext.xml
1
dispatcherServlet
/
encoding
org.springframework.web.filter.CharacterEncodingFilter
encoding
utf-8
encoding
/*
- 在resource目录下编写spring-mvc.xml文件
- 编写Controller
package com.xiaoye.controller;
import com.xiaoye.pojo.Account;
import com.xiaoye.service.AccountService;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import java.util.List;
@Controller("accountController")
@RequestMapping("account")
public class AccountController {
@Autowired
@Qualifier("accountServiceImpl")
private AccountService accountService;
@RequestMapping("/query")
public String queryAccount(Model model){
List accounts = accountService.queryAll();
model.addAttribute("list",accounts);
return "home";
}
}
- 在applicationContext.xml中加入配置
- 在WEB-INF下创建jsp包,在jsp包下创建home.jsp
主页
accounts = (List) request.getAttribute("list");
for (Account account : accounts) {
response.getWriter().write(account.toString());
}
%>
8. 启动服务器,测试!!
Original: https://www.cnblogs.com/xiaoye-Blog/p/16559633.html
Author: 小也取不到名字
Title: SSM简单整合!!!
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/621734/
转载文章受原作者版权保护。转载请注明原作者出处!