borrow.java

Java 图书馆管理系统 Java 图书馆管理系统原代码,包括一些最基本的功能,非常实用.

package 图书馆;

import javax.swing.*;

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
/**
 * 
 * @author hp
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class Borrow extends JFrame implements ActionListener {
	private JTextField jtfd1, jtfd2, jtfd3, jtfd4;
	private JButton btn1, btn2;
	private Connection con;
	private Statement stmt;
	private PreparedStatement pstmt;
	private ResultSet result1;
	private JFrame frame;
	private String sqlstr;

	/**
	 * 构造函数Borrow()
	 *  
	 */

	public Borrow() {
		frame = new JFrame("借书");
		Container content = frame.getContentPane();
		content.setLayout(new GridLayout(5, 2, 10, 10));
		/**
		 * 设置组件
		 */
		JLabel lb1 = new JLabel("借书证号:");
		JLabel lb2 = new JLabel("书号:");
		JLabel lb3 = new JLabel("借书日期:");
		JLabel lb4 = new JLabel("应还日期:");

		jtfd1 = new JTextField();
		jtfd2 = new JTextField();
		jtfd3 = new JTextField();
		jtfd4 = new JTextField();

		btn1 = new JButton("确定");
		btn2 = new JButton("退出");
		btn1.addActionListener(this);
		btn2.addActionListener(this);
		content.add(lb1);
		content.add(jtfd1);
		content.add(lb2);
		content.add(jtfd2);
		content.add(lb3);
		content.add(jtfd3);
		content.add(lb4);
		content.add(jtfd4);
		content.add(btn1);
		content.add(btn2);

		frame.setBounds(100, 100, 420, 320);
		/**
		 * 连接数据库
		 */
		try {
			String str, sqlstr;
			str = "insert into borrow(借书证号,书号,borrowdate,"
					+ "receivedate,renew) values(?,?,?,?,'否')";
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection("jdbc:odbc:demo");
			//生成可滚动且不受其他更新影响的、可更新的结果集
			stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			pstmt = con.prepareStatement(str);
		} catch (ClassNotFoundException e) {
			System.err.println(e);
		} catch (SQLException e) {
			System.err.println(e);
		}
		frame.setVisible(true);

	}

	/**
	 * 主函数
	 * 
	 * @param args
	 */
	public static void main(String[] args) {
		new Borrow();
	}

	/*
	 * (non-Javadoc) 事件处理
	 * 
	 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
	 */
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		String str1, str2, str3, str4;

		str1 = jtfd1.getText().trim();
		str2 = jtfd2.getText().trim();
		str3 = jtfd3.getText().trim();
		str4 = jtfd4.getText().trim();
		int result;
		Object obj = (JButton) e.getSource();
		if (obj == btn1) {
			if (str1.equals("") | str2.equals("") | str3.equals("")
					| str4.equals("")) {
				JOptionPane.showMessageDialog(frame, "can't be null");
				return;
			}

			try {
				pstmt.setString(1, str1);
				pstmt.setString(2, str2);
				pstmt.setString(3, str3);
				pstmt.setString(4, str4);
				result = pstmt.executeUpdate();
				if (result > 0) {
					JOptionPane
							.showMessageDialog(frame, "Borrow successfully!");
					jtfd1.setText("");
					jtfd2.setText("");
					jtfd3.setText("");
					jtfd4.setText("");
				} 
				if (obj == btn2) {
					pstmt.close();
					con.close();
					frame.dispose();
				}
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		} 
	}
}