Using prepared statements
PostgreSQL allows the server side to prepare statements. Its purpose is to reuse the parsing and planning of statements and reduce some overhead. Here is the sample code to use PreparedStatements
in Java:
import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.PreparedStatement; public class JavaPrepare { public static void main(String[] args) throws ClassNotFoundException, SQLException{ Class.forName("org.postgresql.Driver"); Connection con = DriverManager.getConnection ("jdbc:postgresql: //127.0.0.1:5432/postgres","postgres","postgres"); PreparedStatement stmt = con.prepareStatement("select * from demo_create"); ResultSet rs = stmt.executeQuery(); while (rs.next()) { System.out.println(rs.getString("id")); } } }
This is the...