【Alpha版本】冲刺阶段——Day5

最新推荐文章于 2024-09-17 16:06:02 发布

weixin_30896763

最新推荐文章于 2024-09-17 16:06:02 发布

阅读量114

点赞数

文章标签：前端数据库 ViewUI

原文链接：http://www.cnblogs.com/javahc/p/9170308.html

版权

【Alpha版本】冲刺阶段——Day5

阅读目录

今日进展
问题困难
明日任务
今日贡献量
站立式会议
TODOlist

【今日进展】

完成登录类代码

public void LOGIN() {
        con = GetDBConnection.connectDB("mysql","root","");

        if(con == null ) return;
        String select=" username Like '"+name+"'";
        String sqlStr ="select * from javablacktea where "+select;
        try {
            sql=con.createStatement();
            rs = sql.executeQuery(sqlStr);
            if(rs.next()) {
                salt=rs.getString(3);
                //System.out.println(salt);
                String cipherInTheInformation=rs.getString(2);
                //System.out.println(cipherInTheInformation);
                encrypt.setSalt(salt);
                this.cipher=encrypt.getpassword(cipher);
                //System.out.println(cipher);
                if(!cipherInTheInformation.equals(cipher)){
                    System.out.println("用户名或者密码错误！");
                }
                else{
                    System.out.println("登陆成功！");
                }
            }
            else{
                System.out.println("用户名或者密码错误！");
            }
            con.close();
        }
        catch(SQLException e) { }
    }

完成修改密码模块代码

 public void MODIFY() {
        con = GetDBConnection.connectDB("mysql","root","");

        if(con == null ) return;
        String select=" username Like '"+name+"'";
        String sqlStr ="select * from javablacktea where "+select;
        try {
            sql=con.createStatement();
            rs = sql.executeQuery(sqlStr);
            if(rs.next()) {
                salt=rs.getString(3);
                //System.out.println(salt);
                String cipherInTheInformation=rs.getString(2);
                //System.out.println(cipherInTheInformation);
                encrypt.setSalt(salt);
                this.cipher=encrypt.getpassword(cipher);
                //System.out.println(cipher);
                if(!cipherInTheInformation.equals(cipher)){
                    System.out.println("用户名或者密码错误！");
                    //如果两次输入的密码不一致，那么就提醒错误。但是不明确提示是哪个错误。
                }
                else{
                    if(!newCipher1.equals(newCipher2)){
                        System.out.println("两次输入的新密码不一致！");
                    }
                    else{
                        salt=encrypt.getsalt();
                        cipher=encrypt.getpassword(newCipher1);
                        try {
                            String sqlStr2 ="update javablacktea set hash = "+"'"+cipher+"'"+"where username = "+"'"+name+"'";
                            String sqlStr3 ="update javablacktea set salt = "+"'"+salt+"'"+"where username = "+"'"+name+"'";

                            sql.executeUpdate(sqlStr2);
                            sql.executeUpdate(sqlStr3);
                            System.out.println("更改密码成功。");
                        }
                        catch (SQLException e){
                            System.out.println("更改密码失败。");
                        }
                    }
                }
            }
            else{
                System.out.println("用户名或者密码错误！");
                //如果两次输入的账号不一致，那么就提醒错误。但是不明确提示是哪个错误。
            }
            con.close();
        }
        catch(SQLException e) { }
    }
}

完成注销类代码

public void CANCEL() {
        con = GetDBConnection.connectDB("mysql","root","");

        if(con == null ) return;
        String select=" username Like '"+name+"'";
        String sqlStr ="select * from javablacktea where "+select;
        try {
            sql=con.createStatement();
            rs = sql.executeQuery(sqlStr);
            if(rs.next()) {
                salt=rs.getString(3);
                //System.out.println(salt);
                String cipherInTheInformation=rs.getString(2);
                //System.out.println(cipherInTheInformation);
                encrypt.setSalt(salt);
                this.cipher=encrypt.getpassword(cipher);
                //System.out.println(cipher);
                if(!cipherInTheInformation.equals(cipher)){
                    System.out.println("用户名或者密码错误！");
                }
                else{
                    System.out.println("是否确定注销该账户？（'Y'or'N'）");
                    String flag = scanner.next();
                    ///接下来要删除数据库中的该项内容。
                    if(flag.equals("Y")){
                        try {
                            String sqlStr2 ="delete from javablacktea where username = "+"'"+name+"'";
                            sql.executeUpdate(sqlStr2);
                            System.out.println("注销成功。");
                        }
                        catch (SQLException e){
                            System.out.println("注销失败。");
                        }
                    }
                }
            }
            else{
                System.out.println("用户名或者密码错误！");
            }
            con.close();
        }
        catch(SQLException e) { }
    }
}