Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DataSource ds = DBCPDataSourceFactory.getDataSource(model);
- Connection connection = null;
- Statement statement = null;
- ResultSet resultSet = null;
- connection = ds.getConnection();
- statement = connection.createStatement();
- resultSet = statement.executeQuery(model.getQuery());
- public class DBCPDataSourceFactory {
- public static DataSource getDataSource(DBModel model) {
- String url = null;
- BasicDataSource ds = new BasicDataSource();
- if (model.getRdbms().toLowerCase().equals(DBConstants.POSTGRESQL)) {
- ds.setDriverClassName(DBConstants.POSTGRESQL_DRIVER);
- url = "jdbc:postgresql://" + model.getHost() + "/" + model.getDatabase();
- ds.setUrl(url);
- } else if (model.getRdbms().toLowerCase().equals(DBConstants.ORACLE)) {
- ds.setDriverClassName(DBConstants.ORACLE_DRIVER);
- url = "jdbc:oracle:thin:@"+model.getHost()+":"+model.getPort()+":"+model.getDatabase();
- ds.setUrl(url);
- } else if (model.getRdbms().toLowerCase().equals(DBConstants.SQL_SERVER)) {
- ds.setDriverClassName(DBConstants.SQL_SERVER_DRIVER);
- url = "jdbc:sqlserver://"+model.getHost()+":"+model.getPort()+";databaseName="+model.getDatabase();
- ds.setUrl(url);
- }
- ds.setUsername(model.getUsername());
- ds.setPassword(model.getPassword());
- return ds;
- }}
Add Comment
Please, Sign In to add comment