spring整合mybatis博客项目
时间: 2023-07-22 18:20:57 浏览: 55
好的,下面是Spring整合Mybatis的博客项目的简单步骤:
1.创建Maven项目,并添加Spring和Mybatis的依赖。
2.配置数据库连接信息,创建数据库和表。
3.配置Mybatis的SqlSessionFactory,MapperScannerConfigurer等相关信息。
4.编写实体类和Mapper接口。
5.编写Mapper.xml文件,定义SQL语句和映射关系。
6.编写Service接口和实现类,调用Mapper接口中的方法。
7.编写Controller,处理前端请求。
8.编写JSP页面,展示数据。
具体步骤可以参考下面的代码示例:
1.添加Maven依赖:
```
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.1.6.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.3</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.19</version>
</dependency>
```
2.配置数据库连接信息,在application.properties文件中添加:
```
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/blog?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
```
3.配置Mybatis的SqlSessionFactory和MapperScannerConfigurer,创建mybatis-config.xml文件:
```
<configuration>
<typeAliases>
<package name="com.example.blog.entity"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${spring.datasource.driver-class-name}"/>
<property name="url" value="${spring.datasource.url}"/>
<property name="username" value="${spring.datasource.username}"/>
<property name="password" value="${spring.datasource.password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/UserMapper.xml"/>
</mappers>
</configuration>
```
4.创建实体类User:
```
public class User {
private int id;
private String name;
private String password;
// getter and setter
}
```
5.创建Mapper接口UserMapper:
```
public interface UserMapper {
User getUserById(int id);
}
```
6.创建Mapper.xml文件UserMapper.xml:
```
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.blog.mapper.UserMapper">
<select id="getUserById" parameterType="int" resultType="com.example.blog.entity.User">
select * from user where id=#{id}
</select>
</mapper>
```
7.创建Service接口UserService和实现类UserServiceImpl:
```
public interface UserService {
User getUserById(int id);
}
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User getUserById(int id) {
return userMapper.getUserById(id);
}
}
```
8.创建Controller处理前端请求:
```
@Controller
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/user/{id}")
public String getUserById(@PathVariable int id, Model model) {
User user = userService.getUserById(id);
model.addAttribute("user", user);
return "user";
}
}
```
9.创建JSP页面user.jsp,展示数据:
```
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title></title>
</head>
<body>
<h1>User Info</h1>
<table>
<tr>
<td>ID:</td>
<td>${user.id}</td>
</tr>
<tr>
<td>Name:</td>
<td>${user.name}</td>
</tr>
<tr>
<td>Password:</td>
<td>${user.password}</td>
</tr>
</table>
</body>
</html>
```
以上就是一个简单的Spring整合Mybatis的博客项目的步骤。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)