login.java

java课程设计的的许多源代码以及数据库联接

package family;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import com.borland.dx.sql.dataset.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class Login extends JDialog {
  private JPanel panel1 = new JPanel();
  private JLabel jLabel_pass = new JLabel();
  private JButton jButton_ok = new JButton();
  private JButton jButton2 = new JButton();
  private boolean bIsLogin=false;
  private QueryDataSet queryDataSet_User = new QueryDataSet();
  private Database database1 = new Database();
  private JPasswordField jTextField2 = new JPasswordField();
  GridBagLayout gridBagLayout1 = new GridBagLayout();
  public  boolean getLoginStatus(){
    return bIsLogin;
  }
  public Login(Frame frame, String title, boolean modal) {
    super(frame, title, modal);

    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public Login() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    panel1.setLayout(gridBagLayout1);
    jLabel_pass.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel_pass.setText("口令：");
    jButton_ok.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton_ok.setText("确定");
    jButton_ok.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton_ok_actionPerformed(e);
      }
    });
    jButton2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton2.setText("取消");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton2_actionPerformed(e);
      }
    });
    panel1.setFont(new java.awt.Font("Dialog", 0, 14));
    panel1.setMinimumSize(new Dimension(300, 180));
    panel1.setPreferredSize(new Dimension(300, 180));
    this.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
    this.setModal(true);
    this.setResizable(false);
    this.setTitle("登录");
    this.addWindowListener(new java.awt.event.WindowAdapter() {
      public void windowClosed(WindowEvent e) {
        this_windowClosed(e);
      }
    });
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:family", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    database1.setDatabaseName("");
    queryDataSet_User.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from User ;", null, true, Load.ALL));
    panel1.add(jLabel_pass,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(34, 48, 0, 12), 15, 0));
    panel1.add(jTextField2,  new GridBagConstraints(1, 0, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(34, 9, 0, 48), 127, 0));
    panel1.add(jButton2,  new GridBagConstraints(1, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(31, 67, 26, 63), 0, 0));
    panel1.add(jButton_ok,  new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(31, 48, 26, 0), 0, 0));
    this.getContentPane().add(panel1, BorderLayout.CENTER);
  }

  void this_windowClosed(WindowEvent e) {
    if(!bIsLogin)
      System.exit(0);
  }

  void jButton_ok_actionPerformed(ActionEvent e) {
    queryDataSet_User.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * from User where Name =\'admin\' and Pass = \'"
      +jTextField2.getText()+"\'", null, true, Load.ALL));
    try{
      queryDataSet_User.open();
    }catch(Exception ex)
    {
      return;
    }
    if(queryDataSet_User.getRowCount()==0)
    {
      queryDataSet_User.close();
      JOptionPane.showMessageDialog(this,"您输入的口令不正确！请重新输入！","提示",JOptionPane.ERROR_MESSAGE);
      jTextField2.setText("");
      return;
    }else{
          queryDataSet_User.close();
          this.hide();
          bIsLogin = true;
    }

  }

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