基于Java控制台+MySQL数据库的图书管理系统

package test; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Scanner; public class Book implements IAction { private String id; private String bookname; private String booktype; private String author; private String translator; private String publisher; private Date publish_time; private double price; private int stock; public static Connection conn; public static Statement stmt; public static ResultSet rs; public String getId() { return id; } public void setId(String id) { this.id = id; } public String getBookname() { return bookname; } public void setBookname(String bookname) { this.bookname = bookname; } public String getBooktype() { return booktype; } public void setBooktype(String booktype) { this.booktype = booktype; } public String getAuthor() { return author; } public void setAuthor(String author) { this.author = author; } public String getTranslator() { return translator; } public void setTranslator(String translator) { this.translator = translator; } public String getPublisher() { return publisher; } public void setPublisher(String publisher) { this.publisher = publisher; } public Date getPublish_time() { return publish_time; } public void setPublish_time(Date publish_time) { this.publish_time = publish_time; } public double getPrice() { return price; } public void setPrice(double price) { this.price = price; } public int getStock() { return stock; } public void setStock(int stock) { this.stock = stock; } @Override public String toString() { return "图书编号:" + id + ", 图书名:" + bookname + ", 图书类型:" + booktype + ", 作者:" + author + ", 翻译:" + translator + ", 出版社:" + publisher + ", 出版时间:" + new SimpleDateFormat("yyyy-MM-dd").format(publish_time) + ", 价格:" + price + ", 库存:" + stock + "."; } public Book() throws SQLException { } public Book(String id, String bookname, String booktype, String author, String translator, String publisher, Date publish_time, double price, int stock) throws SQLException { this.id = id; this.bookname = bookname; this.booktype = booktype; this.author = author; this.translator = translator; this.publisher = publisher; this.publish_time = publish_time; this.price = price; this.stock = stock; } @Override public boolean add() { boolean flag = false; Scanner scanner = new Scanner(System.in); System.out.print("输入图书编号:"); String id = scanner.nextLine(); System.out.print("输入图书名称"); String bookname = scanner.nextLine(); System.out.print("输入图书类别"); String booktype = scanner.nextLine(); System.out.print("输入图书作者"); String author = scanner.nextLine(); System.out.print("输入图书译者"); String translator = scanner.nextLine(); System.out.print("输入图书出版社"); String publisher = scanner.nextLine(); System.out.print("输入图书定价"); double price = scanner.nextDouble(); System.out.print("输入图书库存数量"); int stock = scanner.nextInt(); Date date = new Date(); String insertBookSql = "insert into book values('" + id + "','" + bookname + "','" + booktype + "','" + author + "','" + translator + "','" + publisher + "','" + new SimpleDateFormat("yyyy-MM-dd").format(date) + "','" + price + "','" + stock + "')"; try { conn = JdbcUtils.getConnection(); stmt = conn.createStatement(); int i = stmt.executeUpdate(insertBookSql); if (i > 0) { flag = true; System.out.println(bookname + "已经添加成功"); } JdbcUtils.closeAll(rs, stmt, conn); } catch (SQLException e) { e.printStackTrace(); } return flag; } @Override public boolean del() { boolean delFlag = false; System.out.print("输入你要删除图书的编号:"); String num = new Scanner(System.in).nextLine(); String lookBookSql = "select * from book"; String delBookSql = "delete from book where id='" + num + "'"; try { conn = JdbcUtils.getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(lookBookSql); while (rs.next()) { stmt = conn.createStatement(); String id = rs.getString("id"); if (id.equals(num)) { int i = stmt.executeUpdate(delBookSql); if (i > 0) { System.out.println("删除成功!"); delFlag = true; } else { System.out.println("删除失败!"); } } } JdbcUtils.closeAll(rs, stmt, conn); } catch (SQLException e) { e.printStackTrace(); } return delFlag; } @Override public int getCount() { int count = 0; String countBookSql = "select count(*) from book"; try { conn = JdbcUtils.getConnection(); stmt = conn.createStatement(); count = stmt.executeUpdate(countBookSql); System.out.println("总共有：" + count + "本书"); JdbcUtils.closeAll(rs, stmt, conn); } catch (SQLException e) { e.printStackTrace(); } return count; } @Override public void getListInfo() { String bookInfoSql = "select * from book"; try { conn = JdbcUtils.getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(bookInfoSql); while (rs.next()) { String id = rs.getString("id"); String bookname = rs.getString("bookname"); String booktype = rs.getString("booktype"); String author = rs.getString("author"); String translator = rs.getString("translator"); String publisher = rs.getString("publisher"); Date publish_time = rs.getDate("publish_time"); double price = rs.getDouble("price"); int stock = rs.getInt("stock"); Book book = new Book(id, bookname, booktype, author, translator, publisher, publish_time, price, stock); System.out.println(book.toString()); } JdbcUtils.closeAll(rs, stmt, conn); } catch (SQLException ex) { ex.printStackTrace(); } } @Override public boolean find() { boolean findFlag = false; System.out.print("输入你要查询图书的编号:"); String findId = new Scanner(System.in).nextLine(); String lookBookSql = "select * from book"; try { conn = JdbcUtils.getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(lookBookSql); while (rs.next()) { String id = rs.g