Example usage for java.sql Types BIGINT

List of usage examples for java.sql Types BIGINT

Introduction

In this page you can find the example usage for java.sql Types BIGINT.

Prototype

int BIGINT

To view the source code for java.sql Types BIGINT.

Click Source Link

Document

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.

Usage

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnSubjectTable.java

public void deleteEnSubjectByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnSubjectByScopeIdx";
    ResultSet resultSet = null;/* w  w  w.java2 s .c  o m*/
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_ensubj_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnSentenceTable.java

public void deleteEnSentenceByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnSentenceByScopeIdx";
    ResultSet resultSet = null;/*  w  ww. j  av  a  2  s .c o m*/
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_ensent_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnModifierTable.java

public void deleteEnModifierByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnModifierByScopeIdx";
    ResultSet resultSet = null;/* ww  w  .j a  va  2 s.  c o m*/
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_enmodif_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnMorphemeTable.java

public void deleteEnMorphemeByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnMorphemeByScopeIdx";
    ResultSet resultSet = null;// www .  jav a 2  s  . c  o  m
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_enmorph_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:fr.aliacom.obm.common.contact.ContactDaoJdbcImpl.java

private int insertIntoContact(Connection con, AccessToken at, Contact c, int addressBookId)
        throws SQLException {
    PreparedStatement ps = null;/* w  w w .java  2  s . c  o m*/
    try {

        ps = con.prepareStatement("INSERT INTO Contact "
                + " (contact_commonname, contact_firstname, contact_lastname, contact_origin, contact_domain_id, contact_usercreate, "
                + "contact_company, contact_aka, contact_service, contact_title, contact_birthday_id, contact_anniversary_id, "
                + "contact_timecreate, "
                + "contact_suffix, contact_middlename, contact_manager, contact_spouse, contact_assistant, "
                + "contact_collected, contact_addressbook_id) "
                + " VALUES (?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, now(), ?, ?, ?, ?, ?, ?, ?) ");
        int idx = 1;
        ps.setString(idx++, c.getCommonname());
        ps.setString(idx++, c.getFirstname());
        ps.setString(idx++, c.getLastname());
        ps.setString(idx++, at.getOrigin());
        ps.setInt(idx++, at.getDomain().getId());
        ps.setInt(idx++, at.getObmId());

        ps.setString(idx++, c.getCompany());
        ps.setString(idx++, c.getAka());
        ps.setString(idx++, c.getService());
        ps.setString(idx++, c.getTitle());
        if (c.getBirthdayId() != null) {
            ps.setInt(idx++, c.getBirthdayId().getObmId());
        } else {
            ps.setNull(idx++, Types.BIGINT);
        }
        if (c.getAnniversaryId() != null) {
            ps.setInt(idx++, c.getAnniversaryId().getObmId());
        } else {
            ps.setNull(idx++, Types.BIGINT);
        }

        ps.setString(idx++, c.getSuffix());
        ps.setString(idx++, c.getMiddlename());
        ps.setString(idx++, c.getManager());
        ps.setString(idx++, c.getSpouse());
        ps.setString(idx++, c.getAssistant());

        ps.setBoolean(idx++, c.isCollected());
        ps.setInt(idx++, addressBookId);

        ps.executeUpdate();

        int contactId = obmHelper.lastInsertId(con);

        return contactId;

    } finally {
        obmHelper.cleanup(null, ps, null);
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnAuxiliaryTable.java

public void deleteEnAuxiliaryByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnAuxiliaryByScopeIdx";
    ResultSet resultSet = null;/*from  w  w w.  ja v a 2  s.c o m*/
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_enaux_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnDiscourseTable.java

public void deleteEnDiscourseByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnDiscourseByScopeIdx";
    ResultSet resultSet = null;//from w  ww . j  a  v  a2  s  .  c o m
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_endisc_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnAdjectiveTable.java

public void deleteEnAdjectiveByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnAdjectiveByScopeIdx";
    ResultSet resultSet = null;/*from w ww. j  av  a2  s  . c  om*/
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_enadjec_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnAdverbialTable.java

public void deleteEnAdverbialByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnAdverbialByScopeIdx";
    ResultSet resultSet = null;/*  w w w .  j  a  v  a 2 s  . c o  m*/
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_enadvbl_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}

From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxMySql.CFEnSyntaxMySqlEnConnectiveTable.java

public void deleteEnConnectiveByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) {
    final String S_ProcName = "deleteEnConnectiveByScopeIdx";
    ResultSet resultSet = null;//  w  w w  .  java 2 s  .c  om
    try {
        Connection cnx = schema.getCnx();
        String sql = "call " + schema.getLowerDbSchemaName() + ".sp_delete_enconn_by_scopeidx( ?, ?, ?, ?, ?"
                + ", " + "?" + " )";
        if (stmtDeleteByScopeIdx == null) {
            stmtDeleteByScopeIdx = cnx.prepareStatement(sql);
        }
        int argIdx = 1;
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecUserId().toString());
        stmtDeleteByScopeIdx.setString(argIdx++,
                (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
        stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
        if (argScopeId != null) {
            stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue());
        } else {
            stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT);
        }
        stmtDeleteByScopeIdx.executeUpdate();
    } catch (SQLException e) {
        throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
    } finally {
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
            }
            resultSet = null;
        }
    }
}