login.java

图书管理设计文档

/*
 * Login.java
 *
 * Created on 2001年2月10日, 上午11:27
 */
import javax.swing.*;
import java.sql.*;
/**
 *
 * @author  root
 */
public class Login extends javax.swing.JInternalFrame {
    private String name,password;
    private DataConnect dc = null;
    private boolean loginOK=false;
    /** Creates new form Login */
    public boolean getLoginOK(){return loginOK;}
    public Login(DataConnect dc) {
        this.dc = dc;
        initComponents();
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    private void initComponents() {//GEN-BEGIN:initComponents
        jLabel1 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jB_d_ok = new javax.swing.JButton();
        jB_d_exit = new javax.swing.JButton();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        jLabel15 = new javax.swing.JLabel();
        jLabel16 = new javax.swing.JLabel();
        jLabel17 = new javax.swing.JLabel();
        jLabel18 = new javax.swing.JLabel();
        jLabel19 = new javax.swing.JLabel();
        jLabel20 = new javax.swing.JLabel();
        jTF_d_user = new javax.swing.JTextField();
        jLabel21 = new javax.swing.JLabel();
        jLabel22 = new javax.swing.JLabel();
        jLabel23 = new javax.swing.JLabel();
        jLabel24 = new javax.swing.JLabel();
        jLabel25 = new javax.swing.JLabel();
        jLabel26 = new javax.swing.JLabel();
        jLabel27 = new javax.swing.JLabel();
        jLabel28 = new javax.swing.JLabel();
        jLabel29 = new javax.swing.JLabel();
        jPF_d_pwd = new javax.swing.JPasswordField();
        jLabel30 = new javax.swing.JLabel();
        jLabel31 = new javax.swing.JLabel();
        jLabel32 = new javax.swing.JLabel();
        jLabel33 = new javax.swing.JLabel();
        jLabel34 = new javax.swing.JLabel();
        jLabel35 = new javax.swing.JLabel();

        setClosable(true);
        setTitle("\u767b\u5f55");
        jLabel1.setFont(new java.awt.Font("汉仪宋体", 1, 32));
        jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel1.setText("\u767b\u5f55");
        getContentPane().add(jLabel1, java.awt.BorderLayout.NORTH);

        jPanel1.setLayout(new java.awt.GridLayout(2, 4, 10, 5));

        jPanel1.setMinimumSize(new java.awt.Dimension(10, 20));
        jPanel1.setPreferredSize(new java.awt.Dimension(10, 60));
        jPanel1.add(jLabel2);

        jB_d_ok.setText("\u786e\u5b9a");
        jB_d_ok.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jB_d_okActionPerformed(evt);
            }
        });

        jPanel1.add(jB_d_ok);

        jB_d_exit.setText(" \u53d6\u6d88");
        jB_d_exit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jB_d_exitActionPerformed(evt);
            }
        });

        jPanel1.add(jB_d_exit);

        jPanel1.add(jLabel3);

        jPanel1.add(jLabel4);

        jPanel1.add(jLabel5);

        jPanel1.add(jLabel6);

        jPanel1.add(jLabel7);

        getContentPane().add(jPanel1, java.awt.BorderLayout.SOUTH);

        jPanel2.setLayout(new java.awt.GridLayout(6, 5, 10, 5));

        jPanel2.add(jLabel8);

        jPanel2.add(jLabel9);

        jPanel2.add(jLabel10);

        jPanel2.add(jLabel11);

        jPanel2.add(jLabel12);

        jPanel2.add(jLabel13);

        jPanel2.add(jLabel14);

        jPanel2.add(jLabel15);

        jPanel2.add(jLabel16);

        jPanel2.add(jLabel17);

        jPanel2.add(jLabel18);

        jLabel19.setText("\u7528\u6237\u540d");
        jPanel2.add(jLabel19);

        jPanel2.add(jLabel20);

        jPanel2.add(jTF_d_user);

        jPanel2.add(jLabel21);

        jPanel2.add(jLabel22);

        jPanel2.add(jLabel23);

        jPanel2.add(jLabel24);

        jPanel2.add(jLabel25);

        jPanel2.add(jLabel26);

        jPanel2.add(jLabel27);

        jLabel28.setText("\u5bc6\u7801");
        jPanel2.add(jLabel28);

        jPanel2.add(jLabel29);

        jPanel2.add(jPF_d_pwd);

        jPanel2.add(jLabel30);

        jPanel2.add(jLabel31);

        jPanel2.add(jLabel32);

        jPanel2.add(jLabel33);

        jPanel2.add(jLabel34);

        jPanel2.add(jLabel35);

        getContentPane().add(jPanel2, java.awt.BorderLayout.CENTER);

        pack();
    }//GEN-END:initComponents

    private void jB_d_exitActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_d_exitActionPerformed
        // TODO 将在此处增加您的处理代码：
        jTF_d_user.setText("");
        jPF_d_pwd.setText("");
    }//GEN-LAST:event_jB_d_exitActionPerformed
void showRight() 
{
    JOptionPane.showMessageDialog(this,"登录成功!","Message",JOptionPane.ERROR_MESSAGE);
}

void showWrong() 
{
    JOptionPane.showMessageDialog(this,"登录失败,请重新登录!","Message",JOptionPane.ERROR_MESSAGE);
}
    private void jB_d_okActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_d_okActionPerformed
        // TODO 将在此处增加您的处理代码：
    try
    {
        //获取用户名，密码
        name = jTF_d_user.getText();
        password = jPF_d_pwd.getText();
        //调用ConnectMysql类  
        //ConnectMysql cm = new ConnectMysql();
    
        //java.sql.Connection cn = cm.Connect();   
        //检验是否存在该用户
        try
        {
            //java.sql.PreparedStatement ps = cn.prepareStatement("select count(name) from User where name=? and password=?");
            java.sql.Statement ps = dc.getStatement();
            //String sql = "select count(name) from User where name='"+name+"' and password='"+password+"'";//? and password=?";
            String sql = "select count(name) from Manager where name='"+name+"' and password='"+password+"'";//? and password=?";
            //ps.setString(1,name);
            //ps.setString(2,password);
            java.sql.ResultSet rs = ps.executeQuery(sql);
            //ps.setCursorName(name);
            //ps.setCursorName(password);
            ////java.sql.ResultSet rs=ps.executeQuery();
            boolean b = false;
            rs.next();
            int name_count=rs.getInt(1);
            rs.close();
            if(name_count==1)
            {
                
                String sql1 = "select id from Manager where name='"+name+"' and password='"+password+"'";
                rs=ps.executeQuery(sql1);
                rs.next();
                System.out.println(rs.getInt(1));
                showRight();
                rs.close();
                loginOK=true;
                this.setVisible(false);
                
            }
            else
            {
                showWrong();
            }
            ps.close();
            //cn.close();
        }
        catch(Exception e)
        {
            javax.swing.JOptionPane.showMessageDialog(this,"查询用户名，密码操作有误！");
            System.out.println(e);
        }  
    }
    catch(Exception e) 
    {
        javax.swing.JOptionPane.showMessageDialog(this,"连接数据库错误！");
    }   
    }//GEN-LAST:event_jB_d_okActionPerformed
    
 /*   
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jB_d_exit;
    private javax.swing.JButton jB_d_ok;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    pivate javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel35;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPasswordField jPF_d_pwd;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JTextField jTF_d_user;
    // 变量声明结束//GEN-END:variables
   */
        private javax.swing.JButton jB_d_exit;
    private javax.swing.JButton jB_d_ok;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel35;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPasswordField jPF_d_pwd;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JTextField jTF_d_user;
}