logincs.java

用java编写的超市管理信息系统的源代码.

package uml_gaokai;

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

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

public class Logincs extends JDialog implements ActionListener{
  private JPanel panel1 = new JPanel();
  private BorderLayout borderLayout1 = new BorderLayout();
  private JPanel jPanel1 = new JPanel();
  private XYLayout xYLayout1 = new XYLayout();
  private JLabel jLabel1 = new JLabel();
  private JLabel jLabel2 = new JLabel();
  private JTextField jTextField1 = new JTextField();
  private JButton jButton1 = new JButton();
  private JButton jButton2 = new JButton();
  private JPasswordField jPasswordField1 = new JPasswordField();
  private Database database1 = new Database();
  private QueryDataSet queryDataSet1 = new QueryDataSet();
  private JLabel jLabel3 = new JLabel();
  private JLabel jLabel4 = new JLabel();
  private JLabel jLabel5 = new JLabel();
  private TitledBorder titledBorder1;
  private TitledBorder titledBorder2;
  private JLabel jLabel6 = new JLabel();

  public Logincs(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public Logincs() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    panel1.setLayout(borderLayout1);
    jPanel1.setLayout(xYLayout1);
    jLabel1.setForeground(Color.blue);//标签控件的字体颜色
    jLabel1.setText("用户名"); //标签标题
    jLabel2.setForeground(Color.blue);
    jLabel2.setText("密码");
    jButton1.setForeground(UIManager.getColor("List.selectionBackground"));//按钮控件字体颜色
    jButton1.setBorder(BorderFactory.createRaisedBevelBorder());//按钮外观
    jButton1.setText("登录");//按钮标题
    jButton1.addActionListener(this);//加入按钮事件
    jButton2.setForeground(UIManager.getColor("Menu.selectionBackground"));
    jButton2.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton2.setToolTipText("");
    jButton2.setText("取消");
    jButton2.addActionListener(this);
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setMinimumSize(new Dimension(600, 600));//设置面板大小
    jPanel1.setPreferredSize(new Dimension(400, 300));
    jPasswordField1.setBorder(titledBorder1);
    jPasswordField1.setToolTipText("");
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:gaokaiSQL", "sa", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT [user].userName,[user].userPassword,[user].userAuthority \n" +
        "FROM [UML_CS].[dbo].[user]", null, true, Load.ALL));
    this.setResizable(false);
    this.setTitle("Login");
    jLabel3.setBackground(Color.white);//标签背景颜色
    jLabel3.setForeground(Color.green);
    jLabel3.setBorder(BorderFactory.createEtchedBorder());
    jLabel3.setText("                                        小型超市管理系统");
    jLabel4.setBorder(BorderFactory.createEtchedBorder());
    jLabel4.setText(" ——制作人：高凯");
    jLabel5.setBorder(BorderFactory.createEtchedBorder());
    jLabel5.setToolTipText("");
    jLabel5.setText("——版本号: 1.1");
    jTextField1.setBorder(titledBorder2);
    jLabel6.setBorder(BorderFactory.createEtchedBorder());
    getContentPane().add(panel1);
    panel1.add(jPanel1, BorderLayout.WEST);
    jPanel1.add(jLabel3,     new XYConstraints(-1, 0, 395, 30));
    jPanel1.add(jLabel5,     new XYConstraints(274, 30, 121, 32));
    jPanel1.add(jLabel4, new XYConstraints(127, 32, 143, 30));
    jPanel1.add(jPasswordField1, new XYConstraints(143, 196, 132, 24));
    jPanel1.add(jTextField1, new XYConstraints(143, 136, 132, 24));
    jPanel1.add(jLabel2, new XYConstraints(23, 195, 60, 25));
    jPanel1.add(jLabel1, new XYConstraints(23, 134, 60, 25));
    jPanel1.add(jLabel6,    new XYConstraints(-2, 65, 396, 191));
    jPanel1.add(jButton1, new XYConstraints(90, 274, 68, 28));
    jPanel1.add(jButton2, new XYConstraints(193, 275, 69, 28));
  }
  public void actionPerformed(ActionEvent e){
    //the user login
    if(e.getSource() == jButton1) //得到界面单击事件
    {
      try{
        String userAuthority = null ;
        String userName = null ;
        String userPassword = null ;
        String testName = jTextField1.getText().toString() ;//从jTextField1中得到用户名
        String testPassword = String.valueOf(jPasswordField1.getPassword()) ;//从jPassword中得到用户密码
        Statement sql = database1.createStatement() ; //打开Statement对象
        ResultSet rs = sql.executeQuery("SELECT userName,userPassword , userAuthority FROM [UML_CS].[dbo].[user] WHERE userName = '"+testName+"'") ;
        //执行SQL语句，从数据库当中选择用户名，密码，和权限。
        while(rs.next()) //
        {
          userName = rs.getString("userName") ; //从数据库当中得到用户名
          userPassword = rs.getString("userPassword") ;//从数据库当中得到密码
          userAuthority = rs.getString("userAuthority") ;//从数据库当中得到权限
        }
        verifyUser(userName,userPassword,testPassword,userAuthority); //调用verifyUser方法
        cancel() ;//退出
      }
      catch(SQLException ex){ex.printStackTrace();}
    }
    //exit the System
    else if(e.getSource() == jButton2){
      cancel();
    }
  }
  void cancel()
  {
    dispose();
  }

  //验证用户名以及密码
  void verifyUser(String userName , String userPassword , String testPassword, String userAuthority)
  {
    if(userName == null) //判断用户名是否为空
    {
      JOptionPane.showMessageDialog(null,"用户名不存在，请先注册","verify user",JOptionPane.DEFAULT_OPTION);
      //抛出对话框
    }
    else
    {
      if(userPassword.equals(testPassword) == false) //判断密码是否相等
      {
        JOptionPane.showMessageDialog(null,"您输入的密码不正确，请重试","verify password" , JOptionPane.DEFAULT_OPTION);
        //抛出对话框
      }
      else{
        JOptionPane.showMessageDialog(null,"success","",JOptionPane.DEFAULT_OPTION);
        //
        verifyUserAuthority(userAuthority) ;//进行权限判断
      }
    }
  }
  //验证用户权限
  void verifyUserAuthority(String userAuthority){
    if(userAuthority.equals("admin"))//如果用户为admin，则弹出管理员界面
    {
      AdminWindow adminWindow = new AdminWindow() ;
      //设置对话框
      Dimension dlgSize = adminWindow.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      adminWindow.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
      adminWindow.setModal(true);
      adminWindow.pack();
      adminWindow.show();
    }
    else if (userAuthority.equals("customer")){
      CustomerWindow customerWindow =new CustomerWindow() ;
      Dimension dlgSize = customerWindow.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      customerWindow.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
      customerWindow.setModal(true);
      customerWindow.pack();
      customerWindow.show();
    }
    else if (userAuthority.equals("buyer")){
      BuyerWindow buyerWindow =new BuyerWindow() ;
      Dimension dlgSize = buyerWindow.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      buyerWindow.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
      buyerWindow.setModal(true);
      buyerWindow.pack();
      buyerWindow.show();
    }
    else if (userAuthority.equals("saler")){
      SalesWindow salesWindow =new SalesWindow() ;
      Dimension dlgSize = salesWindow.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      salesWindow.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
      salesWindow.setModal(true);
      salesWindow.pack();
      salesWindow.show();
    }
    else if (userAuthority.equals("manager")){
      ManagementWindow managementWindow =new ManagementWindow() ;
      Dimension dlgSize = managementWindow.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      managementWindow.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
      managementWindow.setModal(true);
      managementWindow.pack();
      managementWindow.show();
    }
  }
}