JDBC实现用户注册和登陆

使用数据库图形化工具，新建用户表user用来存储用户账号和密码，添加字段name,password。

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

public class jdbcDemo {
    public static void main(String[] args) throws Exception {
        Scanner sc= new Scanner(System.in);
        Class.forName("com.mysql.jdbc.Driver");
        //建立连接
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/df?user=root&password=123456&characterEncoding=UTF-8");
        //创建SQL执行对象
        Statement sta = con.createStatement();
        ResultSet rs = null;
        while (true) {
        System.out.println("1，用户登录");
        System.out.println("2，用户注册");
        System.out.println("3，退出");
        System.out.println("请输入要执行的操作");
        int a = sc.nextInt();

            if (a == 1) {
                System.out.println("请输入账号:");
                String username = sc.next();
                System.out.println("请输入密码:");
                String userpassword = sc.next();
                String sql = "select * from user";
                 rs = sta.executeQuery(sql);
                //循环遍历结果集
                int index = 0;
                while (rs.next()) {
                    String name = rs.getString("name");
                    String password = rs.getString("password");
                    if (name.equals(username) && password.equals(userpassword)) {
                        index = 1;
                        break;
                    }else if(name.equals(username) && !password.equals(userpassword)){
                        index = 2;
                        break;
                    }
                }
                if (index == 0) {
                    System.out.println("用户不存在");
                }else if(index==1){
                    System.out.println("登陆成功");
                }else if(index == 2){
                    System.out.println("账号或密码错误");
                }
            } else if (a == 2) {
                while (true) {
                    System.out.println("请输入新账号:");
                    String username = sc.next();
                    System.out.println("请输入新密码:");
                    String userpassword = sc.next();
                    String sql = "insert into user VALUES('" + username + "','" + userpassword + "')";
                    String sql1 =  "select * from user";
                    rs = sta.executeQuery(sql1);
                    int r = 0;
                    while (rs.next()) {
                        String name = rs.getString("name");
                        if (name.equals(username)){
                            System.out.println("账号已存在");
                            r = 1;
                            break;
                        }
                    }
                    if(r==0){
                    //    System.out.println(sql);
                        sta.executeUpdate(sql);
                        System.out.println("注册成功！！！");
                        break;
                    }

                }
            } else if (a == 3) {
                break;
            } else {
                System.out.println("无此选项");
            }
        }
        rs.close();
        sta.close();
        con.close();
    }
}