JAVA单排日记-2020/3/15-JDBC-练习-登录案例

首先创建一个数据库表，盛放用户和密码

查看输入密码是否匹配

修改配置信息：

程序验证用户输入密码：
自己写的：

package JDBC;

import util.JDBCutil;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;

public class DmeoPassword {
    public static void main(String[] args) throws Exception {

        boolean flag = true;
        while (flag) {
            Scanner sca = new Scanner(System.in);
            System.out.println("输入用户名");
            String userIn = sca.next();
            System.out.println("输入密码");
            String passwordIn = sca.next();

            Connection conn = JDBCutil.connection();

            String sqluser = "SELECT * FROM USER";
            Statement stmt = conn.createStatement();
            ResultSet res = stmt.executeQuery(sqluser);
            int count = 0;
            while (res.next()) {

                if (res.getString("username").equals(userIn)) {
                    count = 1;
                    String sqlpassword = "select password from user where username =" + "'" + userIn + "'";
                    Connection conn2 = JDBCutil.connection();
                    Statement stmt2 = conn.createStatement();
                    ResultSet respassword = stmt2.executeQuery(sqlpassword);
                    respassword.next();
                    if (respassword.getString("password").equals(passwordIn)) {
                        System.out.println("密码正确");
                        flag=false;
                    } else {
                        System.out.println("密码错误");
                    }
                    JDBCutil.close(stmt2, conn2, respassword);
                }
            }
            if (count == 0) {
                System.out.println("不存在该用户");
            }
            JDBCutil.close(stmt, conn, res);
        }
    }
}

优化：

package JDBC;

import util.JDBCutil;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;

public class DmeoPassword2 {
    public static void main(String[] args) throws Exception {

        boolean flag = true;
        while (flag) {
            Scanner sca = new Scanner(System.in);
            System.out.println("输入用户名");
            String userIn = sca.next();
            System.out.println("输入密码");
            String passwordIn = sca.next();

            Connection conn = JDBCutil.connection();

            String sql = "SELECT * FROM USER where username = "+"'"+userIn+"'"+"and password = "+"'"+passwordIn+"'";
            Statement stmt = conn.createStatement();
            ResultSet res = stmt.executeQuery(sql);
            if (res.next()){
                System.out.println("密码正确");
                flag=false;
            }else {
                System.out.println("密码错误");
            }
            JDBCutil.close(stmt, conn, res);
        }
    }
}