| |
BaseService.java
package myapp.server.common;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import myapp.client.common.ApplicationException;
import com.google.gwt.user.server.rpc.RemoteServiceServlet;
public class BaseService extends RemoteServiceServlet
{
Connection connection=null;
public Connection getConnection()
throws SQLException, ApplicationException
{
if (connection==null)
{
String database = "jdbc:oracle:thin:@localhost:1521:YOURDB";
String username = "todo";
String password = "todo";
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Connect to the database
connection =
DriverManager.getConnection ( database, username, password );
if (connection==null) throw new ApplicationException("Could not acquire connection!");
}
return connection;
}
public void returnConnection( Connection c )
throws SQLException
{
// thanks for returning, but I won't do anything with it now
}
public void dropConnection( Connection c )
throws SQLException
{
// note: ignoring the 'c' argument!
if (connection!=null);
{
connection.close();;
connection=null;
}
}
}
|