springmyboot+batis的代码写一个,带有依赖,yml配置,mapper.xml,entity,mapper,service,controller,application
时间: 2024-05-06 14:19:32 浏览: 7
这里是一个示例的Spring Boot + MyBatis项目的代码,包括了依赖、YAML配置文件、Mapper.xml文件、实体类、Mapper接口、Service层、Controller层和应用程序入口。
pom.xml:
```xml
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.23</version>
</dependency>
</dependencies>
```
application.yml:
```yaml
spring:
datasource:
username: root
password: password
url: jdbc:mysql://localhost:3306/mydatabase
driver-class-name: com.mysql.jdbc.Driver
mybatis:
mapper-locations: classpath:mapper/*.xml
```
User.java:
```java
public class User {
private Long id;
private String name;
private Integer age;
// getter and setter methods
}
```
UserMapper.java:
```java
@Mapper
public interface UserMapper {
@Select("SELECT * FROM users WHERE id = #{id}")
User getUserById(Long id);
@Insert("INSERT INTO users(name, age) VALUES(#{name}, #{age})")
@Options(useGeneratedKeys = true, keyProperty = "id")
void insertUser(User user);
}
```
UserService.java:
```java
@Service
public class UserService {
@Autowired
private UserMapper userMapper;
public User getUserById(Long id) {
return userMapper.getUserById(id);
}
public void insertUser(User user) {
userMapper.insertUser(user);
}
}
```
UserController.java:
```java
@RestController
@RequestMapping("/users")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/{id}")
public User getUserById(@PathVariable Long id) {
return userService.getUserById(id);
}
@PostMapping("/")
public void insertUser(@RequestBody User user) {
userService.insertUser(user);
}
}
```
Application.java:
```java
@SpringBootApplication
@MapperScan("com.example.demo.mapper")
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
```
users.xml:
```xml
<mapper namespace="com.example.demo.mapper.UserMapper">
<select id="getUserById" parameterType="java.lang.Long" resultType="com.example.demo.entity.User">
SELECT * FROM users WHERE id = #{id}
</select>
<insert id="insertUser" parameterType="com.example.demo.entity.User">
INSERT INTO users(name, age) VALUES(#{name}, #{age})
</insert>
</mapper>
```