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...