Java与MySQL合作！制作一个简易的BookStore（Dao模式）

 

1.创建Book和BookStore类

package com.oracle.java200229a;

import java.sql.*;

public class Book {
    private Integer b_id;
    private String b_name;
    private int b_price;
    private Blob b_img;

    public Book() {

    }

    public Book(Integer b_id, String b_name, int b_price, Blob b_img) {
        super();
        this.b_id = b_id;
        this.b_name = b_name;
        this.b_price = b_price;
        this.b_img = b_img;
    }

    public Integer getB_id() {
        return b_id;
    }

    public void setB_id(Integer b_id) {
        this.b_id = b_id;
    }

    public String getB_name() {
        return b_name;
    }

    public void setB_name(String b_name) {
        this.b_name = b_name;
    }

    public int getB_price() {
        return b_price;
    }

    public void setB_price(int b_price) {
        this.b_price = b_price;
    }

    public Blob getB_img() {
        return b_img;
    }

    public void setB_img(Blob b_img) {
        this.b_img = b_img;
    }

    @Override
    public String toString() {
        return "Book [b_id=" + b_id + ", b_name=" + b_name + ", b_price=" + b_price + ", b_img=" + b_img + "]";
    }

}

BookStore类

package com.oracle.java200229a;

public class BookStore {

    private Integer bs_id;

    private Integer bs_count;

    public BookStore() {

    }

    public BookStore(Integer bs_id, Integer bs_count) {
        super();
        this.bs_id = bs_id;

        this.bs_count = bs_count;
    }

    public Integer getBs_id() {
        return bs_id;
    }

    public void setBs_id(Integer bs_id) {
        this.bs_id = bs_id;
    }

    public Integer getBs_count() {
        return bs_count;
    }

    public void setBs_count(Integer bs_count) {
        this.bs_count = bs_count;
    }

    @Override
    public String toString() {
        return "BookStore [bs_id=" + bs_id + ", bs_count=" + bs_count + "]";
    }

}

2.创建book和bookStore的Dao模式接口，进行封装bookshop要完成的功能:

package com.oracle.java200229a;

import java.util.*;

//import com.oracle.java200229.JdbcUtil;

public interface BookDao {
    public Integer insert(Book book) throws Exception;

    public void upData(Book book) throws Exception;

    public boolean delete(Integer id) throws Exception;

    public List<Book> searchAll() throws Exception;

    public Book searchOne(Integer id) throws Exception;
}
 

package com.oracle.java200229a;

import java.util.List;

public interface BookStoreDao {

    public Boolean insertBs(Integer id,Integer count) throws Exception;

    public boolean upDataBs(Integer id,Integer count) throws Exception;

    public void deleteBs(Integer id) throws Exception;

    public List<BookStore> searchAll() throws Exception;

    public BookStore searchOne(Integer id) throws Exception;

}
3.bookImple，bookStoreImple分别继承 他们俩的接口，完成里面所有方法：

package com.oracle.java200229a;

import java.sql.*;
import java.util.*;

import com.oracle.java200229.JdbcUtil;;

public class BookImple implements BookDao {

    private class BookConvertor implements Convertor<Book> {

        @Override
    public Book convert(ResultSet rs) throws Exception {
            // TODO Auto-generated method stub
            Book b = new Book();
            b.setB_id(rs.getInt(1));
            b.setB_name(rs.getString(2));
            b.setB_price(rs.getInt(3));
            b.setB_img(rs.getBlob(4));
            r