1. 首页首页
  2. 编程汇总编程汇总

2025年基于Java swing+mysql+eclipse的【图书管理系统】

编程汇总 • • 阅读 14

基于Java swing+mysql+eclipse的【图书管理系统】本项目为 Java swing 项目 在工作环境中基本使用不到 但是很多学校把这个当做编程入门的项目来做 故分享出本项目供初学者参考 CSDN 赞助下载 https download csdn net download weixin 一 效果演示 主要功能 基本数据维护 图书类别管理 图书类别添加 图书类别维护 图书管理

本项目为Java swing项目，在工作环境中基本使用不到，但是很多学校把这个当做编程入门的项目来做，故分享出本项目供初学者参考。
CSDN赞助下载：https://download.csdn.net/download/weixin_44893902/20367467

一、效果演示：

主要功能：

①基本数据维护：
图书类别管理 >> 图书类别添加、图书类别维护
图书管理 >> 图书添加、图书维护
②关于我们

1、登录界面

2、主界面：

3、图书类别维护

4、图书类别添加

5、图书维护

6、图书添加

7、关于我们


可全部缩小到左下角

二、核心代码：

1、Util包 【存放数据库连接工具】

① DBTool（数据库连接工具类）

package cn.ac.azure.util;



import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Properties;



/** * 数据库连接工具类 * @author 明金同学 * */

public class DBTool { 

   
private static String driver;  //数据库驱动
private static String url;  //数据库连接地址
private static String user; //数据库连接用户
private static String password;  //数据库连接密码

static{ 

   
	//新建一个properties,用于读取db.properties配置文件
	Properties p=new Properties();
	//新建一个字符串,保存配置文件的路径
	String path="cn//ac//azure//util//db.properties";
	try { 

   
		//调用Properties.load通过类加载获得配置文件的输入流
		p.load(DBTool.class.getClassLoader().getResourceAsStream(path));
		//读取配置文件中的配置参数
		driver=p.getProperty("driver");  //获取驱动
		url=p.getProperty("url");  //获取数据库连接地址
		user=p.getProperty("user");  //获取数据库用户
		password=p.getProperty("password");  //获取数据库密码
		try { 

   
			//加载数据库驱动类到程序中
			Class.forName(driver);
		} catch (ClassNotFoundException e) { 

   
			e.printStackTrace();
			throw new RuntimeException("加载驱动失败",e);
		}
	} catch (IOException e) { 

   
		e.printStackTrace();
		throw new RuntimeException("找不到配置文件",e);
	}
}
/** * 获取数据库连接 * @return 数据库连接对象 * @throws SQLException 提醒调用者捕获异常,并在finally中关闭关闭异常 */
public static Connection getConnetion() throws SQLException{ 

   
	//通过DriverManager获得数据库连接
	return DriverManager.getConnection(url, user, password);
}
/** * 关闭数据库连接 * @param con */
public static void close(Connection con){ 

   
	if(con!=null){ 

    //如果数据连接不为空
		try { 

   
			//关闭数据库连接
			con.close();
		} catch (SQLException e) { 

   
			e.printStackTrace();
			throw new RuntimeException("数据库关闭失败",e);
		}
	}
}

// /**

// * 测试数据库连接工具是否可用

// * @param args

// */

// public static void main(String[] args) { 

   

// Connection con=null;

// try { 

   

// con=DBTool.getConnetion();

// System.out.println("数据库连接成功!");

// } catch (SQLException e) { 

   

// System.out.println("数据库连接失败!");

// e.printStackTrace();

// }finally{ 

   

// DBTool.close(con);

// }

// }

}

② db.properties（配置文件）

2、model包 【存放实体类】

① Book（图书实体类）

 package cn.ac.azure.model;

/** * 图书实体 * @author 明金同学 * */

public class Book { 

   
private Integer id;  //图书id
private String bookName;  //图书名称
private String author;  //图书作者
private String sex;     //作者性别
private Float price;    //图书价格
private Integer bookTypeId;  //图书类别ID
private String bookTypeName;  //图书类别名称
private String bookDesc;  //图书描述
public Book() { 

   
	super();
}
public Book(Integer id, String bookName, String author, String sex, Float price, Integer bookTypeId,
		String bookTypeName, String bookDesc) { 

   
	super();
	this.id = id;
	this.bookName = bookName;
	this.author = author;
	this.sex = sex;
	this.price = price;
	this.bookTypeId = bookTypeId;
	this.bookTypeName = bookTypeName;
	this.bookDesc = bookDesc;
}

public Integer getId() { 

   
	return id;
}
public void setId(Integer id) { 

   
	this.id = id;
}
public String getBookName() { 

   
	return bookName;
}
public void setBookName(String bookName) { 

   
	this.bookName = bookName;
}
public String getAuthor() { 

   
	return author;
}
public void setAuthor(String author) { 

   
	this.author = author;
}
public String getSex() { 

   
	return sex;
}
public void setSex(String sex) { 

   
	this.sex = sex;
}
public Float getPrice() { 

   
	return price;
}
public void setPrice(Float price) { 

   
	this.price = price;
}
public Integer getBookTypeId() { 

   
	return bookTypeId;
}
public void setBookTypeId(Integer bookTypeId) { 

   
	this.bookTypeId = bookTypeId;
}
public String getBookTypeName() { 

   
	return bookTypeName;
}
public void setBookTypeName(String bookTypeName) { 

   
	this.bookTypeName = bookTypeName;
}
public String getBookDesc() { 

   
	return bookDesc;
}
public void setBookDesc(String bookDesc) { 

   
	this.bookDesc = bookDesc;
}

@Override
public String toString() { 

   
	return "Book [测试=" + id + ", bookName=" + bookName + ", author=" + author + ", sex=" + sex + ", price=" + price
			+ ", bookTypeId=" + bookTypeId + ", bookTypeName=" + bookTypeName + ", bookDesc=" + bookDesc + "]";
}


}

② BookType（图书类别实体类）

package cn.ac.azure.model;

/** * 图书类别实体 * @author 明金同学 * */

public class BookType { 

   
private int id;  //定义ID
private String bookTypeName;  //定义图书类别名称
private String bookTypeDesc;  //定义图书类别描述
//无参构造器
public BookType() { 

   


}
//有参构造函数
public BookType(String bookTypeName, String bookTypeDesc) { 

   
	super();
	this.bookTypeName = bookTypeName;
	this.bookTypeDesc = bookTypeDesc;
}

public BookType(int id, String bookTypeName, String bookTypeDesc) { 

   
	super();
	this.id = id;
	this.bookTypeName = bookTypeName;
	this.bookTypeDesc = bookTypeDesc;
}

public int getId() { 

   
	return id;
}
public void setId(int id) { 

   
	this.id = id;
}
public String getBookTypeName() { 

   
	return bookTypeName;
}
public void setBookTypeName(String bookTypeName) { 

   
	this.bookTypeName = bookTypeName;
}
public String getBookTypeDesc() { 

   
	return bookTypeDesc;
}
public void setBookTypeDesc(String bookTypeDesc) { 

   
	this.bookTypeDesc = bookTypeDesc;
}
@Override
public String toString() { 

   
	return "BookType [id=" + id + ", bookTypeName=" + bookTypeName + ", bookTypeDesc=" + bookTypeDesc + "]";
}

}

③ User（用户实体类）

package cn.ac.azure.model;

/** * 用户实体 * @author 明金同学 * */

public class User { 

   
private int id;              //用户id
private String username;     //用户名称
private String password;     //用户密码

public User() { 

   
	
}

@Override
public String toString() { 

   
	return "User [id=" + id + ", username=" + username + ", password=" + password + "]";
}


public User(String username, String password) { 

   
	super();
	this.username = username;
	this.password = password;
}


public int getId() { 

   
	return id;
}
public void setId(int id) { 

   
	this.id = id;
}
public String getUsername() { 

   
	return username;
}
public void setUsername(String username) { 

   
	this.username = username;
}
public String getPassword() { 

   
	return password;
}
public void setPassword(String password) { 

   
	this.password = password;
}


}

3、Dao包 【数据库访问层】

① BookDao（图书dao类）

package cn.ac.azure.dao;



import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;



import cn.ac.azure.model.Book;



/** * 图书dao类 * @author 明金同学 * */

public class BookDao { 

   
/** * 图书添加 * @param con 数据库库连接对象 * @param book 添加的图书对象 * @return 返回添加操作的数据库记录数 * @throws SQLException 抛出数据库异常 */
public int add(Connection con,Book book) throws SQLException{ 

   
	//拼写sql插入语句
	String sql="insert into t_book values(null,'"+book.getBookName()+"','"+book.getAuthor()+"','"+book.getSex()+"','"+book.getPrice()+"','"+book.getBookTypeId()+"','"+book.getBookTypeName()+"','"+book.getBookDesc()+"')";
	System.out.println(sql);
	//获得预编译对象ps
	
	PreparedStatement ps=con.prepareStatement(sql);
	//设置ps参数
	/*ps.setString(1,book.getBookName()); //设置图书名称 ps.setString(2,book.getAuthor()); //设置图书作者 ps.setString(3, book.getSex()); //设置作者性别 ps.setFloat(4, book.getPrice()); //设置图书价格 ps.setInt(5, book.getBookTypeId()); //设置图书类别ID ps.setString(6, book.getBookDesc()); //设置图书描述 */		//执行sql语句，并返回插入的记录数
	return ps.executeUpdate();
}
/** * 图书查询 * @param con 数据库连接对象 * @param book 图书对象 * @return 查询的结果集 * @throws SQLException 抛出数据库异常 */
public ResultSet search(Connection con,Book book) throws SQLException{ 

   
	//定义图书名称
	String bookName=null;
	//定义图书作者
	String author=null;
	//定义图书类别名称
	String bookTypeName=null;
	//如果图书不为空的话，就为前三个字段赋值，按照条件查询
	if(book!=null){ 

   
		bookName=book.getBookName();
		author=book.getAuthor();
		bookTypeName=book.getBookTypeName();
	}
	//定义一个字符串缓冲对象类存储查询添加
	StringBuilder sb=new StringBuilder("select * from t_book b , t_bookType bt where b.bookTypeId=bt.id ");
	//查询条件有图书名称
	if(!(bookName==null || "".equals(bookName.trim()))){ 

   
		sb.append("and b.bookName like '%"+bookName+"%' ");
	}
	//查询条件有图书作者
	if(!(author==null || "".equals(author.trim()))){ 

   
		sb.append("and b.author like '%"+author+"%' ");
	}
	//查询条件有图书类别名称
	if(!(bookTypeName==null || "".equals(bookTypeName.trim()))){ 

   
		sb.append("and bt.bookTypeName like '%"+bookTypeName+"%' ");
	}
	//从sb生成sql语句
	String sql=sb.toString();
	//获取预处理对象
	PreparedStatement ps=con.prepareStatement(sql);
	//执行查询，并返回结果集
	return ps.executeQuery();
}
/** * 图书修改 * @param con 数据库连接对象 * @param book 修改的图书对象 * @return 返回修改改变的记录数 * @throws SQLException 抛出数据库异常，同时提醒调用者关闭数据库 */
public int update(Connection con,Book book) throws SQLException{ 

   
	//编写sql语句
	String sql="update t_book set bookName=?,author=?,sex=?,"
			+ "price=?,bookTypeId=?,bookDesc=? where id=?";
	//获取预编译对象ps
	PreparedStatement ps=con.prepareStatement(sql);
	//设置ps对象 
	ps.setString(1, book.getBookName()); //图书名称
	ps.setString(2, book.getAuthor());   //图书作者
	ps.setString(3,book.getSex()); //作者性别
	ps.setFloat(4, book.getPrice()); //图书价格
	ps.setInt(5, book.getBookTypeId());  //图书类型Id
	ps.setString(6, book.getBookDesc()); //图书描述
	ps.setInt(7, book.getId());
	//执行修改并返回改变的记录数
	return ps.executeUpdate(); 
}

/** * 图书删除 * @param con 数据库连接对象 * @param id 删除图书的id * @return 返回删除的记录数 * @throws SQLException 抛出数据库异常，同时提醒调用者关闭数据库 */
public int delete(Connection con,int id) throws SQLException{ 

   
	//编写sql语句
	String sql="delete from t_book where id=?";
	//获取预编译对象ps
	PreparedStatement ps=con.prepareStatement(sql);
	//设置ps参数
	ps.setInt(1, id);
	//执行DML删除语句并返回删除的记录数
	return ps.executeUpdate();
}

}

② BookTypeDao（图书类别dao类）

package cn.ac.azure.dao;





import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;



import cn.ac.azure.model.BookType;



/** * 图书类别dao类 * @author 明金同学 * */

public class BookTypeDao { 

   
/** * 图书类别添加 * @param con 数据库连接对象 * @param bookType 要添加的图书类别 * @return 返回数据库操作的记录数 * @throws SQLException */
public int add(Connection con,BookType bookType) throws SQLException{ 

   
	//拼写sql插入语句
	String sql="insert into t_bookType values(null,?,?)";
	//创建预编译对象ps
	PreparedStatement ps=con.prepareStatement(sql);
	//设置ps参数
	ps.setString(1, bookType.getBookTypeName()); //设置bookTypeName
	ps.setString(2, bookType.getBookTypeDesc()); //设置bookTypeDesc
	//返回数据库操作的记录数
	return ps.executeUpdate();
}
/** * 图书类别查询 * @param con 数据库连接对象 * @param bookType 查询的图书类别 * @return 返回查询的结果集 * @throws SQLException 抛出数据库异常 */
public ResultSet search(Connection con,BookType bookType) throws SQLException{ 

   
	/* * 思路：当jdbc查询数据库有多个条件从外部输入时，这是最好创建一个字符串缓冲类来添加条件到sql语句中。 * 同时，不知道有哪些条件是第一条件，无法确定where关键字的所在，于是添加条件都用（and 条件） * 最后字符串转换成字符串时在将第一个and替换成where */
	//定义一个图书类别名称
	String bookTypeName=null;
	if(bookType!=null){ 

    //如果类别对象不为空的话，就获取它的类别名称
		bookTypeName=bookType.getBookTypeName();
	}
	//创建一个字符串缓冲类
	StringBuilder sb=new StringBuilder("select * from t_bookType");
	//添加查询语句的条件（and + 条件）
	if(!(bookTypeName==null || "".equals(bookTypeName.trim()))){ 

   
		//jdbc中，数据库字符串要用单引号括起来
		sb.append(" and bookTypeName like '%"+bookType.getBookTypeName()+"%'");
	}
	//将字符串缓冲对象转换成字符串，同时把第一个and替换成where
	String sql=sb.toString().replaceFirst("and", "where");   
	//获取预编译对象
	PreparedStatement ps=con.prepareStatement(sql);
	//返回ps执行查询之后的结果集
	return ps.executeQuery();
}
/** * 图书类别修改 * @param con 数据路连接对象 * @param bookType 要修改的图书类别 * @return 返回数据库更新的记录数 * @throws SQLException 抛出数据库异常 */
public int update(Connection con,BookType bookType) throws SQLException{ 

   
	//拼写sql更新语句
	String sql="update t_bookType set bookTypeName=? , bookTypeDesc=? where id=?";
	//获取预编译对象ps
	PreparedStatement ps=con.prepareStatement(sql);
	//设置ps参数
	ps.setString(1,bookType.getBookTypeName());
	ps.setString(2,bookType.getBookTypeDesc());
	ps.setInt(3, bookType.getId());
	//赶回ps更新数据库的记录数
	return ps.executeUpdate();
}
/** * 删除数据库记录 * @param con 数据库连接对象 * @param id 传入删除记录的id * @return 返回删除的记录数 * @throws SQLException 抛出数据库异常 */
public int delete(Connection con,String id) throws SQLException{ 

   
	//拼写sql删除语句
	String sql="delete from t_bookType where id=?";
	//获取预编译对象ps
	PreparedStatement ps=con.prepareStatement(sql);
	//设置ps参数
	ps.setString(1, id);
	//执行ps更行操作，并返回改变的数据记录条数
	return ps.executeUpdate();
}

}

③ UserDao（用户数据访问对象）

package cn.ac.azure.dao;



import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;



import cn.ac.azure.model.User;



/** * 用户数据访问对象 * @author 明金同学 * */

public class UserDao { 

   
/** * 登录验证 * @param con 数据库连接对象 * @param user 登录的账户 * @return 返回一个用户对象,为null,则登录失败;反之,则登录成功 * @throws Exception 让调用者处理异常 */
public User login(Connection con,User user) throws SQLException{ 

   
	//定义一个返回用户对象
	User resultUser=null;
	//拼写sql查询语句
	String sql="select * from t_user where username=? and password=?";
	//获取sql语句预编译对象
	PreparedStatement ps=con.prepareStatement(sql);
	//设置ps参数
	ps.setString(1, user.getUsername());
	ps.setString(2, user.getPassword());
	//ps执行sql查询语句返回结果集
	ResultSet rs=ps.executeQuery();
	//遍历结果集
	while(rs.next()){ 

   
		//初始化返回用户对象
		resultUser=new User(); 
		resultUser.setId(rs.getInt("id"));    //设置用户id
		resultUser.setUsername(rs.getString("username"));  //设置用户名称
		resultUser.setPassword(rs.getString("password"));  //设置用户密码
	}
	//返回用户对象
	return resultUser;
}

}

4、View包 【视图层】

① LoginFrame（登录界面）

package cn.ac.azure.view;



import java.awt.EventQueue;

import java.awt.Font;

import java.awt.Toolkit;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.SQLException;



import javax.swing.GroupLayout;

import javax.swing.GroupLayout.Alignment;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JPasswordField;

import javax.swing.JTextField;

import javax.swing.LayoutStyle.ComponentPlacement;

import javax.swing.UIManager;

import javax.swing.UnsupportedLookAndFeelException;

import javax.swing.border.EmptyBorder;



import cn.ac.azure.dao.UserDao;

import cn.ac.azure.model.User;

import cn.ac.azure.util.DBTool;



public class LoginFrame extends JFrame { 

   
static { 

   
	try { 

   
		// 这里是皮肤包可以随意切换

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.mcwin.McWinLookAndFeel");
		 javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.smart.SmartLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.luna.LunaLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.aluminium.AluminiumLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.bernstein.BernsteinLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.hifi.HiFiLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.aero.AeroLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.mint.MintLookAndFeel");
	} catch (ClassNotFoundException | InstantiationException | IllegalAccessException
			| UnsupportedLookAndFeelException e) { 

   
		e.printStackTrace();
	}
}



private JPanel contentPane;
private JTextField usernameText;
private JPasswordField passwordText;
private JButton loginBtn;
private JButton resetBtn;




/** * Launch the application. */
public static void main(String[] args) { 

   
	EventQueue.invokeLater(new Runnable() { 

   
		public void run() { 

   
			try { 

   
				LoginFrame frame = new LoginFrame();
				frame.setVisible(true);
			} catch (Exception e) { 

   
				e.printStackTrace();
			}
		}
	});
}
/** * Create the frame. */
public LoginFrame() { 

   
	//改变系统默认字体
	Font font = new Font("Dialog", Font.PLAIN, 12);
	java.util.Enumeration keys = UIManager.getDefaults().keys();
	while (keys.hasMoreElements()) { 

   
		Object key = keys.nextElement();
		Object value = UIManager.get(key);
		if (value instanceof javax.swing.plaf.FontUIResource) { 

   
			UIManager.put(key, font);
		}
	}
	setIconImage(Toolkit.getDefaultToolkit().getImage(LoginFrame.class.getResource("/images/logo.png")));
	setResizable(false);
	setTitle("管理员登录");
	setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	setBounds(100, 100, 450, 300);
	contentPane = new JPanel();
	contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
	setContentPane(contentPane);
	
	JLabel lblNewLabel = new JLabel("\u56FE\u4E66\u7BA1\u7406\u7CFB\u7EDF");
	lblNewLabel.setFont(new Font("宋体", Font.BOLD, 22));
	lblNewLabel.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/logo.png")));
	
	JLabel lblNewLabel_1 = new JLabel("用户名 :");
	lblNewLabel_1.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/userName.png")));
	
	usernameText = new JTextField();
	usernameText.setColumns(10);
	
	JLabel lblNewLabel_2 = new JLabel("密 码 :");
	lblNewLabel_2.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/password.png")));
	
	passwordText = new JPasswordField();
	
	//添加登陆按钮
	loginBtn = new JButton("登录");
	loginBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			loginActionPerformed(e);
		}
	});
	loginBtn.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/login.png")));
	
	//添加重置按钮
	resetBtn = new JButton("重置");
	resetBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			resetActionPerformed(e);
		}
	});
	
	resetBtn.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/reset.png")));
	GroupLayout gl_contentPane = new GroupLayout(contentPane);
	gl_contentPane.setHorizontalGroup(
		gl_contentPane.createParallelGroup(Alignment.LEADING)
			.addGroup(gl_contentPane.createSequentialGroup()
				.addGap(106)
				.addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
					.addComponent(lblNewLabel)
					.addGroup(gl_contentPane.createSequentialGroup()
						.addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
							.addGroup(gl_contentPane.createSequentialGroup()
								.addPreferredGap(ComponentPlacement.RELATED)
								.addComponent(lblNewLabel_1)
								.addPreferredGap(ComponentPlacement.RELATED)
								.addComponent(usernameText, GroupLayout.PREFERRED_SIZE, 142, GroupLayout.PREFERRED_SIZE))
							.addGroup(gl_contentPane.createSequentialGroup()
								.addComponent(lblNewLabel_2)
								.addPreferredGap(ComponentPlacement.UNRELATED)
								.addComponent(passwordText, GroupLayout.PREFERRED_SIZE, 144, GroupLayout.PREFERRED_SIZE))
							.addGroup(Alignment.TRAILING, gl_contentPane.createSequentialGroup()
								.addGap(16)
								.addComponent(loginBtn)
								.addPreferredGap(ComponentPlacement.RELATED, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
								.addComponent(resetBtn)))
						.addPreferredGap(ComponentPlacement.RELATED)))
				.addContainerGap(105, GroupLayout.PREFERRED_SIZE))
	);
	gl_contentPane.setVerticalGroup(
		gl_contentPane.createParallelGroup(Alignment.LEADING)
			.addGroup(gl_contentPane.createSequentialGroup()
				.addGap(25)
				.addComponent(lblNewLabel)
				.addGap(18)
				.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
					.addComponent(lblNewLabel_1)
					.addComponent(usernameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
				.addGap(18)
				.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
					.addComponent(lblNewLabel_2)
					.addComponent(passwordText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
				.addGap(29)
				.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
					.addComponent(loginBtn)
					.addComponent(resetBtn))
				.addContainerGap())
	);
	contentPane.setLayout(gl_contentPane);
	//设置窗口居中
	this.setLocationRelativeTo(null);
}
/** * 登录事件处理 * @param evt */
private void loginActionPerformed(ActionEvent evt) { 

   
	//从输入框获取用户名
	String username=usernameText.getText().trim();
	//从输入框获取密码
	String password=passwordText.getText().trim();
	//用户名不能为空或空字符串,否则结束事件处理
	if(username==null || "".equals(username)){ 

   
		JOptionPane.showMessageDialog(null, "用户名不能为空");
		return;
	}
	//用户名不能为空或空字符串否则结束事件处理
	if(password==null || "".equals(password)){ 

   
		JOptionPane.showMessageDialog(null, "密码不能为空");
		return;
	}
	//将从输入框获得信息新建一个对象
	User user=new User(username, password);
	//定义数据库连接
	Connection con=null;
	try { 

   
		//利用数据库工具类获取数据库连接
		con=DBTool.getConnetion();
		//新建一个用户数据访问对象
		UserDao userDao=new UserDao();
		//调用其登录验证方法获取一个用户对象
		User currUser=userDao.login(con, user);
		//判断返回的用户对象
		if(currUser!=null){ 

   //不为空,表示登录成功
			//进入主界面,并设置可见
			new MainFrame().setVisible(true);
			//释放当前窗口资源
			dispose();
		}else{ 

    //为空,表示登录不成功
			JOptionPane.showMessageDialog(null, "登录失败(u_u)");
		}
	} catch (SQLException e) { 

   
		e.printStackTrace();
		throw new RuntimeException("登录失败",e);
	}finally{ 

   
		//关闭数据库连接
		DBTool.close(con);
	}
}
/** * 重置事件处理 * @param evt */
private void resetActionPerformed(ActionEvent evt) { 

   
	usernameText.setText("");
	passwordText.setText("");
}

}
② MainFrame（主界面）
package cn.ac.azure.view;



import java.awt.BorderLayout;

import java.awt.Color;

import java.awt.EventQueue;

import java.awt.Font;



import javax.swing.ImageIcon;

import javax.swing.JDesktopPane;

import javax.swing.JFrame;

import javax.swing.JMenu;

import javax.swing.JMenuBar;

import javax.swing.JMenuItem;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.UIManager;

import javax.swing.UnsupportedLookAndFeelException;

import javax.swing.border.EmptyBorder;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;



public class MainFrame extends JFrame { 

   
static { 

   
	try { 

   
		// 这里是皮肤包可以随意切换

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.mcwin.McWinLookAndFeel");
		 javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.smart.SmartLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.luna.LunaLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.aluminium.AluminiumLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.bernstein.BernsteinLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.hifi.HiFiLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.aero.AeroLookAndFeel");

// javax.swing.UIManager.setLookAndFeel("com.jtattoo.plaf.mint.MintLookAndFeel");
	} catch (ClassNotFoundException | InstantiationException | IllegalAccessException
			| UnsupportedLookAndFeelException e) { 

   
		e.printStackTrace();
	}
}

private static final long serialVersionUID = 1L;

//定义内容窗格
private JPanel contentPane;
//定义桌面窗格
private JDesktopPane table;


/** * Launch the application. */
public static void main(String[] args) { 

   
	EventQueue.invokeLater(new Runnable() { 

   
		public void run() { 

   
			try { 

   
				MainFrame frame = new MainFrame();
				frame.setVisible(true);
			} catch (Exception e) { 

   
				e.printStackTrace();
			}
		}
	});
}


/** * Create the frame. */
public MainFrame() { 

   
	
	//改变系统默认字体
	Font font = new Font("Dialog", Font.PLAIN, 12);
	java.util.Enumeration keys = UIManager.getDefaults().keys();
	while (keys.hasMoreElements()) { 

   
		Object key = keys.nextElement();
		Object value = UIManager.get(key);
		if (value instanceof javax.swing.plaf.FontUIResource) { 

   
			UIManager.put(key, font);
		}
	}
	
	
	setTitle("\u56FE\u4E66\u7BA1\u7406\u7CFB\u7EDF\u4E3B\u754C\u9762");
	setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	setBounds(100, 100, 450, 300);
	
	JMenuBar menuBar = new JMenuBar();
	menuBar.setToolTipText("");
	setJMenuBar(menuBar);
	
	JMenu menu = new JMenu("\u57FA\u672C\u6570\u636E\u7EF4\u62A4 ");
	menu.setIcon(new ImageIcon(MainFrame.class.getResource("/images/base.png")));
	menuBar.add(menu);
	
	JMenu mnNewMenu = new JMenu("\u56FE\u4E66\u7C7B\u522B\u7BA1\u7406 ");
	mnNewMenu.setIcon(new ImageIcon(MainFrame.class.getResource("/images/bookTypeManager.png")));
	menu.add(mnNewMenu);
	
	//图书类别添加
	JMenuItem menuItem = new JMenuItem("\u56FE\u4E66\u7C7B\u522B\u6DFB\u52A0");
	menuItem.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			BookTypeAddInterFrame bookTypeAddInterFrame=new BookTypeAddInterFrame();
			bookTypeAddInterFrame.setVisible(true);
			table.add(bookTypeAddInterFrame);
		}
	});
	menuItem.setIcon(new ImageIcon(MainFrame.class.getResource("/images/add.png")));
	mnNewMenu.add(menuItem);
	
	//图书类别维护
	JMenuItem menuItem_1 = new JMenuItem("\u56FE\u4E66\u7C7B\u522B\u7EF4\u62A4");
	menuItem_1.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			BookTypeManageInterFrame bookTypeManageInterFrame=new BookTypeManageInterFrame();
			bookTypeManageInterFrame.setVisible(true);
			table.add(bookTypeManageInterFrame);
		}
	});
	menuItem_1.setIcon(new ImageIcon(MainFrame.class.getResource("/images/edit.png")));
	mnNewMenu.add(menuItem_1);
	
	JMenu menu_1 = new JMenu("\u56FE\u4E66\u7BA1\u7406");
	menu_1.setIcon(new ImageIcon(MainFrame.class.getResource("/images/bookManager.png")));
	menu.add(menu_1);
	
	//图书添加
	JMenuItem menuItem_2 = new JMenuItem("\u56FE\u4E66\u6DFB\u52A0");
	menuItem_2.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			BookAddInterFrame bookAddInterFrame=new BookAddInterFrame();
			bookAddInterFrame.setVisible(true);
			table.add(bookAddInterFrame);
		}
	});
	menuItem_2.setIcon(new ImageIcon(MainFrame.class.getResource("/images/add.png")));
	menu_1.add(menuItem_2);
	//图书维护
	JMenuItem menuItem_3 = new JMenuItem("\u56FE\u4E66\u7EF4\u62A4");
	menuItem_3.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			BookManageInterFrame bookManageInterFrame=new BookManageInterFrame();
			bookManageInterFrame.setVisible(true);
			table.add(bookManageInterFrame);
		}
	});
	menuItem_3.setIcon(new ImageIcon(MainFrame.class.getResource("/images/edit.png")));
	menu_1.add(menuItem_3);
	
	//安全退出
	JMenuItem menuItem_4 = new JMenuItem("\u5B89\u5168\u9000\u51FA");
	menuItem_4.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			//弹出退出确认提示框
			int res=JOptionPane.showConfirmDialog(null, "确定要退出吗？");
			//确定退出
			if(res==JOptionPane.OK_OPTION){ 

   
				dispose();
			} 
			//否则继续留在该界面
		}
	});
	menuItem_4.setIcon(new ImageIcon(MainFrame.class.getResource("/images/exit.png")));
	menu.add(menuItem_4);
	
	JMenu menu_2 = new JMenu("\u5173\u4E8E\u6211\u4EEC");
	menu_2.setIcon(new ImageIcon(MainFrame.class.getResource("/images/about.png")));
	menuBar.add(menu_2);
	
	//关于我们
	JMenuItem menuItem_5 = new JMenuItem("\u5173\u4E8E\u6211\u4EEC");
	menuItem_5.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			//新建一个图书内部窗体
			LibraryInterFrame libraryInnerFrame=new LibraryInterFrame();
			//显示图书内部窗体
			libraryInnerFrame.setVisible(true);
			//将图书内部窗体显示到主界面桌面窗格中
			table.add(libraryInnerFrame);
		}
	});
	menuItem_5.setIcon(new ImageIcon(MainFrame.class.getResource("/images/about.png")));
	menu_2.add(menuItem_5);
	contentPane = new JPanel();
	contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
	contentPane.setLayout(new BorderLayout(0, 0));
	setContentPane(contentPane);
	
	//定义主界面桌面窗格界面，用于装载内部窗体
	table = new JDesktopPane();
	table.setBackground(Color.LIGHT_GRAY);
	contentPane.add(table, BorderLayout.CENTER);
	//设置窗口最大化
	setExtendedState(JFrame.MAXIMIZED_BOTH);
}

}
③ BookTypeManageInterFrame（图书类别管理界面）
package cn.ac.azure.view;



import java.awt.EventQueue;

import java.awt.Font;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Vector;



import javax.swing.GroupLayout;

import javax.swing.GroupLayout.Alignment;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JInternalFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.UIManager;

import javax.swing.LayoutStyle.ComponentPlacement;

import javax.swing.table.DefaultTableModel;



import cn.ac.azure.dao.BookTypeDao;

import cn.ac.azure.model.BookType;

import cn.ac.azure.util.DBTool;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;

import javax.swing.JPanel;

import javax.swing.border.LineBorder;

import javax.swing.border.TitledBorder;

import javax.swing.JTextArea;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;



public class BookTypeManageInterFrame extends JInternalFrame { 

   
private JTextField s_bookTypeNameText;
private JTable bookTypeTable;
private BookTypeDao bookTypeDao=new BookTypeDao();
private JTextField idText;
private JTextField bookTypeNameText;
private JTextArea bookTypeDescText;
/** * Launch the application. */
public static void main(String[] args) { 

   
	EventQueue.invokeLater(new Runnable() { 

   
		public void run() { 

   
			try { 

   
				BookTypeManageInterFrame frame = new BookTypeManageInterFrame();
				frame.setVisible(true);
			} catch (Exception e) { 

   
				e.printStackTrace();
			}
		}
	});
}


/** * Create the frame. */
public BookTypeManageInterFrame() { 

   
	
	//改变系统默认字体
	Font font = new Font("Dialog", Font.PLAIN, 12);
	java.util.Enumeration keys = UIManager.getDefaults().keys();
	while (keys.hasMoreElements()) { 

   
		Object key = keys.nextElement();
		Object value = UIManager.get(key);
		if (value instanceof javax.swing.plaf.FontUIResource) { 

   
			UIManager.put(key, font);
		}
	}
	setIconifiable(true);
	setClosable(true);
	setTitle("图书类别管理");
	setBounds(400, 100, 535, 489);
	
	JScrollPane scrollPane = new JScrollPane();
	
	JLabel label = new JLabel("图书类别名称：");
	
	s_bookTypeNameText = new JTextField();
	s_bookTypeNameText.setColumns(10);
	
	//查询按钮
	JButton searchBtn = new JButton("查询");
	searchBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			searchActionPerformed(e);
		}
	});
	searchBtn.setIcon(new ImageIcon(BookTypeManageInterFrame.class.getResource("/images/search.png")));
	
	JPanel panel = new JPanel();
	panel.setBorder(new TitledBorder(null, "\u8868\u5355\u64CD\u4F5C", TitledBorder.LEADING, TitledBorder.TOP, null, null));
	GroupLayout groupLayout = new GroupLayout(getContentPane());
	groupLayout.setHorizontalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup()
				.addGap(56)
				.addComponent(label)
				.addPreferredGap(ComponentPlacement.UNRELATED)
				.addComponent(s_bookTypeNameText, GroupLayout.PREFERRED_SIZE, 167, GroupLayout.PREFERRED_SIZE)
				.addPreferredGap(ComponentPlacement.RELATED, 54, Short.MAX_VALUE)
				.addComponent(searchBtn)
				.addGap(71))
			.addGroup(groupLayout.createSequentialGroup()
				.addGap(36)
				.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING, false)
					.addComponent(panel, Alignment.LEADING, GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
					.addComponent(scrollPane, Alignment.LEADING))
				.addContainerGap(31, Short.MAX_VALUE))
	);
	groupLayout.setVerticalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup()
				.addGap(27)
				.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
					.addComponent(searchBtn)
					.addComponent(label)
					.addComponent(s_bookTypeNameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
				.addGap(18)
				.addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 167, GroupLayout.PREFERRED_SIZE)
				.addGap(18)
				.addComponent(panel, GroupLayout.DEFAULT_SIZE, 194, Short.MAX_VALUE)
				.addContainerGap())
	);
	
	JLabel label_1 = new JLabel("编号：");
	
	idText = new JTextField();
	idText.setEditable(false);
	idText.setColumns(10);
	
	JLabel label_2 = new JLabel("图书类别名称：");
	
	bookTypeNameText = new JTextField();
	bookTypeNameText.setColumns(10);
	
	JLabel label_3 = new JLabel("描述：");
	
	bookTypeDescText = new JTextArea();
	
	//修改按钮
	JButton modifyBtn = new JButton("修改");
	modifyBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			bookTypeUpdateActionPerformed(e);
		}
	});
	modifyBtn.setIcon(new ImageIcon(BookTypeManageInterFrame.class.getResource("/images/modify.png")));
	
	//删除按钮
	JButton deleteBtn = new JButton("删除");
	deleteBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			bookTypeDeleteActionPerformed(e);
		}
	});
	deleteBtn.setIcon(new ImageIcon(BookTypeManageInterFrame.class.getResource("/images/delete.png")));
	GroupLayout gl_panel = new GroupLayout(panel);
	gl_panel.setHorizontalGroup(
		gl_panel.createParallelGroup(Alignment.LEADING)
			.addGroup(gl_panel.createSequentialGroup()
				.addGap(19)
				.addGroup(gl_panel.createParallelGroup(Alignment.TRAILING)
					.addGroup(Alignment.LEADING, gl_panel.createSequentialGroup()
						.addComponent(label_1)
						.addPreferredGap(ComponentPlacement.RELATED)
						.addComponent(idText, GroupLayout.PREFERRED_SIZE, 47, GroupLayout.PREFERRED_SIZE)
						.addGap(18)
						.addComponent(label_2)
						.addPreferredGap(ComponentPlacement.UNRELATED)
						.addComponent(bookTypeNameText, GroupLayout.PREFERRED_SIZE, 166, GroupLayout.PREFERRED_SIZE))
					.addGroup(Alignment.LEADING, gl_panel.createSequentialGroup()
						.addComponent(label_3)
						.addPreferredGap(ComponentPlacement.RELATED)
						.addComponent(bookTypeDescText))
					.addGroup(gl_panel.createSequentialGroup()
						.addComponent(modifyBtn)
						.addGap(54)
						.addComponent(deleteBtn)
						.addGap(64)))
				.addContainerGap(56, GroupLayout.PREFERRED_SIZE))
	);
	gl_panel.setVerticalGroup(
		gl_panel.createParallelGroup(Alignment.LEADING)
			.addGroup(gl_panel.createSequentialGroup()
				.addContainerGap()
				.addGroup(gl_panel.createParallelGroup(Alignment.BASELINE)
					.addComponent(label_1)
					.addComponent(idText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(label_2)
					.addComponent(bookTypeNameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
				.addGap(27)
				.addGroup(gl_panel.createParallelGroup(Alignment.BASELINE)
					.addComponent(label_3)
					.addComponent(bookTypeDescText, GroupLayout.PREFERRED_SIZE, 51, GroupLayout.PREFERRED_SIZE))
				.addGap(18)
				.addGroup(gl_panel.createParallelGroup(Alignment.BASELINE)
					.addComponent(deleteBtn)
					.addComponent(modifyBtn))
				.addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
	);
	panel.setLayout(gl_panel);
	
	//表格
	bookTypeTable = new JTable();
	//表格鼠标点击事件
	bookTypeTable.addMouseListener(new MouseAdapter() { 

   
		@Override
		public void mousePressed(MouseEvent e) { 

   
			bookTypeTableMousePressed(e);
		}
	});
	bookTypeTable.setModel(new DefaultTableModel(
		new Object[][] { 

   
		},
		new String[] { 

   
			"编号", "图书类别名称", "图书类别描述"
		}
	) { 

   
		boolean[] columnEditables = new boolean[] { 

   
			false, false, false
		};
		public boolean isCellEditable(int row, int column) { 

   
			return columnEditables[column];
		}
	});
	bookTypeTable.getColumnModel().getColumn(1).setPreferredWidth(96);
	bookTypeTable.getColumnModel().getColumn(2).setPreferredWidth(185);
	scrollPane.setViewportView(bookTypeTable);
	getContentPane().setLayout(groupLayout);
	
	//设置文本域边框
	bookTypeDescText.setBorder(new LineBorder(new java.awt.Color(127,157,185), 1, false));
	//构造函数中调用填充表格数据函数，全部图书类别显示在表格中
	fillTable(new BookType());
}
/** * 图书类别删除事件处理 * @param evt */
private void bookTypeDeleteActionPerformed(ActionEvent evt) { 

   
	//获得表单中编号的值id
	String id=idText.getText();
	//判断表单有没有选中的图书类别记录
	if(id==null || "".equals(id.trim())){ 

   
		JOptionPane.showMessageDialog(null, "请选择要修改的记录！");
		return;
	}
	//弹出确认框，是否要删除图书类别记录
	int res=JOptionPane.showConfirmDialog(null, "你确定要删除该条记录吗？");
	if(res!=0){ 

    //否
		return; //结束该事件处理函数
	}
	//定义数据库连接
	Connection con=null;
	try { 

   
		//获取数据路连接
		con=DBTool.getConnetion();
		int row=bookTypeDao.delete(con, id);
		if(row==1){ 

   //删除成功，弹出提示框
			JOptionPane.showMessageDialog(null, "修改数据成功(n_n)");
			//清空表单数据
			resetValue();
			//刷新表格记录显示
			fillTable(new BookType());
		}else{ 

   //删除失败，弹出提示框
			JOptionPane.showMessageDialog(null, "修改数据失败(u_u)");
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("删除记录失败！",e);
	}finally{ 

   
		//关闭数据库
		DBTool.close(con);
	}
}


/** * 图书类别修改事件处理 * @param evt */
private void bookTypeUpdateActionPerformed(ActionEvent evt) { 

   
	//获取表单操作各个文本框的值
	String id=idText.getText();
	String bookTypeName=bookTypeNameText.getText();
	String bookTypeDesc=bookTypeDescText.getText();
	//判断表单有没有选中的图书类别记录
	if(id==null || "".equals(id.trim())){ 

   
		JOptionPane.showMessageDialog(null, "请选择要修改的记录！");
		return;
	}
	//图书类别名称不能为空
	if(bookTypeName==null || "".equals(bookTypeName.trim())){ 

   
		JOptionPane.showMessageDialog(null, "图书类别名称不能为空！");
		return;
	}
	//利用表单的数据新建一个图书类别对象
	BookType bookType=new BookType(Integer.parseInt(id), bookTypeName, bookTypeDesc);
	//定义数据库连接对象
	Connection con=null;
	try { 

   
		//获取数据库连接
		con=DBTool.getConnetion();
		//执行图书类别dao类的修改记录方法
		int res=bookTypeDao.update(con, bookType);
		if(res==1){ 

   //修改成功，弹出提示框
			JOptionPane.showMessageDialog(null, "修改数据成功(n_n)");
			//清空表单数据
			resetValue();
			//刷新表格记录显示
			fillTable(new BookType());
		}else{ 

   //修改失败，弹出提示框
			JOptionPane.showMessageDialog(null, "修改数据失败(u_u)");
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("修改图书类别失败",e);
	}finally{ 

   
		//关闭数据路连接
		DBTool.close(con);
	}
}


/** * 表格鼠标点击事件处理 * @param e */
private void bookTypeTableMousePressed(MouseEvent e) { 

   
	//获取表格选中的行
	int row=bookTypeTable.getSelectedRow();
	//获取表中选中行的第一列的值并显示在idText框中
	idText.setText(String.valueOf(bookTypeTable.getValueAt(row, 0)));
	//获取表中选中行的第二列的值并显示在bookTypeNameText框中
	bookTypeNameText.setText((String)bookTypeTable.getValueAt(row, 1));
	//获取表中选中行的第三列的值并显示在bookTypeDescText框中
	bookTypeDescText.setText((String)bookTypeTable.getValueAt(row, 2));
}


/** * 图书类别查询事件处理 * @param evt */
private void searchActionPerformed(ActionEvent evt) { 

   
	//获取图书类别输入框里的内容
	String s_bookTypeName=s_bookTypeNameText.getText();
	//新建一个图书类别并初始化
	BookType bookType=new BookType();
	//将输入框的内容设置成新建图书类别的图书类别名称
	bookType.setBookTypeName(s_bookTypeName);
	//根据图书类别查询图书类别
	fillTable(bookType);
}


/** * 在表格中填充数据 * @param bookType 传入bookType对象 */
private void fillTable(BookType bookType){ 

   
	//获取表格的模型
	DefaultTableModel dtm=(DefaultTableModel) bookTypeTable.getModel();
	//清空表格
	dtm.setRowCount(0); 
	//定义数据库连接
	Connection con=null;
	try { 

   
		//获取数据库连接
		con=DBTool.getConnetion();
		//调用BookTyPeDao的查询方法，并获得其查询的结果集
		ResultSet rs=bookTypeDao.search(con, bookType);
		//遍历结果集
		while(rs.next()){ 

   
			//新建一个vector并初始化
			Vector v=new Vector(); 
			v.add(rs.getInt("id"));  //向vector中添加id
			v.add(rs.getString("bookTypeName")); //向vector中添加bookTypeName
			v.add(rs.getString("bookTypeDesc"));  //向vector中添加bookTypeDesc
			//将vector中的数据显示到表格中
			dtm.addRow(v);
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("查询失败");
	}finally{ 

   
		//关闭数据库
		DBTool.close(con);
	}
}
/** * 清空表单数据 */
private void resetValue(){ 

   
	idText.setText("");
	bookTypeNameText.setText("");
	bookTypeDescText.setText("");
	s_bookTypeNameText.setText("");
}

}
④ BookTypeAddInterFrame（图书类别添加界面）
package cn.ac.azure.view;



import java.awt.EventQueue;

import java.awt.Font;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.SQLException;



import javax.swing.GroupLayout;

import javax.swing.GroupLayout.Alignment;

import javax.swing.JButton;

import javax.swing.JInternalFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JTextArea;

import javax.swing.JTextField;

import javax.swing.UIManager;

import javax.swing.LayoutStyle.ComponentPlacement;

import javax.swing.border.LineBorder;



import cn.ac.azure.dao.BookTypeDao;

import cn.ac.azure.model.BookType;

import cn.ac.azure.util.DBTool;

/** * 图书类别内部添加窗体 * @author green * */

public class BookTypeAddInterFrame extends JInternalFrame { 

   
//图书类别名称输入框
private JTextField bookTypeNameText;
//图书类别描述输入框
private JTextArea bookTypeDescText;
//重置按钮
private JButton resetBtn;
//添加按钮
private JButton addBtn;
//图书类别数据库访问对象
private BookTypeDao bookTypeDao;
/** * Launch the application. */
public static void main(String[] args) { 

   
	EventQueue.invokeLater(new Runnable() { 

   
		public void run() { 

   
			try { 

   
				BookTypeAddInterFrame frame = new BookTypeAddInterFrame();
				frame.setVisible(true);
			} catch (Exception e) { 

   
				e.printStackTrace();
			}
		}
	});
}


/** * Create the frame. */
public BookTypeAddInterFrame() { 

   
	//改变系统默认字体
	Font font = new Font("Dialog", Font.PLAIN, 12);
	java.util.Enumeration keys = UIManager.getDefaults().keys();
	while (keys.hasMoreElements()) { 

   
		Object key = keys.nextElement();
		Object value = UIManager.get(key);
		if (value instanceof javax.swing.plaf.FontUIResource) { 

   
			UIManager.put(key, font);
		}
	}
	setClosable(true);
	setIconifiable(true);
	setTitle("图书类别添加");
	setBounds(100, 100, 487, 342);
	
	JLabel label = new JLabel("图书类别名称：");
	
	bookTypeNameText = new JTextField();
	bookTypeNameText.setColumns(10);
	
	JLabel label_1 = new JLabel("图书类别描述：");
	
	bookTypeDescText = new JTextArea();
	
	//添加按钮
	addBtn = new JButton("添加");
	addBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			addActionPerformed(e);
		}
	});
	//重置按钮
	resetBtn = new JButton("重置");
	resetBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			resetActionPerformed(e);
		}
	});
	GroupLayout groupLayout = new GroupLayout(getContentPane());
	groupLayout.setHorizontalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup()
				.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
					.addGroup(groupLayout.createSequentialGroup()
						.addGap(128)
						.addComponent(addBtn)
						.addGap(91)
						.addComponent(resetBtn))
					.addGroup(groupLayout.createSequentialGroup()
						.addGap(89)
						.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
							.addComponent(bookTypeDescText)
							.addGroup(groupLayout.createSequentialGroup()
								.addComponent(label)
								.addPreferredGap(ComponentPlacement.RELATED)
								.addComponent(bookTypeNameText, GroupLayout.PREFERRED_SIZE, 189, GroupLayout.PREFERRED_SIZE))
							.addComponent(label_1))))
				.addContainerGap(105, Short.MAX_VALUE))
	);
	groupLayout.setVerticalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup()
				.addGap(49)
				.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
					.addComponent(label)
					.addComponent(bookTypeNameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
				.addGap(18)
				.addComponent(label_1)
				.addGap(10)
				.addComponent(bookTypeDescText, GroupLayout.PREFERRED_SIZE, 87, GroupLayout.PREFERRED_SIZE)
				.addGap(41)
				.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
					.addComponent(resetBtn)
					.addComponent(addBtn))
				.addContainerGap())
	);
	getContentPane().setLayout(groupLayout);
	
	//设置文本域边框
	bookTypeDescText.setBorder(new LineBorder(new java.awt.Color(127,157,185), 1, false));
}
/** * 添加事件处理 * @param evt */
private void addActionPerformed(ActionEvent evt) { 

   
	//获取输入框的值
	String bookTypeName=bookTypeNameText.getText();
	String bookTypeDesc=bookTypeDescText.getText();
	if(bookTypeName==null || "".equals(bookTypeName.trim())){ 

   
		JOptionPane.showMessageDialog(null,"图书类别不能为空！");
		return;
	}
	//新建图书类别实体对象
	BookType bookType=new BookType(bookTypeName, bookTypeDesc);
	//定义数据库连接
	Connection con=null;
	try { 

   
		//获取数据库连接
		con=DBTool.getConnetion();
		//初始化图书类别对象BookTypeDao
		bookTypeDao=new BookTypeDao();
		//调用图书类别dao对象的添加方法
		int res=bookTypeDao.add(con, bookType);
		if(res!=0){ 

   
			//提示添加成功
			JOptionPane.showMessageDialog(null, "图书添加成功(n_n)");
			//清空输入框
			bookTypeNameText.setText("");
			bookTypeDescText.setText("");
		}else{ 

   
			//提示添加失败
			JOptionPane.showMessageDialog(null,"图书添加失败(u_u)");
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("添加图书失败",e);
	}finally{ 

   
		//关闭数据库
		DBTool.close(con);
	}
}


/** * 重置事件处理 * @param evt */
private void resetActionPerformed(ActionEvent evt) { 

   
	//置空图书类别名称输入框
	bookTypeNameText.setText("");
	//置空图书类别描述输入框
	bookTypeDescText.setText("");
}

}
⑤ BookManageInterFrame（图书管理界面）
package cn.ac.azure.view;



import java.awt.EventQueue;

import java.awt.Font;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Vector;



import javax.swing.GroupLayout;

import javax.swing.GroupLayout.Alignment;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JInternalFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.LayoutStyle.ComponentPlacement;

import javax.swing.UIManager;

import javax.swing.border.TitledBorder;

import javax.swing.table.DefaultTableModel;



import cn.ac.azure.dao.BookDao;

import cn.ac.azure.dao.BookTypeDao;

import cn.ac.azure.model.Book;

import cn.ac.azure.model.BookType;

import cn.ac.azure.util.DBTool;

import javax.swing.JRadioButton;

import javax.swing.ButtonGroup;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;



public class BookManageInterFrame extends JInternalFrame { 

   
private JTextField s_bookNameText;
private JTextField s_authorText;
private JTable bookTable;
private JComboBox s_bookTypecomboBox;
private BookTypeDao bookTypeDao;
private BookDao bookDao;
private JTextField idText;
private JTextField bookNameText;
private JTextField priceText;
private JTextField authorText;
private JTextField bookDescText;
private final ButtonGroup buttonGroup = new ButtonGroup();
private JComboBox bookTypeComboBox;
private JRadioButton maleBtn;
private JRadioButton femaleBtn;
/** * Launch the application. */
public static void main(String[] args) { 

   
	EventQueue.invokeLater(new Runnable() { 

   
		public void run() { 

   
			try { 

   
				BookManageInterFrame frame = new BookManageInterFrame();
				frame.setVisible(true);
			} catch (Exception e) { 

   
				e.printStackTrace();
			}
		}
	});
}


/** * Create the frame. */
public BookManageInterFrame() { 

   
	
	//改变系统默认字体
	Font font = new Font("Dialog", Font.PLAIN, 12);
	java.util.Enumeration keys = UIManager.getDefaults().keys();
	while (keys.hasMoreElements()) { 

   
		Object key = keys.nextElement();
		Object value = UIManager.get(key);
		if (value instanceof javax.swing.plaf.FontUIResource) { 

   
			UIManager.put(key, font);
		}
	}
	
	setIconifiable(true);
	setClosable(true);
	setTitle("图书管理 ");
	setBounds(100, 100, 767, 528);
	
	JPanel panel = new JPanel();
	panel.setBorder(new TitledBorder(null, "搜索条件", TitledBorder.LEADING, TitledBorder.TOP, null, null));
	
	JScrollPane scrollPane = new JScrollPane();
	
	JPanel panel_1 = new JPanel();
	panel_1.setBorder(new TitledBorder(null, "表单操作", TitledBorder.LEADING, TitledBorder.TOP, null, null));
	GroupLayout groupLayout = new GroupLayout(getContentPane());
	groupLayout.setHorizontalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(Alignment.TRAILING, groupLayout.createSequentialGroup()
				.addGap(29)
				.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING)
					.addComponent(panel_1, Alignment.LEADING, GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
					.addComponent(scrollPane, GroupLayout.DEFAULT_SIZE, 661, Short.MAX_VALUE)
					.addComponent(panel, GroupLayout.DEFAULT_SIZE, 661, Short.MAX_VALUE))
				.addGap(38))
	);
	groupLayout.setVerticalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup()
				.addGap(29)
				.addComponent(panel, GroupLayout.PREFERRED_SIZE, 75, GroupLayout.PREFERRED_SIZE)
				.addPreferredGap(ComponentPlacement.UNRELATED)
				.addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 137, GroupLayout.PREFERRED_SIZE)
				.addPreferredGap(ComponentPlacement.UNRELATED)
				.addComponent(panel_1, GroupLayout.PREFERRED_SIZE, 217, GroupLayout.PREFERRED_SIZE)
				.addContainerGap(20, Short.MAX_VALUE))
	);
	
	JLabel label_2 = new JLabel("编号：");
	
	idText = new JTextField();
	idText.setColumns(10);
	
	JLabel label_3 = new JLabel("图书名称：");
	
	bookNameText = new JTextField();
	bookNameText.setColumns(10);
	
	JLabel label_4 = new JLabel("作者性别：");
	
	maleBtn = new JRadioButton("男");
	buttonGroup.add(maleBtn);
	
	femaleBtn = new JRadioButton("女");
	buttonGroup.add(femaleBtn);
	
	JLabel label_5 = new JLabel("价格：");
	
	priceText = new JTextField();
	priceText.setColumns(10);
	
	JLabel label_6 = new JLabel("图书作者：");
	
	authorText = new JTextField();
	authorText.setColumns(10);
	
	JLabel label_7 = new JLabel("图书类别：");
	
	bookTypeComboBox = new JComboBox();
	
	JLabel label_8 = new JLabel("图书描述：");
	
	bookDescText = new JTextField();
	bookDescText.setColumns(10);
	
	//修改按钮
	JButton modifyBtn = new JButton("修改");
	modifyBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			modifyBookActionPerformed(e);
		}
	});
	modifyBtn.setIcon(new ImageIcon(BookManageInterFrame.class.getResource("/images/modify.png")));
	
	//删除按钮
	JButton deleteBtn = new JButton("删除");
	deleteBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			deleteBookActionPerformed(e);
		}
	});
	deleteBtn.setIcon(new ImageIcon(BookManageInterFrame.class.getResource("/images/delete.png")));
	GroupLayout gl_panel_1 = new GroupLayout(panel_1);
	gl_panel_1.setHorizontalGroup(
		gl_panel_1.createParallelGroup(Alignment.TRAILING)
			.addGroup(gl_panel_1.createSequentialGroup()
				.addGap(44)
				.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING, false)
					.addGroup(gl_panel_1.createSequentialGroup()
						.addComponent(label_8)
						.addPreferredGap(ComponentPlacement.RELATED)
						.addComponent(bookDescText))
					.addGroup(gl_panel_1.createSequentialGroup()
						.addGroup(gl_panel_1.createParallelGroup(Alignment.TRAILING)
							.addComponent(label_2)
							.addComponent(label_5))
						.addPreferredGap(ComponentPlacement.UNRELATED)
						.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING, false)
							.addComponent(priceText)
							.addComponent(idText, GroupLayout.DEFAULT_SIZE, 86, Short.MAX_VALUE))
						.addGap(37)
						.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING, false)
							.addGroup(gl_panel_1.createSequentialGroup()
								.addComponent(label_3)
								.addPreferredGap(ComponentPlacement.RELATED)
								.addComponent(bookNameText, GroupLayout.PREFERRED_SIZE, 136, GroupLayout.PREFERRED_SIZE))
							.addGroup(gl_panel_1.createSequentialGroup()
								.addComponent(label_6)
								.addPreferredGap(ComponentPlacement.RELATED)
								.addComponent(authorText)))
						.addGap(35)
						.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING)
							.addGroup(gl_panel_1.createSequentialGroup()
								.addComponent(label_4)
								.addPreferredGap(ComponentPlacement.UNRELATED)
								.addComponent(maleBtn)
								.addGap(18)
								.addComponent(femaleBtn))
							.addGroup(gl_panel_1.createSequentialGroup()
								.addComponent(label_7)
								.addPreferredGap(ComponentPlacement.UNRELATED)
								.addComponent(bookTypeComboBox, GroupLayout.PREFERRED_SIZE, 97, GroupLayout.PREFERRED_SIZE)))))
				.addContainerGap(34, Short.MAX_VALUE))
			.addGroup(gl_panel_1.createSequentialGroup()
				.addContainerGap(201, Short.MAX_VALUE)
				.addComponent(modifyBtn)
				.addGap(104)
				.addComponent(deleteBtn)
				.addGap(190))
	);
	gl_panel_1.setVerticalGroup(
		gl_panel_1.createParallelGroup(Alignment.LEADING)
			.addGroup(gl_panel_1.createSequentialGroup()
				.addContainerGap()
				.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
					.addComponent(maleBtn)
					.addComponent(bookNameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(label_3)
					.addComponent(label_2)
					.addComponent(idText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(femaleBtn)
					.addComponent(label_4))
				.addGap(18)
				.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
					.addComponent(priceText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(label_5)
					.addComponent(label_6)
					.addComponent(authorText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(bookTypeComboBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(label_7))
				.addGap(18)
				.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
					.addComponent(label_8)
					.addComponent(bookDescText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
				.addGap(27)
				.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
					.addComponent(modifyBtn)
					.addComponent(deleteBtn))
				.addContainerGap())
	);
	panel_1.setLayout(gl_panel_1);
	
	//表格
	bookTable = new JTable();
	//表格鼠标按下事件
	bookTable.addMouseListener(new MouseAdapter() { 

   
		@Override
		public void mousePressed(MouseEvent e) { 

   
			tableMousePressed(e);
		}
	});
	bookTable.setModel(new DefaultTableModel(
		new Object[][] { 

   
		},
		new String[] { 

   
			"编号", "图书名称", "图书作者", "图书性别", "图书价格", "图书类别", "图书描述"
		}
	) { 

   
		boolean[] columnEditables = new boolean[] { 

   
			false, false, false, false, false, false, false
		};
		public boolean isCellEditable(int row, int column) { 

   
			return columnEditables[column];
		}
	});
	bookTable.getColumnModel().getColumn(0).setPreferredWidth(56);
	bookTable.getColumnModel().getColumn(1).setPreferredWidth(100);
	bookTable.getColumnModel().getColumn(2).setPreferredWidth(63);
	bookTable.getColumnModel().getColumn(3).setPreferredWidth(63);
	bookTable.getColumnModel().getColumn(4).setPreferredWidth(61);
	bookTable.getColumnModel().getColumn(5).setPreferredWidth(94);
	bookTable.getColumnModel().getColumn(6).setPreferredWidth(163);
	scrollPane.setViewportView(bookTable);
	
	JLabel lblL = new JLabel("图书名称：");
	
	s_bookNameText = new JTextField();
	s_bookNameText.setColumns(10);
	
	JLabel label = new JLabel("图书作者：");
	
	s_authorText = new JTextField();
	s_authorText.setColumns(10);
	
	JLabel label_1 = new JLabel("图书类别：");
	
	s_bookTypecomboBox = new JComboBox();
	
	//图书查询按钮
	JButton s_searchBtn = new JButton("查询");
	s_searchBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			searchActionPerformed(e);
		}
	});
	s_searchBtn.setIcon(new ImageIcon(BookManageInterFrame.class.getResource("/images/search.png")));
	GroupLayout gl_panel = new GroupLayout(panel);
	gl_panel.setHorizontalGroup(
		gl_panel.createParallelGroup(Alignment.LEADING)
			.addGroup(gl_panel.createSequentialGroup()
				.addGap(20)
				.addComponent(lblL)
				.addPreferredGap(ComponentPlacement.RELATED)
				.addComponent(s_bookNameText, GroupLayout.PREFERRED_SIZE, 88, GroupLayout.PREFERRED_SIZE)
				.addGap(18)
				.addComponent(label)
				.addPreferredGap(ComponentPlacement.RELATED)
				.addComponent(s_authorText, GroupLayout.DEFAULT_SIZE, 89, Short.MAX_VALUE)
				.addGap(18)
				.addComponent(label_1)
				.addPreferredGap(ComponentPlacement.UNRELATED)
				.addComponent(s_bookTypecomboBox, GroupLayout.PREFERRED_SIZE, 94, GroupLayout.PREFERRED_SIZE)
				.addGap(18)
				.addComponent(s_searchBtn)
				.addGap(29))
	);
	gl_panel.setVerticalGroup(
		gl_panel.createParallelGroup(Alignment.LEADING)
			.addGroup(gl_panel.createSequentialGroup()
				.addContainerGap()
				.addGroup(gl_panel.createParallelGroup(Alignment.BASELINE)
					.addComponent(lblL)
					.addComponent(s_bookNameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(label)
					.addComponent(s_authorText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(label_1)
					.addComponent(s_bookTypecomboBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
					.addComponent(s_searchBtn))
				.addContainerGap(19, Short.MAX_VALUE))
	);
	panel.setLayout(gl_panel);
	getContentPane().setLayout(groupLayout);
	//初始化搜索栏图书类别下拉框
	fillBookTypeComboBox("search");
	//初始化操作栏图书类别下拉框
	fillBookTypeComboBox("modify");
	//初始化表格显示，显示所有的书籍
	fillBookTable(new Book());
}

/** * 图书修改事件 * @param evt */
private void modifyBookActionPerformed(ActionEvent evt) { 

   
	//获取图书id
	String id=idText.getText();
	//获取图书名称
	String bookName=bookNameText.getText();
	//获取图书作者
	String author=authorText.getText();
	//或者作者性别
	String sex="男";
	if(femaleBtn.isSelected()){ 

   
		sex="女";
	}
	//获取图书价格
	String price=priceText.getText();
	//获取图书id
	BookType bookType=(BookType)bookTypeComboBox.getSelectedItem();
	Integer bookTypeId=bookType.getId();
	//获取图书描述
	String bookDesc=bookDescText.getText();
	
	//判断是否id是否为空
	if(id==null || "".equals(id)){ 

    //为空
		JOptionPane.showMessageDialog(null, "请选中要删除的行！");  //给用户提示
		return;
	}
	//判断图书名称是否为空
	if(bookName==null || "".equals(bookName)){ 

    //为空
		JOptionPane.showMessageDialog(null, "图书名称不能为空！");  //给用户提示
		return;
	}
	//判断图书作者是否为空
	if(author==null || "".equals(author)){ 

    //为空
		JOptionPane.showMessageDialog(null, "图书作者不能为空！");  //给用户提示
		return;
	}
	//判断图书价格是否为空
	if(price==null || "".equals(price)){ 

    //为空
		JOptionPane.showMessageDialog(null, "图书价格不能为空！");  //给用户提示
		return;
	}
	//从获取的图书信息创建图书对象
	Book book=new Book(Integer.parseInt(id),bookName, author, sex, Float.parseFloat(price), bookTypeId, bookDesc, null);
	System.out.println("从获取的图书信息创建图书对象:"+book);
	//定义数据库连接
	Connection con=null;
	try { 

   
		//获取数据库连接
		con=DBTool.getConnetion();
		//初始化图书数据访问对象
		bookDao=new BookDao();
		//执行图书访问对象的修改方法，并获得修改的记录数
		int res=bookDao.update(con, book);
		if(res==1){ 

    //为1
			JOptionPane.showMessageDialog(null,"图书修改成功n_n");
			//刷新图书表格显示
			fillBookTable(new Book());
			//重置操作栏
			resetValue();
		}else{ 

    //为0
			JOptionPane.showMessageDialog(null,"图书修改失败u_u");
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("修改图书失败",e);
	}finally{ 

   
		//关闭数据库连接
		DBTool.close(con);
	}
}
/** * 图书删除事件 * @param evt */
private void deleteBookActionPerformed(ActionEvent evt) { 

   
	//获取图书id
	String id=idText.getText();
	//判断是否id是否为空
	if(id==null || "".equals(id)){ 

    //为空
		JOptionPane.showMessageDialog(null, "请选中要删除的行！");  //给用户提示
		return;
	}
	//定义数据库连接对象
	Connection con=null;
	try { 

   
		//初始化数据库连接对象
		con=DBTool.getConnetion(); 
		//初始化图书数据访问对象
		bookDao=new BookDao();
		//执行图书访问对象的删除方法并返回删除的记录数
		int res=bookDao.delete(con, Integer.parseInt(id));
		if(res==1){ 

    //为1
			JOptionPane.showMessageDialog(null, "图书删除成功n_n");
			//刷新图书表格显示
			fillBookTable(new Book());
			//重置操作栏
			resetValue();
		}else{ 

    //为其他
			JOptionPane.showMessageDialog(null, "图书删除失败u_u");
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("删除图书失败",e);
	}finally{ 

   
		//记得关闭数据库（******）
		DBTool.close(con);
	}
}
/** * 重置操作栏的所有值 */
private void resetValue(){ 

   
	idText.setText("");
	bookNameText.setText("");
	authorText.setText("");
	maleBtn.setSelected(true);
	priceText.setText("");
	fillBookTypeComboBox("modify");
	bookDescText.setText("");
}
/** * 表格鼠标按下事件处理 * @param evt */
private void tableMousePressed(MouseEvent evt) { 

   
	//获取图书表格选中的行的行号
	int row=bookTable.getSelectedRow();
	//获取选中行第一个数据并设置显示在操作栏的id框
	idText.setText((Integer)bookTable.getValueAt(row,0)+"");
	//获取选中行第二个数据并设置显示在操作栏的图书名称框
	bookNameText.setText((String)bookTable.getValueAt(row, 1));
	//获取选中行第三个数据并设置显示在操作栏的图书作者框
	authorText.setText((String)bookTable.getValueAt(row, 2));
	//获取选中行第四个数据并设置显示在操作栏的作者性别单选框
	String sex=(String)bookTable.getValueAt(row, 3);
	if("男".equals(sex)){ 

   
		maleBtn.setSelected(true);
	}else{ 

   
		femaleBtn.setSelected(true);
	}
	//获取选中行第五个数据并设置显示在操作栏的图书价格框
	priceText.setText((Float)bookTable.getValueAt(row, 4)+"");
	//获取选中行第六个数据并设置显示在操作栏的图书类别下拉框中
	String bookTypeName=(String)bookTable.getValueAt(row, 5);
	int rows=bookTypeComboBox.getItemCount();  //获取下拉框总共的选项
	for(int i=0;i
    //遍历下拉框
		BookType item=(BookType) bookTypeComboBox.getItemAt(i); //获取每一个选项并强转图书类别对象
		if(item.getBookTypeName().equals(bookTypeName)){ 

     //将获取的图书类别和下拉框中的图书类别比较，若相同
			bookTypeComboBox.setSelectedIndex(i); //则该下拉框选项被选中
		}
	}
	//获取选中行第七个数据并设置显示在操作栏的图书描述框
	bookDescText.setText((String)bookTable.getValueAt(row, 6));
}


/** * 图书查询事件处理 * @param evt 事件对象 */
private void searchActionPerformed(ActionEvent evt) { 

   
	//获取查询的条件
	String bookName=s_bookNameText.getText();  //图书名称
	String author=s_authorText.getText();  //图书作者
	String bookTypeName=s_bookTypecomboBox.getSelectedItem().toString(); //图书类别
	//对图书类别"请选择..."换成""
	if("请选择...".equals(bookTypeName)){ 

   
		bookTypeName="";
	}
	//生成带有条件的图书对象
	Book book=new Book();
	book.setBookName(bookName);  //设置图书名称条件
	book.setAuthor(author);   //设置图书作者条件
	book.setBookTypeName(bookTypeName);  //设置图书类别条件
	//调用table填充函数，根据查询结果重新填充表格
	fillBookTable(book);  
}


/** * 初始化图书类别下拉框 * @param type 根据不同的参数填充不同的下拉框 */

private void fillBookTypeComboBox(String type){ 

   
	
	//定义一个图书类别，用于存储查询的图书类别
	BookType s_bookType=null;
	//定义一个数据库连接
	Connection con=null;
	try { 

   
		//获取数据库连接
		con=DBTool.getConnetion();
		//初始化图书类别访问数据对象
		bookTypeDao=new BookTypeDao();
		//查询图书类别，得到结果集
		ResultSet rs=bookTypeDao.search(con, new BookType());
		if("search".equals(type)){ 

   
			BookType bookType=new BookType();
			bookType.setBookTypeName("请选择...");
			bookType.setId(-1);
			s_bookTypecomboBox.addItem(bookType);
		}
		//遍历结果集
		while(rs.next()){ 

    //如果有数据的话
			//初始化接受查询的图书类别
			s_bookType=new BookType();
			//根据查询结果设置id
			s_bookType.setId(rs.getInt("id"));
			//根据查询结果设置图书类别名称
			s_bookType.setBookTypeName(rs.getString("bookTypeName"));
			if("search".equals(type)){ 

   
				//将查询的图书类别添加到下拉框中
				s_bookTypecomboBox.addItem(s_bookType);
			}
			if("modify".equals(type)){ 

   
				//将查询的图书类别添加到表单操作下拉框中
				bookTypeComboBox.addItem(s_bookType);
			}
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("初始化下拉框失败",e);
	}finally{ 

   
		//关闭数据库连接
		DBTool.close(con);
	}
}
/** * 初始化表格，列出所有的书籍 * @param book */
private void fillBookTable(Book book){ 

   
	//获取表格的模型
	DefaultTableModel dtm=(DefaultTableModel) bookTable.getModel();
	//填充表格时设置成0行（相当于归零处理）
	dtm.setRowCount(0);
	//定义数据库连接
	Connection con=null;
	try { 

   
		//获取数据库连接
		con=DBTool.getConnetion();
		//初始化图书数据访问对象
		bookDao=new BookDao();
		//按条件查询图书（这里没有条件，查出所有书籍）
		ResultSet rs=bookDao.search(con, book);
		//遍历查询结果
		while(rs.next()){ 

   
			//定义一个集合，由于存储图书信息
			Vector v=new Vector();
			v.add(rs.getInt("id"));  //添加编号
			v.add(rs.getString("bookName"));  //添加图书名称
			v.add(rs.getString("author"));  //添加图书作者
			v.add(rs.getString("sex"));     //添加作者性别
			v.add(rs.getFloat("price"));    //添加图书价格
			v.add(rs.getString("bookTypeName"));  //添加图书类别
			v.add(rs.getString("bookDesc"));
			//添加表格新行
			dtm.addRow(v);
		}
	} catch (SQLException e) { 

   
		//记录日志
		e.printStackTrace();
		throw new RuntimeException("初始化表格失败",e);
	}finally{ 

   
		//关闭数据库连接
		DBTool.close(con);
	}
}

}
⑥ BookAddInterFrame（图书添加界面）
package cn.ac.azure.view;



import java.awt.EventQueue;

import java.awt.Font;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;



import javax.swing.ButtonGroup;

import javax.swing.GroupLayout;

import javax.swing.GroupLayout.Alignment;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JInternalFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JRadioButton;

import javax.swing.JTextArea;

import javax.swing.JTextField;

import javax.swing.UIManager;

import javax.swing.LayoutStyle.ComponentPlacement;

import javax.swing.border.LineBorder;



import cn.ac.azure.dao.BookDao;

import cn.ac.azure.dao.BookTypeDao;

import cn.ac.azure.model.Book;

import cn.ac.azure.model.BookType;

import cn.ac.azure.util.DBTool;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;



public class BookAddInterFrame extends JInternalFrame { 

   
private JTextField bookNameText;
private JTextField authorText;
private final ButtonGroup buttonGroup = new ButtonGroup();
private JTextField priceText;
private JComboBox bookTypeComboBox;
private JRadioButton maleBtn;
private JRadioButton femaleBtn;
private JTextArea bookDescText;


private BookTypeDao bookTypeDao;
private BookDao bookDao;


/** * Launch the application. */
public static void main(String[] args) { 

   
	EventQueue.invokeLater(new Runnable() { 

   
		public void run() { 

   
			try { 

   
				BookAddInterFrame frame = new BookAddInterFrame();
				frame.setVisible(true);
			} catch (Exception e) { 

   
				e.printStackTrace();
			}
		}
	});
}


/** * Create the frame. */
public BookAddInterFrame() { 

   
	setIconifiable(true);
	setClosable(true);


	// 改变系统默认字体
	Font font = new Font("Dialog", Font.PLAIN, 12);
	java.util.Enumeration keys = UIManager.getDefaults().keys();
	while (keys.hasMoreElements()) { 

   
		Object key = keys.nextElement();
		Object value = UIManager.get(key);
		if (value instanceof javax.swing.plaf.FontUIResource) { 

   
			UIManager.put(key, font);
		}
	}
	setTitle("图书添加 ");
	setBounds(100, 100, 699, 449);


	JLabel label = new JLabel("图书名称：");


	bookNameText = new JTextField();
	bookNameText.setColumns(10);


	JLabel label_1 = new JLabel("图书作者：");


	authorText = new JTextField();
	authorText.setColumns(10);


	JLabel label_2 = new JLabel("作者性别：");


	maleBtn = new JRadioButton("男");
	buttonGroup.add(maleBtn);


	femaleBtn = new JRadioButton("女");
	buttonGroup.add(femaleBtn);


	JLabel label_3 = new JLabel("图书价格：");


	priceText = new JTextField();
	priceText.setColumns(10);


	JLabel label_4 = new JLabel("图书类别：");
	// 图书类别下拉框
	bookTypeComboBox = new JComboBox();


	JLabel label_5 = new JLabel("图书描述：");


	bookDescText = new JTextArea();


	// 图书添加按钮
	JButton addBtn = new JButton("添加");
	addBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			// 图书添加按钮事件处理
			bookAddActionPerformed(e);
		}
	});
	addBtn.setIcon(new ImageIcon(BookAddInterFrame.class.getResource("/images/add.png")));


	// 图书重置按钮
	JButton resetBtn = new JButton("重置");
	resetBtn.addActionListener(new ActionListener() { 

   
		public void actionPerformed(ActionEvent e) { 

   
			bookResetActionPerformed(e);
		}
	});
	resetBtn.setIcon(new ImageIcon(BookAddInterFrame.class.getResource("/images/reset.png")));
	GroupLayout groupLayout = new GroupLayout(getContentPane());
	groupLayout
			.setHorizontalGroup(groupLayout.createParallelGroup(Alignment.LEADING)
					.addGroup(groupLayout.createSequentialGroup().addGap(38).addGroup(groupLayout
							.createParallelGroup(
									Alignment.LEADING)
							.addGroup(
									groupLayout.createSequentialGroup().addGap(6).addGroup(groupLayout
											.createParallelGroup(Alignment.LEADING, false)
											.addGroup(groupLayout.createSequentialGroup().addGroup(groupLayout
													.createParallelGroup(Alignment.LEADING, false)
													.addGroup(groupLayout.createSequentialGroup()
															.addComponent(label_4).addPreferredGap(
																	ComponentPlacement.RELATED)
															.addComponent(bookTypeComboBox, 0,
																	GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
													.addGroup(groupLayout.createSequentialGroup()
															.addComponent(label)
															.addPreferredGap(ComponentPlacement.RELATED)
															.addComponent(bookNameText, GroupLayout.PREFERRED_SIZE,
																	116, GroupLayout.PREFERRED_SIZE))
													.addGroup(groupLayout.createSequentialGroup()
															.addComponent(label_2)
															.addPreferredGap(ComponentPlacement.RELATED)
															.addComponent(maleBtn)
															.addPreferredGap(ComponentPlacement.UNRELATED)
															.addComponent(femaleBtn)))
													.addGap(44)
													.addGroup(groupLayout
															.createParallelGroup(Alignment.LEADING, false)
															.addGroup(groupLayout.createSequentialGroup()
																	.addComponent(label_3)
																	.addPreferredGap(ComponentPlacement.UNRELATED)
																	.addComponent(priceText))
															.addGroup(groupLayout.createSequentialGroup()
																	.addComponent(label_1)
																	.addPreferredGap(ComponentPlacement.RELATED)
																	.addComponent(authorText,
																			GroupLayout.PREFERRED_SIZE, 128,
																			GroupLayout.PREFERRED_SIZE))))
											.addGroup(groupLayout.createSequentialGroup().addComponent(label_5)
													.addPreferredGap(ComponentPlacement.RELATED)
													.addComponent(bookDescText)))
											.addPreferredGap(ComponentPlacement.RELATED, 164, Short.MAX_VALUE))
							.addGroup(groupLayout.createSequentialGroup().addGap(94).addComponent(addBtn).addGap(96)
									.addComponent(resetBtn)))
							.addContainerGap()));
	groupLayout.setVerticalGroup(groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup().addGap(32)
					.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE).addComponent(label)
							.addComponent(bookNameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE,
									GroupLayout.PREFERRED_SIZE)
							.addComponent(label_1).addComponent(authorText, GroupLayout.PREFERRED_SIZE,
									GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
					.addGap(31)
					.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE).addComponent(label_2)
							.addComponent(maleBtn).addComponent(femaleBtn).addComponent(label_3).addComponent(
									priceText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE,
									GroupLayout.PREFERRED_SIZE))
					.addGap(37)
					.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
							.addComponent(label_4).addComponent(bookTypeComboBox, GroupLayout.PREFERRED_SIZE,
									GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
					.addGap(30)
					.addGroup(
							groupLayout.createParallelGroup(Alignment.BASELINE).addComponent(label_5).addComponent(
									bookDescText, GroupLayout.PREFERRED_SIZE, 102, GroupLayout.PREFERRED_SIZE))
					.addGap(38).addGroup(groupLayout.createParallelGroup(Alignment.BASELINE).addComponent(addBtn)
							.addComponent(resetBtn))
					.addContainerGap(45, Short.MAX_VALUE)));
	getContentPane().setLayout(groupLayout);
	// 设置文本域边框
	bookDescText.setBorder(new LineBorder(new java.awt.Color(127, 157, 185), 1, false));
	// 在构造函数中调用图书类别下拉框初始化方法
	fillBookTypeName();
	// 在构造函数中初始化性别。默认为男
	maleBtn.setSelected(true);
}


/** * 重置按钮事件处理 * * @param evt * 重置按钮事件对象 */
private void bookResetActionPerformed(ActionEvent evt) { 

   
	reset();
}


/** * 图书添加界面信息重置 */
private void reset() { 

   
	bookNameText.setText("");
	authorText.setText("");
	maleBtn.setSelected(true);
	priceText.setText("");
	bookTypeComboBox.setSelectedIndex(0);
	bookDescText.setText("");
}


/** * 图书添加按钮事件处理 * * @param evt * 添加事件对象 */
private void bookAddActionPerformed(ActionEvent evt) { 

   


	String bookName = bookNameText.getText(); // 获取图书名称
	if (bookName == null || "".equals(bookName.trim())) { 

   
		JOptionPane.showMessageDialog(null, "图书名称不能为空！");
		return;
	}
	String author = authorText.getText(); // 获取图书作者


	String sex = null; // 获取图书作者性别
	if (maleBtn.isSelected()) { 

   
		sex = "男";
	} else { 

   
		sex = "女";
	}


	String prices = priceText.getText(); // 获取图书价格
	if (prices == null || "".equals(prices.trim())) { 

   
		JOptionPane.showMessageDialog(null, "图书价格不能为空！");
		return;
	}
	float price = Float.parseFloat(prices);


	BookType bookType = (BookType) bookTypeComboBox.getSelectedItem(); // 获取图书类别
	int bookTypeId = bookType.getId(); // 获取图书类别id
	System.out.println("ID="+bookTypeId);


	String bookDesc = bookDescText.getText(); // 获取图书描述
	
	// 根据获取的添加图书界面获取的信息创建图书对象
	Book book = new Book(null, bookName, author, sex, price, bookTypeId, bookName, bookDesc);
	System.out.println("实体类："+book);
	// 定义数据库连接
	Connection con = null;
	try { 

   
		// 获取数据库连接
		con = DBTool.getConnetion();
		// 初始化图书数据访问对象
		bookDao = new BookDao();
		// 调用添加方法，向数据库添加书籍
		System.out.println("5555"+book);
		int num = bookDao.add(con, book);
		// 根据返回值判断图书是否添加成功
		if (num > 0) { 

   
			JOptionPane.showMessageDialog(null, "图书添加成功n_n");
			// 添加成功之后重置界面
			reset();
		} else { 

   
			JOptionPane.showMessageDialog(null, "图书添加成功u_u");
		}
	} catch (SQLException e) { 

   
		// 记录日志
		e.printStackTrace();
		throw new RuntimeException("添加图书失败", e);
	} finally { 

   
		// 关闭数据库连接
		DBTool.close(con);
	}
}


// 填充图书类别名称
private void fillBookTypeName() { 

   
	// 定义数据库连接对象
	Connection con = null;
	// 定义图书类别,用于查询和储存查询的书籍
	BookType bookType = null;
	try { 

   
		// 获取数据库连接
		con = DBTool.getConnetion();
		// 初始化图书类别访问对象
		bookTypeDao = new BookTypeDao();
		// 查询t_bookType中含有的图书类别
		ResultSet rs = bookTypeDao.search(con, bookType);
		// 遍历查询结果
		while (rs.next()) { 

   
			// 出事化图书类别
			bookType = new BookType();
			// 设置图书的id
			bookType.setId(rs.getInt("id"));
			// 设置图书的名称
			bookType.setBookTypeName(rs.getString("bookTypeName"));
			// 将图书类别对象添加到下拉框中（这里添加对象，便于获得id）
			bookTypeComboBox.addItem(bookType.getBookTypeName());
		}
	} catch (SQLException e) { 

   
		// 记录日志
		e.printStackTrace();
		throw new RuntimeException("初始化列表失败", e);
	} finally { 

   
		// 关闭数据路连接
		DBTool.close(con);
	}
}

}
⑦ LibraryInterFrame（关于我们界面）
package cn.ac.azure.view;



import java.awt.EventQueue;



import javax.swing.JInternalFrame;

import javax.swing.GroupLayout;

import javax.swing.GroupLayout.Alignment;

import javax.swing.JLabel;

import javax.swing.UIManager;

import javax.swing.ImageIcon;

import java.awt.Font;

import java.awt.Color;



public class LibraryInterFrame extends JInternalFrame { 

   

private static final long serialVersionUID = 1L;


/** * Launch the application. */
public static void main(String[] args) { 

   
	EventQueue.invokeLater(new Runnable() { 

   
		public void run() { 

   
			try { 

   
				LibraryInterFrame frame = new LibraryInterFrame();
				frame.setVisible(true);
			} catch (Exception e) { 

   
				e.printStackTrace();
			}
		}
	});
}


/** * Create the frame. */
public LibraryInterFrame() { 

   
	//改变系统默认字体
	Font font = new Font("Dialog", Font.PLAIN, 12);
	java.util.Enumeration keys = UIManager.getDefaults().keys();
	while (keys.hasMoreElements()) { 

   
		Object key = keys.nextElement();
		Object value = UIManager.get(key);
		if (value instanceof javax.swing.plaf.FontUIResource) { 

   
			UIManager.put(key, font);
		}
	}
	setClosable(true);
	setIconifiable(true);
	setBounds(450, 150, 503, 300);
	
	JLabel label = new JLabel("");
	label.setIcon(new ImageIcon(LibraryInterFrame.class.getResource("/images/library.png")));
	
	JLabel label_1 = new JLabel("欢迎使用图书管理系统");
	label_1.setForeground(Color.GREEN);
	label_1.setBackground(Color.GREEN);
	label_1.setFont(new Font("宋体", Font.PLAIN, 20));
	GroupLayout groupLayout = new GroupLayout(getContentPane());
	groupLayout.setHorizontalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup()
				.addContainerGap(140, Short.MAX_VALUE)
				.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
					.addGroup(Alignment.TRAILING, groupLayout.createSequentialGroup()
						.addComponent(label)
						.addGap(175))
					.addGroup(Alignment.TRAILING, groupLayout.createSequentialGroup()
						.addComponent(label_1)
						.addGap(137))))
	);
	groupLayout.setVerticalGroup(
		groupLayout.createParallelGroup(Alignment.LEADING)
			.addGroup(groupLayout.createSequentialGroup()
				.addGap(39)
				.addComponent(label)
				.addGap(28)
				.addComponent(label_1)
				.addContainerGap(51, Short.MAX_VALUE))
	);
	getContentPane().setLayout(groupLayout);
}

}
5、数据库【db_book】
/* Navicat Premium Data Transfer Source Server : 127.0.0.1 Source Server Type : MySQL Source Server Version : 50733 Source Host : localhost:3306 Source Schema : db_book Target Server Type : MySQL Target Server Version : 50733 File Encoding : 65001 Date: 19/07/2021 17:34:44 */



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for t_book

-- ----------------------------

DROP TABLE IF EXISTS `t_book`;

CREATE TABLE `t_book`  (

  `id` int(50) NOT NULL AUTO_INCREMENT,

  `bookName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `sex` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `price` double(50, 2) NULL DEFAULT NULL,

  `bookTypeId` int(50) NULL DEFAULT NULL,

  `bookTypeName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `bookDesc` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `fk_booktype`(`bookTypeId`) USING BTREE,

  CONSTRAINT `fk_booktype` FOREIGN KEY (`bookTypeId`) REFERENCES `t_booktype` (`id`) ON DELETE SET NULL ON UPDATE SET NULL

) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of t_book

-- ----------------------------

INSERT INTO `t_book` VALUES (1, '《人间失格》', '（日）太宰治', '男', 66.00, 1, '小说', '（日本小说家太宰治代表作，一个对村上春树影响至深的绝望凄美故事）');

INSERT INTO `t_book` VALUES (2, '《三体》', '刘慈欣', '女', 55.80, 1, '小说', '刘慈欣代表作，亚洲首部“雨果奖”获奖作品！\r\n《三体》第73届世界科幻雨果奖获奖作品，银河奖特别奖，《三体3》轨迹奖长篇科幻小说！2017年世界雨果奖提名作品。');

INSERT INTO `t_book` VALUES (3, '《人生海海》', '麦家', '男', 55.00, 2, '文化科学', '麦家重磅力作，莫言、董卿盛赞，连续两年高居各大畅销榜，发行量超180万册，罗一舟同款书）\r\n上校赢了所有的仗，却败给一个不足道的秘密。茅盾文学奖得主麦家暌违8年，打磨5年，挑战常人不敢落笔之处，解密人性的荒唐与高尚。人生海海，何必在意一时沉浮！');

INSERT INTO `t_book` VALUES (4, '《大国崛起》', '唐晋', '男', 50.40, 2, '历史', '以历史的眼光和全球的视野解读15世纪以来9个世界性大国崛起的历史，中国能否成为第十个崛起的大国？');

INSERT INTO `t_book` VALUES (5, '《中华人民共和国民法典》', '法律出版社', '男', 8.10, 2, '哲学、社会', '民法典是新中国首部以“法典”命名的法律，是新时代我国社会主义法治建设的重大成果，是为百姓生活量身定制的权利宝典。自2021年1月1日起施行。');



-- ----------------------------

-- Table structure for t_booktype

-- ----------------------------

DROP TABLE IF EXISTS `t_booktype`;

CREATE TABLE `t_booktype`  (

  `id` int(50) NOT NULL AUTO_INCREMENT,

  `bookTypeName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `bookTypeDesc` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of t_booktype

-- ----------------------------

INSERT INTO `t_booktype` VALUES (1, 'A 马克思主义、列宁主义、毛泽东思想、邓小平理论', 'A 马克思主义、列宁主义、毛泽东思想、邓小平理论');

INSERT INTO `t_booktype` VALUES (2, 'B 哲学、宗教', 'B 哲学、宗教');

INSERT INTO `t_booktype` VALUES (3, 'C 社会科学总论', 'C 社会科学总论');

INSERT INTO `t_booktype` VALUES (4, 'D 政治、法律', 'D 政治、法律');

INSERT INTO `t_booktype` VALUES (5, 'F 经济', 'F 经济');

INSERT INTO `t_booktype` VALUES (6, 'G 文化、科学、教育、体育', 'G 文化、科学、教育、体育');

INSERT INTO `t_booktype` VALUES (7, 'H 语言、文字', 'H 语言、文字');

INSERT INTO `t_booktype` VALUES (8, 'I 文学', 'I 文学');

INSERT INTO `t_booktype` VALUES (9, 'J 艺术', 'J 艺术');

INSERT INTO `t_booktype` VALUES (10, 'K 历史、地理', 'K 历史、地理');

INSERT INTO `t_booktype` VALUES (11, 'N 自然科学总论', 'N 自然科学总论');

INSERT INTO `t_booktype` VALUES (12, 'O 数理科学和化学', 'O 数理科学和化学');

INSERT INTO `t_booktype` VALUES (13, 'Q 生物科学', 'Q 生物科学');

INSERT INTO `t_booktype` VALUES (14, 'R 医药、卫生 ', 'R 医药、卫生');

INSERT INTO `t_booktype` VALUES (15, 'S 农业科学', 'S 农业科学');

INSERT INTO `t_booktype` VALUES (16, 'T-TN 工业技术', 'T-TN 工业技术');

INSERT INTO `t_booktype` VALUES (17, 'TP 自动化技术、计算机技术', 'TP 自动化技术、计算机技术');

INSERT INTO `t_booktype` VALUES (18, 'TQ 化学工业', 'TQ 化学工业');

INSERT INTO `t_booktype` VALUES (19, 'TU 建筑科学', 'TU 建筑科学');

INSERT INTO `t_booktype` VALUES (20, 'TV 水利工程', 'TV 水利工程');

INSERT INTO `t_booktype` VALUES (21, 'U 交通运输', 'U 交通运输');

INSERT INTO `t_booktype` VALUES (22, 'V 航空、航天', 'V 航空、航天');

INSERT INTO `t_booktype` VALUES (23, 'X 环境科学、安全科学', 'X 环境科学、安全科学');

INSERT INTO `t_booktype` VALUES (24, 'Z 综合性图书', 'Z 综合性图书');



-- ----------------------------

-- Table structure for t_user

-- ----------------------------

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user`  (

  `id` int(50) NOT NULL AUTO_INCREMENT,

  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of t_user

-- ----------------------------

INSERT INTO `t_user` VALUES (1, '11', '123456');



SET FOREIGN_KEY_CHECKS = 1;
三、项目地址：
CSDN赞助下载：
https://download.csdn.net/download/weixin_44893902/20367467

                    

                    


                    

                        

                            

                                编程小号
                            

                            

                                

                                    
                                        
                                    
                                

                            

                        

                    

                

                

                    
                    
                    

                        
                        

                             上一篇
                            2025-01-27 08:06
                        

                    

                    
                    


                    
                    
                    

                        
                        

                            下一篇 
                            2025-03-21 21:57
                        

                    

                    
                    
                


                

                    
相关推荐

                    
                

                

                    

                        版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，
                        请发送邮件至 举报，一经查实，本站将立刻删除。
如需转载请保留出处：https://bianchenghao.cn/hz/141712.html