import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class KineticaJdbcExample { private static final String DATABASE_URL = "jdbc:kinetica://localhost:9191/kinetica_db"; private static final String USERNAME = "your_username"; private static final String PASSWORD = "your_password"; public static void main(String[] args) { try { Connection connection = DriverManager.getConnection(DATABASE_URL, USERNAME, PASSWORD); insertData(connection, "John Doe", 25, "USA"); updateData(connection, "John Doe", 26); connection.close(); } catch (SQLException e) { e.printStackTrace(); } } private static void insertData(Connection connection, String name, int age, String country) throws SQLException { String sql = "INSERT INTO table_name (name, age, country) VALUES (?, ?, ?)"; PreparedStatement preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, name); preparedStatement.setInt(2, age); preparedStatement.setString(3, country); preparedStatement.executeUpdate(); preparedStatement.close(); } private static void updateData(Connection connection, String name, int newAge) throws SQLException { String sql = "UPDATE table_name SET age = ? WHERE name = ?"; PreparedStatement preparedStatement = connection.prepareStatement(sql); preparedStatement.setInt(1, newAge); preparedStatement.setString(2, name); preparedStatement.executeUpdate(); preparedStatement.close(); } }


上一篇:
下一篇:
切换中文