kaihuframe.java

java 编写的图书管理系统源代码 密码和用户名都是123

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class KaiHuFrame extends Frame implements ActionListener
{
	  	Label label1 = new Label("借阅者编号");
  		Label label2 = new Label("姓名");
  		Label label3 = new Label("年龄");
  		Label label4 = new Label("性别");
  		Label label5 = new Label("专业");
  		Label label6 = new Label("系别");
  		TextField textField2 = new TextField();
  		TextField textField3 = new TextField();
  		TextField textField4 = new TextField();
  		TextField textField1 = new TextField();
  		TextField textField5 = new TextField();
  		TextField textField6 = new TextField();
 		Button button1 = new Button("确定");
 		Button button2 = new Button("取消");
		  	Connection conn;
  	Statement stmt;
  	ResultSet rs;  
    	String strurl;

	public KaiHuFrame() throws Exception
	{
		super("开户窗口");
		setSize(400,300);
		setLayout(null);
		setBackground(new Color(110,200,150));
		this.setLocation(200,200);
    button2.setBounds(219, 228, 89, 25);
   button2.setBounds(219, 228, 89, 25);
    button1.setBounds(68, 226, 83, 23);
	button1.addActionListener(this);
        button2.addActionListener(this);
    textField6.setBounds(271, 169, 70, 19);
    textField5.setBounds(271, 126, 70, 19);
    textField1.setBounds(105, 86, 70, 19);
    textField4.setBounds(271, 86, 70, 19);
    textField3.setBounds(105, 170, 70, 19);
    textField2.setBounds(105, 126, 70, 19);
    label1.setBounds(45, 86, 57, 19);
    label2.setBounds(45, 126, 57, 19);
    label3.setBounds(45, 170, 57, 19);
    label4.setBounds(210, 86, 53, 19);
    label5.setBounds(210, 126, 57, 19);
    label6.setBounds(210, 170, 57, 19);
    add(button1);
    add(button2);
    add(label1);
    add(label2);
   add(label3);
    add(textField3);
   add(textField2);
   add(textField1);
    add(label4);
   add(label5);
   add(label6);
   add(textField6);
   add(textField5);
  add(textField4);


    
    	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();
		if (str.equals("确定"))
		{
			if(textField1.getText().equals(""))
			{
			
			}
			else{
			try
			{
			 rs = stmt.executeQuery("select * from LLZB where 借阅者编号 ='"+textField1.getText()+"'" );
			if(rs.next()){
        				JOptionPane.showMessageDialog(null, "借阅者编号存在重新输入",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
					textField1.setText("");
					textField2.setText("");	
					textField3.setText("");
					textField4.setText("");	
					textField5.setText("");
					textField6.setText("");	
			}	
			else{
       			stmt.execute(
            			"insert into LLZB(借阅者编号,姓名,年龄,性别,专业,系别) values ('" +
            			textField1.getText() + "','" + textField2.getText() + "','" +
            			textField3.getText() + "','" + textField4.getText() + "','" +
            			textField5.getText() +"','"+ textField6.getText()+ "')");
					textField1.setText("");
					textField2.setText("");	
					textField3.setText("");
					textField4.setText("");	
					textField5.setText("");
					textField6.setText("");	
      				JOptionPane.showMessageDialog(null, "开户成功",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
			}
		
						
			}
      			catch (Exception eg) {

			eg.printStackTrace();
			}
			}

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

}