frame1.java~2~

学生管理系统

package 学生信息管理系统;

import java.awt.*;
import java.awt.event.*;
import java.sql.*;

import javax.swing.*;
import javax.swing.border.*;
import java.awt.Rectangle;
import java.awt.Font;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame1 extends JFrame {
 Connection con;
 Statement set;
 ResultSet re;
    JPanel contentPane;
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JTextField F1 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField F2 = new JTextField();
    JButton jButton1 = new JButton();
    TitledBorder titledBorder2 = new TitledBorder("");
    JButton jButton2 = new JButton();
    public Frame1() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(400, 300));
        setTitle("学生信息管理系统登陆界面");
        jLabel1.setFont(new java.awt.Font("华文新魏", Font.PLAIN, 25));
        jLabel1.setText("用户登陆");
        jLabel1.setBounds(new Rectangle(145, 33, 119, 30));
        jLabel2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jLabel2.setBorder(null);
        jLabel2.setText("用户名");
        jLabel2.setBounds(new Rectangle(58, 110, 96, 16));
        F1.setBorder(BorderFactory.createEtchedBorder());
        F1.setBounds(new Rectangle(159, 107, 169, 22));
        jLabel3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jLabel3.setText("密  码");
        jLabel3.setBounds(new Rectangle(57, 177, 84, 16));
        F2.setBorder(BorderFactory.createEtchedBorder());
        F2.setText("");
        F2.setBounds(new Rectangle(158, 171, 169, 22));
        jButton1.setBounds(new Rectangle(157, 228, 73, 25));
        jButton1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 12));
        jButton1.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton1.setText("登陆");
        jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(267, 228, 73, 25));
        jButton2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 12));
        jButton2.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton2.setText("取消");
        jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
        contentPane.add(jLabel2);
        contentPane.add(jLabel3);
        contentPane.add(F1);
        contentPane.add(F2);
        contentPane.add(jButton1);
        contentPane.add(jButton2);
        contentPane.add(jLabel1);
    }

    public void jButton2_actionPerformed(ActionEvent e) {
                    System.exit(0);
    }

    public void jButton1_actionPerformed(ActionEvent e) {
      String  sd=F1.getText();
     String sd1=F2.getText();
     if(sd.length()==0&&sd1.length()==0){
         JOptionPane .showMessageDialog(this,"未填入姓名或密码");
     }else{
         try{
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             String urll="jdbc:odbc:ser";
             con=DriverManager.getConnection(urll);
             set=con.createStatement();
            // String dd="select UserName from Users where UserName='"+sd+"'";
             String dd="select  *  from Users  where UserName='"+sd+"' and PassWord='"+sd1+"'";
              re=set.executeQuery(dd);
              if(re.next()){

            if(sd.equals(re.getString(1))&& sd1.equals(re.getString(2))){

                Frame2 sts=new Frame2();
                sts.setSize(420,650);
                      sts.setVisible(true) ;
                    sts.show();

            }else{
                JOptionPane.showMessageDialog(this,"姓名或密码有错,");
             }

            } else{
               JOptionPane .showMessageDialog(this,"UserName or PassWord Error");
            }



         }catch(Exception ex){
             ex.printStackTrace();
         }
     }
     }


}


class Frame1_jButton1_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton1_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class Frame1_jButton2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}