book.java

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

package 图书馆;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

import java.sql.*;
/**
 * 
 * @author hp
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class Book implements ActionListener {
	private JButton btn1, btn2;
	private JTextField jtfd1, jtfd2, jtfd3, jtfd4, jtfd5, jtfd6;
	private Connection con;
	private PreparedStatement pstmt1, pstmt2;
	private JFrame frame;
	/**
	 * 构造函数
	 *
	 */
	public Book() {
		frame = new JFrame("图书入库");
		Container content = frame.getContentPane();
		/**
		 * 设置标签JLabel lb1,lb2,lb3,lb4,lb5,lb6
		 */
		JLabel lb1 = new JLabel("书名:");
		JLabel lb2 = new JLabel( "书号:");
		JLabel lb3 = new JLabel("作者:");
		JLabel lb4 = new JLabel("出版社:");
		JLabel lb5 = new JLabel("书价:");
		JLabel lb6 = new JLabel("位置:");
        /**
         * 设置单行文本框JTextField jtfd2,jtfd3,jtfd4,jtfd5,jtfd6,jtfd7
         */
		jtfd1 = new JTextField();
		jtfd2 = new JTextField();
		jtfd3 = new JTextField();
		jtfd4  = new JTextField();
		jtfd5  = new JTextField();
		jtfd6  = new JTextField();
		/**
		 * 设置按钮btn1,btn2
		 */
		btn1 = new JButton("添加");
		btn2 = new JButton("退出");
	    /**
	     * 按钮btn1,btn2事件监听
	     */
		btn1.addActionListener(this);
		btn2.addActionListener(this);
	    /**
	     * 设置JPanel pl1的排版GridLayout
	     */
		JPanel pl1 = new JPanel();	
		pl1.setLayout(new GridLayout(3,2,0,10));
		pl1.add(lb1);
		pl1.add(jtfd1);
		pl1.add(lb2);
		pl1.add(jtfd2);
		pl1.add(lb3);
		pl1.add(jtfd3);
		pl1.add(lb4);
		pl1.add(jtfd4);
		pl1.add(lb5);
		pl1.add(jtfd5);
		pl1.add(lb6);
		pl1.add(jtfd6);
		/**
		 *  设置JPanel pl4的排版GridLayout
		 */
		JPanel pl4 = new JPanel();
		pl4.setLayout(new GridLayout(1,2, 6, 0));
		pl4.add(btn1);
		pl4.add(btn2);
        /**
         * 设置content 的排版BorderLayout
         */
		content.setLayout(new BorderLayout());
		content.add(pl1, BorderLayout.CENTER);
		content.add(pl4, BorderLayout.SOUTH);

		frame.setSize( 400,200) ;
		frame.setVisible(true);
  /**
   * 连接数据库
   */
		try {

			String sqlStr1;
			sqlStr1 = "insert into Bookinfo ( 书名, 书号, 作者, 出版社, 书价, 位置 )" +
					            " values ( ?,?,?,?,?,? )";
            /**
             * 加载驱动jdbc
             */	
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			/**
			 * 连接demo数据库
			 */
			con = DriverManager.getConnection("jdbc:odbc:demo");
			pstmt1 = con.prepareStatement(sqlStr1);

		} catch (ClassNotFoundException e) {
		} catch (SQLException sqle) {
		}
	}
	/**
	 * 事件处理
	 */
	public void actionPerformed(ActionEvent e) {
		String str1, str2, str3, str4, str5, str6;
		/**
		 * 获取Text信息
		 */
		str1 = jtfd1.getText().trim();
		str2 = jtfd2.getText().trim();
		str3 = jtfd3.getText().trim();
		str4 = jtfd4.getText().trim();
		str5 = jtfd5.getText().trim();
		str6 = jtfd6.getText().trim();

		int result;
		try {
			Object obj = (JButton) e.getSource();
			/**
			 * 按钮btn1的处理
			 */
			if (obj == btn1) {
				if (str1.equals("") | str2.equals("") | str3.equals("")
						| str4.equals("") | str5.equals("")| str6.equals("")) {
					JOptionPane.showMessageDialog(frame, "can't be null");
					return;
				}
				/**
				 * 将Text信息传给表Bookinfo
				 */
				pstmt1.setString(1, str1);
				pstmt1.setString(2, str2);
				pstmt1.setString(3, str3);
				pstmt1.setString(4, str4);
				pstmt1.setString(5, str5);
				pstmt1.setString(6, str6);

				result = pstmt1.executeUpdate();
				if (result > 0) {
					JOptionPane.showMessageDialog(frame, "add successfully!");
				}
				jtfd1.setText("");
				jtfd2.setText("");
				jtfd3.setText("");
				jtfd4.setText("");
				jtfd5.setText("");
				jtfd6.setText("");	
			}
			/**
			 * 按钮btn2的处理
			 * 退出当前对话框
			 */
	         if (obj == btn2) {
				pstmt1.close();
				con.close();
				frame.dispose();
			}
		} catch (SQLException sqle) {
			System.err.println(sqle);
		}
	}
               /**
                * 主函数
                * @param args
                */
	public static void main(String[] args) {
		new Book();
	}

}