return_ok.java

能实现图书管理的基本功能,例如读者管理,书库管理等!

import javax.swing.SwingUtilities;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import java.awt.GraphicsConfiguration;
import java.awt.HeadlessException;

import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JTextArea;

public class return_ok extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JTextField jTextField = null;

	private JButton jButton = null;

	private JTextArea jTextArea = null;

	private JButton jButton1 = null;

	private JButton jButton2 = null;

	public return_ok() throws HeadlessException {
		// TODO Auto-generated constructor stub
		super();
		initialize();
	}

	public return_ok(GraphicsConfiguration arg0) {
		super(arg0);
		// TODO Auto-generated constructor stub
		initialize();
	}

	public return_ok(String arg0) throws HeadlessException {
		super(arg0);
		// TODO Auto-generated constructor stub
		initialize();
	}

	public return_ok(String arg0, GraphicsConfiguration arg1) {
		super(arg0, arg1);
		// TODO Auto-generated constructor stub
		initialize();
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setBounds(new Rectangle(112, 16, 110, 27));
		}
		return jTextField;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(250, 16, 65, 27));
			jButton.setText("查找");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					try
					{
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
					}
					catch(ClassNotFoundException ce)
					{
						System.out.println("ClassNotFoundException:"+ce.getMessage());
					}
					try
					{
						Connection con=DriverManager.getConnection("jdbc:odbc:lib");
						Statement stmt=con.createStatement();
						ResultSet rs=stmt.executeQuery( "SELECT * from bookInfo where Code ='"+jTextField.getText()+"'");
						if(rs.next())
						{
							jTextArea.setText("图书编号"+"\t"+"书名"+"\t"+"类型"+"\t"+"出版社"+"\t"+"作者"+"\t"+"是否被借"+"\t"+"借阅者编号");
							jTextArea.append("\n"+rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getString(5)+"\t"+rs.getString(6));
							rs=stmt.executeQuery("SELECT * from bookInfo where Code ='"+jTextField.getText()+"' and isBorrow=false");
						} 
						else
							jTextArea.setText("没有该编号的书");
					}
					catch(SQLException ce)
					{
						System.out.println("SQLException"+ce.getMessage());
					}
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jTextArea	
	 * 	
	 * @return javax.swing.JTextArea	
	 */
	private JTextArea getJTextArea() {
		if (jTextArea == null) {
			jTextArea = new JTextArea();
			jTextArea.setBounds(new Rectangle(20, 59, 593, 79));
		}
		return jTextArea;
	}

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(176, 168, 95, 27));
			jButton1.setText("归还");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					Button_gh(e);
				}
			});
		}
		return jButton1;
	}
	void Button_gh(ActionEvent e)
	{
		
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
		}
		catch(ClassNotFoundException ce)
		{
			System.out.println("ClassNotFoundException:"+ce.getMessage());
		}
		try
		{
			boolean a;
			Connection con=DriverManager.getConnection("jdbc:odbc:lib");
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery( "SELECT * from bookInfo where Code ='"+jTextField.getText()+"'");
			if(rs.next()){
				jTextArea.setText("图书编号"+"\t"+"书名"+"\t"+"类型"+"\t"+"出版社"+"\t"+"作者"+"\t"+"是否被借"+"\t"+"借阅者编号");
				jTextArea.append("\n"+rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getString(5)+"\t"+rs.getString(6));
				rs=stmt.executeQuery("SELECT * from bookInfo where Code ='"+jTextField.getText()+"' and isBorrow=false");
				if(rs.next()){
			        JOptionPane.showMessageDialog(this,"该书未被借出！请重新输入！","提示",JOptionPane.ERROR_MESSAGE);
			        jTextField.setText("");
			        jTextArea.setText("");
			        //jPasswordField.setText("");
			        return;
			      }
			      else{
			    	  stmt.executeUpdate("update bookInfo set isBorrow=false,reader_code='null'"+"where Code ='"+jTextField.getText()+"'");
			    	  JOptionPane.showMessageDialog(this,"操作成功！","提示",JOptionPane.YES_NO_CANCEL_OPTION);
			            //bIsLogin = true;
			      }
			} 
			else{
				jTextArea.setText("没有该编号的书");rs=stmt.executeQuery("SELECT * from bookInfo where Code ='"+jTextField.getText()+"' and isBorrow=false");
				JOptionPane.showMessageDialog(this,"操作错误，没有该书！","提示",JOptionPane.YES_NO_CANCEL_OPTION);
			}
			
		}
		catch(SQLException ce)
		{
			System.out.println("SQLException"+ce.getMessage());
		}
	}

	/**
	 * This method initializes jButton2	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton2() {
		if (jButton2 == null) {
			jButton2 = new JButton();
			jButton2.setBounds(new Rectangle(330, 168, 95, 27));
			jButton2.setText("返回");
			jButton2.addActionListener(new java.awt.event.ActionListener() {   
				public void actionPerformed(java.awt.event.ActionEvent e) {    
					//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					quxiao(e);
				}
			
			});
		}
		return jButton2;
	}
	void quxiao(ActionEvent e){
		this.hide();
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				return_ok thisClass = new return_ok();
				thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
				thisClass.setVisible(true);
			}
		});
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(634, 251);
		this.setContentPane(getJContentPane());
		this.setTitle("还书");
		this.setVisible(true);
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(20, 16, 89, 27));
			jLabel.setText("图书编号：");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getJTextField(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.add(getJTextArea(), null);
			jContentPane.add(getJButton1(), null);
			jContentPane.add(getJButton2(), null);
		}
		return jContentPane;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"