How to use min() function of postgresql using java code?
1 answer
by
lily ,
2 months ago
@kadin
To use the min() function of PostgreSQL in Java code, you can execute a SQL query using a PreparedStatement object and retrieve the result using a ResultSet.
Here is an example code snippet showing how to use the min() function in PostgreSQL:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class MinFunctionExample {
public static void main(String[] args) {
String url = "jdbc:postgresql://localhost:5432/db_name";
String user = "username";
String password = "password";
try (Connection conn = DriverManager.getConnection(url, user, password)) {
String sql = "SELECT MIN(column_name) FROM table_name";
try (PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery()) {
if (rs.next()) {
int minValue = rs.getInt(1);
System.out.println("Minimum value: " + minValue);
}
}
} catch (SQLException e) {
System.out.println("SQL exception: " + e.getMessage());
}
}
}
|
Replace db_name, username, password, column_name, and table_name with your actual database name, username, password, column name, and table name respectively.
This code snippet connects to a PostgreSQL database, executes a SQL query to find the minimum value of a specific column in a table, and then prints the result.