图书信息的增删改查

最新推荐文章于 2021-05-22 11:31:45 发布

置顶

一路归途

最新推荐文章于 2021-05-22 11:31:45 发布

阅读量2.5k

点赞数

分类专栏： JAVA 文章标签： java

本文链接：https://blog.csdn.net/qq_45963003/article/details/112383428

版权

实现增删改查具体代码

编写配置文件我们在上一节已经配置好了，接下来就是从底层编写图书信息代码
实现用户的增删改查

BookDao

public interface BookDao {
   
//查询图书信息
List<Book> finaAllBook();
//删除数据操作
@Delete("delete from bookinfo where bid=#{bid}")//使用注解方式进行配置
void delBook(int bid);
//新增图书信息
void savebook(Book book);
//修改图书操作
void updatebook(Book book);
}

BookDao.xml(执行SQL语句)

<?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">
<!--namespace的值习惯上设置成包名+sql映射文件名，
这样就能够保证namespace的值是唯一的-->
<mapper namespace="com.dao.BookDao">
<select id="finaAllBook" resultType="com.entity.Book" parameterType="com.entity.Book">
select * from bookinfo order by bid asc
</select>
<insert id="savebook" parameterType="com.entity.Book">
insert into bookinfo (bname,bprice,bpublish) values (#{
   bname},#{
   bprice},#{
   bpublish})
</insert>
<update id="updatebook" parameterType="com.entity.Book">
update bookinfo set bname=#{
   bname},bprice=#{
   bprice},bpublish=#{
   bpublish}
where bid=#{
   bid}
</update>
</mapper>

编写Book实体类

Book

package com.entity;

/**
* @author 爱敲代码的小白
* @date 2020/12/8 14:09
*/
public class Book {
   
private Integer bid;
private String bname;
private Float bprice;
private String bpublish;

public Book() {
   
}

public Book(Integer bid, String bname, Float bprice, String bpublish) {
   
this.bid = bid;
this.bname = bname;
this.bprice = bprice;
this.bpublish = bpublish;
}

public Integer getBid() {
   
return bid;
}

public void setBid(Integer bid) {
   
this.bid = bid;
}

public String getBname() {
   
return bname;
}

public void setBname(String bname) {
   
this.bname = bname;
}

public Float getBprice() {
   
return bprice;
}

public void setBprice(Float bprice)