基于 Java swing+mysql+eclipse 的 [图书馆管理系统]。
最编程
2024-06-03 16:01:25
...
大家好,又见面了,我是你们的朋友全栈君。
本项目为Java swing项目,在工作环境中基本使用不到,但是很多学校把这个当做编程入门的项目来做,故分享出本项目供初学者参考。
****赞助下载:https://download.****.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<Object> 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<Object> 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("");
//置空图书类别描述输入框
bookTypeDescTex
上一篇: 文字输入背后的文字消失的原因是什么?
下一篇: qq_42358549 的博客
推荐阅读
-
第一天就完成了一个基于SpringBoot的简易管理系统
-
Java爬虫+协同过滤+Springboot+vue.js实现的小说推荐系统,小说推荐平台,小说管理系统
-
"设计与实现基于SpringBoot的校园失物招领网站/平台/系统的计算机毕业设计:Java实战项目附带源码,文档和视频讲解"
-
我的毕业设计:基于SpringBoot的社区居民健康档案管理系统
-
毕业设计:打造个人健康管理利器——JAVA+Vue+SpringBoot+MySQL实现的系统
-
打造你的健康管理小助手——基于SpringBoot的个人健康管理系统简介
-
打造高校健康管理系统的Java、Spring Boot与Vue框架实践
-
Java实现的健康管理系统的功能和应用探讨
-
Java打造:宠物医院管理系统的设计与实践
-
高校宿舍调配管理系统实战:利用Java、Vue和Spring Boot实现的核心代码分享