readermanagement.java

JAVA编写的图书馆管理系统

//办理读者挂失、解除挂失、读者注销与到期续证
import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;
import java.io.*;
import java.util.*;

public class ReaderManagement implements ActionListener,ListSelectionListener
{
 public  JButton btn01,btn02,btn03,btn04,btn05,btn06;
 public  JTextField jtfd1,jtfd2,jtfd3,jtfd5,jtfd6,jtfd7,jtfd9,jtfd11,jtfd12,jtfd13,jtfd14,jtfd15,jtfd16,jtfd4,jtfd8,jtfd10;
 public  JTextArea jta;
 public String str1,str2,str3,str4,str5,str6,str7,str8,str9,str10,str11,str12,str13,str14,str15,str16,str17;
 public  Connection con;
 public JTable table;
 public Object rowData[][];
 public ListSelectionModel selectionMode=null;
 public  JFrame frame;

public ReaderManagement()
{JFrame.setDefaultLookAndFeelDecorated(true);
 frame=new JFrame("读者挂失、解除挂失与到期续证");
 ImageIcon icon=new ImageIcon("images/home.gif");
 frame.setIconImage(icon.getImage());
 frame.setResizable(false);
 Font font1=new Font("宋体",Font.PLAIN,13);
 Container content=frame.getContentPane();
 content.setLayout(null);
 Toolkit tool=frame.getToolkit();
 Dimension wndsize=tool.getScreenSize();

 /*************************************创建工具栏***********************************************************/
 //--初始化工具栏各个组件--
         btn01=new JButton("查询",new ImageIcon("images/find.gif"));
 		btn02=new JButton("刷新",new ImageIcon("images/BOOKS02.gif"));
 		btn03=new JButton("挂失",new ImageIcon("images/cc.gif"));
 		btn04=new JButton("恢复",new ImageIcon("images/reader.gif"));
         btn05=new JButton("到期续证",new ImageIcon("images/card.gif"));
         btn06=new JButton("退出",new ImageIcon("images/ren1.gif"));

 	    //--设置工具栏各个组件的提示--
 	    btn01.setToolTipText("查询读者借书证信息");
 		btn02.setToolTipText("刷新读者借书证信息");
 		btn03.setToolTipText("挂失读者借书证");
 		btn04.setToolTipText("恢复读者借书证");
 		btn05.setToolTipText("读者到期续证,请在截止日期文本框内输入续证期限");
        btn06.setToolTipText("退出");

 	    //--为工具栏中各个组件添加事件--
 	    btn01.addActionListener(this);
 	    btn02.addActionListener(this);
 	    btn03.addActionListener(this);
 	    btn04.addActionListener(this);
         btn05.addActionListener(this);
         btn06.addActionListener(this);

         //--添加工具栏各个组件--
         JToolBar JTB=new JToolBar();
 	    JTB.addSeparator();
 		JTB.addSeparator();
 		JTB.add(btn01);
 		JTB.add(btn02);
 		JTB.addSeparator();
 		JTB.add(btn03);
 		JTB.add(btn04);
 		JTB.add(btn05);
 		JTB.addSeparator();
 		JTB.add(btn06);

 		//--为各个组件设置字体--
 		btn01.setFont(font1);
 	    btn02.setFont(font1);
 		btn03.setFont(font1);
 	    btn04.setFont(font1);
 	    btn05.setFont(font1);
 	     btn06.setFont(font1);
 	    JTB.setFont(font1);

 	    JTB.setFloatable(false);
 		JTB.setBorder(BorderFactory.createLoweredBevelBorder());
        JTB.setBounds(0,2,wndsize.width-10,45);

/*************************************创建验证信息界面***********************************************************/
 //--初始化各个组件--
 JLabel lb0=new JLabel("读者姓名:");
 JLabel lb1=new JLabel("读者编号:");
 JLabel lb2=new JLabel("条形编码:");
 JLabel lb3=new JLabel("性   别:");
 JLabel lb4=new JLabel("读者身份:");
 JLabel lb5=new JLabel("有效证件:");
 JLabel lb6=new JLabel("证件号码:");
 JLabel lb7=new JLabel("注册日期:");
 JLabel lb8=new JLabel("截止日期:");
 JLabel lb9=new JLabel("出生日期:");
 JLabel lb10=new JLabel("联系电话:");
 JLabel lb11=new JLabel("联系地址:");
 JLabel lb12=new JLabel("读者状态:");
 JLabel lb13=new JLabel("可借数量:");
 JLabel lb14=new JLabel("最长期限:");
 JLabel lb15=new JLabel("操作人员:");
 JLabel lb16=new JLabel("备   注:");

 jtfd1=new JTextField();
 jtfd2=new JTextField();
 jtfd3=new JTextField();
 jtfd4=new JTextField();
 jtfd8=new JTextField();
 jtfd10=new JTextField();
 jtfd5=new JTextField();
 jtfd6=new JTextField();
 jtfd7=new JTextField();
 jtfd9=new JTextField();
 jtfd11=new JTextField();
 jtfd12=new JTextField();
 jtfd13=new JTextField();
 jtfd14=new JTextField();
 jtfd15=new JTextField();
 jtfd16=new JTextField();
 jta=new JTextArea();
 jta.setLineWrap(true);
 JScrollPane js=new JScrollPane(jta,
             JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,
             JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

 //--设置各个组件初始化时不可用--
 jtfd1.setEnabled(false);
 jtfd2.setEnabled(false);
 jtfd3.setEnabled(false);
 jtfd4.setEnabled(false);
 jtfd8.setEnabled(false);
 jtfd10.setEnabled(false);
 jtfd5.setEnabled(false);
 jtfd6.setEnabled(false);
 jtfd9.setEnabled(false);
 jtfd11.setEnabled(false);
 jtfd12.setEnabled(false);
 jtfd13.setEnabled(false);
 jtfd14.setEnabled(false);
 jtfd15.setEnabled(false);
 jtfd16.setEnabled(false);
 jta.setEnabled(false);

 //--设置各个组件的大小和位置--
 lb0.setBounds(40,35,60,25);jtfd1.setBounds(110,35,150,25);
 lb1.setBounds(270,35,60,25);jtfd2.setBounds(340,35,150,25);
 lb2.setBounds(500,35,60,25);jtfd3.setBounds(570,35,150,25);
 lb3.setBounds(730,35,60,25);jtfd4.setBounds(800,35,150,25);

 lb4.setBounds(40,70,60,25);jtfd8.setBounds(110,70,150,25);
 lb5.setBounds(270,70,60,25);jtfd10.setBounds(340,70,150,25);
 lb6.setBounds(500,70,60,25);jtfd5.setBounds(570,70,150,25);
 lb7.setBounds(730,70,60,25);jtfd6.setBounds(800,70,150,25);

 lb8.setBounds(40,105,60,25);jtfd7.setBounds(110,105,150,25);
 lb9.setBounds(270,105,60,25);jtfd9.setBounds(340,105,150,25);
 lb11.setBounds(500,105,60,25);jtfd12.setBounds(570,105,150,25);
 lb10.setBounds(730,105,60,25);jtfd11.setBounds(800,105,150,25);

 lb12.setBounds(40,140,60,25);jtfd13.setBounds(110,140,150,25);
 lb13.setBounds(270,140,60,25);jtfd14.setBounds(340,140,150,25);
 lb14.setBounds(500,140,60,25);jtfd15.setBounds(570,140,150,25);
 lb15.setBounds(730,140,60,25);jtfd16.setBounds(800,140,150,25);

 lb16.setBounds(40,175,60,25);js.setBounds(110,180,840,80);

 //--设置各个组件的字体--
 lb0.setFont(font1);
 jtfd1.setFont(font1);

 lb1.setFont(font1);
 jtfd2.setFont(font1);

 lb2.setFont(font1);
 jtfd3.setFont(font1);

 lb3.setFont(font1);
 jtfd4.setFont(font1);

 lb4.setFont(font1);
 jtfd5.setFont(font1);

 lb5.setFont(font1);
 jtfd6.setFont(font1);

 lb6.setFont(font1);
 jtfd7.setFont(font1);

 lb7.setFont(font1);
 jtfd8.setFont(font1);

 lb8.setFont(font1);
 jtfd9.setFont(font1);

 lb9.setFont(font1);
 jtfd10.setFont(font1);

 lb10.setFont(font1);
 jtfd11.setFont(font1);

 lb11.setFont(font1);
 jtfd12.setFont(font1);

 lb12.setFont(font1);
 jtfd13.setFont(font1);

 lb13.setFont(font1);
 jtfd14.setFont(font1);

 jta.setFont(font1);
 lb14.setFont(font1);
 lb15.setFont(font1);
 lb16.setFont(font1);
 jtfd15.setFont(font1);
 jtfd16.setFont(font1);

 //--添加各个组件--
 JPanel pane=new JPanel();
 pane.setLayout(null);
 pane.add(lb0);
 pane.add(jtfd1);
 pane.add(lb1);
 pane.add(jtfd2);
 pane.add(lb2);
 pane.add(jtfd3);
 pane.add(lb3);
 pane.add(jtfd4);
 pane.add(lb4);
 pane.add(jtfd8);
 pane.add(lb5);
 pane.add(jtfd10);
 pane.add(lb6);
 pane.add(jtfd5);
 pane.add(lb7);
 pane.add(jtfd6);
 pane.add(lb8);
 pane.add(jtfd7);
 pane.add(lb9);
 pane.add(jtfd9);
 pane.add(lb10);
 pane.add(jtfd11);
 pane.add(lb11);
 pane.add(jtfd12);
 pane.add(lb12);
 pane.add(jtfd13);
 pane.add(lb13);
 pane.add(jtfd14);
 pane.add(lb14);
 pane.add(jtfd15);
 pane.add(lb15);
 pane.add(jtfd16);
 pane.add(lb16);
 pane.add(js);
 pane.setBounds(5,50,wndsize.width-20,wndsize.height-85);
 pane.setBorder(
 	 	 		                BorderFactory.createCompoundBorder(
 	 	 		                BorderFactory.createTitledBorder("读者信息"),
	                            BorderFactory.createLoweredBevelBorder()));

/*********************************创建数据表格界面************************************************/
Object columnNames[]={"读者姓名","读者编号","条形码","性别","身份","有效证件","证件号码","注册日期","截止日期","出生日期","联系电话","联系地址","读者状态","可借数量","最长期限","借阅次数","操作员","备注"};
        rowData=new Object[1000][18];
        table=new JTable(rowData,columnNames);
        table.setRowHeight(20);
        table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        table.setCellSelectionEnabled(true);//使得表格的选取是以cell为单位,而不是以列为单位.若你没有写此行,则在选取表格数
		                                           //据时以整列为单位.
		selectionMode=table.getSelectionModel();//取得table的ListSelectionModel.
   	    selectionMode.addListSelectionListener(this);
        table.setPreferredScrollableViewportSize(new Dimension(500,30));