复件 jieshu.java

一个小型的图书管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.io.*;
public class Jieshu{
	JFrame frame;
	JLabel  jslabel,jszhlabel,smlabel,shlabel,jssjlabel;
	JTextField jszhfield,smfield,shfield,jssjfield;
	JButton qdbutton,qxbutton,backbutton;
	public static void main(String args[]){
		Jieshu js=new Jieshu();
		js.go();
	}
	public void go(){
		jslabel=new JLabel("借书");

		jszhlabel=new JLabel("借书证号");
		jszhfield=new JTextField(15);
		JPanel p1=new JPanel();
		p1.add(jszhlabel);
		p1.add(jszhfield);
		
	
		smlabel=new JLabel("书名");
		smfield=new JTextField(15);
		JPanel p2=new JPanel();
		p2.add(smlabel);
		p2.add(smfield);
		
	
		shlabel=new JLabel("书号");
		shfield=new JTextField(15);
		JPanel p3=new JPanel();
		p3.add(shlabel);
		p3.add(shfield);
		
	
		jssjlabel=new JLabel("借书时间");
		jssjfield=new JTextField(15);
		JPanel p4=new JPanel();
		p4.add(jssjlabel);
		p4.add(jssjfield);
		
      
        qdbutton=new JButton("确定");
        qdbutton.addActionListener(new ActionListener(){
		public void actionPerformed(ActionEvent e){
			
			String str1=shfield.getText();
		    String str2=smfield.getText();
		    String jszh=jszhfield.getText();
            String jssj=jssjfield.getText();
              //System.out.println(checkbook(str1,str2));
           if(checkbook(str1,str2)){
                    System.out.println(borrowresult(jszh,jssj,str2,str1));
			     if(borrowresult(jszh,jssj,str2,str1)){
				      JOptionPane.showMessageDialog(null, "借书成功");
				      Zhujiemian zjm=new Zhujiemian();
		 	         zjm.go();
		 	        frame.setVisible(false);
					
			    }else {
				       JOptionPane.showMessageDialog(null, "此书不存在");
			      }
                		  
	         }
	      else{
	         			JOptionPane.showMessageDialog(null, "输入有误或该书不存在！");
				    	shfield.setText("");
				    	smfield.setText("");
	         	}	
			
          }
   });
        
        qxbutton=new JButton("退出");
        qxbutton.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			Jc dl=new Jc();
				dl.go();
				frame.setVisible(false);
				}
			});
			 backbutton=new JButton("返回");
       backbutton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				Zhujiemian zjm=new Zhujiemian();
		 	    zjm.go();
		 	    frame.setVisible(false);
		  }
		  });  
        JPanel p5=new JPanel();
        p5.setLayout(new FlowLayout());
		p5.add(qdbutton);
		p5.add(qxbutton);
		p5.add(backbutton); 
		 
		frame=new JFrame("借书");
		Container contentPane2=frame.getContentPane();
		contentPane2.setLayout(new GridLayout(6,1));
		contentPane2.add(jslabel);
	    contentPane2.add(p1);
	    contentPane2.add(p2);
	    contentPane2.add(p3);
	    contentPane2.add(p4);
	    contentPane2.add(p5);	
		frame.setSize(500,450);
		frame.setVisible(true);
	}
	
	
	public static boolean checkbook(String shuhao,String shuming){
	      boolean a=false;
		try{
		String driver="sun.jdbc.odbc.JdbcOdbcDriver";
			File f=new File("jcdb.mdb");
			String url="Jdbc:Odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+f.getPath();
			Class.forName(driver);
			Connection con=DriverManager.getConnection(url);
			System.out.println("数据源="+con.getCatalog());
			Statement st=con.createStatement();
			String sql="select * from books";

			ResultSet rs=st.executeQuery(sql);
  
			while(rs.next()){
				String s1=rs.getString(1);
				String s2=rs.getString(2);
				if(s1.equals(shuhao)&&s2.equals(shuming)){
					a=true;
					break;
				}
           
			}
			  st.close();
			con.close();
		}catch(Exception e){
			e.printStackTrace();
		}
         return a;
	}	
	
	
	public boolean borrowresult(String s1,String s2,String s3,String s4){
		boolean a=false;
		int b=0;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				File f=new File("jcdb.mdb");
			Connection con=DriverManager.getConnection("Jdbc:Odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+f.getPath());
			String sql="update books set cardno=? where bname=? and bno=?";
			PreparedStatement st=con.prepareStatement(sql);
			st.setString(1,s1);
			//st.setString(2,s2);
			st.setString(2,s3);
			st.setString(3,s4);
		    b=st.executeUpdate();
		   
		    if(b>0){
		    		    a=true;
		    }
		    else if(b==0){
		    //	JOptionPane.showMessageDialog(null, "此书不存在");
		    }
		    
	    /*	Statement st1=con.createStatement();
			String sql1="select * from books";

			ResultSet rs=st1.executeQuery(sql1);
			while(rs.next()){
				System.out.println(rs.getString(1)+"  "+rs.getString(2)+"  "+rs.getString(3)+"  "+rs.getString(4));
		   } */
            st.close();
			con.close();
		}catch(Exception e){
			e.printStackTrace();
		}
		return a;
	}
}