borrow.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 borrow 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 JLabel jLabel1 = null;

	private JTextField jTextField1 = null;

	private JButton jButton1 = null;

	private JTextArea jTextArea1 = null;

	private JButton jButton2 = null;

	private JButton jButton3 = null;

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

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

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

	public borrow(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(106, 19, 116, 23));
		}
		return jTextField;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(239, 18, 74, 25));
			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 readerInfo where Code ='"+jTextField.getText()+"'");
						if(rs.next())
						{
							jTextArea.setText("读者编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"职业"+"\t"+"联系电话"+"\t"+"部门"+"\t"+"联系地址"+"\t"+"brief");
							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)+"\t"+rs.getString(7));
							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(22, 59, 683, 77));
		}
		return jTextArea;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(106, 155, 116, 23));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(239, 155, 74, 25));
			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()
					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 ='"+jTextField1.getText()+"'");
						if(rs.next())
						{
							jTextArea1.setText("图书编号"+"\t"+"书名"+"\t"+"类型"+"\t"+"出版社"+"\t"+"作者"+"\t"+"是否被借"+"\t"+"借阅者编号");
							jTextArea1.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 ='"+jTextField1.getText()+"' and isBorrow=false");
						} 
						else
							jTextArea1.setText("没有该编号的书");
					}
					catch(SQLException ce)
					{
						System.out.println("SQLException"+ce.getMessage());
					}
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes jTextArea1	
	 * 	
	 * @return javax.swing.JTextArea	
	 */
	private JTextArea getJTextArea1() {
		if (jTextArea1 == null) {
			jTextArea1 = new JTextArea();
			jTextArea1.setBounds(new Rectangle(22, 193, 686, 77));
		}
		return jTextArea1;
	}

	/**
	 * This method initializes jButton2	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton2() {
		if (jButton2 == null) {
			jButton2 = new JButton();
			jButton2.setBounds(new Rectangle(205, 285, 83, 22));
			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()
					Button_jch(e);
				}
			});
		}
		return jButton2;
	}
	void Button_jch(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();
			Statement stmt1=con.createStatement();
			ResultSet rs=stmt.executeQuery( "SELECT * from bookInfo where Code ='"+jTextField1.getText()+"'");
			ResultSet hs=stmt1.executeQuery( "SELECT * from readerInfo where Code ='"+jTextField.getText()+"'");
			if(rs.next()&&hs.next()){
				jTextArea1.setText("图书编号"+"\t"+"书名"+"\t"+"类型"+"\t"+"出版社"+"\t"+"作者"+"\t"+"是否被借"+"\t"+"借阅者编号");
				jTextArea1.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));
				jTextArea.setText("读者编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"职业"+"\t"+"联系电话"+"\t"+"部门"+"\t"+"联系地址"+"\t"+"brief");
				jTextArea.append("\n"+hs.getString(1)+"\t"+hs.getString(2)+"\t"+hs.getString(3)+"\t"+hs.getString(4)+"\t"+hs.getString(5)+"\t"+hs.getString(6)+"\t"+hs.getString(7));
				rs=stmt.executeQuery("SELECT * from bookInfo where Code ='"+jTextField1.getText()+"' and isBorrow=true");
				if(rs.next())
				{
			        JOptionPane.showMessageDialog(this,"该已经被借出！请重新输入！","提示",JOptionPane.ERROR_MESSAGE);
			        jTextField.setText("");
			        jTextArea.setText("");
			        //jPasswordField.setText("");
			        return;
			    }
			    else
			    {
			    	  stmt.executeUpdate("update bookInfo set isBorrow=true,reader_code='"+jTextField.getText()+"'"+"where code ='"+jTextField1.getText()+"'");
			    	  JOptionPane.showMessageDialog(this,"操作成功！","提示",JOptionPane.YES_NO_CANCEL_OPTION);
			            
			    }
			} 
			else{
				//jTextArea.setText("没有该编号的书或者该读者不存在");
				JOptionPane.showMessageDialog(this,"操作错误，没有该书或者该读者不存在！","提示",JOptionPane.YES_NO_CANCEL_OPTION);
			}
			
		}
		catch(SQLException ce)
		{
			System.out.println("SQLException"+ce.getMessage());
		}
	}
	/**
	 * This method initializes jButton3	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton3() {
		if (jButton3 == null) {
			jButton3 = new JButton();
			jButton3.setBounds(new Rectangle(344, 285, 83, 22));
			jButton3.setText("返回");
			jButton3.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_qx(e);
				}
			});
		}
		return jButton3;
	}
	public void Button_qx(ActionEvent e)
	{
		this.hide();
	}

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

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

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(22, 155, 86, 23));
			jLabel1.setText("图书编号");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(22, 19, 86, 23));
			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(jLabel1, null);
			jContentPane.add(getJTextField1(), null);
			jContentPane.add(getJButton1(), null);
			jContentPane.add(getJTextArea1(), null);
			jContentPane.add(getJButton2(), null);
			jContentPane.add(getJButton3(), null);
		}
		return jContentPane;
	}

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