systemmanagewindow.java

图书馆的图书管理系统！ 图书查询

package labraryManager;
import javax.swing.*;

import java.awt.*;
import java.awt.event.*;
import java.io.*;

import java.sql.SQLException;
import java.util.Vector;

import javax.swing.border.*;


public class SystemManageWindow extends JFrame implements ActionListener{
    public static final int WIDTH=500;
    public static final int HEIGHT=300;
    public static JFileChooser fileChooser=new JFileChooser(".");
    public static String bank="book";
    public static int count=0;
    private CardLayout dealer;
    private JPanel deck;
    int result;
    JDialog frame=new JDialog();
    JTextField t111;
    JPasswordField t211;
    String s="";

    
    Vector vv=new Vector();
    String ss1="";
    String ss2="";
    String ss3="";
    String ss4="";
    String ss5="";
    String ss6="";
    String ss7="";
    String ss8="";
    
    JTextField t11;
    JTextField t13;
    JTextField t14;
    JTextField t15;
    JTextField t16;
    JTextField t17;
    JTextField t18;
    JTextField t19;
    
    JTextField t1;
    JTextField t3;
    JTextField t4;
    JTextField t5;
    JTextField t6;
    JTextField t7;
    
    JTextField t21;
    JTextField t22;
    JTextField t23;
    JTextField t24;
    JTextField t25;
    
    JTextField bt2;
    JTextField bt4;
    JTextField bt6;
    
    JTextField rn2;
    JTextField bn2;
    JTextField ot2;
    
    JTextField mn2;
    JPasswordField op2;
    JPasswordField np2;
    JPasswordField anp2;
    
    public SystemManageWindow(){
    	setSize(WIDTH,HEIGHT);
    	setDefaultCloseOperation(WindowConstants.DO_NOTHING_ON_CLOSE);
    	addWindowListener(new WindowDestroyer());
    	setTitle("图书管理系统");
    	Container x=getContentPane();
    	
    	x.setLayout(new BorderLayout());
    	
    	
    	
    	dealer=new CardLayout();
    	deck=new JPanel();
    	deck.setLayout(dealer);
    	
    	JPanel c1=new JPanel();
    	
    	c1.setLayout(new BorderLayout());
    	
    	JPanel m5=new JPanel();
    	
    	m5.setLayout(new GridLayout(8,1));
    	
    	JPanel m1=new JPanel();
    	
    	m1.setLayout(new FlowLayout());
    	JLabel l1=new JLabel("  图书编号");
    	
    	t11=new JTextField(30);
    	
    	m1.add(l1);
    	m1.add(t11);
    	
    	
    	
    	m5.add(m1);
    	
    	JPanel m2=new JPanel();
    	
    	m2.setLayout(new FlowLayout());
    	JLabel l2=new JLabel("  图书书名");
    	t13=new JTextField(30);
    	m2.add(l2);
    	m2.add(t13);
    	m5.add(m2);
    	
    	JPanel m3=new JPanel();
    	
    	m3.setLayout(new FlowLayout());
    	JLabel l3=new JLabel("  图书作者");
    	 t14=new JTextField(30);
    	m3.add(l3);
    	m3.add(t14);
    	m5.add(m3);
    	
    	JPanel m4=new JPanel();
    	
    	m4.setLayout(new FlowLayout());
    	JLabel l4=new JLabel("图书出版社");
    	 t15=new JTextField(30);
    	m4.add(l4);
    	m4.add(t15);
    	m5.add(m4);
    	
    	JPanel m6=new JPanel();
    	
    	m6.setLayout(new FlowLayout());
    	JLabel l6=new JLabel("  图书单价");
    	 t16=new JTextField(30);
    	m6.add(l6);
    	m6.add(t16);
    	m5.add(m6);
    	
    	JPanel m7=new JPanel();
    	
    	m7.setLayout(new FlowLayout());
    	JLabel l7=new JLabel("  图书摘要");
    	 t17=new JTextField(30);
    	m7.add(l7);
    	m7.add(t17);
    	m5.add(m7);
    	
    	JPanel m8=new JPanel();
    	
    	m8.setLayout(new FlowLayout());
    	JLabel l8=new JLabel("  图书分类");
    	 t18=new JTextField(30);
    	m8.add(l8);
    	m8.add(t18);
    	m5.add(m8);
    	
    	JPanel m9=new JPanel();
    	
    	m9.setLayout(new FlowLayout());
    	JLabel l9=new JLabel("  图书状态");
    	 t19=new JTextField(30);
    	 t19.setEnabled(false);
    	 t19.setText("在库");
    	m9.add(l9);
    	m9.add(t19);
    	m5.add(m9);
    	
    	c1.add(m5,BorderLayout.CENTER);
    	
    	
    	
    	JPanel m=new JPanel();
    	m.setLayout(new BoxLayout(m,BoxLayout.Y_AXIS));
    	
    	
    	JButton n1=new JButton("上移");
    	
    	n1.addActionListener(this);
    	m.add(n1);
    	JButton n2=new JButton("下移");
    	
    	n2.addActionListener(this);
    	m.add(n2);
    	JButton n3=new JButton("添加");
    	
    	n3.addActionListener(this);
    	m.add(n3);
    	JButton n4=new JButton("删除");
    	
    	n4.addActionListener(this);
    	m.add(n4);
    	JButton n5=new JButton("修改");
    	
    	n5.addActionListener(this);
    	m.add(n5);
    	
    	c1.add(m,BorderLayout.EAST);
    	
    	deck.add("c1",c1);
    	
    	JPanel c2=new JPanel();
    	
    	c2.setLayout(new BorderLayout());
    	
    	
    	
    	
    	JPanel g5=new JPanel();
    	
    	g5.setLayout(new GridLayout(6,1));
    	
    	JPanel g1=new JPanel();
    	
    	g1.setLayout(new FlowLayout());
    	JLabel l11=new JLabel("读者识别号");
    	
    	 t1=new JTextField(30);
    	
    	g1.add(l11);
    	g1.add(t1);
    	
    	
    	
    	g5.add(g1);
    	
    	JPanel g2=new JPanel();
    	
    	g2.setLayout(new FlowLayout());
    	JLabel l21=new JLabel("  读者姓名");
    	 t3=new JTextField(30);
    	g2.add(l21);
    	g2.add(t3);
    	g5.add(g2);
    	
    	JPanel g3=new JPanel();
    	
    	g3.setLayout(new FlowLayout());
    	JLabel l31=new JLabel("  读者权限");
    	 t4=new JTextField(30);
    	g3.add(l31);
    	g3.add(t4);
    	g5.add(g3);
    	
    	JPanel g4=new JPanel();
    	
    	g4.setLayout(new FlowLayout());
    	JLabel l41=new JLabel("  联系地址");
    	 t5=new JTextField(30);
    	g4.add(l41);
    	g4.add(t5);
    	g5.add(g4);
    	
    	JPanel g6=new JPanel();
    	
    	g6.setLayout(new FlowLayout());
    	JLabel l61=new JLabel("  电话号码");
    	 t6=new JTextField(30);
    	g6.add(l61);
    	g6.add(t6);
    	g5.add(g6);
    	
    	JPanel g7=new JPanel();
    	
    	g7.setLayout(new FlowLayout());
    	JLabel l71=new JLabel("  电子邮件");
    	 t7=new JTextField(30);
    	g7.add(l71);
    	g7.add(t7);
    	g5.add(g7);
    	
    	c2.add(g5,BorderLayout.CENTER);
    	
    	
    	
    	JPanel n=new JPanel();
    	n.setLayout(new BoxLayout(n,BoxLayout.Y_AXIS));
    	
    	
    	JButton n11=new JButton("上移");
    	
    	n11.addActionListener(this);
    	n.add(n11);
    	JButton n21=new JButton("下移");
    	
    	n21.addActionListener(this);
    	n.add(n21);
    	JButton n31=new JButton("添加");
    	
    	n31.addActionListener(this);
    	n.add(n31);
    	JButton n41=new JButton("删除");
    	
    	n41.addActionListener(this);
    	n.add(n41);
    	JButton n51=new JButton("修改");
    	
    	n51.addActionListener(this);
    	n.add(n51);
    	
    	c2.add(n,BorderLayout.EAST);
    	
    	
    	
    	
    	
    	
    	deck.add("c2",c2);
    	
    	JPanel c3=new JPanel();
    	
    	c3.setLayout(new BorderLayout());
    	
    	JPanel total=new JPanel();
    	
    	total.setLayout(new GridLayout(3,1));
    	
    	JPanel booktotal=new JPanel();
    	
    	booktotal.setLayout(new FlowLayout());
    	JLabel bt1=new JLabel("图书总量");
    	 bt2=new JTextField(30);
    	 bt2.setEditable(false);
    	booktotal.add(bt1);
    	booktotal.add(bt2);
    	total.add(booktotal);
    	
    	JPanel readertotal=new JPanel();
    	
    	readertotal.setLayout(new FlowLayout());
    	JLabel bt3=new JLabel("读者总量");
    	 bt4=new JTextField(30);
    	 bt4.setEditable(false);
    	readertotal.add(bt3);
    	readertotal.add(bt4);
    	total.add(readertotal);
    	
    	JPanel booktotalin=new JPanel();
    	
    	booktotalin.setLayout(new FlowLayout());
    	JLabel bt5=new JLabel("在库图书");
    	 bt6=new JTextField(30);
    	 bt6.setEditable(false);
    	booktotalin.add(bt5);
    	booktotalin.add(bt6);
    	total.add(booktotalin);
    	
    	c3.add(total,BorderLayout.NORTH);
    	
    	deck.add("c3",c3);
    	
    	JPanel c4=new JPanel();
    	
    	c4.setLayout(new BorderLayout());
    	
    	JPanel system=new JPanel();
    	
    	system.setLayout(new GridLayout(3,1));
    	
    	JPanel readernumber=new JPanel();
    	
    	readernumber.setLayout(new FlowLayout());
    	JLabel rn1=new JLabel("    读者号码");
    	 rn2=new JTextField(30);
    	readernumber.add(rn1);
    	readernumber.add(rn2);
    	system.add(readernumber);
    	
    	JPanel booknumber=new JPanel();
    	
    	booknumber.setLayout(new FlowLayout());
    	JLabel bn1=new JLabel("最大借书本数");
    	 bn2=new JTextField(30);
    	booknumber.add(bn1);
    	booknumber.add(bn2);
    	system.add(booknumber);
    	
    	JPanel outtime=new JPanel();
    	
    	outtime.setLayout(new FlowLayout());
    	JLabel ot1=new JLabel("最长借阅时间");
    	 ot2=new JTextField(30);
    	outtime.add(ot1);
    	outtime.add(ot2);
    	system.add(outtime);
    	
    	c4.add(system,BorderLayout.NORTH);
    	
    	JPanel system1=new JPanel();
    	
    	system1.setLayout(new FlowLayout());
    	
    	JButton system2=new JButton("更改");
    	
    	system2.addActionListener(this);
    	system1.add(system2);
    	
    	c4.add(system1,BorderLayout.CENTER);