net.plsar.Dao Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of plsar-java Show documentation

PLSA.R is an Open Source Server + Framework Environment for small to large scale requirements. There are no static references, no file reads, access to static fields per request. Everything is either cached and or instantiated on the fly. PLSA.R runs via one command so there are no .war files to deploy, no additional plugins to install it is a simple yet powerful alternative to container deployment environments.

There is a newer version: 3.0.1

Show newest version

package net.plsar;

import javax.sql.DataSource;
import java.lang.reflect.Constructor;
import java.lang.reflect.Field;
import java.lang.reflect.Type;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Logger;

public class Dao {

    Logger Log = Logger.getLogger(Dao.class.getName());

    DataSource datasource;

    public Dao(PersistenceConfig config){
        this.datasource = new ExecutableDatasource.Builder()
                .driver(config.getDriver())
                .url(config.getUrl())
                .user(config.getUser())
                .password(config.getPassword())
                .connections(1)
                .create();
    }

    public Object get(String preSql, Object[] sqlparams, Class klass){
        Object result = null;
        String sql = "";
        try {
            sql = getPopulatedSqlStatement(preSql, sqlparams);
            Connection connection = datasource.getConnection();
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);

            if(resultSet.next()){
                result = getResult(resultSet, klass);
            }
            if(result == null){
                throw new Exception(klass + " not found using '" + sql + "'");
            }

            connection.commit();
            connection.close();

        } catch (SQLException ex) {
            Log.info("bad sql:" + sql);
        } catch (Exception ex) {
            Log.info(ex.getMessage());
        }

        return result;
    }

    public Integer getInt(String preSql, Object[] sqlparams){
        Integer result = null;
        String sql = "";
        try {
            sql = getPopulatedSqlStatement(preSql, sqlparams);
            Connection connection = datasource.getConnection();
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);

            if(resultSet.next()){
                result = Integer.parseInt(resultSet.getObject(1).toString());
            }

            if(result == null){
                throw new Exception("no results using '" + sql + "'");
            }

            connection.commit();
            connection.close();

        } catch (SQLException ex) {
            Log.info("bad sql:" + sql);
        } catch (Exception ex) {
            Log.info(ex.getMessage());
        }

        return result;
    }

    public Long getLong(String preSql, Object[] sqlparams){
        Long result = null;
        String sql = "";
        try {
            sql = getPopulatedSqlStatement(preSql, sqlparams);
            Connection connection = datasource.getConnection();
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);

            if(resultSet.next()){
                result = Long.parseLong(resultSet.getObject(1).toString());
            }

            if(result == null){
                throw new Exception("no results using '" + sql + "'");
            }

            connection.commit();
            connection.close();
        } catch (SQLException ex) {
            Log.info("bad sql:" + sql);
        } catch (Exception ex) {
            Log.info(ex.getMessage());
        }

        return result;
    }

    public boolean save(String preSql, Object[] sqlparams){
        try {
            String sql = getPopulatedSqlStatement(preSql, sqlparams);
            Connection connection = datasource.getConnection();
            Statement statement = connection.createStatement();
            statement.execute(sql);
            connection.commit();
            connection.close();
        }catch(Exception ex){
            Log.info(ex.getMessage());
            return false;
        }
        return true;
    }

    public List