学生管理系统----JavaSE和JDBC练习

package free.exer;

import java.sql.*;
import java.util.Scanner;

/**
 *
 * 学生管理系统
 * 
 */
public class test27{
   
    public static void main(String[] args) {
   

        String url = "jdbc:mysql://localhost:3306/student?characterEncoding=utf-8&serverTimeZone=Asia/Shanghai";
        String username = "root";
        String password = "mysql";
        try {
   
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
   
            e.printStackTrace();
        }
        boolean isflag = true;
        while (isflag) {
   
        System.out.println("欢迎进入学生管理系统");
        System.out.println("1.登录");
        System.out.println("2.注册");
        System.out.println("3.注销");
        System.out.println("4.退出");
        Scanner scan = new Scanner(System.in);
        System.out.print("请输入你的选择：");
        int num = scan.nextInt();

            switch (num) {
   
                case 1:
                    System.out.println("请输入你的登录账户");
                    System.out.print("请输入你的账号:");
                    String inusername = scan.next();
                    System.out.print("请输入你的密码:");
                    String inpassword = scan.next();
                    String boolname = null;
                    Connection conn = null;
                    PreparedStatement ps = null;
                    ResultSet rs = null;
                    try {
   
                        conn = DriverManager.getConnection(url, username, password);
                        String sql = "select * from user where username=? and password=?";
                        ps = conn.prepareStatement(sql);
                        ps.setString(1, inusername);
                        ps.setString(2, inpassword);
                        rs = ps.executeQuery();
                        while (rs.next()) {
   
                            boolname = rs.getString("username");
                        }
                    } catch (SQLException e) {
   
                        e.printStackTrace();
                    } finally {
   
                        if (rs != null) {
   
                            try {
   
                                rs.close();
                            } catch (SQLException e) {
   
                                e.printStackTrace();
                            }
                        }
                        if (ps != null) {
   
                            try {
   
                                ps.close();
                            } catch (SQLException e) {
   
                                e.printStackTrace();
                            }
                        }
                        if (conn != null) {
   
                            try {
   
                                conn.close();
                            } catch (SQLException e) {
   
                                e.printStackTrace();