数据库课程设计（图书馆管理系统）springboot+swing+mysql+mybatis

package com.eins.databasedemo.service; import com.eins.databasedemo.controller.WindowController; import com.eins.databasedemo.mapper.BooksMapper; import com.eins.databasedemo.pojo.Books; import com.eins.databasedemo.pojo.LendRecord; import com.eins.databasedemo.pojo.User; import org.apache.ibatis.annotations.Mapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.awt.*; import java.sql.*; import java.util.List; import java.util.Vector; @Service public class BooksService { @Autowired private BooksMapper booksMapper; private Connection con = WindowController.con; private PreparedStatement pstmt; private String sql; /** * 添加图书 * @param books */ public void InsertBook(Books books) { booksMapper.Insert(books); } /** * 查询全部图书 * @return */ public List<Books> list() { return booksMapper.list(); } /** * 查询出版社信息 * @return */ public Vector<String> getPublisher() { return booksMapper.getPublisher(); } /** * 删除图书 * @param id * @return */ public int deleteBooks(int id) { try{ booksMapper.deleteBooksById(id); } catch (Exception e) { return -1; } return 0; } /** * 检索图书 * @param con * @param name * @param author * @param publisher * @param radio * @return */ public Vector<String> selectBooks(Connection con,String name, String author, String publisher, String radio) { // Vector<String> books = new Vector<>(); // if(!name.equals("") && author.equals("")) { // if(radio.equals("模糊查询")) { // name = "%" + name + "%"; // } // Vector<String> v = booksMapper.selectByName(name); // } // if(!author.equals("")) { // // } this.con = con; Vector<String> result = new Vector<String>(); if(publisher.equals("null"))publisher = ""; sql = "select * from books"; int flag = 0; if (name.equals("")) { if (author.equals("")) { if (!publisher.equals("")) { sql += " where publisher like ?"; flag = 1; } } else { if (publisher.equals("")) { sql += " where author like ?"; flag = 2; } else { sql += " where author like ? and publisher like ?"; flag = 3; } } } else { if (author.equals("") && publisher.equals("")) { sql += " where name like ?"; flag = 4; } if (author.equals("") && !publisher.equals("")) { sql += " where name like ? and publisher like ?"; flag = 5; } if (!author.equals("") && publisher.equals("")) { sql += " where name like ? and author like ?"; flag = 6; } if (!author.equals("") && !publisher.equals("")) { sql += " where name like ? and author like ? and publisher like ?"; flag = 7; } } if (radio.equals("模糊查询")) { name = "%" + name + "%"; author = "%" + author + "%"; publisher = "%" + publisher + "%"; } try { pstmt = con.prepareStatement(sql); switch (flag) { case 0: break; case 1: pstmt.setString(1, publisher); break; case 2: pstmt.setString(1, author); break; case 3: pstmt.setString(1, author); pstmt.setString(2, publisher); break; case 4: pstmt.setString(1, name); break; case 5: pstmt.setString(1, name); pstmt.setString(2, publisher); break; case 6: pstmt.setString(1, name); pstmt.setString(2, author); break; case 7: pstmt.setString(1, name); pstmt.setString(2, author); pstmt.setString(3, publisher); break; } ResultSet rs = pstmt.executeQuery(); String str = ""; while (rs.next()) { for (int i = 1; i <= 10/* rs.getMetaData().getColumnCount() */; i++) { if (i == 1 || i == 8 || i == 10) { if (i == 1) { str += "序号: " + rs.getInt(i) + "; "; } if (i == 8) { str += "此书的总数量: " + rs.getInt(i) + "; "; } if (i == 10) { str += "存放时间: " + rs.getDate(i) + " " + rs.getTime(i) + ";"; } } else { if (i == 2) { str += "书号: "; } if (i == 3) { str += "书名: "; } if (i == 4) { str += "作者: "; } if (i == 5) { str += "出版社: "; } if (i == 6) { str += "出版日期: "; } if (i == 7) { str += "位置: "; } if (i == 9) { str += "借出数量: "; } str += rs.getString(i).trim() + "; "; } } str = str.substring(0, str.length()); result.add(str); str = ""; } } catch (SQLException e) { System.out.println("查询数据库出错"); System.out.println(e); } return result; } /** * 修改图书 * @param bookInfo1 * @param id * @return */ public int updateBook(Connection con,Vector<String> bookInfo1, String id) { this.con = con; int Id = Integer.parseInt(id); //System.out.println(Id); sql = "update books set isbn = ?, name = ?, author = ?, publisher = ?, pubDate = ?, deposit = ?, quantify = ?, deposit_time = ? where id = ?"; // 存储sql语句 try { pstmt = con.prepareStatement(sql); // 预处理sql语句 for (int i = 1; i <= bookInfo1.size(); i++) {// 循环遍历得到录入内容 //System.out.println(bookInfo1.elementAt(i - 1).trim()); if (i == 7) { // 录入书本数量为整数，要转化为整数 pstmt.setInt(i, Integer.parseInt(bookInfo1.elementAt(i - 1).trim()));// elmentAt返回指定索引处的组件。 } else { // 录入内容为字符串 pstmt.setString(i, bookInfo1.elementAt(i - 1).trim()); } } pstmt.setInt(bookInfo1.size() + 1, Id); pstmt.executeUpdate(); // 更新数据库 retu