Questino with classes

[mikedaruke]

I am new to Java. So bare with me. I come from a Perl background.

Java is made up of classes, each having their own methods right?

I am creating an application. Pretty much to learn.

It connects to a database. Well should I make a seperate class that makes the connection? This way I would call it when I need the connection. How would I do that and pass back the connection to the main part of the program? I guess I need to hit the books since I am sure its all basic knowlege that I lack.

Any examples that I can play with to learn would be helpful.

 

[sedj]

I would do it like this :

public class DbHelper {
  // a static method so you need not instantiate the class
  public static Connection getConnection() {
     // get the connection and return it
  }
}

Then in your client code :

Connection conn = DbHelper.getConnection();

// .. do stuff

conn.close();

Check out the JDBC tutorial here :

http://java.sun.com/docs/books/tutorial/jdbc/

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[mikedaruke]

Thanks Sedj

I really appreciate it.