gov.nih.nlm.nls.lvg.Db

Class DbInflectionUtil

java.lang.Object

gov.nih.nlm.nls.lvg.Db.DbInflectionUtil

public class DbInflectionUtil
extends java.lang.Object

This class provides lower level interfaces by generating SQL query to Inflection and CitationLowerCase tables in LVG database.

History:

Version:

V-2020

Author:

NLM NLS Development Team

See Also:

InflectionRecord, Desgin Document

Constructor Summary

Constructors

Constructor and Description
DbInflectionUtil()

Method Summary

Modifier and Type	Method and Description
(package private) static InflectionRecord	GetOneInflectionRecord(java.sql.ResultSet rs) Get one inflectional record from Lexicon inflectional table
(package private) static InflectionRecord	GetRecordByIfTerm(java.lang.String ifTerm, java.sql.Connection conn) Get all inflection records for an inflected term.
(package private) static InflectionRecord	GetRecordByPreparedStatement(java.sql.PreparedStatement ps) Get the last inflection records from Inflection tables from LVG database for an specific SQL query.
(package private) static java.util.Vector<InflectionRecord>	GetRecords(java.lang.String query, java.sql.Connection conn, boolean isUniqueEui) Get all inflection records from Inflection table from LVG database for an specific SQL query.
(package private) static java.util.Vector<InflectionRecord>	GetRecordsBeginWithIfTerm(java.lang.String ifTermBegin, java.sql.Connection conn, boolean isUniqueEui) Get all inflection records for an inflected term begin with a specified string pattern.
(package private) static java.util.Vector<InflectionRecord>	GetRecordsByIfTerm(java.lang.String ifTerm, java.sql.Connection conn, boolean isUniqueEui) Get all inflection records for an inflected term.
(package private) static java.util.Vector<InflectionRecord>	GetRecordsByIfTermCat(java.lang.String ifTerm, int cat, java.sql.Connection conn) Get all inflection records for an inflected term and category.
static java.util.Vector<InflectionRecord>	GetRecordsByIfTermCatInfl(java.lang.String ifTerm, int cat, long infl, java.sql.Connection conn, boolean isUniqueEui) Get all inflection records for an inflected term.
(package private) static java.util.Vector<InflectionRecord>	GetRecordsByIfTermInfl(java.lang.String ifTerm, long infl, java.sql.Connection conn) Get all inflection records for an inflected term and inflection.
(package private) static java.util.Vector<InflectionRecord>	GetRecordsByIfTermInfl(java.lang.String ifTerm, long infl, java.sql.Connection conn, boolean isUniqueEui) Get all inflection records for an inflected term and inflection.
(package private) static java.util.Vector<InflectionRecord>	GetRecordsByPreparedStatement(java.sql.PreparedStatement ps, boolean isUniqueEui) Get all inflection records from Inflection table from LVG database for an specific SQL query, using prepare statement.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DbInflectionUtil

public DbInflectionUtil()

Method Detail

GetRecordsByIfTermCatInfl

public static java.util.Vector<InflectionRecord> GetRecordsByIfTermCatInfl(java.lang.String ifTerm,
                                                                           int cat,
                                                                           long infl,
                                                                           java.sql.Connection conn,
                                                                           boolean isUniqueEui)
                                                                    throws java.sql.SQLException

Get all inflection records for an inflected term.

Parameters:

ifTerm - inflected term

cat - specified categories for output

infl - specified inflections for output

conn - database connection

isUniqueEui - a boolean flag to specified the output to an unique EUI. If true, only the first record of records with same EUI is added to output.

Returns:

all inflection records for a specified inflected term, categories, and inflections.

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordsByIfTermCat

static java.util.Vector<InflectionRecord> GetRecordsByIfTermCat(java.lang.String ifTerm,
                                                                int cat,
                                                                java.sql.Connection conn)
                                                         throws java.sql.SQLException

Get all inflection records for an inflected term and category.

Parameters:

ifTerm - inflected term

cat - specified categories for output

conn - database connection

Returns:

all inflection records for a specified inflected term and categories.

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordsByIfTermInfl

static java.util.Vector<InflectionRecord> GetRecordsByIfTermInfl(java.lang.String ifTerm,
                                                                 long infl,
                                                                 java.sql.Connection conn)
                                                          throws java.sql.SQLException

Get all inflection records for an inflected term and inflection.

Parameters:

ifTerm - inflected term

infl - specified inflections for output

conn - database connection

Returns:

all inflection records for a specified inflected term and inflections.

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordsByIfTermInfl

static java.util.Vector<InflectionRecord> GetRecordsByIfTermInfl(java.lang.String ifTerm,
                                                                 long infl,
                                                                 java.sql.Connection conn,
                                                                 boolean isUniqueEui)
                                                          throws java.sql.SQLException

Get all inflection records for an inflected term and inflection.

Parameters:

ifTerm - inflected term

infl - specified inflections for output

conn - database connection

isUniqueEui - a boolean flag to specified the output to an unique EUI. If true, only the first record of records with same EUI is added to output.

Returns:

all inflection records for a specified inflected term and inflections.

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordByIfTerm

static InflectionRecord GetRecordByIfTerm(java.lang.String ifTerm,
                                          java.sql.Connection conn)
                                   throws java.sql.SQLException

Get all inflection records for an inflected term.

Parameters:

ifTerm - inflected term

conn - database connection

Returns:

all inflection records for a specified inflected term

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordsByIfTerm

static java.util.Vector<InflectionRecord> GetRecordsByIfTerm(java.lang.String ifTerm,
                                                             java.sql.Connection conn,
                                                             boolean isUniqueEui)
                                                      throws java.sql.SQLException

Get all inflection records for an inflected term.

Parameters:

ifTerm - inflected term

conn - database connection

isUniqueEui - a boolean flag to specified the output to an unique EUI. If true, only the first record of records with same EUI is added to output.

Returns:

all inflection records for a specified inflected term

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordsBeginWithIfTerm

static java.util.Vector<InflectionRecord> GetRecordsBeginWithIfTerm(java.lang.String ifTermBegin,
                                                                    java.sql.Connection conn,
                                                                    boolean isUniqueEui)
                                                             throws java.sql.SQLException

Get all inflection records for an inflected term begin with a specified string pattern.

Parameters:

ifTermBegin - beginning string pattern of the inflected term

conn - database connection

isUniqueEui - a boolean flag to specified the output to an unique EUI. If true, only the first record of records with same EUI is added to output.

Returns:

all inflection records for an inflected term begins with a specified string pattern

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordByPreparedStatement

static InflectionRecord GetRecordByPreparedStatement(java.sql.PreparedStatement ps)
                                              throws java.sql.SQLException

Get the last inflection records from Inflection tables from LVG database for an specific SQL query.

Parameters:

ps - prepared statement of SQL query

Returns:

the last inflection records for a specified SQL query

Throws:

java.sql.SQLException - if there is a database error happens

GetRecords

static java.util.Vector<InflectionRecord> GetRecords(java.lang.String query,
                                                     java.sql.Connection conn,
                                                     boolean isUniqueEui)
                                              throws java.sql.SQLException

Get all inflection records from Inflection table from LVG database for an specific SQL query.

Parameters:

query - SQL query

conn - database connection

isUniqueEui - a boolean flag to specified the output to an unique EUI. If true, only the first record of records with same EUI is added to output.

Returns:

all inflection records for a specified SQL query

Throws:

java.sql.SQLException - if there is a database error happens

GetRecordsByPreparedStatement

static java.util.Vector<InflectionRecord> GetRecordsByPreparedStatement(java.sql.PreparedStatement ps,
                                                                        boolean isUniqueEui)
                                                                 throws java.sql.SQLException

Get all inflection records from Inflection table from LVG database for an specific SQL query, using prepare statement.

Parameters:

ps - prepared statement of SQL query

isUniqueEui - a boolean flag to specified the output to an unique EUI. If true, only the first record of records with same EUI is added to output.

Returns:

all inflection records for a specified SQL query

Throws:

java.sql.SQLException - if there is a database error happens

GetOneInflectionRecord

static InflectionRecord GetOneInflectionRecord(java.sql.ResultSet rs)
                                        throws java.sql.SQLException

Get one inflectional record from Lexicon inflectional table

Parameters:

rs - ResultSet

Returns:

InflectionRecord inflection record

Throws:

java.sql.SQLException - if there is a database error happens