📄 图书管理系统3).txt
字号:
String r_no=tf_r_no.getText();
try{
r_sql r_reg_insert=new r_sql();
r_reg_insert.r_del(r_no);
}catch(SQLException exc){
System.out.println("删除异常");
exc.printStackTrace();
System.exit(1);
}catch(ClassNotFoundException exc){
System.out.println("未发现类");
System.exit(1);
}
}
}
}
图书管理：
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
class b_reg_dia implements ActionListener{
private JDialog b_reg_dialog=null;
private JLabel la_b_no=new JLabel("书号");
private JLabel la_b_name=new JLabel("书名");
private JLabel la_b_auth=new JLabel("作者");
private JLabel la_b_typle=new JLabel("类型");
private JLabel la_b_puli=new JLabel("出版社");
private JTextField tf_b_no=new JTextField(10);
private JTextField tf_b_name=new JTextField(10);
private JTextField tf_b_auth=new JTextField(10);
private JTextField tf_b_typle=new JTextField(20);
private JTextField tf_b_puli=new JTextField(20);
private JButton b_regrit_butt=new JButton("注册");
private JButton b_reset_butt=new JButton("重置");
private JPanel la_b_panel= new JPanel();
private JPanel tf_b_panel= new JPanel();
private JPanel mess_b_panel= new JPanel();
private JPanel bu_b_panel= new JPanel();
public b_reg_dia(){
b_reg_dialog=new JDialog(frameDemo.mainFrame,"图书登记");
JPanel mainpanel=(JPanel)b_reg_dialog.getContentPane();
la_b_panel.setLayout(new GridLayout(5,1,2,2));
la_b_no.setHorizontalAlignment(SwingConstants.CENTER);
la_b_panel.add(la_b_no);
la_b_name.setHorizontalAlignment(SwingConstants.CENTER);
la_b_panel.add(la_b_name);
la_b_auth.setHorizontalAlignment(SwingConstants.CENTER);
la_b_panel.add(la_b_auth);
la_b_typle.setHorizontalAlignment(SwingConstants.CENTER);
la_b_panel.add(la_b_typle);
la_b_puli.setHorizontalAlignment(SwingConstants.CENTER);
la_b_panel.add(la_b_puli);
tf_b_panel.setLayout(new GridLayout(5,1,2,2));
tf_b_panel.add(tf_b_no);
tf_b_panel.add(tf_b_name);
tf_b_panel.add(tf_b_auth);
tf_b_panel.add(tf_b_typle);
tf_b_panel.add(tf_b_puli);
bu_b_panel.setLayout(new FlowLayout());
bu_b_panel.add(b_regrit_butt);
b_regrit_butt.addActionListener(this);
bu_b_panel.add(b_reset_butt);
b_reset_butt.addActionListener(this);
mess_b_panel.setLayout(new GridLayout(1,2));
mess_b_panel.add(la_b_panel);
mess_b_panel.add(tf_b_panel);
mainpanel.setLayout(new BorderLayout());
mainpanel.add(mess_b_panel,BorderLayout.CENTER);
mainpanel.add(bu_b_panel,BorderLayout.SOUTH);
b_reg_dialog.setSize(400,260);
b_reg_dialog.setLocation(200,180);
b_reg_dialog.setVisible(true);
}
public void actionPerformed(ActionEvent e){
String com=e.getActionCommand();
if(com=="注册"){
String b_no=tf_b_no.getText();
String b_name=tf_b_name.getText();
String b_auth=tf_b_auth.getText();
String b_typle=tf_b_typle.getText();
String b_puli=tf_b_puli.getText();
try{
b_sql b_reg_=new b_sql();
b_reg_.b_reg(b_no,b_name,b_auth,b_typle,b_puli);
}catch(SQLException exc){
System.out.println("注册异常");
exc.printStackTrace();
System.exit(1);
}catch(ClassNotFoundException exc){
System.out.println("未发现类");
System.exit(1);
}
}
else{
tf_b_no.setText("");
tf_b_name.setText("");
tf_b_auth.setText("");
tf_b_typle.setText("");
tf_b_puli.setText("");
}
}
}
图书查询：
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
class b_sel_dia implements ActionListener{
private JDialog b_sel_dialog=null;
private JLabel la_b_no=new JLabel("书号");
private JLabel la_b_name=new JLabel("书名");
private JLabel la_b_auth=new JLabel("作者");
private JLabel la_b_typle=new JLabel("类型");
private JLabel la_b_puli=new JLabel("出版社");
static JTextField tf_b_no=new JTextField(10);
static JTextField tf_b_name=new JTextField(10);
static JTextField tf_b_auth=new JTextField(10);
static JTextField tf_b_typle=new JTextField(10);
static JTextField tf_b_puli=new JTextField(20);
private JButton jb_b_sel=new JButton("查询");
private JButton jb_b_del=new JButton("删除");
private JButton jb_b_reset=new JButton("重置");
private JPanel jp_b_sel=new JPanel();
private JPanel jp_b_la=new JPanel();
private JPanel jp_b_tf=new JPanel();
private JPanel jp_b_main=new JPanel();
private JPanel jp_b_del=new JPanel();
public b_sel_dia(){
b_sel_dialog=new JDialog(frameDemo.mainFrame,"图书信息查询");
JPanel mainpanel=(JPanel)b_sel_dialog.getContentPane();
jp_b_sel.setLayout(new FlowLayout());
jp_b_sel.add(la_b_no);
jp_b_sel.add(tf_b_no);
jp_b_sel.add(jb_b_sel);
jb_b_sel.setEnabled(true);
jb_b_sel.addActionListener(this);
jp_b_la.setLayout(new GridLayout(4,1,2,2));
la_b_name.setHorizontalAlignment(SwingConstants.CENTER);
jp_b_la.add(la_b_name);
la_b_auth.setHorizontalAlignment(SwingConstants.CENTER);
jp_b_la.add(la_b_auth);
la_b_typle.setHorizontalAlignment(SwingConstants.CENTER);
jp_b_la.add(la_b_typle);
la_b_puli.setHorizontalAlignment(SwingConstants.CENTER);
jp_b_la.add(la_b_puli);
jp_b_tf.setLayout(new GridLayout(4,1,2,2));
jp_b_tf.add(tf_b_name);
jp_b_tf.add(tf_b_auth);
jp_b_tf.add(tf_b_typle);
jp_b_tf.add(tf_b_puli);
jp_b_del.setLayout(new FlowLayout());
jp_b_del.add(jb_b_del);
jp_b_del.add(jb_b_reset);
jb_b_del.setEnabled(false);
jb_b_reset.setEnabled(false);
jb_b_del.addActionListener(this);
jb_b_reset.addActionListener(this);
jp_b_main.setLayout(new GridLayout(1,2));
jp_b_main.add(jp_b_la);
jp_b_main.add(jp_b_tf);
mainpanel.setLayout(new BorderLayout());
mainpanel.add(jp_b_sel,BorderLayout.NORTH);
mainpanel.add(jp_b_main,BorderLayout.CENTER);
mainpanel.add(jp_b_del,BorderLayout.SOUTH);
b_sel_dialog.setSize(400,260);
b_sel_dialog.setLocation(200,180);
b_sel_dialog.setVisible(true);
}
public void actionPerformed(ActionEvent e){
String com = e.getActionCommand();
if(com.equals("查询"))
{ jb_b_sel.setEnabled(false);
jb_b_del.setEnabled(true);
jb_b_reset.setEnabled(true);
String b_no=tf_b_no.getText();
try{
b_sql b_sel_=new b_sql();
b_sel_.b_sel(b_no);
}catch(SQLException exc){
System.out.println("查询异常");
exc.printStackTrace();
System.exit(1);
}catch(ClassNotFoundException exc){
System.out.println("未发现类");
System.exit(1);
}
}
if(com.equals("重置")){
jb_b_sel.setEnabled(true);
jb_b_del.setEnabled(false);
jb_b_reset.setEnabled(false);
tf_b_no.setText("");
tf_b_name.setText("");
tf_b_auth.setText("");
tf_b_typle.setText("");
tf_b_puli.setText("");
}
if(com.equals("删除")){
jb_b_sel.setEnabled(false);
jb_b_del.setEnabled(false);
jb_b_reset.setEnabled(true);
String b_no=tf_b_no.getText();
try{
b_sql b_del_=new b_sql();
b_del_.b_del(b_no);
}catch(SQLException exc){
System.out.println("删除异常");
exc.printStackTrace();
System.exit(1);
}catch(ClassNotFoundException exc){
System.out.println("未发现类");
System.exit(1);
}
}
}
}
图书借出：
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
import java.text.*;
class bo_borrow_dia implements ActionListener{
private JDialog bo_borrow_dialog=null;
private JLabel la_bo_rno=new JLabel("读者号");
private JLabel la_bo_bno=new JLabel("书号");
private JLabel la_bo_outday=new JLabel("借出日期");
private JLabel la_bo_inday=new JLabel("归还日期");
private JTextField tf_bo_rno=new JTextField(10);
private JTextField tf_bo_bno=new JTextField(10);
private JTextField tf_bo_outday=new JTextField(20);
private JTextField tf_bo_inday=new JTextField(20);
private JButton bo_regrit_butt=new JButton("登记");
private JButton bo_reset_butt=new JButton("重置");
private JPanel la_bo_panel= new JPanel();
private JPanel tf_bo_panel= new JPanel();
private JPanel mess_bo_panel= new JPanel();
private JPanel bu_bo_panel= new JPanel();
public bo_borrow_dia(){
bo_borrow_dialog=new JDialog(frameDemo.mainFrame,"图书借阅");
JPanel mainpanel=(JPanel)bo_borrow_dialog.getContentPane();
la_bo_panel.setLayout(new GridLayout(4,1,2,2));
la_bo_rno.setHorizontalAlignment(SwingConstants.CENTER);
la_bo_panel.add(la_bo_rno);
la_bo_bno.setHorizontalAlignment(SwingConstants.CENTER);
la_bo_panel.add(la_bo_bno);
la_bo_outday.setHorizontalAlignment(SwingConstants.CENTER);
la_bo_panel.add(la_bo_outday);
la_bo_inday.setHorizontalAlignment(SwingConstants.CENTER);
la_bo_panel.add(la_bo_inday);
tf_bo_panel.setLayout(new GridLayout(4,1,2,2));
tf_bo_panel.add(tf_bo_rno);
tf_bo_panel.add(tf_bo_bno);
tf_bo_panel.add(tf_bo_outday);
tf_bo_panel.add(tf_bo_inday);
bu_bo_panel.setLayout(new FlowLayout());
bu_bo_panel.add(bo_regrit_butt);
bo_regrit_butt.addActionListener(this);
bu_bo_panel.add(bo_reset_butt);
bo_reset_butt.addActionListener(this);
mess_bo_panel.setLayout(new GridLayout(1,2));
mess_bo_panel.add(la_bo_panel);
mess_bo_panel.add(tf_bo_panel);
mainpanel.setLayout(new BorderLayout());
mainpanel.add(mess_bo_panel,BorderLayout.CENTER);
mainpanel.add(bu_bo_panel,BorderLayout.SOUTH);
bo_borrow_dialog.setSize(400,260);
bo_borrow_dialog.setLocation(200,180);
bo_borrow_dialog.setVisible(true);
}
public void actionPerformed(ActionEvent e){
String com=e.getActionCommand();
if(com=="登记"){
String bo_rno=tf_bo_rno.getText();
String bo_bno=tf_bo_bno.getText();
String bo_outday=tf_bo_outday.getText();
tf_bo_inday.setEnabled(false);
String bo_inday=tf_bo_inday.getText();
try{
bo_sql bo_reg_=new bo_sql();
bo_reg_.bo_reg(bo_rno,bo_bno,bo_outday,bo_inday);
}catch(SQLException exc){
System.out.println("注册异常");
exc.printStackTrace();
System.exit(1);
}catch(ClassNotFoundException exc){
System.out.println("未发现类");
System.exit(1);
}
}
else{
tf_bo_rno.setText("");
tf_bo_bno.setText("");
tf_bo_outday.setText("");
tf_bo_inday.setText("");
}
}
}
图书归还：
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.lang.*;
import java.sql.*;
class bo_return_dia implements ActionListener{
private JDialog bo_return_dialog=null;
private JLabel la_bo_rno=new JLabel("读者号");
private JLabel la_bo_bno=new JLabel("书号");
private JLabel la_bo_outday=new JLabel("借出日期");
private JLabel la_bo_inday=new JLabel("归还日期");
static JTextField tf_bo_rno=new JTextField(10);
static JTextField tf_bo_bno=new JTextField(10);
static JTextField tf_bo_outday=new JTextField(20);
static JTextField tf_bo_inday=new JTextField(20);
private JButton bo_return_butt=new JButton("归还");
private JButton bo_reset_butt=new JButton("重置");
private JPanel la_bo_panel= new JPanel();
private JPanel tf_bo_panel= new JPanel();
private JPanel mess_bo_panel= new JPanel();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -