How to use MySQL to implement data insertion function in Java

How to use MySQL to implement data insertion function in Java

Java is a widely used programming language, and MySQL is a popular relational database management system. In Java, we can use MySQL to store and manage data. This article will introduce how to use MySQL to implement data insertion function in Java and provide corresponding code examples.

First, we need to connect to the MySQL database in Java. We can use JDBC (Java Database Connectivity) to achieve this. The following is a basic code example to connect to the MySQL database:

import java.sql.Connection;
import java.sql.DriverManager;

public class MySQLConnection {
    private static final String URL = "jdbc:mysql://localhost:3306/database_name";
    private static final String USERNAME = "username";
    private static final String PASSWORD = "password";

    public static void main(String[] args) {
        try {
            Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
            System.out.println("连接成功！");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

In the above code, URL is the URL address of the MySQL database connection, USERNAME and PASSWORD is the user name and password to log in to the database. Please replace database_name with the actual database name you want to connect to.

Next, we can use MySQL’s INSERT INTO statement to insert data into the database. The following is a sample code that demonstrates how to insert data into MySQL:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class MySQLInsert {
    private static final String URL = "jdbc:mysql://localhost:3306/database_name";
    private static final String USERNAME = "username";
    private static final String PASSWORD = "password";

    public static void main(String[] args) {
        try {
            Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
            System.out.println("连接成功！");

            String sql = "INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1, "value1");
            preparedStatement.setString(2, "value2");
            preparedStatement.setInt(3, 123);

            int rowsAffected = preparedStatement.executeUpdate();
            System.out.println(rowsAffected + " 行已插入！");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

In the above code, table_name is the name of the table where data is to be inserted, column1, column2 and column3 are the column names in the table. ? is a placeholder. We can use methods such as setString and setInt to set specific values ​​for the placeholder.

Finally, we execute the INSERT INTO statement by calling the executeUpdate method and get the number of affected rows.

It is worth noting that in actual applications, we need to write corresponding insertion code according to specific business requirements and table structure. In addition, in order to ensure data security, we also need to pay attention to preventing SQL injection and other security issues.

Through the introduction of this article, we have learned how to use MySQL to implement the data insertion function in Java, and provided corresponding code examples. Hope these contents are helpful to you!

The above is the detailed content of How to use MySQL to implement data insertion function in Java. For more information, please follow other related articles on the PHP Chinese website!