图书管理系统小程序.rar

package com.cn.cx.util; import com.cn.cx.util.bean.*; import java.sql.*; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; public class Dao { static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://localhost:3306/htuser?useUnicode=true&amp;characterEncoding=UTF-8"; static final String USER = "root"; static final String PASS = "123"; //搜索书的全部信息-----小程序首页全部书籍 public static ArrayList<BookInfo> searchbook() { Connection conn = null; Statement stmt = null; ArrayList<BookInfo> rst = new ArrayList<BookInfo>(); try { Class.forName(JDBC_DRIVER); System.out.println("allInfo:正在连接数据库......"); conn = DriverManager.getConnection(DB_URL, USER, PASS); stmt = conn.createStatement(); StringBuffer sql = new StringBuffer("select book.xuhao,bookname,zongliang,yuliang,sj_number,leixing,image FROM book,book_image where book.xuhao=book_image.xuhao"); ResultSet rs = stmt.executeQuery(sql.toString()); while (rs.next()) { BookInfo dto = new BookInfo(); dto.setXuhao(rs.getInt("xuhao")); dto.setBookname(rs.getString("bookname")); dto.setZongliang(rs.getInt("zongliang")); dto.setYuliang(rs.getInt("yuliang")); dto.setSj_number(rs.getString("sj_number")); dto.setLeixing(rs.getString("leixing")); dto.setImage(rs.getString("image")); rst.add(dto); } rs.close(); stmt.close(); conn.close(); System.out.println(" allInfo:连接数据库成功......"); } catch (SQLException se) { se.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { if (stmt != null) stmt.close(); } catch (SQLException se2) { } try { if (conn != null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } } return rst; } //搜索好书信息-----对应小程序活动板块 public static ArrayList<GoodBook> searchgoodbook() { Connection conn = null; Statement stmt = null; ArrayList<GoodBook> rst = new ArrayList<GoodBook>(); try { Class.forName(JDBC_DRIVER); System.out.println("goodbook:连接数据库......"); conn = DriverManager.getConnection(DB_URL, USER, PASS); stmt = conn.createStatement(); StringBuffer sql = new StringBuffer("select * FROM good_book"); ResultSet rs = stmt.executeQuery(sql.toString()); while (rs.next()) { GoodBook dto = new GoodBook(); dto.setId(rs.getInt("id")); dto.setTitle(rs.getString("title")); dto.setUser_id(rs.getString("user_id")); dto.setUser_content(rs.getString("user_content")); dto.setTime(rs.getString("time")); dto.setImage(rs.getString("image")); rst.add(dto); } rs.close(); stmt.close(); conn.close(); System.out.println(" goodbook:连接数据库成功......"); } catch (SQLException se) { se.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { if (stmt != null) stmt.close(); } catch (SQLException se2) { } try { if (conn != null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } } return rst; } //二维码借书功能-----插入数据表book中 public void insertbook(String xuhao) { Connection conn = null; Statement stmt = null; ArrayList<GoodBook> rst = new ArrayList<GoodBook>(); try { Class.forName(JDBC_DRIVER); System.out.println("连接数据库......"); conn = DriverManager.getConnection(DB_URL, USER, PASS); stmt = conn.createStatement(); StringBuffer sql = new StringBuffer("insert into book(xuhao) values(" + xuhao + ")"); ResultSet rs = stmt.executeQuery(sql.toString()); rs.close(); stmt.close(); conn.close(); System.out.println("连接数据库成功......"); } catch (SQLException se) { se.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { if (stmt != null) stmt.close(); } catch (SQLException se2) { } try { if (conn != null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } } return; } //通过扫一扫进行显示对应书籍的全部内容 public static ArrayList<BookInfo> saoyisao(String xuhao) { Connection conn = null; Statement stmt = null; ArrayList<BookInfo> rst = new ArrayList<BookInfo>(); try { Class.forName(JDBC_DRIVER); System.out.println("saoyisao:连接数据库......"); conn = DriverManager.getConnection(DB_URL, USER, PASS); stmt = conn.createStatement(); // int shu=Integer.parseInt(xuhao); StringBuffer sql = new StringBuffer("select book.xuhao,bookname,zongliang,yuliang,sj_number,leixing,image from book,book_image where book.xuhao='" + xuhao + "' and book.xuhao=book_image.xuhao"); ResultSet rs = stmt.executeQuery(sql.toString()); while (rs.next()) { BookInfo dto = new BookInfo(); dto.setXuhao(rs.getInt("xuhao")); dto.setBookname(rs.getString("bookname")); dto.setZongliang(rs.getInt("zongliang")); dto.setYuliang(rs.getInt("yuliang")); dto.setSj_number(rs.getString("sj_number")); dto.setLeixing(rs.getString("leixing")); dto.setImage(rs.getString("image")); rst.add(dto); } rs.close(); stmt.close(); conn.close(); System.out.println(" saoyisao:连接数据库成功......"); } catch (SQLException se) { se.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { if (stmt != null) stmt.close(); } catch (SQLException se2) { } try { if (conn != null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } } return rst; } //搜索对应书籍的信息———计算机、数学、中文、外语、护理、体育、经济 public static ArrayList<BookInfo> booktype(String leixing) { Connection conn = null; Statement stmt = null; // ArrayList<BookInfo> rst = new ArrayList<BookInfo>(); ArrayList<BookInfo> rst = new ArrayList<BookInfo>(); try { Class.forName(JDBC_DRIVER); System.out.println("booktype:连接数据库......"); conn = DriverManager.getConnection(DB_URL, USER, PASS); stmt = conn.createStatement(); StringBuffer sql = new StringBuffer("select book.xuhao,bookname,zongliang,yuliang,sj_number,leixing,image from book ,book_image where book.xuhao=book_image.xuhao and leixing='" + leixing + "'"); ResultSet rs = stmt.executeQuery(sql.toSt