borbookfrm.java

用Java实现的图书馆的管理系统

import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.Date;
class Borbookfrm extends JFrame implements ActionListener
{
	JLabel l_msg,l_bookid,l_user,l_bookname,l_data,l_beizhu;
	JTextField t_bookid,t_user,t_bookname,t_data,t_beizhu;
	JButton b_enter,b_clear,b_back;
	JPanel pan1,pan2,pan3,pan4,pan5,pan6,pan7;
	Date d;
	Statement s;
	
	Borbookfrm()
	{
		l_msg      =new JLabel("借书窗口    ");
		l_user     =new JLabel("借阅者：");
		l_bookid =new JLabel("编  号： ");
		l_bookname =new JLabel("书  名：");
		l_data     =new JLabel("日  期：");
		l_beizhu   =new JLabel("备  注：");
		t_user     =new JTextField("",11);
		t_bookid =new JTextField("",11);
		t_bookname =new JTextField("",11);
		t_data     =new JTextField("",11);
		d=new Date();
		t_data.setText(d.toLocaleString());
		t_beizhu   =new JTextField("",11);
		b_enter    =new JButton("确定");
		b_clear    =new JButton("清除");
		b_back     =new JButton("返回");
		b_enter.addActionListener(this);
		b_clear.addActionListener(this);
		b_back.addActionListener(this);
		pan1=new JPanel();pan2=new JPanel();pan3=new JPanel();pan4=new JPanel();pan5=new JPanel();pan6=new JPanel();pan7=new JPanel();
		pan1.add(l_msg);
		pan2.add(l_user);
		pan2.add(t_user);
		pan3.add(l_bookid);
		pan3.add(t_bookid);
		pan4.add(l_bookname);
		pan4.add(t_bookname);
		pan5.add(l_data);
		pan5.add(t_data);
		pan6.add(l_beizhu);
		pan6.add(t_beizhu);
		pan7.add(b_enter);
		pan7.add(b_clear);
		pan7.add(b_back);
		setLayout(new GridLayout(7,1));
		add(pan1);add(pan2);add(pan3);add(pan4);add(pan5);add(pan6);add(pan7);
		
		
		setBounds(400,100,400,500);
		
		
	}
	public void actionPerformed(ActionEvent ed)
	{String JDriver = "sun.Jdbc.Odbc.JdbcOdbcDriver";
	String conURL = "jdbc:odbc:abc";
	try {
		Class.forName(JDriver);
	} catch (java.lang.ClassNotFoundException e1) {
		System.out.println("forname:" + e1.getMessage());
	}
	try {
		Connection con = DriverManager.getConnection(conURL);
		s = con.createStatement();
	} catch (SQLException e1) {
		System.out.println("SQLException:" + e1.getMessage());
	}
		if(ed.getSource()==b_back)
		{
			
				dispose();
		}
		else if(ed.getSource()==b_clear)
		{
			t_user.setText("");t_beizhu.setText("");t_bookname.setText("");
		}
		else if(ed.getSource()==b_enter)
		{
			try
			{
				 String s2="'"+t_user.getText().trim()+"'";
				 String s3="'"+t_bookid.getText().trim()+"'";
				 String s4="'"+t_bookname.getText().trim()+"'";
				 String s5="'"+t_data.getText().trim()+"'";
				 String s6="'"+t_beizhu.getText().trim()+"'";
				 String s7="'"+"NO"+"'";
				 l_msg.setText("操作失败！用户名或书名及编号有误！");
				 String temp="INSERT INTO bookbrowse (username,bookid, bookname, borrowdata, beizhu, isreturn) VALUES ("+s2+","+s3+","+s4+","+s5+","+s6+","+s7+")";
				 s.executeUpdate(temp);
				 l_msg.setText("用户借书成功");
			}
			catch(SQLException er)
			{
				
			}
		}
	}
}