searchreader.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

/**
 * @(#)SearchReader.java
 *
 *
 * @author 
 * @version 1.00 2009/5/15
 */


import java.applet.*;
import javax.swing.*;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
class SearchReader extends JFrame implements ActionListener{
private JTextField textId,textName,textType,textMax,textNow;
private JButton ok;
public SearchReader(){
	   super("读者信息查询");
	   Container c=getContentPane();
	   JPanel panel=new JPanel();
	   //创建读者编号标签与文本框
	   JLabel labelId=new JLabel("读者编号：");
	   textId=new JTextField(10);
	   panel.add(labelId);
	   panel.add(textId);
	   ok=new JButton("确定"); //创建确定按钮	 
	   ok.addActionListener(this);      //为确定按钮注册监听器                    
	   panel.add(ok);
	   //创建读者姓名标签与文本框
	   JLabel labelName=new JLabel("读者姓名：");
	   textName=new JTextField(15);
	   panel.add(labelName);
	   panel.add(textName);	   
	   //创建读者类型标签与文本框
	   JLabel labelType=new JLabel("读者类型：");
	   textType=new JTextField(15);
	   panel.add(labelType);
	   panel.add(textType);	 
	   //创建读者限借标签与文本框
	   JLabel labelMax=new JLabel("限借数量：");
	   textMax=new JTextField(15);
	   panel.add(labelMax);
	   panel.add(textMax);
	   JLabel labelNow=new JLabel("已借数量:");
	   	 textNow=new JTextField(15);
	   	panel.add(labelNow);
	   	panel.add(textNow);	    
	   c.add(panel);
	   setBounds(400,110,300,250);
	   setVisible(true);
	   }
	   public void actionPerformed(ActionEvent e1){
	     if(e1.getSource()==ok){	    
	     		display();		     	
	     }
	   }
	 void display(){
	      	Connection con;
        PreparedStatement sql;
        ResultSet rs;
        boolean boo=false;
      try {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
          }
     catch(ClassNotFoundException f){}
      try {  
             String bianhao=textId.getText();
             con=DriverManager.getConnection("jdbc:odbc:tushuguan");
             	sql=con.prepareStatement("SELECT * FROM reader where rid=?");
             	sql.setString(1,bianhao);
             	rs=sql.executeQuery();
             if(bianhao.equals("")){
             JOptionPane.showMessageDialog(this,"读者编号不能为空！","提示对话框",JOptionPane.WARNING_MESSAGE);
             }
             else if(!rs.next()){
             		JOptionPane.showMessageDialog(this,"所要修改的读者不存在！","提示对话框",JOptionPane.WARNING_MESSAGE);
             	    }	
             else{
             	textName.setText(rs.getString(2));
             	textType.setText(rs.getString(3));
             	textMax.setText(rs.getString(4));
             	textNow.setText(rs.getString(5));
             	con.close();
             	
             }
       
	      }
	      catch(SQLException e2) 
           {  System.out.println(e2);
          }
	 }
    public static void main(String args[]){
	   SearchReader frame=new SearchReader();
	   //frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	   
        }
}