」工欲善其事,必先利其器。「—孔子《論語.錄靈公》
首頁 > 程式設計 > 使用 Express、MongoDB 和 Passport.js 實作 JWT 驗證

使用 Express、MongoDB 和 Passport.js 實作 JWT 驗證

發佈於2024-11-03
瀏覽:701

Introduction

Secure authentication is a core concept in the development of modern web applications. Authentication is crucial in safeguarding user data and restricting access to certain resources. Authentication involves a series of processes that verify the identity of a user. There are various techniques of authentication, some include:

  • Basic authentication
  • API keys
  • OAuth 2.0
  • JWT (JSON Web Tokens)
  • OpenID Connect

Each technique listed above has pros and cons, refer to article for a detailed explanation.

This article will focus on using JWTs for authentication. According to the docs:

JSON Web Token (JWT) is an open standard (RFC 7519) that defines a compact and self-contained way for securely transmitting information between parties as a JSON object.

JWTs are widely used for authentication because of their simplicity and scalability. In this tutorial, you will implement JWT authentication in an Express.js application, using MongoDB and the Passport.js library. By the end of this tutorial, you will create an authentication system with user registration, login, token refresh, and a protected route. You will create the following endpoints:

  • POST /api/v1/auth/register: Registers a new user.
  • POST /api/v1/auth/token: Authenticate a user and return a JWT.
  • POST /api/v1/auth/token/refresh: Refreshes the JWT.
  • POST /api/v1/auth/whoami: Protected route, that retrieves the details of the authentication user.

Authentication Workflow

The diagram below shows the authentication workflow for the application created in this tutorial:

Implementing JWT Authentication with Express, MongoDB, and Passport.js

Prerequisites

Before proceeding with the tutorial, ensure you have the following:

  • You have Node.js and NPM installed on your computer.
  • Basic knowledge of Express.js and MongoDB.
  • You have Git installed on your computer.
  • A MongoDB instance that runs locally or remotely (e.g. MongoDB Atlas).
  • A code editor (e.g. VS Code).

Project Setup

For this tutorial, boilerplate code is available in the GitHub repository. Follow these steps to set up the boilerplate code for the application:

  1. Run the command below to clone the repository:

    git clone https://github.com/michaelikoko/express-passport-jwt-auth.git
    
  2. Navigate to the starter directory:

    cd express-passport-jwt-auth/starter
    

    This is the folder structure for the starter directory: Implementing JWT Authentication with Express, MongoDB, and Passport.js

  3. Install the required dependencies:

    npm install
    
  4. Create a .env file in the current directory, and provide the application's port, MongoDB connection string, and the secret key used in signing tokens. The secret key is confidential and should be a random secure string. You can generate a secret key using OpenSSL:

    openssl rand -base64 32 
    

    The .env should look like this:

    PORT=3000
    MONGODB_URI=mongodb srv://<username>:<password>@cluster1.menjafx.mongodb.net
    SECRET=<your-secret-key>
    
  5. Run the development server:

    npm run dev
    
  6. In a web browser, navigate to http://localhost:3000/api/v1/docs/ (replace with the appropriate port number) to access the Swagger documentation. This is an interactive interface that you can use to test the application. Implementing JWT Authentication with Express, MongoDB, and Passport.js

Creating The User Schema

With the boilerplate code all set, you will need to create the schema for the user model. The user schema will be created using the mongoose library, and will include the following fields:

  • email: The email field is unique to each user. It will function as the username.
  • password: This field will contain a hash of the user's password. Storing passwords as plain text in the database poses significant security risks. To learn more about password hashing, you can check out this article.
  • firstname: The user's first name.
  • lastname: The user's last name.

In the models/User.js file, input the following:

const  mongoose  =  require("mongoose");
const  uniqueValidator  =  require("mongoose-unique-validator");

const userSchema = new mongoose.Schema(
  {
    email: {
      type: String,
      required: true,
      unique: true,
      trim: true
    },
    password: {
      type: String,
      required: true,
      trim: true,
      unique: true
    },
    firstName: {
      type: String,
      required: true,
      trim: true,
      minLength: [3, 'First Name too short'],
      maxLength: [50, 'First Name too long']
    },
    lastName: {
      type: String,
      required: true,
      trim: true,
      minLength: [3, 'Last Name too short'],
      maxLength: [50, 'Last Name too long']
    },
  },
  { timestamps: true }
);

userSchema.set('toJSON', {
  transform: (document,returnedObject) => {
    returnedObject.id  =  returnedObject._id.toString()
    delete returnedObject._id
    delete returnedObject.__v
    delete returnedObject.password  //do not reveal password
    delete returnedObject.createdAt
    delete returnedObject.updatedAt
  }
})

userSchema.plugin(uniqueValidator)

module.exports  =  mongoose.model('User', userSchema)

Creating Refresh Token Schema

To improve security, JWT access tokens will be short-lived. When they expire, the client application can use a valid refresh token to get new access tokens. This prevents the user from having to log in every time the access token expires.

In this tutorial, refresh tokens will be stored in the database. This will allow you to securely track and manage issued refresh tokens.

The schema for the refresh token will contain the following fields:

  • token: The refresh token string. In this tutorial, it is a randomly generated UUIDv4 identifier.
  • user: This field references the id of the user assigned to the refresh token. It establishes a many-to-one relationship with the User model.
  • expiryDate: This field indicates when the refresh token will become invalid.

In the models/RefreshToken.js file, input the following:

const mongoose = require("mongoose");
const uniqueValidator = require("mongoose-unique-validator");
const refreshTokenSchema = new mongoose.Schema(
  {
    token: {
      type: String,
      required: true,
      unique: true,
      trim: true,
    },
    user: {
      type: mongoose.Schema.Types.ObjectId,
      ref: "User",
    },
    expiryDate: {
      type: Date,
      required: true,
    },
  },
  { timestamps: true }
);

refreshTokenSchema.plugin(uniqueValidator);

module.exports = mongoose.model("RefreshToken", refreshTokenSchema);

Configuring Passport.js

Passport.js is a well-known authentication library for Node.js. Passport.js is described in the docs as:

Simple, unobtrusive authentication for Node.js

Passport.js provides a set of different authentication strategies, such as JWT, and Oauth2, as well as social login using Google, Facebook, GitHub, and many more.

In this tutorial, you will configure the passport-jwt and passport-http strategies.

Install Passport

To make use of the Passport.js library, you need to first install passport and the passport-jwt and passport-http strategies:

npm install passport passport-jwt passport-http

Create Helper Functions

Before configuring Passport.js, you need to create helper functions for hashing and comparing passwords. As stated earlier in the article, a hash of the user's password will be saved in the database. The bcrypt library can be used to hash passwords.

Install bcrypt using:

npm install bcrypt

In the utils/helper.js file, input the following:

const bcrypt = require("bcrypt");
const saltRounds = 10;

async function hashPassword(password) {
  const salt = await bcrypt.genSalt(saltRounds);
  const passwordHash = await bcrypt.hash(password, salt);
  return passwordHash;
}

async function comparePassword(password, hashPassword) {
  return await bcrypt.compare(password, hashPassword);
}

module.exports = {
  hashPassword,
  comparePassword
};

Create Configuration File

In the middleware directory, create a file named passport.js. The file will contain the code necessary for configuring the authentication strategies. The middleware/passport.js file has the following content:

const passport = require("passport");
const PassportJWT = require("passport-jwt");
const PassportHttp = require("passport-http");
const config = require("../utils/config");
const User = require("../models/User");
const helper = require("../utils/helper");

const options = {
  jwtFromRequest: PassportJWT.ExtractJwt.fromAuthHeaderAsBearerToken(),
  secretOrKey: config.SECRET,
};

passport.use(
  new PassportJWT.Strategy(options, async (payload, done) => {
    try {
      const user = await User.findOne({ _id: payload.id });
      if (user) {
        return done(null, user);
      } else {
        return done(null, false);
      }
    } catch (error) {
      return done(error);
    }
  })
);

passport.use(
  new PassportHttp.BasicStrategy( async (userid, password, done) => {
    try {
      const user = await User.findOne({ email: userid });
      if (!user) {
        return done(null, false);
      }
      const isPasswordCorrect = await helper.comparePassword(password, user.password)
      if (!isPasswordCorrect) {
        return done(null, false);
      }
      return done(null, user);
    } catch (error) {
      return done(error);
    }
  })
);

module.exports = passport;

You start by requiring the passport library, passport-jwt strategy, passport-http strategy, the User schema, the helper functions, and the config object which reads the secret key set in the .env file.

JWT Strategy

To set up an authentication strategy, you pass the strategy instance into the passport.use() method. The passport-jwt strategy instance is constructed using:

new PassportJWT.Strategy(options, verify)

The constructor has two parameters:

  1. options: The options parameter is an object that controls token extraction. The options have several properties, visit the docs for a comprehensive list. In this tutorial, you only made use of the two required object properties:

    • secretOrKey: The value of the secretOrKey property is a string containing the secret key used for signing the token.
    • jwtFromRequest: A function that accepts a request as a parameter, and extracts and returns the JWT. The passport-jwt strategy provides a couple of inbuilt extractors. To extract the token from the authorization header with the scheme 'bearer', you make use of the fromAuthHeaderAsBearerToken() extractor. Visit the docs for all included extractors.
  2. verify: The verify parameter is a function with two parameters verify(payload, done):

    • payload: An object that contains the decoded JWT payload.
    • done: A passport error first callback function accepting arguments done(error, user, info).

    In the verify function, you check if the id provided in the JWT payload matches any user in the database. This is done using User.findOne({ _id: payload.id }).

    If the id belongs to a registered user, you call the done function with no error and the user details:

    return  done(null, user);
    

    If the id doesn't belong to a registered user in the database, you call the done function with no error, and a false value for the user:

    return done(null, false);
    

    If the search fails, and an error occurs, you call the done function with the corresponding value for the error:

    return done(error);
    

    When called successfully, the done function attaches the user's details to the request object.

Basic Strategy

Passport.js HTTP Basic authentication strategy verifies users using a user ID, which is an email in this tutorial, and a password. The passport-http strategy constructors require a verify callback function:

 new  PassportHttp.BasicStrategy(verify)

The verify callback function has three parameters:

  • userid
  • password
  • done

In the verify callback function, you check if the email provided belongs to a registered user. This is done using:

User.findOne({ email: userid })

If the user exists, you then compare the provided password to the stored hashed password. Here, you make use of the comparePassword helper function:

helper.comparePassword(password, user.password)

The done callback function is called appropriately.

Initialize Passport

After creating the configuration, you need to initialize Passport.js authentication modules as middleware in your main application file, app.js.

To initialize Passport.js as a middleware in your application, first require the passport library from the configuration file, /middleware/passport.js. Then, you make use of Passport's built-in middleware function:

 passport.initialize()

Modify the app.js file as follows:

// ...

//import middleware
// ...
const passport = require("./middleware/passport");
// ...

//middleware
// ...
app.use(passport.initialize());
// ...

User Registration Endpoint

In this part of the tutorial, you will create two endpoints:

  • GET /api/v1/auth: An endpoint that lists all users in the database.

  • POST /api/v1/auth/register: An endpoint that allows the registration of new users.

The boilerplate code has already taken care of routing, error handling using express-async-errors, and request body validation using express-validator. This means your main focus will be on the controller's logic.

To begin, require the User schema and the helper functions in the controllers/auth.js file:

const User = require("../models/User");
const helper = require("../utils/helper");
// ...

List Users

In the controllers/auth.js file, add the following lines of code to the listUsers function:

//...
async function listUsers(req, res) {
  const users = await User.find({}).exec();
  return res.status(200).json(users);
}
// ...

The listUsers function is pretty straightforward, it queries and returns all users in the database.

Create Users

The code for creating users is implemented in the createUser function. Edit the controllers/auth.js file as follows:

// ...
async function createUser(req, res) {
  const { email, firstName, lastName, password } = req.body;
  const passwordHash = await helper.hashPassword(password);
  const user = await User.create({
    email,
    firstName,
    lastName,
    password: passwordHash,
  });
  return res.status(201).json(user);
}
// ...

The createUser controller first extracts the email, firstName, lastName, and password from the request body. It then hashes the password provided using the helper.hashPassword function and creates a new user in the database.

Testing the User Registration Endpoint

You can navigate to http://localhost:3000/api/v1/docs/ (ensure the appropriate port number is used) to test the user registration endpoints using Swagger UI.

Creating a new user should appear as follows:

Implementing JWT Authentication with Express, MongoDB, and Passport.js

Testing the list user endpoint should show the user you created:

Implementing JWT Authentication with Express, MongoDB, and Passport.js

User Authentication Endpoint

In this step of the tutorial, you will create the user authentication endpoint. The /api/v1/auth/token endpoint allows users to log in to the application by verifying the credentials provided.

More Helper Functions

Before creating the login endpoint, you need to create three more helper functions:

  • issueAccessToken: This function generates and returns a signed JWT. The payload is passed as a parameter.

    You can use the jsonwebtoken library to create JWTs. Install the jsonwebtoken library using:

    npm install jsonwebtoken
    
  • createRefreshToken: This function creates a new refresh token. The user ID is passed as a parameter.

    To generate a random UUIDv4 string as the token value, you can use the uuid library. Install the library using:

    npm install uuid
    
  • verifyRefreshTokenExpiration: This function checks whether a given refresh token is expired.

    Edit the utils/helper.js file as follows:

    const bcrypt = require("bcrypt");
    const jwt = require("jsonwebtoken");
    const config = require("./config");
    const { v4: uuidv4 } = require('uuid'); 
    const RefreshToken = require("../models/RefreshToken");
    
    const saltRounds = 10;
    
    async function hashPassword(password) {
        // ...
    }
    
    async function comparePassword(password, hashPassword) {
    // ...
    }
    
    function issueAccessToken(payload) {
        return jwt.sign(payload, config.SECRET, { expiresIn: 60 * 2}); //2 mins validity 
    }
    
    async function createRefreshToken(userId) {
        let expiryDate = new Date()
        expiryDate.setSeconds(60 * 60 *24) //24 hours validity 
        const token = uuidv4() 
        const refreshToken = await RefreshToken.create({
            token,
            user: userId,
            expiryDate: expiryDate.getTime()
        })
        return refreshToken.token
    }
    
    function verifyRefreshTokenExpiration (token) {
        return token.expiryDate.getTime() 
    
    

Login Controller

The loginUser controller, in the controllers/auth.js file, contains the logic for the user authentication endpoint. Modify the controllers/auth.js file as shown below:

// ...
async function listUsers(req, res) {
    // ...
}

async function createUser(req, res) {
    // ...
}

async function loginUser(req, res) {
  const { email, password } = req.body; 
  const user = await User.findOne({ email });

  if (!user) {
    return res.status(401).json({ error: "Invalid Email" }); 
  }

  const isPasswordCorrect = await helper.comparePassword(
    password,
    user.password
  );

  if (!isPasswordCorrect) {
    return res.status(401).json({ error: "Invalid Password" });
  }

  const payload = {
    email: user.email,
    id: user.id,
  };

  const accessToken = helper.issueAccessToken(payload);
  const refreshToken = await helper.createRefreshToken(user.id);
  return res.status(200).json({
    accessToken,
    refreshToken,
  });
}
// ...

The loginUser controller extracts the login credentials, i.e. email and password from the request body. The function searches for the user in the database with the given email. If no user is found, it returns an error with the 401 Unauthorized status code.

The function proceeds to compare the password provided with the password hash stored in the database using the helper.comparePassword function earlier created. If the passwords don't match, it returns a 401 Unauthorized error, with the appropriate error message.

After the user has been successfully verified, the function creates the payload for the JWT. The payload will contain the user's email and id. It generates a JWT access token using the helper function issueAccessToken passing the payload as a parameter. It also generates a refresh token using the helper function issueRefreshToken. The loginUser controller then returns both tokens as a response.

Testing the User Authentication Endpoint

You can proceed to test the login endpoint using Swagger UI. Passing a valid email and password should give you a response like this:

Implementing JWT Authentication with Express, MongoDB, and Passport.js

Token Refresh

As mentioned earlier, access tokens will be short-lived and users will be able to get new access tokens using refresh tokens. This feature will allow users to maintain their authenticated sessions without having to log in again.

In this section, you will write the controller logic for implementing refresh tokens. Add the following code to the controllers/auth.js file:

// ...

const  RefreshToken  =  require("../models/RefreshToken");
async function listUsers(req, res) {
    // ...
}

async function createUser(req, res) {
    // ...
}

async function loginUser(req, res) {
    // ...
}

async function refreshToken(req, res) {
  const { refreshToken: refreshTokenUUID } = req.body; 
  const refreshToken = await RefreshToken.findOne({
    token: refreshTokenUUID,
  }).populate("user");

  if (!refreshToken) {
    return res.status(404).json({ error: "invalid refresh token" 
    });
  }

  const isExpired = helper.verifyRefreshTokenExpiration(refreshToken);

  if (isExpired) {
    await RefreshToken.findByIdAndDelete(refreshToken._id).exec();
    return res.status(403).json({ error: "Refresh token is expired" });
  }

  const payload = {
    email: refreshToken.user.email,
    id: refreshToken.user.id,
  };

  await RefreshToken.findByIdAndDelete(refreshToken._id).exec();
  const newAccessToken = helper.issueAccessToken(payload);
  const newRefreshToken = await helper.createRefreshToken(payload.id);

  return res.status(200).json({
    accessToken: newAccessToken,
    refreshToken: newRefreshToken,
  });
}

// ...

The refreshToken function first extracts the UUIDv4 refresh token passed by the user from the request body. It then searches the database for the token provided by the user. This is done using the RefreshToken.findOne method. The user data associated with the token is retrieved using the .populate("user") method. The user data will be necessary when creating the payload object for a new access token. If the refresh token does not exist in the database, an error with the 404 Not Found status is returned.

The refreshToken controller proceeds to check if the token is expired using the verifyRefreshTokenExpiration helper function. If the token is expired, it is deleted from the database, and an error with 403 Forbidden status is returned.

The function creates the payload object with the user's email and id.

The refresh token rotation technique helps to improve security. It ensures that refresh tokens can only be used once. To invalidate the refresh token after use, the refreshToken function deletes the old refresh token. The function generates a new access token and refresh token using the issueAccessToken and createRefreshToken helper functions. The function then returns the generated tokens to the client.

Testing the Token Refresh Endpoint

You can test the refresh token passing endpoint using Swagger UI. Passing a valid token should give a result that looks like this:

Implementing JWT Authentication with Express, MongoDB, and Passport.js

Protected Route

Protected routes are endpoints that can only be accessed by authenticated users. They can be crucial for securing sensitive information and restricting certain actions.

To test the authentication system you just built, you are going to create a protected route. In this tutorial, it is just going to be a simple route that returns the details of the authenticated user.

In the controllers/auth.js file, create the whoami controller function:

// ...

async function listUsers(req, res) {
    // ...
}

async function createUser(req, res) {
    // ...
}

async function loginUser(req, res) {
    // ...
}

async function refreshToken(req, res) {
    // ...
}

async function whoami(req, res) {
  return res.status(200).json(req.user);
}

//...

To use the Passport.js library to create protected routes, add the passport.authenticate middleware is to the route definition. Edit the routes/auth.js as follows:

// ...
const  passport  =  require("../middleware/passport");

//...
router
  .route("/whoami")
  .get(passport.authenticate(["jwt", "basic"], { session: false }), whoami);

module.exports = router;

In the passport.authenticate pass a list of the authentication strategies used as the first parameter. In this application, you made use of the JWT strategy and basic authentication. Therefore, you pass the list: [ "jwt", "basic"].

The { session: false } option tells Passport.js not to maintain a session. This is done because JWT authentication is stateless.

Testing the Protected Route

You can test the protected route using Swagger UI. First, log in to obtain a valid access user token using the /api/v1/auth/token endpoint. Then click on the “Authorize” button in the Swagger UI, pass the access token into the input box under “bearer Auth”, and click the “Authorize” button. This ensures that subsequent requests made with Swagger UI will have the token passed in the request header.

Implementing JWT Authentication with Express, MongoDB, and Passport.js

Testing the /api/v1/auth/whoami endpoint should look like this:

Implementing JWT Authentication with Express, MongoDB, and Passport.js

Conclusion

In this tutorial, you implemented JWT authentication in an Express.js application using the Passport.js library, and MongoDB.

You started by exploring the workflow for JWT authentication. You proceeded to create the necessary schemas. Furthermore, you configured the Passport.js library for both JWT and basic authentication. You also created the controller logic for user registration, user authentication, token refresh, and protected route endpoints. You also tested the endpoints using the Swagger UI interactive interface.

This article should give you a solid foundation for securing APIs built in Express.js using JWT and Passport.js. For further improvements, you should consider sending tokens as HTTP-only cookies, email verification for users, and password reset endpoint.

References

  • Passport.js Documentation

  • MongoDB Documentation

  • Express.js Documentation

  • Mongoose Documentation

  • JWT docs

  • jsonwebtoken package

  • Bcrypt package

  • uuid package

版本聲明 本文轉載於:https://dev.to/michaelikoko/implementing-jwt-authentication-with-express-mongodb-and-passportjs-3fl7?1如有侵犯,請聯絡[email protected]刪除
最新教學 更多>
  • ✨ 從貢獻者到核心專案維護者:我的開源之旅 ✨
    ✨ 從貢獻者到核心專案維護者:我的開源之旅 ✨
    這一切都始於一個簡單的拉取請求...... 我記得當我第一次涉足開源世界。我最初的目標只是解決我欣賞的項目中的一個小問題。我幾乎不知道,這小小的貢獻將開始一段令人難以置信的旅程。 第 1 步:作為貢獻者開始 最初,我對貢獻感到緊張。我不確定我的程式碼是否足夠好或我的解決方案是否有效。但隨著時間的推...
    程式設計 發佈於2024-11-08
  • 程式設計基礎:C 簡介
    程式設計基礎:C 簡介
    C語言基礎:變數與類型: 定義變數以儲存數據,類型指定儲存的資料類型。輸入輸出: printf() 輸出到螢幕,scanf() 讀取使用者輸入。運算子: 使用算術和比較運算子進行運算和比較。控制流程: if-else 和 switch-case 用於選擇性執行程式碼,循環用於重複執行程式碼。函數: ...
    程式設計 發佈於2024-11-08
  • Mixin 如何在沒有傳統繼承的情況下增強類別功能?
    Mixin 如何在沒有傳統繼承的情況下增強類別功能?
    理解Mixins:類擴展的模組化方法mixin 是一種軟體設計模式,允許組合多個類,提供一種擴展基底類別功能而不直接繼承基底類別的方法。這種技術通常被稱為“抽象子類別”,因為它類似於繼承的概念,但具有更靈活和更精細的方法。 要了解 mixin 的工作原理,讓我們檢查以下範例:// Number cl...
    程式設計 發佈於2024-11-08
  • PHP 中可以像 JavaScript 一樣建立匿名物件嗎?
    PHP 中可以像 JavaScript 一樣建立匿名物件嗎?
    在 PHP 中建立匿名物件在 JavaScript 中,可以輕鬆建立匿名物件。然而,這種技術也可以應用在 PHP 上嗎? 術語解釋在討論對象時,術語「匿名」並不完全準確。相反,它應該被稱為“匿名類型的對象”。 PHP 物件創建在 PHP 中,所有物件都有一個指定的類別。預設類別是stdClass,該...
    程式設計 發佈於2024-11-08
  • 為什麼我的程式僅在 Windows Vista 的發布模式下崩潰?
    為什麼我的程式僅在 Windows Vista 的發布模式下崩潰?
    僅在發布版本中程序崩潰:深入研究調試晦澀之處遇到一個奇特的“薛定諤貓”錯誤可能會讓程式設計師感到困惑。在這種情況下,只有在發布模式下建置並從命令列啟動時,程式才會可靠地崩潰,並留下神秘的終止通知。 追蹤崩潰的根源透過細緻的調試,罪魁禍首方法已經被識別出來,但崩潰本身駐留在最後一個可見跟踪消息之後執行...
    程式設計 發佈於2024-11-08
  • Python 循環 2
    Python 循環 2
    大家好!这是 python 循环系列的第二部分。 第 1 部分在这里: https://dev.to/coderanger08/python-loops-1-5dho 本周,我们将更多地讨论 while 和 for 循环、break 和 pass 语句、范围函数等等。让我们开始吧。 ...
    程式設計 發佈於2024-11-08
  • 你能比較 C++ 中不同容器的迭代器嗎?
    你能比較 C++ 中不同容器的迭代器嗎?
    比較來自不同容器的迭代器:一個警示故事在C 中,迭代器提供了一個強大的遍歷集合的機制。然而,在使用來自不同容器的迭代器時,重要的是要意識到這些限制。 比較不同容器的迭代器是否合法的問題經常出現。考慮以下範例:std::vector<int> foo; std::vector<int...
    程式設計 發佈於2024-11-08
  • Spring Boot:Java 應用程式開發的革命
    Spring Boot:Java 應用程式開發的革命
    如果你用Java開發,你可能聽過Spring Boot。但如果您還不知道,請準備好發現最強大、最實用的工具之一,它徹底改變了 Java 應用程式的創建方式! 什麼是 Spring Boot? Spring Boot 是一個框架,它使 Java 應用程式的開發變得更加容易(而且更加容易!)。它消除...
    程式設計 發佈於2024-11-08
  • LESS CSS 偽元素選擇器中與號 (&) 的作用是什麼?
    LESS CSS 偽元素選擇器中與號 (&) 的作用是什麼?
    揭秘CSS 偽元素選擇器中的& 符號當在CSS 中遇到這樣的代碼時,很自然地想知道& 符號(&) 的意義) 字元:.clearfix { *zoom: 1; &amp;:before, &amp;:after { display: table; conte...
    程式設計 發佈於2024-11-08
  • 如何在沒有子查詢的情況下在 MySQL 中更新行並取得更新的 ID?
    如何在沒有子查詢的情況下在 MySQL 中更新行並取得更新的 ID?
    在 MySQL 中組合 SELECT 和 UPDATE 查詢將 SELECT 和 UPDATE 查詢組合成單一操作對於優化資料庫效能非常有用。在這種情況下,使用者希望組合以下查詢:SELECT * FROM table WHERE group_id = 1013 and time > 100;...
    程式設計 發佈於2024-11-08
  • 將 SQLite 遷移到 MySQL。
    將 SQLite 遷移到 MySQL。
    我介紹一下自己,我是 Alfredo Riveros,我已經學習程式設計多年了,我目前正在 Río Tercero 高等商業學院學習軟體開發高級技術員,下面我將描述我面臨的挑戰遭遇。 正如標題所說,我的目標是將 SQLite 資料庫遷移到 MySQL,這是由我正在接受的資料庫主題中的作業引起的。 ...
    程式設計 發佈於2024-11-08
  • 在 Mageia 9 上安裝 ASDF
    在 Mageia 9 上安裝 ASDF
    今天我們要在 Mageia 9 上安裝 ASDF。接下來的步驟是將外掛程式安裝到 PHP 和 Node.js。 要在版本 0.14.1 上安裝 ASDF,我使用了 Git ZSH 版本: git克隆 https://github.com/asdf-vm/asdf.git ~/.asdf --bra...
    程式設計 發佈於2024-11-08
  • 最佳化效能:為資料透視表選擇最佳資料來源
    最佳化效能:為資料透視表選擇最佳資料來源
    TL;DR: Syncfusion Pivot Table connects to multiple data sources, making it a versatile tool for data analysis. Selecting the right data source is cruc...
    程式設計 發佈於2024-11-08
  • 使用 Secrets Loader 輕鬆管理 Laravel 和 JS 項目
    使用 Secrets Loader 輕鬆管理 Laravel 和 JS 項目
    跨各种环境管理 API 密钥、令牌和凭证等敏感数据可能非常棘手,尤其是在开发和部署应用程序时。确保秘密在需要时安全地存储和获取,而不是将它们硬编码到版本控制中,对于维护安全性至关重要。 这就是为什么我创建了 Secrets Loader,这是一个 Bash 脚本,可以动态地将 AWS SSM 和 C...
    程式設計 發佈於2024-11-08
  • 如何在 Android 中正確實作 CheckBox 的偵聽器?
    如何在 Android 中正確實作 CheckBox 的偵聽器?
    Android 中的CheckBox 偵聽器Android 中的CheckBox 偵聽器在Android 中實作CheckBox 偵聽器時,必須解決使用標準時面臨的常見問題OnCheckedChangeListener類。 satView.setOnCheckedChangeListener(new...
    程式設計 發佈於2024-11-08

免責聲明: 提供的所有資源部分來自互聯網,如果有侵犯您的版權或其他權益,請說明詳細緣由並提供版權或權益證明然後發到郵箱:[email protected] 我們會在第一時間內為您處理。

Copyright© 2022 湘ICP备2022001581号-3