Example usage for org.apache.commons.dbutils DbUtils closeQuietly

Introduction

In this page you can find the example usage for org.apache.commons.dbutils DbUtils closeQuietly.

Prototype

public static void closeQuietly(Statement stmt) 

Source Link

Document

Close a Statement, avoid closing if null and hide any SQLExceptions that occur.

Usage

From source file:com.mum.edu.cs472.DbConnection.java

public static String resultSetToJson(String word) {
    try {/*from www .  ja  v  a2s  .  c  om*/
        //            Thread.sleep(8000);
    } catch (Exception e) {
    }
    Connection connection = getConnection();
    List<Map<String, Object>> listOfMaps = null;
    String query = "SELECT * FROM entries where lower(word)=Lower(?);";
    try {
        QueryRunner queryRunner = new QueryRunner();

        listOfMaps = queryRunner.query(connection, query, word, new MapListHandler());
    } catch (SQLException se) {
        throw new RuntimeException("Couldn't query the database.", se);
    } finally {
        DbUtils.closeQuietly(connection);
    }
    return new Gson().toJson(listOfMaps);
}

---

From source file:jp.co.golorp.emarf.sql.Connections.java

/**
 * //from  ww w .  j a v a2  s .c o m
 */
public static void close() {
    Connection cn = threadLocalConnection.get();
    LOG.trace("close connection.");
    DbUtils.closeQuietly(cn);
    threadLocalConnection.remove();
}

---

From source file:com.intelligentz.appointmentz.controllers.Data.java

public static String getRooms(String hospital_id) {
    String rooms = "";
    try {//from   w  ww . ja  v a 2 s  . com

        connection = DBConnection.getDBConnection().getConnection();
        //String SQL = "select room_number,room_id from room where hospital_id = ?";
        String SQL = "select room_number,room_id from room where hospital_id = ?";
        preparedStatement = connection.prepareStatement(SQL);
        preparedStatement.setString(1, hospital_id);
        resultSet = preparedStatement.executeQuery();

        while (resultSet.next()) {
            String room_number = resultSet.getString("room_number");
            String room_id = resultSet.getString("room_id");
            //String room_id = resultSet.getString("room_id");
            rooms += "<option value=\"" + room_id + "\">" + room_number + "</option>";
        }

    } catch (SQLException | IOException | PropertyVetoException e) {
        //throw new IllegalStateException
        rooms = "Error";
    } finally {
        try {
            DbUtils.closeQuietly(resultSet);
            DbUtils.closeQuietly(preparedStatement);
            DbUtils.close(connection);
        } catch (SQLException ex) {
            Logger.getLogger(register.class.getName()).log(Level.SEVERE, ex.toString(), ex);
        }
    }
    return rooms;
}

---

From source file:com.sql.WebCase.java

public static List<WEBCaseModel> getWebCaseList() {
    List<WEBCaseModel> list = new ArrayList();
    Connection conn = null;/*from   ww  w. ja  v a 2 s .  c o m*/
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        conn = DBConnection.connectToDB();

        String sql = "SELECT" + " CMDSCase.CaseYear," + " CMDSCase.caseNumber," + " CMDSCase.casemonth,"
                + " CMDSCase.casetype," + " Users.initials AS ALJ," + " CMDSCase.groupNumber"
                + " FROM CMDSCase " + " LEFT JOIN Users ON" + " CMDSCase.aljID = Users.id"
                + " WHERE (CMDSCase.caseYear > YEAR(GETDATE()) - 5) "
                + " ORDER BY CMDSCase.caseyear, CMDSCase.caseNumber";
        ps = conn.prepareStatement(sql);
        rs = ps.executeQuery();
        while (rs.next()) {
            WEBCaseModel item = new WEBCaseModel();
            item.setYear(rs.getString("caseyear") == null ? "" : rs.getString("caseyear"));
            item.setCaseSeqNumber(rs.getString("caseNumber") == null ? "" : rs.getString("caseNumber"));
            item.setMonth(rs.getString("casemonth") == null ? "" : rs.getString("casemonth"));
            item.setType(rs.getString("casetype") == null ? "" : rs.getString("casetype"));
            item.setALJ(rs.getString("ALJ") == null ? "" : rs.getString("ALJ"));
            item.setGroupNumber(rs.getString("groupNumber") == null ? "" : rs.getString("groupNumber"));
            list.add(item);
        }
    } catch (SQLException ex) {
        Logger.getLogger(WebCase.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        DbUtils.closeQuietly(conn);
        DbUtils.closeQuietly(ps);
        DbUtils.closeQuietly(rs);
    }
    return list;
}

---

From source file:ca.qc.adinfo.rouge.achievement.db.AchievementDb.java

public static HashMap<String, Achievement> getAchievementList(DBManager dbManager) {

    Connection connection = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;/*from w  w w .  j  av a  2  s.co m*/
    HashMap<String, Achievement> returnValue = new HashMap<String, Achievement>();

    String sql = "SELECT `key`, `name`, `point_value`, `total` FROM rouge_achievements";
    try {
        connection = dbManager.getConnection();
        stmt = connection.prepareStatement(sql);

        rs = stmt.executeQuery();

        while (rs.next()) {

            String key = rs.getString("key");

            Achievement achievement = new Achievement(key, rs.getString("name"), rs.getInt("point_value"),
                    rs.getDouble("total"), 0);

            returnValue.put(key, achievement);
        }

        return returnValue;

    } catch (SQLException e) {
        log.error(stmt);
        log.error(e);
        return null;

    } finally {

        DbUtils.closeQuietly(rs);
        DbUtils.closeQuietly(stmt);
        DbUtils.closeQuietly(connection);
    }
}

---

From source file:ca.qc.adinfo.rouge.mail.db.MailDb.java

public static boolean sendMail(DBManager dbManager, long fromId, long toId, RougeObject content) {

    Connection connection = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;//from   ww w.ja  v  a  2 s  .  co  m
    String sql = null;

    sql = "INSERT INTO rouge_mail (`from`, `to`, `content`, `status`, `time_sent`) " + "VALUES (?, ?, ?, ?, ?)";

    try {
        connection = dbManager.getConnection();
        stmt = connection.prepareStatement(sql);

        stmt.setLong(1, fromId);
        stmt.setLong(2, toId);
        stmt.setString(3, content.toJSON().toString());
        stmt.setString(4, "unr");
        stmt.setTimestamp(5, new Timestamp(System.currentTimeMillis()));

        int ret = stmt.executeUpdate();

        return (ret > 0);

    } catch (SQLException e) {
        log.error(stmt);
        log.error(e);
        return false;

    } finally {

        DbUtils.closeQuietly(rs);
        DbUtils.closeQuietly(stmt);
        DbUtils.closeQuietly(connection);
    }
}

---

From source file:com.sql.RelatedCase.java

public static List<RelatedCaseModel> getRelatedCases(EmailOutModel eml) {
    List<RelatedCaseModel> list = new ArrayList();
    Connection conn = null;//from   www.j a  v a  2 s.c  o m
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        int i = 0;
        conn = DBConnection.connectToDB();
        String sql = "SELECT * FROM RelatedCase WHERE LEN(relatedCaseNumber) = 16 " + " AND CaseYear = ? "
                + " AND CaseType = ? " + " AND CaseMonth = ? " + " AND CaseNumber = ? ";

        ps = conn.prepareStatement(sql);
        ps.setString(1, eml.getCaseYear());
        ps.setString(2, eml.getCaseType());
        ps.setString(3, eml.getCaseMonth());
        ps.setString(4, eml.getCaseNumber());

        rs = ps.executeQuery();
        while (rs.next()) {
            String[] relatedCase = rs.getString("relatedCaseNumber").split("-");

            if (relatedCase.length == 4) {
                RelatedCaseModel item = new RelatedCaseModel();
                item.setCaseYear(rs.getString("caseYear"));
                item.setCaseType(rs.getString("caseType"));
                item.setCaseMonth(rs.getString("caseMonth"));
                item.setCaseNumber(rs.getString("caseNumber"));
                item.setRelatedCaseYear(relatedCase[0]);
                item.setRelatedCaseType(relatedCase[1]);
                item.setRelatedCaseMonth(relatedCase[2]);
                item.setRelatedCaseNumber(relatedCase[3]);
                list.add(item);
            }
        }
    } catch (SQLException ex) {
        ExceptionHandler.Handle(ex);
    } finally {
        DbUtils.closeQuietly(conn);
        DbUtils.closeQuietly(ps);
        DbUtils.closeQuietly(rs);
    }
    return list;
}

---

From source file:com.mirth.connect.donkey.server.data.jdbc.SqlServerDaoFactory.java

@Override
public JdbcDao getDao(SerializerProvider serializerProvider) {
    JdbcDao dao = super.getDao(serializerProvider);

    if (deadlockPriority != null) {
        Statement statement = null;

        try {/*from  w  w  w .j  a va2 s. c  om*/
            statement = dao.getConnection().createStatement();
            statement.executeUpdate("SET DEADLOCK_PRIORITY " + deadlockPriority);
        } catch (SQLException e) {
            throw new DonkeyDaoException(e);
        } finally {
            DbUtils.closeQuietly(statement);
        }
    }

    return dao;
}

---

From source file:com.sql.SystemEmail.java

/**
 * Gathers active email accounts for sending or receiving. 
 * /*from   w ww  .  jav a  2 s  .  c  o m*/
 * @return
 */
public static boolean loadEmailConnectionInformation() {
    List<SystemEmailModel> systemEmailList = new ArrayList();
    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        conn = DBConnection.connectToDB();
        String sql = "SELECT * FROM SystemEmail WHERE active = 1";
        ps = conn.prepareStatement(sql);
        rs = ps.executeQuery();
        while (rs.next()) {
            SystemEmailModel row = new SystemEmailModel();
            row.setId(rs.getInt("id"));
            row.setActive(rs.getInt("active"));
            row.setSection(rs.getString("section"));
            row.setEmailAddress(rs.getString("emailAddress"));
            row.setUsername(rs.getString("username"));
            row.setPassword(rs.getString("password"));
            row.setIncomingURL(rs.getString("incomingURL"));
            row.setIncomingPort(rs.getInt("incomingPort"));
            row.setIncomingProtocol(rs.getString("incomingProtocol"));
            row.setIncomingFolder(rs.getString("incomingFolder"));
            row.setOutgoingURL(rs.getString("outgoingURL"));
            row.setOutgoingPort(rs.getInt("outgoingPort"));
            row.setOutgoingProtocol(rs.getString("outgoingProtocol"));
            row.setOutgoingFolder(rs.getString("outgoingFolder"));
            systemEmailList.add(row);
        }
        Global.setSystemEmailParams(systemEmailList);
    } catch (SQLException ex) {
        ExceptionHandler.Handle(ex);
        return false;
    } finally {
        DbUtils.closeQuietly(conn);
        DbUtils.closeQuietly(ps);
        DbUtils.closeQuietly(rs);
    }
    return true;
}

---

From source file:com.sql.DocketNotification.java

/**
 * Delete item from docket notification based off of ID
 * /*from  w  w  w  .  j  a  v a  2s  . com*/
 * @param id Integer
 */
public static void deleteEmailEntry(int id) {
    Connection conn = null;
    PreparedStatement ps = null;
    try {
        conn = DBConnection.connectToDB();
        String sql = "DELETE FROM DocketNotifications WHERE id = ?";
        ps = conn.prepareStatement(sql);
        ps.setInt(1, id);
        ps.executeUpdate();
    } catch (SQLException ex) {
        ExceptionHandler.Handle(ex);
    } finally {
        DbUtils.closeQuietly(conn);
        DbUtils.closeQuietly(ps);
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• »