title: null pointer exception on dao layer
body: <p>I have developed the below program but it is throwing null pointer exception. </p>
  
  <p>Below is the model class..</p>
  
  <pre><code>public class Circle {
  
      private int Id;
      public Circle(int id, String name) {
          super();
          Id = id;
          this.name = name;
      }
      private String name;
      public int getId() {
          return Id;
      }
      public void setId(int id) {
          Id = id;
      }
      public String getName() {
          return name;
      }
      public void setName(String name) {
          this.name = name;
      }
  
  }
  </code></pre>
  
  <p>Below is the dao class..</p>
  
  <pre><code>public class jdbcdaoimpl {
      public Circle getCircle(int circleId) 
          {   
          Circle circle = null;
  
          try
          {
          Class.forName("oracle.jdbc.driver.OracleDriver");
          Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","saral","saral");
          PreparedStatement stmt=con.prepareStatement("select * from CIRCLE where id = ?");
          stmt.setInt(1,circleId);
          ResultSet rset=stmt.executeQuery();
          while(rset.next())
          {
               circle= new Circle(circleId, rset.getString("name") );
          }       
          rset.close();
          stmt.close();
          con.close();
          }                   
          catch (Exception e)
          {
              e.printStackTrace();            
          }
          return circle;
      }
  }
  </code></pre>
  
  <p>and finally the main class..</p>
  
  <pre><code>public class jdbcDemo {
  
      public static void main(String[] args) {
          Circle c = new jdbcdaoimpl().getCircle(1);
          System.out.println(c.getName());
      }
  
  }
  </code></pre>
  
  <p>please advise as on execution of main class it is throwing the null pointer exception.</p>