Java连接PI数据库实例

Java与PI数据库连接是一项关键的任务，通过此连接，您可以实现对PI数据库的查询和修改。PI数据库是一个高性能的时间序列数据库，广泛应用于工业控制和数据分析领域。下面是一个简单的Java连接PI数据库的示例代码，供您参考：

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

public class PIDatabaseConnection {
    public static void main(String[] args) {
        String url = "jdbc:pioledb://your_PI_server/DataArchive"
        String user = "your_username";
        String password = "your_password";

        try {
            // Establishing connection
            Connection connection = DriverManager.getConnection(url, user, password);

            // Performing a simple query
            String query = "SELECT * FROM your_table";
            PreparedStatement preparedStatement = connection.prepareStatement(query);
            ResultSet resultSet = preparedStatement.executeQuery();

            // Modifying data example
            String updateQuery = "UPDATE your_table SET column_name = ? WHERE condition";
            PreparedStatement updateStatement = connection.prepareStatement(updateQuery);
            updateStatement.setString(1, "new_value");
            updateStatement.executeUpdate();

            // Closing resources
            resultSet.close();
            preparedStatement.close();
            updateStatement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}