DB Class Reference

Collaboration diagram for DB:

[legend]

List of all members.

Public Member Functions
void	connect ()
void	execute (String sql) throws SQLException
ResultSet	getResult (String sql) throws SQLException
void	execute (String sql, String[] params) throws SQLException
Static Public Member Functions
static DB	getInstance ()
Static Public Attributes
static Connection	conn = null

---

Member Function Documentation

void DB::connect

(

)

[inline]

                               {
                
                try {
                        // The newInstance() call is a work around for some
                        // broken Java implementations
                        Class.forName("com.mysql.jdbc.Driver").newInstance();
                } catch (Exception ex) {
                        System.out.println("JDBC Not loaded! " + ex);
                        System.exit(-1);
                }

                try {
                    conn = DriverManager.getConnection("jdbc:mysql://localhost/proxy?" + 
                                       "user=work&password=w0rk1nG");
                } catch (SQLException ex) {
                        // handle any errors
                        System.out.println("SQLException: " + ex.getMessage());
                        System.out.println("SQLState: " + ex.getSQLState());
                        System.out.println("VendorError: " + ex.getErrorCode());
                        System.exit(-1);
                }
        }

void DB::execute	(	String	sql,
		String[]	params
	)			throws SQLException [inline]

                                                                            {
                if (!checkConnection()){
                        connect();
                }
                try{
                        PreparedStatement prepStmt = conn.prepareStatement(sql);
                        for (int i = 0; i < params.length; i++){
                                prepStmt.setString(i+1, params[i]);
                        }
                        prepStmt.executeUpdate();
                        prepStmt.close();
                }catch (SQLException e){
                        System.out.println("Execute failed with " + e);
                }
        }

Here is the call graph for this function:

void DB::execute

(

String

sql

)

throws SQLException [inline]

                                                            {
                if (!checkConnection()){
                        connect();
                }
                Statement stmt = null;

                try {
                        stmt = conn.createStatement();
                        if (stmt.execute(sql)) {
                                stmt = null;
                        }
                } catch (SQLException e) {
                        stmt = null;
                        System.out.println(e);
                }       
        }

Here is the call graph for this function:

static DB DB::getInstance

(

)

[inline, static]

                                      {
                if (_theInstance == null) {
                        throw new RuntimeException("No singleton instance available");
                } else {
                        return _theInstance;
                }
        }

ResultSet DB::getResult

(

String

sql

)

throws SQLException [inline]

                                                                  {
                if (!checkConnection()){
                        connect();
                }
                Statement stmt = null;

                try {
                        stmt = conn.createStatement();
                        if (stmt.execute(sql)) {
                                ResultSet rs = stmt.getResultSet();
                                stmt = null;
                                return rs;
                        }
                } catch (SQLException e) {
                        stmt = null;
                        System.out.println("Can't get resultSet " + e);
                }
                return null;
        }

Here is the call graph for this function:

---

Member Data Documentation

Connection DB::conn = null [static]

---

The documentation for this class was generated from the following file:

• DB.java