gov.nih.nlm.nls.lvg.Db

Class DbDerivation

java.lang.Object

gov.nih.nlm.nls.lvg.Db.DbDerivation

public class DbDerivation
extends java.lang.Object

This class provides high level interfaces to derivation table in LVG database.

History:

Version:

V-2025

Author:

NLM NLS Development Team

See Also:

DerivationRecord, Desgin Document

Constructor Summary

Constructors

Constructor and Description
DbDerivation()

Method Summary

Modifier and Type	Method and Description
static java.util.Vector<DerivationRecord>	GetDerivations(java.lang.String inStr, java.sql.Connection conn) Get derivation records for a specific term (lower case) from LVG database.
static java.util.Vector<DerivationRecord>	GetDerivationsByOption(java.lang.String inStr, java.sql.Connection conn, int typeFlag, int negOption) Get derivation records for a specific term (lower case) from LVG database.
static void	main(java.lang.String[] args) Test driver for this class.

Methods inherited from class java.lang.Object

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

Constructor Detail

DbDerivation

public DbDerivation()

Method Detail

GetDerivationsByOption

public static java.util.Vector<DerivationRecord> GetDerivationsByOption(java.lang.String inStr,
                                                                        java.sql.Connection conn,
                                                                        int typeFlag,
                                                                        int negOption)
                                                                 throws java.sql.SQLException

Get derivation records for a specific term (lower case) from LVG database. Two SQL queries are performed to get bi-directional search: one uses termLc1 as key, one uses termLc2 as key.

Parameters:

inStr - term for derivations (lower case)

conn - database connection

typeFlag - type flag: 0 (Z), 1 (P), 2(S), 3(ZP), 4 (ZS), 5 (PS), 6 (ZPS)

negOption - negation tag: N|O

Returns:

all derivation records for the specified term, inStr, with option

Throws:

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

GetDerivations

public static java.util.Vector<DerivationRecord> GetDerivations(java.lang.String inStr,
                                                                java.sql.Connection conn)
                                                         throws java.sql.SQLException

Get derivation records for a specific term (lower case) from LVG database. Two SQL queries are performed to get bi-directional search: one uses termLc1 as key, one uses termLc2 as key.

Parameters:

inStr - term for derivations (lower case)

conn - database connection

Returns:

all non-negative derivation records for the specified term, inStr

Throws:

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

main

public static void main(java.lang.String[] args)

Test driver for this class.

Parameters:

args - arguments