2024.3.13

public static int login(String userAccount, String userPassword) {
    Connection connection = null;
    boolean success = false;

    try {
        connection = JDBCUtils.getConn();

        if (connection != null) {
            String query = "SELECT * FROM user WHERE UserID = ? AND password = ?";

            try (PreparedStatement pstmt = connection.prepareStatement(query)) {
                pstmt.setString(1, userAccount);
                pstmt.setString(2, userPassword);

                try (ResultSet rs = pstmt.executeQuery()) {
                    if (rs.next()) {
                        String a1 = rs.getString("UserID");
                        if(a1.length() == 10) {
                            Log.d("MysqlHelp_denglu", "用户名和密码匹配成功！");
                            success = true;
                            return 1;
                        }else if (a1.length() < 10){
                            Log.d("MysqlHelp_denglu", "用户名和密码匹配成功！");
                            success = true;
                            return 2;
                        }
                    } else {
                        Log.d("MysqlHelp_denglu", "用户名和密码不匹配。");
                        success = false;
                    }
                }
            }
        } else {
            Log.d("MysqlHelp_denglu", "无法获取数据库连接。");
        }
    } catch (Exception ex) {
        Log.e("MysqlHelp_denglu", "验证登录时发生异常", ex);
        success = false;
    }

    return 0;
}