Re: Database helper class with PreparedStatements

teser3@hotmail.com wrote:


*snip*

I started replying to this post, but I gave it up. I don't quite get
what you want answered here. I'll give you some tips on how to organize
things.

Make a class that takes care of the database connection:

public class DatabaseConnector {

    private Connection con;

    public DatabaseConnector(user, pass, ...) {
       con = ...;
    }

    public Connection getConnection() {
       return con;
    }

    public void close() {
       con.close();
    }

    //...

}

And a database handler class:

public class DatabaseHandler {

    private DatabaseConnector dbCon;
    private Connection con;
    private PreparedStatement stmt1 = new PreparedStatement("...");

    public DatabaseHandler(user, pass, ...) {
       dbCon = new DatabaseConnector(user, pass, ...);
       con = dbCon.getConnection();
    }

    public void insertSomeObject(SomeObject obj) {
       stmt.setXxx(...);
       //...

       stmt.executeXxx();
    }

    /...

    public void closeConnection() {
       dbCon.close();
    }

}

Remember that the point of PreparedStatements is a way to declare
statements that are frequently used. To declare such a statement for
every method call removes the point entirely.

About closing connections, simply close them when you won't be using it
for a while. I don't think open connections would make any problem
unless the database is accessed by a lot of clients simultaneously.