a simple example for jdbc PreparedStatement

a simple example for PreparedStatement

package basics.in.java.blogspot.in;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
 
 private static final String USERNAME="root";
 private static final String PASSWORD="";
 private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot";
 

 public static void main(String[] args) throws ClassNotFoundException, SQLException {
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn=null;
  Statement stmt=null;
  ResultSet rs=null;
  
  
  try {
   conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);
            System.out.println("database connection successful"); 
            //stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            String sql="select * from tours where tourId=?";
            PreparedStatement stmtp=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            //rs=stmt.executeQuery("select * from tours");     
            stmtp.setInt(1,1);
            rs=stmtp.executeQuery();
            
            display(rs);
            
  } catch (SQLException e) {
   System.err.println(e);
   System.err.println("Error message:"+e.getMessage());
   System.err.println("Error code is:"+e.getErrorCode());
   System.err.println("sql state:"+e.getSQLState());
   
  }
  
  finally{
   if(rs!=null){
    rs.close();
   }
   if(stmt!=null){
    stmt.close();
   }
   if(conn!=null){
    conn.close();
   }
  }
  

 }
 public static void display(ResultSet rs) throws SQLException{
  while(rs.next()){
   StringBuffer sBuffer=new StringBuffer();
   sBuffer.append("Tour id: "+rs.getInt("tourId"));
   System.out.println(sBuffer);
  }
 }
 

}