数据库课程设计-图书馆信息管理系统

package gui; import java.awt.Color; import java.awt.Component; import java.awt.Font; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.awt.*; import java.sql.ResultSet; import java.sql.SQLException; import java.util.concurrent.ExecutorService; import java.util.concurrent.Executors; import javax.swing.*; import dbAPI.DataBaseAPI; import dbAPI.SearchOrdersAndBorrows; import myManagerPanels.BookAddPane; import myManagerPanels.BookListPane; import myManagerPanels.BorrowPane; import myManagerPanels.MUpdatePane; import myManagerPanels.ManagerAddPane; import myManagerPanels.ManagerListPane; import myManagerPanels.ManagerPane; import myManagerPanels.OrderListPane; import myManagerPanels.PunishListPane; import myManagerPanels.ReaderAddPane; import myManagerPanels.ReaderListPane; import myManagerPanels.ReturnPane; public class ManagerGUI extends JFrame implements ActionListener{ JLayeredPane jlayeredpane; ImageIcon backIcon; JLabel background; JMenuBar jmb; JMenu mxx,msjgl,myhgl,mjygl; JMenuItem mizy,misjc,misjtj,midztj,miglytj,miyhlb,miglylb,misjjy,misjgh,miwzq,miyys,mixx1,mixx2,mitc; Font font=new Font("隶书",Font.BOLD,15),font2=new Font("宋体",Font.ITALIC|Font.BOLD,28); JLabel jl; JPanel contentPane; BookListPane blp; PunishListPane plp; OrderListPane olp; MUpdatePane mup; ManagerPane mp; ReaderAddPane rap; ManagerAddPane map; ReaderListPane rlp; ManagerListPane mlp; BookAddPane bap; BorrowPane bp; ReturnPane rp; String managerid; DataBaseAPI databaseapi; SearchOrdersAndBorrows soab; //JPanel j1=new JPanel(); public ManagerGUI(String mid){ super("管理员主页系统"); this.setLocation(300, 100); this.setDefaultCloseOperation(DISPOSE_ON_CLOSE); this.addWindowListener(new WindowAdapter(){ public void windowClosed(WindowEvent e){ System.out.println("Window closing"); System.exit(0); } }); this.setSize(800, 600); this.setVisible(true); managerid=mid; //把内容板设成层板 jlayeredpane=new JLayeredPane(); this.setContentPane(jlayeredpane); //设置背景图片 backIcon=new ImageIcon("meihua.jpg"); background=new JLabel(backIcon); background.setBounds(0, 0, 800, 600); background.setBorder(BorderFactory.createEtchedBorder()); jlayeredpane.setLayer(background, JLayeredPane.FRAME_CONTENT_LAYER.intValue()); jlayeredpane.add(background); //构造contentpane contentPane=new JPanel(); contentPane.setSize(800, 600); contentPane.setOpaque(false); contentPane.setLayout(null); //加菜单 jmb=new JMenuBar(); jmb.setLayout(new GridLayout(1,10)); mizy=new JMenuItem("主页"); //mizy.setBackground(Color.LIGHT_GRAY); mizy.setForeground(Color.BLACK); mizy.setSize(50,25); mizy.setFont(font); //mizy.setBorder(BorderFactory.createRaisedBevelBorder()); //mizy.setLocation(1, 2); mizy.addActionListener(this); //contentPane.add(mizy); jl=new JLabel("欢迎使用图书管理信息系统"); jl.setOpaque(false); jl.setFont(font2); jl.setSize(380,100); jl.setLocation(100, 100); jl.setForeground(Color.red); contentPane.add(jl); jmb.add(mizy); //书籍管理菜单 msjgl=new JMenu("书籍管理"); msjgl.setSize(100,25); msjgl.setForeground(Color.BLACK); msjgl.setFont(font); misjtj=new JMenuItem("书籍添加"); //mixx1.setBackground(Color.LIGHT_GRAY); misjtj.setForeground(Color.BLACK); misjtj.setSize(100,25); misjtj.setFont(font); misjtj.addActionListener(this); msjgl.add(misjtj); misjc=new JMenuItem("书籍列表"); //misjc.setBackground(Color.LIGHT_GRAY); misjc.setForeground(Color.BLACK); misjc.setSize(100,25); misjc.setFont(font); //misjc.setBorder(BorderFactory.createRaisedBevelBorder()); misjc.addActionListener(this); //misjc.setLocation(56, 2); //contentPane.add(misjc); msjgl.add(misjc); jmb.add(msjgl); //用户管理菜单midztj,miglytj,miyhlb,miglylb myhgl=new JMenu("用户管理"); myhgl.setSize(100,25); myhgl.setForeground(Color.BLACK); myhgl.setFont(font); midztj=new JMenuItem("读者添加"); //mixx1.setBackground(Color.LIGHT_GRAY); midztj.setForeground(Color.BLACK); midztj.setSize(100,25); midztj.setFont(font); midztj.addActionListener(this); myhgl.add(midztj); miglytj=new JMenuItem("管理员添加"); //misjc.setBackground(Color.LIGHT_GRAY); miglytj.setForeground(Color.BLACK); miglytj.setSize(100,25); miglytj.setFont(font); //misjc.setBorder(BorderFactory.createRaisedBevelBorder()); miglytj.addActionListener(this); //misjc.setLocation(56, 2); //contentPane.add(misjc); myhgl.add(miglytj); miyhlb=new JMenuItem("读者列表"); //mixx1.setBackground(Color.LIGHT_GRAY); miyhlb.setForeground(Color.BLACK); miyhlb.setSize(100,25); miyhlb.setFont(font); miyhlb.addActionListener(this); myhgl.add(miyhlb); miglylb=new JMenuItem("管理员列表"); //misjc.setBackground(Color.LIGHT_GRAY); miglylb.setForeground(Color.BLACK); miglylb.setSize(100,25); miglylb.setFont(font); //misjc.setBorder(BorderFactory.createRaisedBevelBorder()); miglylb.addActionListener(this); //misjc.setLocation(56, 2); //contentPane.add(misjc); myhgl.add(miglylb); jmb.add(myhgl); //借阅管理 mjygl=new JMenu("借阅管理"); mjygl.setSize(100,25); mjygl.setForeground(Color.BLACK); mjygl.setFont(font); misjjy=new JMenuItem("书籍借阅"); //mixx1.setBackground(Color.LIGHT_GRAY); misjjy.setForeground(Color.BLACK); misjjy.setSize(100,25); misjjy.setFont(font); misjjy.addActionListener(this); mjygl.add(misjjy); misjgh=new JMenuItem("书籍归还"); //misjc.setBackground(Color.LIGHT_GRAY); misjgh.setForeground(Color.BLACK); misjgh.setSize(100,25); misjgh.setFont(font); //misjc.setBorder(BorderFactory.createRaisedBevelBorder()); misjgh.addActionListener(this); //misjc.setLocation(56, 2); //contentPane.add(misjc); mjygl.add(misjgh); jmb.add( mjygl); //预约列表 miyys=new JMenuItem("书籍预约"); //miyys.setBackground(Color.LIGHT_GRAY); miyys.setForeground(Color.BLACK); miyys.setSize(80,25); //miyys.setLocation(311,2); miyys.setFont(font); //miyys.setBorder(BorderFactory.createRaisedBevelBorder()); miyys.addActionListener(this); //contentPane.add(miyys); jmb.add(miyys); //违章列表 miwzq=new JMenuItem("违章列表"); //miwzq.setBackground(Color.LIGHT_GRAY); miwzq.setForeground(Color.BLACK); miwzq.setSize(80,25); miwzq.setFont(font); //miwzq.setLocation(226,2); //miwzq.setBorder(BorderFactory.createRaisedBevelBorder()); miwzq.addActionListener(this); //contentPane.add(miwzq); jmb.add(miwzq); //读者信息查看 mxx=new JMenu("管理员信息"); mxx.setSize(100,25); mxx.setForeground(Color.BLACK); mxx.setFont(font); mixx1=new JMenuItem("个人信息查看"); //mixx1.setBackground(Color.LIGHT_GRAY); mixx1.setForeground(Color.BLACK); mixx1.setSize(100,25); mixx1.setFont(font); //mixx1.setLocation(396,2); //mixx1.setBorder