Service Scenario Description

Scenario

Doris can use SQL statements to perform common service operations. The SQL operations involved in the code example include creating a database, creating a table, inserting table data, querying table data, and deleting a table.

The code sample operation process is as follows:

1. Connect to Doris using JDBC.
2. Create a database.
3. Create a table in the database.
4. Inserts data into a table.
5. Query table data.
6. Delete the table.

Function Decomposition

Doris is compatible with the MySQL protocol. Common operations can be performed by using the SQL language.

The development process consists of the following parts:

• Establish a connection: Establish a connection to the Doris service instance.
• Create Library: Create a Doris database.
• Create Table: Create a table in the Doris database.
• Insert Data: Insert data into the Doris table.
• Querying data: Query the Doris table data.
• Deleting a table: You can delete a created Doris table.