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

基于Java swing的图书管理系统

1、源码下载链接

Gitee: https://gitee.com/liu-yipin/book-management.

2、效果展示

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();
	}
}