Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

org.ydp.db
Class Database  view Database download Database.java

java.lang.Object
  extended byorg.ydp.db.Database

public class Database
extends java.lang.Object


Field Summary
(package private) static java.sql.Connection con
           
(package private) static java.lang.String connectionURL
           
(package private) static java.lang.String db_name
           
(package private) static java.lang.String driverName
           
private static java.util.Vector fields
           
(package private) static java.lang.String pass
           
(package private) static java.sql.ResultSet rs
           
(package private) static java.lang.String sqlStatement
           
(package private) static java.sql.Statement stmt
           
(package private) static java.lang.String user
           
 
Constructor Summary
Database()
           
Database(java.lang.String name)
          Class constructor specifying the name of the database
 
Method Summary
static java.util.Vector browse(int offset, int count, char letter)
          Composes an SQL statement to find all files beginning with letter.
static void close()
          Closes the connection with the database.
 void connect()
           
static boolean create()
          Composes and sends an SQL statement to create the database.
static boolean delete(java.lang.String file)
          Composes and sends an SQL statement to delete the file specified.
static java.util.Vector getInfo(java.lang.String theURL)
          Composes an SQL statement to find all fields relating to a particular filename.
static boolean insert(java.util.Vector values)
          Composes and sends an SQL statement to insert items into the database
static void main(java.lang.String[] args)
          Main method used only for internal test purposes
static java.util.Vector query(int offset, int count, java.util.Vector fields, java.util.Vector values)
          Composes and sends an SQL statement to query the database
 void setConnectionURL(java.lang.String str)
           
 void setDBName(java.lang.String str)
           
 void setPass(java.lang.String str)
           
private static void setup()
           
 void setUser(java.lang.String str)
           
static boolean update(java.util.Vector values)
          Composes and sends an SQL statement to update record indicated by values[0]
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

driverName

static java.lang.String driverName

connectionURL

static java.lang.String connectionURL

user

static java.lang.String user

pass

static java.lang.String pass

con

static java.sql.Connection con

stmt

static java.sql.Statement stmt

sqlStatement

static java.lang.String sqlStatement

rs

static java.sql.ResultSet rs

db_name

static java.lang.String db_name

fields

private static java.util.Vector fields
Constructor Detail

Database

public Database(java.lang.String name)
Class constructor specifying the name of the database


Database

public Database()
Method Detail

setup

private static void setup()

setConnectionURL

public void setConnectionURL(java.lang.String str)

setDBName

public void setDBName(java.lang.String str)

setUser

public void setUser(java.lang.String str)

setPass

public void setPass(java.lang.String str)

connect

public void connect()

create

public static boolean create()
Composes and sends an SQL statement to create the database.


insert

public static boolean insert(java.util.Vector values)
Composes and sends an SQL statement to insert items into the database


delete

public static boolean delete(java.lang.String file)
Composes and sends an SQL statement to delete the file specified.


update

public static boolean update(java.util.Vector values)
Composes and sends an SQL statement to update record indicated by values[0]


query

public static java.util.Vector query(int offset,
                                     int count,
                                     java.util.Vector fields,
                                     java.util.Vector values)
Composes and sends an SQL statement to query the database


browse

public static java.util.Vector browse(int offset,
                                      int count,
                                      char letter)
Composes an SQL statement to find all files beginning with letter.


getInfo

public static java.util.Vector getInfo(java.lang.String theURL)
Composes an SQL statement to find all fields relating to a particular filename.


close

public static void close()
Closes the connection with the database.


main

public static void main(java.lang.String[] args)
Main method used only for internal test purposes