bradleyross.library.database

Class SQLServer

java.lang.Object

bradleyross.library.database.DatabaseExtras

bradleyross.library.database.SQLServer

public class SQLServer
extends DatabaseExtras

Subclass of DatabaseExtras for the SQLServer database manager by Microsoft.

The following are the date and time functions for SQL Server.

• DateAdd Adds to a date (days, weeks, and so on)
• DateDiff Calculates the difference between two dates
• DateName Returns a string representation of date parts
• DatePart Returns parts of a date (day of week, month, year, and so on)
• Day Returns the day of month of a year
• GetDate Returns the current date and time
• Month Returns the month portion of a date
• Year Returns the year portion of a date

Author:

Bradley Ross

Field Summary

Fields inherited from class bradleyross.library.database.DatabaseExtras

terms, validTerms

Constructor Summary

Constructors

Constructor and Description
SQLServer()

Method Summary

Methods

Modifier and Type	Method and Description
String	getDbms() Returns database code
protected void	setup() Sets up database specific objects.

Methods inherited from class bradleyross.library.database.DatabaseExtras

addTerm, getTerm, listAllTerms

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLServer

public SQLServer()

Method Detail

getDbms

public String getDbms()

Description copied from class: DatabaseExtras

Returns database code

Specified by:

getDbms in class DatabaseExtras

Returns:

Identifying code for database type

setup

protected void setup()

Description copied from class: DatabaseExtras

Sets up database specific objects.

Specified by:

setup in class DatabaseExtras