import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class HerdDBConnectionExample {
public static void main(String[] args) {
try {
Class.forName("org.postgresql.Driver");
String url = "jdbc:herddb:localhost:7000/mydatabase";
Connection connection = DriverManager.getConnection(url, "username", "password");
// ...
connection.close();
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class HerdDBQueryExample {
public static void main(String[] args) {
try {
// ...
Statement statement = connection.createStatement();
String sql = "SELECT * FROM mytable";
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
String column1 = resultSet.getString("column1");
int column2 = resultSet.getInt("column2");
// ...
}
resultSet.close();
statement.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class HerdDBConnectionPropertiesExample {
public static void main(String[] args) {
try {
Class.forName("org.postgresql.Driver");
Properties properties = new Properties();
properties.setProperty("user", "username");
properties.setProperty("password", "password");
properties.setProperty("ssl", "true");
properties.setProperty("tcpKeepAlive", "true");
String url = "jdbc:herddb:localhost:7000/mydatabase";
Connection connection = DriverManager.getConnection(url, properties);
// ...
connection.close();
e.printStackTrace();
}
}
}
try {
// ...
// ...
// ...
} catch (SQLException e) {
e.printStackTrace();
}
