Java练手项目实战——图书管理系统（Java swing + JDBC）

桃扇骨 2023-10-02 09:18 51阅读 0赞

#### 目录 ####

*   *   *  基于Java swing的图书管理系统
         *   *   *  1、源码下载链接
                 *  2、效果展示
                 *  3、部分源码展示

#### 基于Java swing的图书管理系统 ####

###### 1、源码下载链接 ######

Gitee: [https://gitee.com/liu-yipin/book-management][https_gitee.com_liu-yipin_book-management].

###### 2、效果展示 ######

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16]

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 1]  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 2]  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 3]  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 4]

###### 3、部分源码展示 ######

bookDao.java

package com.dao;
    
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.util.ArrayList;
    
    
    
    import com.util.DbUtil;
    import com.view.delete_book_Frame;
    import com.model.book;
    import com.model.reader;
    
    public class bookDao {
        
    
    	private DbUtil dbUtil;
    	private Connection connection;
    	public ArrayList<book> getAll() {
        
    		ArrayList<book> arrayList = new ArrayList<>();
    		Statement stat;
    		
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			
    			stat = connection.createStatement();
    			String sql ="select *from book"; //
    			ResultSet rs=stat.executeQuery(sql);
    			
    			
    			while(rs.next()) {
        
    				//System.out.println("1111111111111");
    				book b = new book();
    				b.setBook_id(rs.getString(1));
    				b.setIsbn(rs.getString(2));
    				b.setBook_name(rs.getString(3));
    				b.setWriter(rs.getString(4));
    				b.setPublisher(rs.getString(5));
    				b.setPubdate(rs.getDate(6));
    				b.setBook_shelf_no(rs.getString(7));
    				b.setBook_status(rs.getInt(8));
    				b.setDel(rs.getInt(9));
    				arrayList.add(b);
    			}
    			
    			rs.close();
    			stat.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			// TODO: handle exception
    			return arrayList;
    		}
    		
    		return arrayList;
    	}
    	public ArrayList<book> findID(String id) {
        
    		ArrayList<book> arrayList = new ArrayList<>();
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			String sql ="select * from book where book_id = ? "; //
    			
    			PreparedStatement pre = connection.prepareStatement(sql);
    			pre.setString(1, id);
    			
    			
    			ResultSet rs=pre.executeQuery();
    			
    			while(rs.next()) {
        
    				book b = new book();
    				b.setBook_id(rs.getString(1));
    				b.setIsbn(rs.getString(2));
    				b.setBook_name(rs.getString(3));
    				b.setWriter(rs.getString(4));
    				b.setPublisher(rs.getString(5));
    				b.setPubdate(rs.getDate(6));
    				b.setBook_shelf_no(rs.getString(7));
    				b.setBook_status(rs.getInt(8));
    				b.setDel(rs.getInt(9));
    				arrayList.add(b);
    			}
    			rs.close();
    			pre.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			// TODO: handle exception
    			return arrayList;
    		}
    		return arrayList;
    	}
    	public void deleteBook(int choose, String id) {
        
    		
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			String sql=null; //
    			if(choose==0) {
        
    				sql ="delete from book where book_name = ? ";
    			} else if(choose==1){
        
    				sql ="delete from book where book_id = ? ";
    			} else {
        
    				sql ="delete from book where isbn = ? ";
    			}
    			PreparedStatement pre = connection.prepareStatement(sql);
    			pre.setString(1, id);
    			pre.executeUpdate();
    			pre.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			e.printStackTrace();
    		}
    		
    	}
    	public ArrayList<book> findName(String name) {
        
    		ArrayList<book> arrayList = new ArrayList<>();
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			String sql ="select * from book where book_name = ? "; //
    			
    			PreparedStatement pre = connection.prepareStatement(sql);
    			pre.setString(1, name);
    			
    			
    			ResultSet rs=pre.executeQuery();
    			
    			while(rs.next()) {
        
    				book b = new book();
    				b.setBook_id(rs.getString(1));
    				b.setIsbn(rs.getString(2));
    				b.setBook_name(rs.getString(3));
    				b.setWriter(rs.getString(4));
    				b.setPublisher(rs.getString(5));
    				b.setPubdate(rs.getDate(6));
    				b.setBook_shelf_no(rs.getString(7));
    				b.setBook_status(rs.getInt(8));
    				b.setDel(rs.getInt(9));
    				arrayList.add(b);
    			}
    			rs.close();
    			pre.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			// TODO: handle exception
    			return arrayList;
    		}
    		return arrayList;
    	}
    	public ArrayList<book> findPublisher(String publisher) {
        
    		ArrayList<book> arrayList = new ArrayList<>();
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			String sql ="select * from book where publisher = ? "; //
    			
    			PreparedStatement pre = connection.prepareStatement(sql);
    			pre.setString(1, publisher);
    			
    			
    			ResultSet rs=pre.executeQuery();
    			
    			while(rs.next()) {
        
    				book b = new book();
    				b.setBook_id(rs.getString(1));
    				b.setIsbn(rs.getString(2));
    				b.setBook_name(rs.getString(3));
    				b.setWriter(rs.getString(4));
    				b.setPublisher(rs.getString(5));
    				b.setPubdate(rs.getDate(6));
    				b.setBook_shelf_no(rs.getString(7));
    				b.setBook_status(rs.getInt(8));
    				b.setDel(rs.getInt(9));
    				arrayList.add(b);
    			}
    			rs.close();
    			pre.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			// TODO: handle exception
    			return arrayList;
    		}
    		return arrayList;
    	}
    	public ArrayList<book> findWriter(String writer) {
        
    		ArrayList<book> arrayList = new ArrayList<>();
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			String sql ="select * from book where writer = ? "; //
    			
    			PreparedStatement pre = connection.prepareStatement(sql);
    			pre.setString(1, writer);
    			
    			
    			ResultSet rs=pre.executeQuery();
    			
    			while(rs.next()) {
        
    				book b = new book();
    				b.setBook_id(rs.getString(1));
    				b.setIsbn(rs.getString(2));
    				b.setBook_name(rs.getString(3));
    				b.setWriter(rs.getString(4));
    				b.setPublisher(rs.getString(5));
    				b.setPubdate(rs.getDate(6));
    				b.setBook_shelf_no(rs.getString(7));
    				b.setBook_status(rs.getInt(8));
    				b.setDel(rs.getInt(9));
    				arrayList.add(b);
    			}
    			rs.close();
    			pre.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			// TODO: handle exception
    			return arrayList;
    		}
    		return arrayList;
    	}
    	public ArrayList<book> findISBN(String isbn) {
        
    		ArrayList<book> arrayList = new ArrayList<>();
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			String sql ="select * from book where isbn = ? "; //
    			
    			PreparedStatement pre = connection.prepareStatement(sql);
    			pre.setString(1, isbn);
    			
    			
    			ResultSet rs=pre.executeQuery();
    			
    			while(rs.next()) {
        
    				book b = new book();
    				b.setBook_id(rs.getString(1));
    				b.setIsbn(rs.getString(2));
    				b.setBook_name(rs.getString(3));
    				b.setWriter(rs.getString(4));
    				b.setPublisher(rs.getString(5));
    				b.setPubdate(rs.getDate(6));
    				b.setBook_shelf_no(rs.getString(7));
    				b.setBook_status(rs.getInt(8));
    				b.setDel(rs.getInt(9));
    				arrayList.add(b);
    			}
    			rs.close();
    			pre.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			// TODO: handle exception
    			return arrayList;
    		}
    		return arrayList;
    	}
    	public int addBookInfro(book newb) {
        
    		int ok = 0;
    		try {
        
    			dbUtil = new DbUtil();
    			connection = dbUtil.getCon();
    			String sql ="insert into book values(?,?,?,?,?,?,?,?,?) "; //
    			
    			PreparedStatement pre = connection.prepareStatement(sql);
    			pre.setString(1, newb.getBook_id());
    			pre.setString(2, newb.getIsbn());
    			pre.setString(3, newb.getBook_name());
    			pre.setString(4, newb.getWriter());
    			pre.setString(5, newb.getPublisher());
    			pre.setDate(6, newb.getPubdate());
    			pre.setString(7, newb.getBook_shelf_no());
    			pre.setInt(8, newb.getBook_status());
    			pre.setInt(9, newb.getDel());
    			
    			ok=pre.executeUpdate();
    			
    			
    			pre.close();
    			dbUtil.closeCon(connection);
    		} catch (Exception e) {
        
    			// TODO: handle exception
    			e.printStackTrace();
    		}
    		return ok;
    	}
    	public static void main(String[] args) {
        
    		new bookDao().deleteBook(1, "9");
    		if(new bookDao().returnBookDao("8", "201824100456") == 1) {
        
    			System.out.println("success");
    		}else {
        
    			System.out.println("failed");
    		}
    	}
    	/**
    	 * ļ¼
    	 * @param con
    	 * @return
    	 * @throws Exception
    	 */
    		public static ResultSet record(Connection con)throws Exception{
        
    			String sql="select book_name,reader_no,borrow_start_time,return_time from book,return_book where book.book_id=return_book.book_id";
    			PreparedStatement pstmt=con.prepareStatement(sql);
    			ResultSet rs=pstmt.executeQuery();
    			return rs;
    		}
    		
    
    		public book bookInfo(String book_id) {
        
    			
    			book newbook = null;
    			try {
        
    				dbUtil = new DbUtil();
    				connection = dbUtil.getCon();
    				String sql = "select book_name,book_status from book where book_id=? and del<>1";
    				PreparedStatement pre = connection.prepareStatement(sql);
    				pre.setString(1, book_id);
    				ResultSet rs=pre.executeQuery();
    				
    				newbook = new book();
    				newbook.setBook_id(book_id);
    				if(rs.next()) {
        
    					newbook.setBook_name(rs.getString(1));
    					newbook.setBook_status(rs.getInt(2));
    				}else {
        
    					return null;
    				}
    				rs.close();
    				pre.close();
    				dbUtil.closeCon(connection);
    				
    			}catch (Exception e) {
        
    				// TODO: handle exception
    				e.printStackTrace();
    			}
    			return newbook;
    			
    		}
    		
    		public boolean alterBookInfo(book newbook) {
        
    			
    			try {
        
    				dbUtil = new DbUtil();
    				connection = dbUtil.getCon();
    				String sqltest = "select * from book where book_id=? and del<>1";
    				PreparedStatement pretest = connection.prepareStatement(sqltest);
    				pretest.setString(1, newbook.getBook_id());
    				ResultSet rs=pretest.executeQuery();
    				if(!rs.next()) {
        
    					return false;
    				}
    				
    				if(newbook.getBook_name() != null) {
        
    					String sql = "update book set book_name='" + newbook.getBook_name() + "' where book_id='" + newbook.getBook_id() + "'";
    					PreparedStatement pre = connection.prepareStatement(sql);
    					pre.execute();
    				}
    				if(newbook.getBook_shelf_no() != null) {
        
    					String sql = "update book set book_shelf_no='" + newbook.getBook_shelf_no() + "' where book_id='" + newbook.getBook_id() + "'";
    					PreparedStatement pre = connection.prepareStatement(sql);
    					pre.execute();
    				}
    				if(newbook.getIsbn() != null) {
        
    					String sql = "update book set isbn='" + newbook.getIsbn() + "' where book_id='" + newbook.getBook_id() + "'";
    					//String sql = "update book set isbn=? where book_id=?";
    					PreparedStatement pre = connection.prepareStatement(sql);
    //					pre.setString(1, newbook.getIsbn());
    //					pre.setString(2, newbook.getBook_id());
    					pre.execute();
    				}
    				if(newbook.getWriter() != null) {
        
    					String sql = "update book set writer='" + newbook.getWriter() + "' where book_id='" + newbook.getBook_id() + "'";
    					PreparedStatement pre = connection.prepareStatement(sql);
    					pre.execute();
    				}
    				if(newbook.getPublisher() != null) {
        
    					String sql = "update book set publisher='" + newbook.getPublisher() + "' where book_id='" + newbook.getBook_id() + "'";
    					PreparedStatement pre = connection.prepareStatement(sql);
    					pre.execute();
    				}
    				
    				String sql = "update book set del='" + newbook.getDel() + "', book_status='" + newbook.getBook_status() + "' where book_id='" + newbook.getBook_id() + "'";
    				PreparedStatement pre = connection.prepareStatement(sql);
    //				pre.setString(1, book_id);
    				pre.execute();
    				
    //				rs.close();
    				pre.close();
    				dbUtil.closeCon(connection);
    				return true;
    			}catch (Exception e) {
        
    				// TODO: handle exception
    				e.printStackTrace();
    				return false;
    			}
    		}
    		
    		public int borrowBookDao(String book_id, String reader_id) {
        
    			int isBorrow, isDel;
    			try {
        
    				dbUtil = new DbUtil();
    				connection = dbUtil.getCon();
    				String sql = "select * from book where book_id=? and del<>1";
    				PreparedStatement pretest = connection.prepareStatement(sql);
    				pretest.setString(1, book_id);
    				ResultSet rs=pretest.executeQuery();
    				if(!rs.next()) {
        
    					return 0;
    				}else {
        
    					isBorrow = Integer.parseInt(rs.getString(8));
    					isDel = Integer.parseInt(rs.getString(9));
    					if(isBorrow == 1 || isDel == 1) {
        
    						return -1;
    					}
    				}
    				sql = "select * from reader where reader_no=? and del<>1";
    				pretest = connection.prepareStatement(sql);
    				pretest.setString(1, reader_id);
    				rs=pretest.executeQuery();
    				int borrownum = 0;
    				if(!rs.next()) {
        
    					return 0;
    				}else {
        
    					borrownum = Integer.parseInt(rs.getString(7));
    					isDel = Integer.parseInt(rs.getString(9));
    					if(borrownum <= 0 || isDel == 1) {
        
    						return -2;
    					}
    				}
    				
    				String sql1 = "select borrow_id from borrow";
    				PreparedStatement pre1 = connection.prepareStatement(sql1);
    				rs = pre1.executeQuery();
    				int borrowid = -1;
    				while(rs.next()) {
        
    					if(Integer.parseInt(rs.getString(1))+1 > borrowid)
    						borrowid = Integer.parseInt(rs.getString(1))+1;
    				}
    				if(borrowid == -1) {
        
    					return 0;
    				}
    				
    				sql1 = "select can_borrow_days from reader_type, reader where reader_no ='" + reader_id + "' and reader.reader_type=reader_type.reader_type";
    				pre1 = connection.prepareStatement(sql1);
    				rs = pre1.executeQuery();
    				int may_borrow_day = 0;
    				
    				if(rs.next()) {
        
    					may_borrow_day = Integer.parseInt(rs.getString(1));
    				}else {
        
    					return 0;
    				}
    				java.util.Date date = new java.util.Date(); 
    				java.sql.Date sql_date = new java.sql.Date(date.getTime()); 
    				
    				sql = "insert into borrow values(?, ?, ?, ?, ?)";
    				pretest = connection.prepareStatement(sql);
    				pretest.setString(1, String.valueOf(borrowid));
    				pretest.setString(2, book_id);
    				pretest.setString(3, reader_id);
    				
    				pretest.setDate(4, sql_date);
    				pretest.setInt(5, may_borrow_day);
    				int result = pretest.executeUpdate();
    				pretest.close();
    				dbUtil.closeCon(connection);
    				return result;
    			}catch (Exception e) {
        
    				// TODO: handle exception
    				e.printStackTrace();
    				return 0;
    			}
    		}
    		
    		public int returnBookDao(String book_id, String reader_id) {
        
    			
    			int isBorrow, isDel;
    			try {
        
    				dbUtil = new DbUtil();
    				connection = dbUtil.getCon();
    				String sql = "select * from book where book_id=? and del<>1";
    				PreparedStatement pretest = connection.prepareStatement(sql);
    				pretest.setString(1, book_id);
    				ResultSet rs=pretest.executeQuery();
    				if(!rs.next()) {
        
    					return 0;
    				}else {
        
    					isBorrow = Integer.parseInt(rs.getString(8));
    					isDel = Integer.parseInt(rs.getString(9));
    					if(isBorrow == 0 || isDel == 1) {
        
    						return -1;
    					}
    				}
    				sql = "select * from reader where reader_no=? and del<>1";
    				pretest = connection.prepareStatement(sql);
    				pretest.setString(1, reader_id);
    				rs=pretest.executeQuery();
    				int borrownum = 0;
    				if(!rs.next()) {
        
    					return 0;
    				}else {
        
    					borrownum = Integer.parseInt(rs.getString(5));
    					isDel = Integer.parseInt(rs.getString(9));
    					if(borrownum <= 0 || isDel == 1) {
        
    						return -2;
    					}
    				}
    				
    				String sql1 = "select return_id from `return_book`";
    				PreparedStatement pre1 = connection.prepareStatement(sql1);
    				rs = pre1.executeQuery();
    				int returnid = -1;
    				while(rs.next()) {
        
    					if(Integer.parseInt(rs.getString(1))+1 > returnid)
    						returnid = Integer.parseInt(rs.getString(1))+1;
    				}
    				if(returnid == -1) {
        
    					return 0;
    				}
    				
    				
    				sql = "insert into return_book(return_id, book_id, reader_no) values(?, ?, ?)";
    				pretest = connection.prepareStatement(sql);
    				pretest.setString(1, String.valueOf(returnid));
    				pretest.setString(2, book_id);
    				pretest.setString(3, reader_id);
    				int result = pretest.executeUpdate();
    				pretest.close();
    				dbUtil.closeCon(connection);
    				return result;
    			}catch (Exception e) {
        
    				// TODO: handle exception
    				e.printStackTrace();
    				return 0;
    			}
    			
    		}
    
    }

book.java

package com.model;
    /**
     * ͼʵ
     * @author ASUS
     *
     */
    
    import java.sql.Date;
    
    public class book {
        
    	private String book_id;
    	private String isbn;
    	private String book_name;
    	private String writer;
    	private String publisher;
    	private Date pubdate;
    	private String book_shelf_no;
    	private int book_status;
    	private int del;
    	
    	public String getBook_id() {
        
    		return book_id;
    	}
    	public void setBook_id(String book_id) {
        
    		this.book_id = book_id;
    	}
    	public String getIsbn() {
        
    		return isbn;
    	}
    	public void setIsbn(String isbn) {
        
    		this.isbn = isbn;
    	}
    	public String getBook_name() {
        
    		return book_name;
    	}
    	public void setBook_name(String book_name) {
        
    		this.book_name = book_name;
    	}
    	public String getWriter() {
        
    		return writer;
    	}
    	public void setWriter(String writer) {
        
    		this.writer = writer;
    	}
    	public String getPublisher() {
        
    		return publisher;
    	}
    	public void setPublisher(String publisher) {
        
    		this.publisher = publisher;
    	}
    	public Date getPubdate() {
        
    		return pubdate;
    	}
    	public void setPubdate(Date pubdate) {
        
    		this.pubdate = pubdate;
    	}
    	public String getBook_shelf_no() {
        
    		return book_shelf_no;
    	}
    	public void setBook_shelf_no(String book_shelf_no) {
        
    		this.book_shelf_no = book_shelf_no;
    	}
    	public int getBook_status() {
        
    		return book_status;
    	}
    	public void setBook_status(int book_status) {
        
    		this.book_status = book_status;
    	}
    	public int getDel() {
        
    		return del;
    	}
    	public void setDel(int del) {
        
    		this.del = del;
    	}
    	
    }

addbook\_Frame.java

package com.view;
    
    import java.awt.EventQueue;
    
    import javax.swing.JFrame;
    import javax.swing.JPanel;
    import java.awt.BorderLayout;
    import javax.swing.JLabel;
    import javax.swing.JOptionPane;
    import javax.swing.ImageIcon;
    import javax.swing.GroupLayout;
    import javax.swing.GroupLayout.Alignment;
    import javax.swing.LayoutStyle.ComponentPlacement;
    import javax.swing.border.TitledBorder;
    
    import com.dao.bookDao;
    import com.dao.shelfDao;
    import com.model.book;
    import com.model.book_shelf;
    
    import java.awt.Color;
    import javax.swing.UIManager;
    import java.awt.Font;
    import java.util.ArrayList;
    import java.util.Calendar;
    
    import javax.swing.JComboBox;
    import javax.swing.JTextField;
    import javax.swing.JButton;
    import java.awt.event.ActionListener;
    import java.sql.Date;
    import java.awt.event.ActionEvent;
    
    public class addbook_Frame{
        
    	 JFrame jf=new JFrame() ;
    	private JTextField nameText;
    	private JTextField bnoText;
    	private JTextField isbnText;
    	private JTextField publisherText;
    	private JTextField writerText;
    	private JComboBox typeBox;
    	private ArrayList<book_shelf> res;
    	private JTextField yearText;
    	private JTextField monthText;
    	private JTextField dayText;
    	/**
    	 * Create the frame.
    	 * @wbp.parser.entryPoint
    	 */
    	public void init() {
        
    		jf.setTitle("\u6DFB\u52A0\u56FE\u4E66");
    		jf.setBounds(100, 100, 743, 735);
    		
    		JPanel panel = new JPanel();
    		jf.getContentPane().add(panel, BorderLayout.WEST);
    		
    		JLabel lblNewLabel = new JLabel("New label");
    		lblNewLabel.setIcon(new ImageIcon(addbook_Frame.class.getResource("/img/table_head.jpg")));
    		
    		JPanel panel_1 = new JPanel();
    		panel_1.setToolTipText("");
    		panel_1.setForeground(new Color(0, 0, 0));
    		panel_1.setBorder(new TitledBorder(UIManager.getBorder("TitledBorder.border"), "\u6DFB\u52A0\u56FE\u4E66\u4FE1\u606F", TitledBorder.LEFT, TitledBorder.TOP, null, new Color(0, 0, 0)));
    		GroupLayout gl_panel = new GroupLayout(panel);
    		gl_panel.setHorizontalGroup(
    			gl_panel.createParallelGroup(Alignment.LEADING)
    				.addGroup(gl_panel.createSequentialGroup()
    					.addGroup(gl_panel.createParallelGroup(Alignment.LEADING)
    						.addComponent(lblNewLabel, GroupLayout.PREFERRED_SIZE, 727, GroupLayout.PREFERRED_SIZE)
    						.addGroup(gl_panel.createSequentialGroup()
    							.addContainerGap()
    							.addComponent(panel_1, GroupLayout.PREFERRED_SIZE, 698, GroupLayout.PREFERRED_SIZE)))
    					.addContainerGap(324, Short.MAX_VALUE))
    		);
    		gl_panel.setVerticalGroup(
    			gl_panel.createParallelGroup(Alignment.LEADING)
    				.addGroup(gl_panel.createSequentialGroup()
    					.addComponent(lblNewLabel, GroupLayout.PREFERRED_SIZE, 293, GroupLayout.PREFERRED_SIZE)
    					.addPreferredGap(ComponentPlacement.UNRELATED)
    					.addComponent(panel_1, GroupLayout.PREFERRED_SIZE, 381, Short.MAX_VALUE)
    					.addGap(7))
    		);
    		
    		JLabel label = new JLabel("\u56FE\u4E66\u7C7B\u522B\uFF1A");
    		label.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		typeBox = new JComboBox();
    		typeBox.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		setBookSheltInfro();
    		JLabel label_1 = new JLabel("\u56FE\u4E66\u540D\u79F0\uFF1A");
    		label_1.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		JLabel label_1_1 = new JLabel("\u56FE  \u4E66  \u53F7\uFF1A");
    		label_1_1.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		nameText = new JTextField();
    		nameText.setColumns(10);
    		
    		bnoText = new JTextField();
    		bnoText.setColumns(10);
    		
    		JLabel label_2_1 = new JLabel("isbn    \u53F7\uFF1A");
    		label_2_1.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		isbnText = new JTextField();
    		isbnText.setColumns(10);
    		
    		JLabel label_2_2 = new JLabel("\u51FA  \u7248  \u793E\uFF1A");
    		label_2_2.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		publisherText = new JTextField();
    		publisherText.setColumns(10);
    		
    		JButton button = new JButton("\u786E\u8BA4");
    		button.addActionListener(new ActionListener() {
        
    			public void actionPerformed(ActionEvent e) {
        
    				addAction(e);
    			}
    		});
    		button.setIcon(new ImageIcon(addbook_Frame.class.getResource("/icon/device-floppy\u4FDD\u5B58.png")));
    		
    		JLabel label_1_2 = new JLabel("\u56FE\u4E66\u4F5C\u8005\uFF1A");
    		label_1_2.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		writerText = new JTextField();
    		writerText.setColumns(10);
    		
    		JLabel lblNewLabel_1 = new JLabel("\u51FA\u7248\u65E5\u671F\uFF1A");
    		lblNewLabel_1.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		JLabel lblNewLabel_2 = new JLabel("\u5E74");
    		lblNewLabel_2.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		yearText = new JTextField();
    		yearText.setColumns(10);
    		
    		JLabel lblNewLabel_3 = new JLabel("\u6708");
    		lblNewLabel_3.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		monthText = new JTextField();
    		monthText.setColumns(10);
    		
    		JLabel lblNewLabel_4 = new JLabel("\u65E5");
    		lblNewLabel_4.setFont(new Font("微软雅黑", Font.PLAIN, 18));
    		
    		dayText = new JTextField();
    		dayText.setColumns(10);
    		GroupLayout gl_panel_1 = new GroupLayout(panel_1);
    		gl_panel_1.setHorizontalGroup(
    			gl_panel_1.createParallelGroup(Alignment.LEADING)
    				.addGroup(gl_panel_1.createSequentialGroup()
    					.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING)
    						.addGroup(gl_panel_1.createSequentialGroup()
    							.addGap(59)
    							.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING)
    								.addGroup(gl_panel_1.createSequentialGroup()
    									.addComponent(label)
    									.addGap(18)
    									.addComponent(typeBox, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
    								.addGroup(gl_panel_1.createSequentialGroup()
    									.addComponent(label_1, GroupLayout.PREFERRED_SIZE, 90, GroupLayout.PREFERRED_SIZE)
    									.addGap(18)
    									.addComponent(nameText, GroupLayout.PREFERRED_SIZE, 121, GroupLayout.PREFERRED_SIZE))
    								.addGroup(gl_panel_1.createSequentialGroup()
    									.addComponent(label_1_1, GroupLayout.PREFERRED_SIZE, 94, GroupLayout.PREFERRED_SIZE)
    									.addPreferredGap(ComponentPlacement.UNRELATED)
    									.addComponent(bnoText, GroupLayout.PREFERRED_SIZE, 121, GroupLayout.PREFERRED_SIZE))
    								.addGroup(gl_panel_1.createSequentialGroup()
    									.addComponent(lblNewLabel_1)
    									.addGap(18)
    									.addComponent(lblNewLabel_2)
    									.addPreferredGap(ComponentPlacement.UNRELATED)
    									.addComponent(yearText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)))
    							.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING)
    								.addGroup(gl_panel_1.createSequentialGroup()
    									.addGap(74)
    									.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING, false)
    										.addGroup(gl_panel_1.createSequentialGroup()
    											.addComponent(label_2_2, GroupLayout.PREFERRED_SIZE, 94, GroupLayout.PREFERRED_SIZE)
    											.addPreferredGap(ComponentPlacement.RELATED)
    											.addComponent(publisherText))
    										.addGroup(gl_panel_1.createSequentialGroup()
    											.addComponent(label_2_1, GroupLayout.PREFERRED_SIZE, 94, GroupLayout.PREFERRED_SIZE)
    											.addPreferredGap(ComponentPlacement.RELATED)
    											.addComponent(isbnText, GroupLayout.PREFERRED_SIZE, 121, GroupLayout.PREFERRED_SIZE))
    										.addGroup(gl_panel_1.createSequentialGroup()
    											.addComponent(label_1_2, GroupLayout.PREFERRED_SIZE, 90, GroupLayout.PREFERRED_SIZE)
    											.addPreferredGap(ComponentPlacement.RELATED)
    											.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING)
    												.addGroup(gl_panel_1.createSequentialGroup()
    													.addComponent(lblNewLabel_4)
    													.addGap(18)
    													.addComponent(dayText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
    												.addComponent(writerText)))))
    								.addGroup(gl_panel_1.createSequentialGroup()
    									.addGap(18)
    									.addComponent(lblNewLabel_3)
    									.addGap(27)
    									.addComponent(monthText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))))
    						.addGroup(gl_panel_1.createSequentialGroup()
    							.addGap(291)
    							.addComponent(button)))
    					.addContainerGap(103, Short.MAX_VALUE))
    		);
    		gl_panel_1.setVerticalGroup(
    			gl_panel_1.createParallelGroup(Alignment.LEADING)
    				.addGroup(gl_panel_1.createSequentialGroup()
    					.addGap(39)
    					.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
    						.addComponent(label)
    						.addComponent(typeBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
    						.addComponent(label_2_1, GroupLayout.PREFERRED_SIZE, 24, GroupLayout.PREFERRED_SIZE)
    						.addComponent(isbnText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
    					.addGap(35)
    					.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
    						.addComponent(label_1, GroupLayout.PREFERRED_SIZE, 24, GroupLayout.PREFERRED_SIZE)
    						.addComponent(nameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
    						.addComponent(label_2_2, GroupLayout.PREFERRED_SIZE, 24, GroupLayout.PREFERRED_SIZE)
    						.addComponent(publisherText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
    					.addGap(47)
    					.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
    						.addComponent(label_1_1, GroupLayout.PREFERRED_SIZE, 24, GroupLayout.PREFERRED_SIZE)
    						.addComponent(bnoText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
    						.addComponent(label_1_2, GroupLayout.PREFERRED_SIZE, 24, GroupLayout.PREFERRED_SIZE)
    						.addComponent(writerText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
    					.addGap(18)
    					.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
    						.addComponent(lblNewLabel_1)
    						.addComponent(lblNewLabel_2)
    						.addComponent(yearText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
    						.addComponent(lblNewLabel_3)
    						.addComponent(monthText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
    						.addComponent(lblNewLabel_4)
    						.addComponent(dayText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
    					.addGap(68)
    					.addComponent(button, GroupLayout.PREFERRED_SIZE, 36, GroupLayout.PREFERRED_SIZE)
    					.addContainerGap())
    		);
    		panel_1.setLayout(gl_panel_1);
    		panel.setLayout(gl_panel);
    		//设置窗体是否可改变
    		jf.setResizable(false);
    		//设置窗体可见
    		jf.setVisible(true);	
    		//设置JFrame居中显示
    		jf.setLocationRelativeTo(null);
    
    	}
    	protected void addAction(ActionEvent e) {
        
    		// TODO Auto-generated method stub
    		String idS = bnoText.getText().toString();
    		String typeS = typeBox.getSelectedItem().toString();
    		String nameS = nameText.getText().toString();
    		String writerS = writerText.getText().toString();
    		String publisherS = publisherText.getText().toString();
    		String isbnS = isbnText.getText().toString();
    		String yearS = yearText.getText().toString();
    		String monthS = monthText.getText().toString();
    		String dayS = dayText.getText().toString();
    		if(idS.equals("")||idS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(typeS.equals("")||typeS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(nameS.equals("")||nameS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(writerS.equals("")||writerS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(publisherS.equals("")||publisherS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(isbnS.equals("")||isbnS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(yearS.equals("")||yearS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(dayS.equals("")||dayS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		if(monthS.equals("")||monthS==null) {
        
    			JOptionPane.showMessageDialog(null, "请填写完整信息");
    			return;
    		}
    		book newbook = new book();
    		newbook.setBook_name(nameS);
    		newbook.setWriter(writerS);
    		newbook.setBook_id(idS);
    		newbook.setPublisher(publisherS);
    		newbook.setBook_status(0);
    		newbook.setDel(0);
    		for(book_shelf bs : res) {
        
    			if(bs.getBooks_type().equals(typeS)) {
        
    				newbook.setBook_shelf_no(bs.getBook_shelf_no());
    				break;
    			}
    		}
    		newbook.setIsbn(isbnS);
    		
    		int year = Integer.parseInt(yearS.trim());//去掉空格  
            int month = Integer.parseInt(monthS.trim());  
            int day = Integer.parseInt(dayS.trim());  
            Calendar c = Calendar.getInstance();//获取一个日历实例  
            c.set(year, month-1, day);//设定日历的日期
            java.util.Date date1 = c.getTime();
            java.sql.Date date = new Date(date1.getTime());
            newbook.setPubdate(date);
            
            int ok = new bookDao().addBookInfro(newbook);
            if(ok==1) {
        
            	JOptionPane.showMessageDialog(null, "成功添加书籍信息");
            	return;
            } else {
        
            	JOptionPane.showMessageDialog(null, "添加书籍信息失败，请仔细核对信息");
            	return;
            }
    	}
    	protected void setBookSheltInfro() {
        
    		res = new shelfDao().getAll();
    		for(book_shelf b : res) {
        
    			typeBox.addItem(b.getBooks_type());
    		}
    	}
    	public static void main(String[] args) {
        
    		new addbook_Frame().init();
    	}
    }

[https_gitee.com_liu-yipin_book-management]: https://gitee.com/liu-yipin/book-management
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/a174c312151d40799fe347f6c032001b.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA54ix5omT576955CD55qE56CB54y_,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/e19ac4545ce0456d815ca76149d33cba.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA54ix5omT576955CD55qE56CB54y_,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/063e637f1d554913850feb6a0955ef65.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA54ix5omT576955CD55qE56CB54y_,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/a49e91adc7264f039c2a96b896e34c54.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA54ix5omT576955CD55qE56CB54y_,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA54ix5omT576955CD55qE56CB54y_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/d75b0482387545cd98a1892e8451a482.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA54ix5omT576955CD55qE56CB54y_,size_20,color_FFFFFF,t_70,g_se,x_16