基于ssm写的图书管理系统中的图书库存量管理和更新的代码
时间: 2024-02-22 13:59:45 浏览: 23
这是一个基于SSM框架的图书库存量管理和更新的代码示例:
1. BookMapper.xml
```xml
<!-- 查询图书信息 -->
<select id="getBookByBookId" resultMap="bookResultMap">
select * from tb_book where book_id = #{bookId}
</select>
<!-- 更新图书库存 -->
<update id="updateBookStock" parameterType="map">
update tb_book set stock = #{newStock} where book_id = #{bookId}
</update>
```
2. BookMapper.java
```java
public interface BookMapper {
// 查询图书信息
Book getBookByBookId(String bookId);
// 更新图书库存
int updateBookStock(Map<String, Object> map);
}
```
3. BookServiceImpl.java
```java
@Service
public class BookServiceImpl implements BookService {
@Autowired
private BookMapper bookMapper;
// 根据图书ID查询图书信息
@Override
public Book getBookByBookId(String bookId) {
return bookMapper.getBookByBookId(bookId);
}
// 更新图书库存
@Override
public boolean updateBookStock(String bookId, int newStock) {
Map<String, Object> map = new HashMap<>();
map.put("bookId", bookId);
map.put("newStock", newStock);
int result = bookMapper.updateBookStock(map);
return result > 0;
}
}
```
4. BookController.java
```java
@RestController
@RequestMapping("/book")
public class BookController {
@Autowired
private BookService bookService;
// 查询图书信息
@GetMapping("/{bookId}")
public Book getBookByBookId(@PathVariable String bookId) {
return bookService.getBookByBookId(bookId);
}
// 更新图书库存
@PutMapping("/{bookId}/{newStock}")
public boolean updateBookStock(@PathVariable String bookId, @PathVariable int newStock) {
return bookService.updateBookStock(bookId, newStock);
}
}
```
以上代码中,BookMapper.xml中定义了两个SQL语句,getBookByBookId用于查询图书信息,updateBookStock用于更新图书库存。BookMapper.java中定义了两个对应的方法。BookServiceImpl.java中实现了这两个方法,并且在updateBookStock方法中使用了Map来传递参数。BookController.java中定义了两个API,用于查询图书信息和更新图书库存。