musicbox.database
Class Database

java.lang.Object
  extended by musicbox.database.Database

public class Database
extends java.lang.Object

Author:
Isaac Hammon

Constructor Summary
Database(MusicBoxView mbv)
           
 
Method Summary
 void addPlaylistsToDatabase(java.sql.Statement stmt)
           
 void addToBetterMusicLibrary(java.sql.Statement stmt, noTalent.MusicOutputDesign m)
           
 void addToPlayList(java.sql.Statement stmt, java.lang.String name, java.lang.String id)
           
 void addToPlayListTable(java.lang.String name, java.lang.String file)
           
 void closeCustomConnection()
           
 void createCurrentlyPlayingTable()
           
 void createTable(java.sql.Statement stmt, java.lang.String name)
           
 void deleteAll(java.sql.Statement stmt)
           
 void deleteEntirePlaylist(java.sql.Statement stmt, java.lang.String name)
           
 void deleteFromCurrentlyPlaying(java.lang.String id)
           
 void deleteFromMusicLibrary(java.sql.Statement stmt, noTalent.MusicOutputDesign m)
           
 void deleteFromPlaylistTable(java.sql.Statement stmt, java.lang.String name)
           
 void deleteSongFromPlaylist(java.sql.Statement stmt, java.lang.String name, java.lang.String id)
           
 void deleteSongFromPlaylists(java.lang.String id)
           
 void findAudioFiles(java.io.File myDir, java.lang.String dir, java.sql.Statement stmt)
           
 java.util.Vector<java.io.File> getAudioVector()
           
 java.util.Vector<java.lang.String> getColumnNames(java.sql.ResultSet results)
           
 java.sql.Connection getConnection()
           
 void getCustomConnection(java.io.File f)
           
 java.lang.String getID(java.lang.String parent, java.lang.String name)
           
 void insertIntoCurrentlyPlaying(int playOrder, java.lang.String id)
           
 noTalent.MusicOutputDesign insertMusicFile(java.io.File myFile, java.sql.Statement stmt)
           
 void insertOldIntoNew(java.sql.ResultSet rs)
           
 java.sql.ResultSet list(java.sql.Statement stmt, java.lang.String colName)
           
 java.sql.ResultSet listDuplicateRecords(java.sql.Statement stmt)
           
 java.util.Vector<java.lang.String> listPlayList(java.sql.Statement stmt, java.lang.String name)
           
static void main(java.lang.String[] args)
           
 java.util.Vector<java.lang.String> playLists(java.sql.Statement stmt)
           
 java.lang.String replaceApostrophe(java.lang.String s)
           
 java.lang.String replaceApostropheAndSlash(java.lang.String s)
           
 java.sql.ResultSet selectAll(java.sql.Statement stmt)
           
 java.sql.ResultSet selectAllCustom()
           
 java.lang.Object[] selectDistinct(java.sql.Statement stmt, java.lang.String column)
           
 noTalent.MusicOutputDesign selectTrack(java.lang.String ID)
           
 void updateCurrentTrack(java.lang.String id)
           
 void updateImagePath(java.sql.Statement stmt, noTalent.MusicOutputDesign m)
           
 void updatePlayCount(java.sql.Statement stmt, noTalent.MusicOutputDesign m)
           
 void updatePlayOrder(java.util.Vector<java.lang.String> v)
           
 void updateRating(java.sql.Statement stmt, noTalent.MusicOutputDesign m)
           
 void updateTags(java.sql.Statement stmt, noTalent.MusicOutputDesign oldM, noTalent.MusicOutputDesign newM)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Database

public Database(MusicBoxView mbv)
Method Detail

list

public java.sql.ResultSet list(java.sql.Statement stmt,
                               java.lang.String colName)
Parameters:
stmt -
colName - The column to be returned from the database.
Returns:
list A list of everything in the requested column.

addToBetterMusicLibrary

public void addToBetterMusicLibrary(java.sql.Statement stmt,
                                    noTalent.MusicOutputDesign m)
Parameters:
stmt -
m -
Throws:
java.sql.SQLException

deleteFromMusicLibrary

public void deleteFromMusicLibrary(java.sql.Statement stmt,
                                   noTalent.MusicOutputDesign m)
                            throws java.sql.SQLException
Parameters:
stmt -
m -
Throws:
java.sql.SQLException

listDuplicateRecords

public java.sql.ResultSet listDuplicateRecords(java.sql.Statement stmt)
                                        throws java.sql.SQLException
Parameters:
stmt -
Returns:
rs ResultSet of the SQL query.
Throws:
java.sql.SQLException

selectAll

public java.sql.ResultSet selectAll(java.sql.Statement stmt)
                             throws java.sql.SQLException
Parameters:
stmt -
Returns:
ResultSet ResultSet from SQL query.
Throws:
java.sql.SQLException

selectDistinct

public java.lang.Object[] selectDistinct(java.sql.Statement stmt,
                                         java.lang.String column)
                                  throws java.sql.SQLException
Throws:
java.sql.SQLException

selectTrack

public noTalent.MusicOutputDesign selectTrack(java.lang.String ID)

updatePlayCount

public void updatePlayCount(java.sql.Statement stmt,
                            noTalent.MusicOutputDesign m)
                     throws java.sql.SQLException
Parameters:
stmt -
m -
Throws:
java.sql.SQLException

updateRating

public void updateRating(java.sql.Statement stmt,
                         noTalent.MusicOutputDesign m)
                  throws java.sql.SQLException
Parameters:
stmt -
m -
Throws:
java.sql.SQLException

updateTags

public void updateTags(java.sql.Statement stmt,
                       noTalent.MusicOutputDesign oldM,
                       noTalent.MusicOutputDesign newM)
                throws java.sql.SQLException
Parameters:
stmt -
oldM -
newM -
Throws:
java.sql.SQLException

updateImagePath

public void updateImagePath(java.sql.Statement stmt,
                            noTalent.MusicOutputDesign m)
                     throws java.sql.SQLException
Parameters:
stmt -
m -
Throws:
java.sql.SQLException

getColumnNames

public java.util.Vector<java.lang.String> getColumnNames(java.sql.ResultSet results)
                                                  throws java.sql.SQLException
Parameters:
results -
Returns:
columnNames Vector of columnNames from ResultSet results.
Throws:
java.sql.SQLException

deleteAll

public void deleteAll(java.sql.Statement stmt)
Parameters:
stmt -

deleteFromPlaylistTable

public void deleteFromPlaylistTable(java.sql.Statement stmt,
                                    java.lang.String name)
                             throws java.sql.SQLException
Parameters:
stmt -
name -
Throws:
java.sql.SQLException

deleteSongFromPlaylist

public void deleteSongFromPlaylist(java.sql.Statement stmt,
                                   java.lang.String name,
                                   java.lang.String id)
                            throws java.sql.SQLException
Parameters:
stmt -
name -
filePath -
file -
Throws:
java.sql.SQLException

deleteEntirePlaylist

public void deleteEntirePlaylist(java.sql.Statement stmt,
                                 java.lang.String name)
                          throws java.sql.SQLException
Parameters:
stmt -
name -
Throws:
java.sql.SQLException

createTable

public void createTable(java.sql.Statement stmt,
                        java.lang.String name)
Parameters:
stmt -
name -

createCurrentlyPlayingTable

public void createCurrentlyPlayingTable()

addToPlayList

public void addToPlayList(java.sql.Statement stmt,
                          java.lang.String name,
                          java.lang.String id)
Parameters:
stmt -
name -
filePath -
file -

listPlayList

public java.util.Vector<java.lang.String> listPlayList(java.sql.Statement stmt,
                                                       java.lang.String name)
Parameters:
stmt -
name -
Returns:
list

updatePlayOrder

public void updatePlayOrder(java.util.Vector<java.lang.String> v)

updateCurrentTrack

public void updateCurrentTrack(java.lang.String id)

deleteFromCurrentlyPlaying

public void deleteFromCurrentlyPlaying(java.lang.String id)

insertIntoCurrentlyPlaying

public void insertIntoCurrentlyPlaying(int playOrder,
                                       java.lang.String id)

addToPlayListTable

public void addToPlayListTable(java.lang.String name,
                               java.lang.String file)
Parameters:
stmt -
name -

replaceApostrophe

public java.lang.String replaceApostrophe(java.lang.String s)
Parameters:
s -
Returns:
s

replaceApostropheAndSlash

public java.lang.String replaceApostropheAndSlash(java.lang.String s)

insertMusicFile

public noTalent.MusicOutputDesign insertMusicFile(java.io.File myFile,
                                                  java.sql.Statement stmt)
Parameters:
myFile -
stmt -

playLists

public java.util.Vector<java.lang.String> playLists(java.sql.Statement stmt)
Parameters:
stmt -
Returns:
list

findAudioFiles

public void findAudioFiles(java.io.File myDir,
                           java.lang.String dir,
                           java.sql.Statement stmt)
Parameters:
myDir -
dir -
stmt -

getConnection

public java.sql.Connection getConnection()

addPlaylistsToDatabase

public void addPlaylistsToDatabase(java.sql.Statement stmt)

getID

public java.lang.String getID(java.lang.String parent,
                              java.lang.String name)

getAudioVector

public java.util.Vector<java.io.File> getAudioVector()

getCustomConnection

public void getCustomConnection(java.io.File f)

selectAllCustom

public java.sql.ResultSet selectAllCustom()

insertOldIntoNew

public void insertOldIntoNew(java.sql.ResultSet rs)

closeCustomConnection

public void closeCustomConnection()

deleteSongFromPlaylists

public void deleteSongFromPlaylists(java.lang.String id)

main

public static void main(java.lang.String[] args)
Parameters:
args -
Throws:
java.io.IOException