xujieframe.java

图书馆里系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.Date;
public class XuJieFrame extends Frame implements ActionListener
{
		 Label label1 = new Label("借阅者编号");
  TextField textField1 = new TextField();
  Label label2 = new Label("图书编号");
  TextField textField2 = new TextField();
  Button button1 = new Button("提交");
  Button button2 = new Button("取消");
  Label label3 = new Label();

  	Connection conn;
  	Statement stmt;
  	ResultSet rs;  
    	String strurl;
	Date today=new Date();
	public XuJieFrame() throws Exception
	{
		super("续借窗口");
		setSize(400,350);
		setLayout(null);
   	setBackground(new Color(110,200,150));
   	this.setLocation(200,200);
    label1.setBounds(68, 70, 79, 23);
    textField1.setBounds(68, 101, 107, 25);
    label2.setBounds(212, 65, 73, 26);
    textField2.setBounds(212, 98, 114, 26);
    button1.setBounds(70, 171, 99, 25);
	button1.addActionListener(this);
    button2.addActionListener(this);
    button2.setBounds(209, 170, 103, 28);
    label3.setBounds(95, 223, 199, 32);
    add(button1);
    add(button2);
    add(textField2);
    add(label1);
    add(textField1);
    add(label2);
    add(label3);
	strurl ="jdbc:odbc:Library";

    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	conn = DriverManager.getConnection(strurl);
    	stmt = conn.createStatement();


		setVisible(true);
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				dispose();
				setVisible(false);
			}
		}); 
	}
	public void actionPerformed(ActionEvent e)
	{
		String str=e.getActionCommand();
		String str1;
		int s;
		if (str.equals("提交"))
		{

			if (textField1.getText().equals(" "))
			{
				label3.setText("不能为空");
			}	
			else
			{        

	
				try{
			 	rs = stmt.executeQuery("select * from JHB where 借阅者编号 ='"+textField1.getText()+"'and 图书编号='"+textField2.getText()+"'" );
				if(rs.next())
				{
 	 	                	stmt.execute("update JHB set 借书日期 ='"+today.toString()+"' where 借阅者编号='"+textField1.getText()+"'AND 图书编号='"+textField2.getText()+"'"); 

                         		JOptionPane.showMessageDialog(null, "续借成功",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
				}
				else{
        				JOptionPane.showMessageDialog(null, "你没有借书",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
					}

				}
	      			catch (Exception eg) {
        				JOptionPane.showMessageDialog(null, "续借失败",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
			eg.printStackTrace();
			}
			}
			textField1.setText("");
			textField2.setText("");

		}
                if(str.equals("取消"))
                {
                    setVisible(false);
                 }

	}
}