Introduction to Database management tools

To configure database connections for databases components

• On the surface, many people think that configuring database is to have a GUI to manage databases, but this is not the most important feature of IntelliJ idea. There are many GUI tools for databases, and IntelliJ idea's database has no obvious advantage. The biggest feature of IntelliJ idea's Database is that for Java Web projects, often used ORM frameworks, such as Hibernate, Mybatis, have good support, such as the configuration of database, IntelliJ idea will be self- To identify the relationship between the domain object and the data table, you can generate the domain object directly from the database data table, and so on.

• As shown in Gif, this is a complete configuration of the database process, and for the dependent packages required by the databases, IntelliJ idea can automatically help us to download, so we just need to configure the corresponding connection parameters.

Database settings

• As shown in the red circle labeled, this is the four commonly used Database operations.

• The first button is: Synchronizes the current database connection. This is the most important operation, in some cases, when we have configured the connection, the data table is not displayed, it is necessary to click the button to synchronize. Another thing is that we use other tools to manipulate databases, such as new tables, outside of IntelliJ idea. When the Database of IntelliJ idea is not synchronized to the new table, it needs to be synchronized by clicking this button.
• The second button is: Configure the current connection, the same interface that we set up the connection for the first time.
• The third button is: disconnects the current connection.
• The fourth button is to view the icon structure of the currently selected object, for example, we are currently selecting the entire database name, and if we click this button, we will display an icon map of all the data tables under that database.

Introduction to Database management tools