readeru.java

JAVA 图书馆管理系统 是个学习JAVA 语言的好材料

//读者资料修改条件
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;
import java.io.*;
import java.util.*;

public class ReaderU extends JFrame implements ActionListener
{   private JLabel MoneyLabel,ViewLabel;
	private JTextField MoneyTextField;
	private JComboBox jcb;
	private JButton ModifyBtn,CancelBtn;
    private JPanel panel;
	private JFrame frame;
	private Connection con;
    private Statement stmt;
    private String yesORno;
    private ReaderAdd reader;
	public ReaderU(ReaderAdd reader)
	{   JFrame.setDefaultLookAndFeelDecorated(true);
	    frame=new JFrame("读者资料修改");
	    Font font1=new Font("宋体",Font.PLAIN,13);
	    Container content=frame.getContentPane();
	    content.setLayout(null);
	    ImageIcon icon=new ImageIcon("images/home.gif");
	    frame.setIconImage(icon.getImage());
        frame.setResizable(false);
        this.reader=reader;

        //--初始化各个组件--
		MoneyLabel=new JLabel("请输入信息:");
		ViewLabel=new JLabel("请选择条件:");
        String tiaojian[]={"读者姓名","读者编号","条形码"};
        jcb=new JComboBox(tiaojian);
		MoneyTextField=new JTextField();
		ModifyBtn=new JButton("查 询");
		CancelBtn=new JButton("取 消");

		//--设置各个组件的事件--
        ModifyBtn.addActionListener(this);
		CancelBtn.addActionListener(this);
		jcb.addActionListener(this);

        //--设置各个组件的大小和位置--
        MoneyLabel.setBounds(10,15,100,25);
        MoneyTextField.setBounds(110,15,150,25);
        ViewLabel.setBounds(10,50,100,25);
        jcb.setBounds(110,50,150,25);
        ModifyBtn.setBounds(40,90,80,25);
        CancelBtn.setBounds(160,90,80,25);

        //--设置各个组件的字体--
        MoneyLabel.setFont(font1);
        MoneyTextField.setFont(font1);
	    ViewLabel.setFont(font1);
		ModifyBtn.setFont(font1);
		CancelBtn.setFont(font1);

        //--添加各个组件--
        panel=new JPanel();
        panel.setLayout(null);
        panel.setBorder(
			 	 		 BorderFactory.createCompoundBorder(
			 	 		 BorderFactory.createEtchedBorder(),
	                     BorderFactory.createLoweredBevelBorder()));
	    panel.setBounds(10,10,280,130);
		panel.add(MoneyLabel);
		panel.add(MoneyTextField);
	    panel.add(ViewLabel);
	    panel.add(jcb);
		panel.add( ModifyBtn);
		panel.add(CancelBtn);
		content.add(panel);

        //--初始化窗体--
		frame.pack();
		frame.setLocationRelativeTo(null);
		frame.setBounds(400,150,305,180);
		frame.setVisible(true);
	}

	public void actionPerformed(ActionEvent e)
	{  Object obj=e.getSource();
	  if(obj==CancelBtn)
	    { int m=JOptionPane.showConfirmDialog(this, "您确定要放弃修改读者信息吗？", "确认对话框",JOptionPane.YES_NO_OPTION);
		  if(m==JOptionPane.YES_OPTION)
		  {frame.dispose();}
        }
	  if(obj== ModifyBtn)
	    { try{ Update1();}
	      catch(SQLException ed){}
         }
	}

    public void Update1() throws SQLException
    { String fajin=MoneyTextField.getText().trim();
      int j,k;
      String strurl =
	  	             "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	  catch (ClassNotFoundException e) {}
	  con= DriverManager.getConnection(strurl);
	  Statement stmt = con.createStatement();
	  ResultSet rs1 = stmt.executeQuery("select * from 读者资料 ");
	  while(rs1.next())
	  { String bookname=rs1.getString(1);
		String bianhao=rs1.getString(2);
		String bookcode=rs1.getString(3);
		String fenlei=rs1.getString(4);
		String zuozhe=rs1.getString(5);
		String type=rs1.getString(6);
		String zjhm=rs1.getString(7);
		String price=rs1.getString(8);
		String press=rs1.getString(9);
		String page=rs1.getString(10);
		String sheefname=rs1.getString(11);
		String chuban=rs1.getString(12);
		String ruku=rs1.getString(13);
		String stock=rs1.getString(14);
		String zuicang=rs1.getString(15);
		String borrow=rs1.getString(16);
		String status=rs1.getString(17);
        String oparator=rs1.getString(18);
	    if(jcb.getSelectedIndex()==0)
		{if(bookname.equals(fajin))
		 {reader.jtfd1.setText(bookname);reader.jtfd2.setText(bianhao);reader.jtfd3.setText(bookcode);
		  reader.jtfd5.setText(zjhm);reader.jtfd6.setText(price);
		  reader.jtfd7.setText(press);reader.jtfd9.setText(page);
		  reader.jtfd11.setText(sheefname);reader.jtfd12.setText(chuban);
		  reader.jtfd13.setText(ruku);reader.jtfd14.setText(stock);
		  reader.jtfd15.setText(zuicang);reader.jtfd16.setText(status);reader.jta.setText(oparator);

		  for(j=0;j<=reader.jtfd8.getItemCount();j++)
		  {if(zuozhe.equals((String)reader.jtfd8.getItemAt(j)))
		  {reader.jtfd8.setSelectedIndex(j);}
		  	j++;
		  }
		  for(k=0;k<=reader.jtfd10.getItemCount();k++)
		  {if(type.equals((String)reader.jtfd10.getItemAt(k)))
		  {reader.jtfd10.setSelectedIndex(k);}
		  	k++;
	      }
		  reader.btn5.setVisible(true);
          reader.btn6.setVisible(false);
		 }
		}
		if(jcb.getSelectedIndex()==1)
	    { if(bianhao.equals(fajin))
		 {reader.jtfd1.setText(bookname);reader.jtfd2.setText(bianhao);reader.jtfd3.setText(bookcode);
		  reader.jtfd5.setText(zjhm);reader.jtfd6.setText(price);reader.jtfd7.setText(press);
		  reader.jtfd9.setText(page);reader.jtfd11.setText(sheefname);reader.jtfd12.setText(chuban);
		  reader.jtfd13.setText(ruku);reader.jtfd14.setText(stock);
		  reader.jtfd15.setText(zuicang);reader.jtfd16.setText(status);reader.jta.setText(oparator);
		  for(j=0;j<=reader.jtfd8.getItemCount();j++)
		  		  {if(zuozhe.equals((String)reader.jtfd8.getItemAt(j)))
		  		  {reader.jtfd8.setSelectedIndex(j);}
		  		  	j++;
		  		  }
		  		  for(k=0;k<=reader.jtfd10.getItemCount();k++)
		  		  {if(type.equals((String)reader.jtfd10.getItemAt(k)))
		  		  {reader.jtfd10.setSelectedIndex(k);}
		  		  	k++;
	      }
		  reader.btn5.setVisible(true);
          reader.btn6.setVisible(false);
		 }
		}
		if(jcb.getSelectedIndex()==2)
			    { if(bookcode.equals(fajin))
				 {reader.jtfd1.setText(bookname);reader.jtfd2.setText(bianhao);reader.jtfd3.setText(bookcode);
				  reader.jtfd5.setText(zjhm);reader.jtfd6.setText(price);reader.jtfd7.setText(press);
				  reader.jtfd9.setText(page);reader.jtfd11.setText(sheefname);reader.jtfd12.setText(chuban);
				  reader.jtfd13.setText(ruku);reader.jtfd14.setText(stock);
				  reader.jtfd15.setText(zuicang);reader.jtfd16.setText(status);reader.jta.setText(oparator);
				  for(j=0;j<=reader.jtfd8.getItemCount();j++)
				  		  {if(zuozhe.equals((String)reader.jtfd8.getItemAt(j)))
				  		  {reader.jtfd8.setSelectedIndex(j);}
				  		  	j++;
				  		  }
				  		  for(k=0;k<=reader.jtfd10.getItemCount();k++)
				  		  {if(type.equals((String)reader.jtfd10.getItemAt(k)))
				  		  {reader.jtfd10.setSelectedIndex(k);}
				  		  	k++;
	      }
				  reader.btn5.setVisible(true);
		          reader.btn6.setVisible(false);
				 }
		}
	  }

	}
}