Re: Database helper class with PreparedStatements

Thanks for your quick response.

Would this be better where I put the Connection and PreparedStatement
instances in the method??

 public class DbWork
 {
      public void cityInserter(FormBean city) throws SQLException
      {
         Connection connection = ConnectionMgr().getConnection();
         PreparedStatement stat = connection.prepareStatement("Insert
into City (street, school) values (?,?)");
         stat.setString(1, city.getStreet());
         stat.setString(2, city.getSchool());
         stat.executeUpdate();
     }

    public void dbMethod(FormBean city)
    {
         try
        {
                cityInserter(city);
        }
        catch(SQLException ex)
        {
               System.out.println(ex);
        }
       finally
        {
              connection.close();
//not sure if I corrected this issue here or not??


        }
    }