KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > phonebill > PhoneDatabase


1 package phonebill;
2
3 import java.sql.*;
4 import java.util.*;
5
6 /**
7  * A simple Bean encapsulating a database connection. In
8  * a live environment should be replaced with a connection
9  * pooling equivalent.
10  */
11 public class PhoneDatabase
12 {
13     private static final String JavaDoc url = "jdbc:mysql://localhost/test?user=testuser&password=secret";
14
15     public PhoneDatabase()
16     {
17     try {
18         Class.forName("org.gjt.mm.mysql.Driver").newInstance();
19
20         DriverManager.getConnection(url).close();
21     }
22     catch (Exception JavaDoc e) {
23         e.printStackTrace();
24     }
25     }
26
27     public Connection getConnection()
28         throws SQLException
29     {
30     return DriverManager.getConnection(url);
31     }
32 }
33
Popular Tags