学生信息管理系统 login.java

import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.net.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
class Login extends Frame implements ActionListener
{  
    MenuBar menubar;
 Panel p1,p2,p3;
 Label l1,l2;
 TextField text1,text2;
 Button b1,b2;
 Login(String s,int a,int b)
 {
  super(s);
  setSize(a,b);
  setResizable(false); //ﾊｹﾗ鋗ｯｴｰｿﾚｱ莎ﾉｻﾒﾉｫ
  p1=new Panel();
  p2=new Panel();
  p3=new Panel();
        setLayout(new GridLayout(1,3));//2ﾐﾐ3ﾁﾐ
  l1=new Label("ﾕﾋｺﾅ:");
  l2=new Label("ﾃﾜﾂ・");
  text1=new TextField(10);
  text2=new TextField(10);
  text2.setEchoChar('*');
  b1=new Button("ﾈｷﾈﾏ");
  b2=new Button("ﾈ｡ﾏ・);
  setMenuBar(menubar);
  setBackground(Color.white);
  setVisible(true);
       p1.setLayout(new GridLayout(4,1));
       p1.add(new Label());p1.add(l1);p1.add(l2);
       p2.setLayout(new GridLayout(4,1));
       p2.add(new Label());p2.add(text1);p2.add(text2);
       p3.setLayout(new GridLayout(4,2));
       p3.add(new Label()); p3.add(new Label());p3.add(b1);p3.add(new Label());p3.add(b2);
       p3.add(new Label()); p3.add(new Label()); p3.add(new Label());
        add(p1);
        add(p2);
        add(p3);
        b1.addActionListener(this);
        b2.addActionListener(this);
        addWindowListener(new WindowAdapter()
        {
         public void windowClosing(WindowEvent e)
         {
          setVisible(false);
          /*System.exit(0);*///ﾊｹﾋﾐｵﾄｴｰｿﾚｹﾘｱﾕ
         }
        });
 }
 public void actionPerformed(ActionEvent e)
 {  
  if(e.getSource()==b1)//ﾌ晴ﾓ・ﾅ･
  {
   String t1,t2;
   t1=text1.getText();
   t2=text2.getText();
  if((t1==null)||(t1.length()==0))
   JOptionPane.showMessageDialog(null,"ﾇ・菠・ﾋｺﾅ!");
  else if((t2==null)||(t2.length()==0))
  JOptionPane.showMessageDialog(null,"ﾇ・菠・ﾜﾂ・");
        else {
    Connection con=null;
    Statement st=null;
    String sql="";
          sql="select User,Psd from Users where User='"+t1+"' and Psd='"+t2+"';";
       try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     //ﾁｬｽﾓﾊｾﾝｿ・
       con=DriverManager.getConnection("jdbc:odbc:Stu");
        st=con.createStatement();
     ResultSet rs=st.executeQuery(sql);
     if (rs.next())
     {
        setVisible(false);
            new Student("ﾑｧﾉ昻ﾅﾏ｢ｹﾜﾀ榘ｵﾍｳ",400,400);
            pack();
            }
          else
              JOptionPane.showMessageDialog(null,"ﾓﾃｻｧﾃ釗ﾜﾂ・﨔・");
            }
  catch(Exception e4){
   {JOptionPane.showMessageDialog(null,"ｳ・");}
  }
     }
  }
      else if (e.getSource()==b2)
    {
    setVisible(false);
    System.exit(0);
   }
  }
}