文件上传

    <!--文件上传-->
    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>1.3.3</version>
    </dependency>

    <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>2.6</version>
    </dependency>

    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
        <!--设置请求编码格式-->
        <property name="defaultEncoding" value="utf-8"></property>
        <!--设置允许上传的文件的最大值,单位为字节-->
        <property name="maxInMemorySize" value="8388608"></property>
    </bean>

    @RequestMapping("/addBook")
    public String addBook(Book book, @RequestParam("uploadFile") MultipartFile uploadFile, HttpServletRequest request){
        //判断上传文件是否存在
        if(!uploadFile.isEmpty()){
            //获取文件原始名称
            String originalFilename = uploadFile.getOriginalFilename();
            //设置上传文件的保存目录
            String dirPath = request.getServletContext().getRealPath("/images/");
            File filePath = new File(dirPath);
            //如果保存的文件不错在，就先创建目录
            if(!filePath.exists()){
                filePath.mkdirs();
            }
            //使用uuid重新命名上传的文件名称（uuid_原始文件名称）
            String savePath = UUID.randomUUID()+"_"+originalFilename;
            try {
                uploadFile.transferTo(new File(dirPath+savePath));
            } catch (IOException e) {
                e.printStackTrace();
            }
            book.setPicturePath("images/"+savePath);
            String bookCode = UUID.randomUUID().toString().replace("-", "");
            book.setBookCode(bookCode);
            bookService.addBook(book);
        }
        return "book/addBook";
    }

CREATE TABLE book_tb
(
id INT(11) PRIMARY KEY AUTO_INCREMENT,    id（自增）
bookName VARCHAR(50) NOT NULL,              书名
author VARCHAR(50) NOT NULL,                      作者名
description VARCHAR(200) NOT NULL,              简介
press VARCHAR(20) NOT NULL,                        出版社
creatDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP() NOT NULL,                入库日期（自生）
inventory INT(5) NOT NULL,                             库存
typeId INT(11) NOT NULL,                              类型id
bookCode VARCHAR(32) NOT NULL,              书籍编码（uuid32位）
picturePath VARCHAR(200) NOT NULL,          书籍图片路径
price DOUBLE(7,2) NOT NULL,                         价格
salesNumber INT(5) NOT NULL                      
)

ALTER TABLE book_tb ADD create_date  TIMESTAMP DEFAULT CURRENT_TIMESTAMP() NOT NULL

ALTER TABLE book_tb ADD sale_state INT(1) NOT NULL       销售状态（1在售 0下架）

DELETE FROM book_tb  

CREATE TABLE book_type_tb
(
id INT(11) PRIMARY KEY AUTO_INCREMENT,
typeName VARCHAR(20) NOT NULL
)

ALTER TABLE book_tb ADD CONSTRAINT type_of_book FOREIGN KEY(typeId) REFERENCES book_type_tb(id)