musicbox.database
Class Database
java.lang.Object
musicbox.database.Database
public class Database
- extends java.lang.Object
- Author:
- Isaac Hammon
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 |
Database
public Database(MusicBoxView mbv)
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