复件 huanshu.java

一个小型的图书管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.io.*;
public class Huanshu{
	JFrame frame;
	JLabel  hslabel,smlabel,shlabel;
	JTextField smfield,shfield ;
	JButton qdbutton,qxbutton,backbutton;
	public static void main(String args[]){
	  Huanshu hs=new Huanshu();
		hs.go();
	}
	public void go(){
	 hslabel=new JLabel("还书");

	
		smlabel=new JLabel("书名");
		smfield=new JTextField(15);
		JPanel p1=new JPanel();
		p1.add(smlabel);
		p1.add(smfield);
		
	
		shlabel=new JLabel("书号");
		shfield=new JTextField(15);
		JPanel p2=new JPanel();
		p2.add(shlabel);
		p2.add(shfield);
		

        qdbutton=new JButton("确定");
        qdbutton.addActionListener(new ActionListener(){
		public void actionPerformed(ActionEvent e){
			String s=shfield.getText();
			if(returnbook(s)){
				JOptionPane.showMessageDialog(null, "还书成功");
				Zhujiemian zjm=new Zhujiemian();
		 	         zjm.go();
		 	        frame.setVisible(false);
					
			}else {
				JOptionPane.showMessageDialog(null, "此书已经还或此书不存在！");
			}
	}});
       
        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 p3=new JPanel();
        p3.setLayout(new FlowLayout());
		p3.add(qdbutton);
		p3.add(qxbutton);
		p3.add(backbutton); 
		frame=new JFrame("还书");
		Container hscontentPane=frame.getContentPane();
		hscontentPane.setLayout(new GridLayout(4,1));
			hscontentPane.add(hslabel);
	    	hscontentPane.add(p1);
	    	hscontentPane.add(p2);
	    	hscontentPane.add(p3);
	    	
		frame.setSize(500,450);
		frame.setVisible(true);
		
	}
		public boolean returnbook(String s1){
		 boolean a=false;
		 int b=0;
		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);
			String sql="update books set cardno=null where bno=?";
				PreparedStatement st=con.prepareStatement(sql);
			st.setString(1,s1);
			
		    b=st.executeUpdate();
		   	if(b>0){	
		    		    a=true;
		    }
		    if(b==0){
		     	
		    }
		   }catch(Exception e){
			e.printStackTrace();
		}
		return a;
	}
}