How to perform database integration for Java function development

How to carry out database integration for Java function development

The database is an important part of application development and can easily store and manage data. In Java development, data persistence is usually implemented through a database. This article will introduce how to use Java for database integration, including connecting to the database, executing SQL statements, and processing data addition, deletion, modification, and query operations.

1. Connecting to the database
   First, you need to import the database driver provided by Java. Generally speaking, database drivers provide a DriverManager class for connecting to the database.

import java.sql.*;

public class DBConnector {
    private static final String url = "jdbc:mysql://localhost:3306/test";
    private static final String username = "root";
    private static final String password = "123456";
    
    public static Connection getConnection() throws SQLException {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        
        return DriverManager.getConnection(url, username, password);
    }
    
    public static void main(String[] args) {
        try {
            Connection conn = getConnection();
            System.out.println("Successful connection to the database!");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

In the above code, we used the MySQL database driver com.mysql.jdbc.Driver and specified the connection URL, user name and password. The getConnection() method returns a Connection object representing the connection to the database.

2. Execute SQL statements
   After connecting to the database, we can execute SQL statements through the Statement object. The Statement interface provides a variety of methods, including executeQuery() for executing query statements and executeUpdate() for executing non-query statements.

import java.sql.*;

public class DBConnector {
    // ...
    
    public static void main(String[] args) {
        try {
            Connection conn = getConnection();
            Statement stmt = conn.createStatement();
            String sql = "SELECT * FROM users";
            ResultSet rs = stmt.executeQuery(sql);
            
            while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");
                String email = rs.getString("email");
                System.out.println("ID: " + id + ", Name: " + name + ", Email: " + email);
            }
            
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

In the above code, we created a Statement object, then executed a query statement SELECT * FROM users, and obtained the query results through the ResultSet object. Next, we traverse the ResultSet object and obtain the data for each row.

3. Data operations
   In addition to query statements, we can also perform data addition, deletion and modification operations. The PreparedStatement interface provides the ability to precompile SQL statements to prevent SQL injection attacks. Below is an example of inserting data.

import java.sql.*;

public class DBConnector {
    // ...
    
    public static void main(String[] args) {
        try {
            Connection conn = getConnection();
            String sql = "INSERT INTO users (name, email) VALUES (?, ?)";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            
            pstmt.setString(1, "John");
            pstmt.setString(2, "john@example.com");
            pstmt.executeUpdate();
            
            System.out.println("Data inserted successfully!");
            
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

In the above code, we use the PreparedStatement object, set the parameter value in the SQL statement through the setString() method, and then execute the executeUpdate() method to insert data.

4. Conclusion
   This article introduces how to perform database integration for Java function development. We learned the basic steps of connecting to the database, executing SQL statements, and processing data addition, deletion, modification, and query operations, and demonstrated the specific implementation through code examples. I hope this article can help readers better learn and master Java's database integration technology.

The above is the detailed content of How to perform database integration for Java function development. For more information, please follow other related articles on the PHP Chinese website!