java图书

学习目标：

mavel版mybatis连接数据库

---

---

学习产出：

package test;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.jdbc.SQL;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class Test {
    public static void main(String[] args) throws IOException {
        String resource = "mybatis.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        SqlSession SQLSession = sqlSessionFactory.openSession();


        while (true) {
            System.out.println("1.展示书籍");
            System.out.println("2.上新书籍");
            System.out.println("3.下架书籍");
            System.out.println("4.退出应用");
            Scanner sc = new Scanner(System.in);
            System.out.print("请输入序号；");
            int choice = sc.nextInt();
            SqlSession sqlSession = sqlSessionFactory.openSession();
            if (choice == 1) {
                List list = SQLSession.selectList("findBook");
                if(list.size() == 0) {
                    System.out.println("书籍库没有存入书籍");
                }else {
                    for(int i=0;i<=list.size()-1;i++) {
                        Book b = (Book)(list.get(i));
                        System.out.println(b.getId()+"----" + b.getBook()+"----" +  b.getName());
                    }
                }

            }
            if (choice == 2) {
                System.out.println("请输入书籍ID：");
                int id = sc.nextInt();
                System.out.println("请输入书籍名称：");
                String book = sc.next();
                System.out.println("请输入作者名称：");
                String name = sc.next();
                Book e = new Book();
                e.setId(id);
                e.setName(name);
                e.setBook(book);
                SQLSession.insert("topBook",e);

            }
            if (choice == 3) {
                System.out.println("请输入要删除的书籍ID：");
                int bookId = sc.nextInt();
                sc.nextLine(); // 处理nextInt后的换行符

                // 调用SQLSession的delete方法，注意方法名应与Mapper XML中定义的id匹配
                int rowsDeleted = SQLSession.delete("deleteBook", bookId);
                if (rowsDeleted > 0) {
                    System.out.println("书籍已成功下架！");
                } else {
                    System.out.println("书籍下架失败，可能是因为书籍ID不存在。");
                }

            }
            if (choice == 4) {
                System.out.println("4.退出应用");
                break;
            }
        }

    }
}

package test;

public class Book{
    private int id;
    private String book;
    private String name;

    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getBook() {
        return book;
    }
    public void setBook(String book) {
        this.book = book;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }


}

```bookmapper.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="org.mybatis.example.BlogMapper">
    <select id="findBook" resultType="Book">
        select * from test
    </select>
    <insert id="topBook">
        INSERT INTO test (id, book, name) VALUES (#{id}, #{book}, #{name})
    </insert>
    <delete id="deleteBook">
        DELETE FROM test WHERE id = #{id}
    </delete>
</mapper>

db.properties
url=jdbc:mysql://localhost:3306/book
driver=com.mysql.cj.jdbc.Driver
username=root
password=root``

```c mybatis.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="db.properties"/>
    <typeAliases>
        <package name="test"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mapper/bookmapper.xml"/>
    </mappers>
</configuration>

例如：

 - [x] 技术笔记 2 遍
 - [x] 优快云 技术博客 3 篇
 - [x] 习的 vlog 视频 1 个