|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectcz.hdf.db.model.DBModel
cz.hdf.cdnavigator.db.DBModel_0_5
cz.hdf.cdnavigator.db.DBModel_0_6
cz.hdf.cdnavigator.db.DataManagement
public class DataManagement
DOCUMENT ME!
| Field Summary | |
|---|---|
static java.lang.String |
APP_CD
Application name for table CD |
static java.lang.String |
APP_CD_COLUMN_BOX
Application column name |
static java.lang.String |
APP_CD_COLUMN_COVER
Application column name |
static java.lang.String |
APP_CD_COLUMN_HASHCODE
Application column name |
static java.lang.String |
APP_CD_COLUMN_INFO
Application column name |
static java.lang.String |
APP_CD_COLUMN_NUMBER
Application column name |
static java.lang.String |
APP_CD_COLUMN_TYPE
Application column name |
static java.lang.String |
APP_CD_COLUMN_VOLUME
Application column name |
static int |
APP_COLUMN_TYPE_BOOLEAN
Application column type |
static int |
APP_COLUMN_TYPE_BOXES
Application column type |
static int |
APP_COLUMN_TYPE_CD_TYPE
Application column type |
static int |
APP_COLUMN_TYPE_DATE
Application column type |
static int |
APP_COLUMN_TYPE_GENRE
Application column type |
static int |
APP_COLUMN_TYPE_NUMBER
Application column type |
static int |
APP_COLUMN_TYPE_RATE
Application column type |
static int |
APP_COLUMN_TYPE_TEXT
Application column type |
static java.lang.String |
APP_MUSIC
Application name for tables music_album, interpret, song, album_interpret |
static java.lang.String |
APP_MUSIC_COLUMN_ALBUM_GENRE
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_ALBUM_NAME
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_ALBUM_RATING
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_ALBUM_YEAR
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_INTERPRET_NAME
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_SONG_FILE
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_SONG_GENRE
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_SONG_NAME
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_SONG_NUMBER
Application column name |
static java.lang.String |
APP_MUSIC_COLUMN_SONG_RATING
Application column name |
static java.lang.String |
APP_PHOTO
Application name for tables photos, ... |
static java.lang.String |
APP_PHOTO_COLUMN_ALBUM_INFO
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_ALBUM_NAME
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_ALBUM_RATING
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_APPERTURE
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_CAMERA
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_COLOR
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_DATE
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_EXPOSURE
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_EXPOSURE_BIAS
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_FILE
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_FLASH
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_FOCAL_LENGTH
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_HEIGHT
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_INFO
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_ISO_SENSITIVITY
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_METERING_MODE
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_NUMBER
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_RATING
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_SHUTTER_SPEED
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_SUBJECT_DISTANCE
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_THUMB
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_WHITE_BALANCE
Application column name |
static java.lang.String |
APP_PHOTO_COLUMN_WIDTH
Application column name |
static java.lang.String |
DATABASE_MODEL_FILE
Database model file name in config dir |
static java.lang.String |
DATABASE_MODEL_VERSION
Description ID name for model version |
private cz.hdf.db.DBManager |
dbManager
Database manager with real connection |
static java.lang.String |
DISC_TYPE_CD_AUDIO
type audio CD for device DiskDrive |
static int |
DISC_TYPE_CD_AUDIO_INT
type audio CD for device DiskDrive |
static java.lang.String |
DISC_TYPE_CD_DATA
type data CD for device DiskDrive |
static int |
DISC_TYPE_CD_DATA_INT
type data CD for device DiskDrive |
static java.lang.String |
DISC_TYPE_DVD_DATA
type data DVD for device DiskDrive |
static int |
DISC_TYPE_DVD_DATA_INT
type data DVD for device DiskDrive |
static java.lang.String |
DISC_TYPE_DVD_MOVIE
type DVD for device DiskDrive |
static int |
DISC_TYPE_DVD_MOVIE_INT
type DVD for device DiskDrive |
private FullTextParse |
ftParse
? |
private static DataManagement |
instance
Singleton instance. |
private java.util.logging.Logger |
logger
Logger. |
private java.sql.PreparedStatement |
pstmtExistInterpret
|
private java.sql.PreparedStatement |
pstmtExistMusicAlbum
|
private java.sql.PreparedStatement |
pstmtExistPhotoAlbum
|
private java.sql.PreparedStatement |
pstmtInsertAlbumInterpret
|
private java.sql.PreparedStatement |
pstmtInsertCD
|
private java.sql.PreparedStatement |
pstmtInsertInterpret
|
private java.sql.PreparedStatement |
pstmtInsertMusicAlbum
|
private java.sql.PreparedStatement |
pstmtInsertPhoto
|
private java.sql.PreparedStatement |
pstmtInsertPhotoAlbum
|
private java.sql.PreparedStatement |
pstmtInsertSong
|
private java.sql.PreparedStatement |
pstmtQueryAllCDs
|
private java.sql.PreparedStatement |
pstmtQueryAllInterprets
|
private java.sql.PreparedStatement |
pstmtQueryAllMusicAlbums
|
private java.sql.PreparedStatement |
pstmtQueryAllPhotoAlbums
|
private java.sql.PreparedStatement |
pstmtQueryCDBoxes
|
private java.sql.PreparedStatement |
pstmtSelectMaxCDID
|
private java.sql.PreparedStatement |
pstmtSelectMaxInterpretID
|
private java.sql.PreparedStatement |
pstmtSelectMaxMusicAlbumID
|
private java.sql.PreparedStatement |
pstmtSelectMaxPhotoAlbumID
|
private java.sql.PreparedStatement |
pstmtSelectMaxPhotoID
|
private java.sql.PreparedStatement |
pstmtSelectMaxSongID
|
private java.sql.PreparedStatement |
pstmtSelectPhotoThumb
|
private java.sql.PreparedStatement |
pstmtUpdateCD
|
private java.sql.PreparedStatement |
pstmtUpdateInfo
|
private java.sql.PreparedStatement |
pstmtUpdateInterpret
|
private java.sql.PreparedStatement |
pstmtUpdateMusicAlbum
|
private java.sql.PreparedStatement |
pstmtUpdatePhoto
|
private java.sql.PreparedStatement |
pstmtUpdatePhotoAlbum
|
private java.sql.PreparedStatement |
pstmtUpdateRating
|
private java.sql.PreparedStatement |
pstmtUpdateSong
|
static java.lang.String |
SELECT_CD_PREFIX
this is prefix of SQL select command on CD table |
static java.lang.String |
SELECT_INTERPRET_PREFIX
this is prefix of SQL select command on interpret table |
static java.lang.String |
SELECT_MUSIC_ALBUM_PREFIX
this is prefix of SQL select command on music album table |
static java.lang.String |
SELECT_PHOTO_ALBUM_PREFIX
this is prefix of SQL select command on photo album table |
static java.lang.String |
SELECT_PHOTO_PREFIX
this is prefix of SQL select command on photo table |
static java.lang.String |
SELECT_SONG_PREFIX
this is prefix of SQL select command on song table |
| Fields inherited from class cz.hdf.cdnavigator.db.DBModel_0_6 |
|---|
DATABASE_MODEL_VERSION_0_6 |
| Constructor Summary | |
|---|---|
DataManagement()
Initialize database connection. |
|
| Method Summary | |
|---|---|
static java.lang.String[] |
appColumnNames(java.lang.String _appTableName)
Get readable application column names according to application table name (like movie -> movie, genre, director, ...) |
static java.lang.String |
appNames2dbColumnName(java.lang.String _appTableName,
java.lang.String _appColumnName)
Convert readable application table and column names to DB table name. |
static java.lang.String |
appNames2dbTableName(java.lang.String _appTableName,
java.lang.String _appColumnName)
Convert readable application table and column names to DB table name. |
static void |
close()
Release DB statements and connections. |
private java.lang.String[] |
convertGenres(java.lang.String _genres)
DOCUMENT ME! |
private java.lang.String |
convertGenres(java.lang.String[] _genres)
DOCUMENT ME! |
static java.lang.String |
dbNames2appColumnName(java.lang.String _dbTableName,
java.lang.String _dbColumnName)
Convert DB table name and column name to readable column name for application. |
static java.lang.String |
dbTableName2appName(java.lang.String _dbTableName)
Convert DB table name to readable name for application. |
static int |
executeDeleteCD(int _cdid)
Delete one cd and all his photos, music, movies records from DB. |
static int |
executeDeleteInterpret(int _iid)
Delete one interpret record from DB and all interpret records from music albums. |
static int |
executeDeleteMusicAlbum(int _maid)
Delete one music album and all his songs from DB. |
static int |
executeDeletePhoto(int _pid)
Delete one photo from DB. |
static int |
executeDeletePhotoAlbum(int _paid)
Delete one photo album and all his photos from DB. |
static int |
executeDeleteSong(int _sid)
Delete one song from DB. |
static int |
executeInsertCD(CDData _cdData)
Execute SQL insert for CD table. |
static int |
executeInsertInterpret(java.lang.String _interpretName)
Execute SQL insert for Interpret table. |
static void |
executeInsertModelVersion()
Insert model version into DB. |
static int |
executeInsertMusicAlbum(MusicAlbumData _aData)
Execute SQL insert for MusicAlbum table. |
static int |
executeInsertPhoto(PhotoData _pData)
Execute SQL insert for PhotoAlbum table. |
static int |
executeInsertPhotoAlbum(PhotoAlbumData _paData)
Execute SQL insert for PhotoAlbum table. |
static int |
executeInsertSong(SongData _sData)
Execute SQL insert for Song table. |
static java.lang.String[] |
executeQueryAllCDs()
|
static java.lang.String[] |
executeQueryAllInterprets()
|
static java.lang.String[] |
executeQueryAllMusicAlbums()
|
static java.lang.String[] |
executeQueryAllPhotoAlbums()
|
static CDData[] |
executeQueryCD(java.lang.String _sql)
Execute SQL query for CD table. |
static java.lang.String[] |
executeQueryCDBoxes()
|
static CDData[] |
executeQueryFullTextCD(java.lang.String _fulltext)
Execute SQL query for CD table. |
static PhotoData[] |
executeQueryFullTextPhoto(java.lang.String _fulltext)
Execute SQL query for Photo table. |
static SongData[] |
executeQueryFullTextSong(java.lang.String _fulltext)
Execute SQL query for Song table. |
static java.lang.String |
executeQueryModelVersion()
Select from DB model version. |
static MusicAlbumData[] |
executeQueryMusicAlbum(java.lang.String _sql)
Execute SQL query for MusicAlbum table and Interpret table. |
static PhotoData[] |
executeQueryPhoto(java.lang.String _sql)
Execute SQL query for Photo table. |
static PhotoAlbumData[] |
executeQueryPhotoAlbum(java.lang.String _sql)
Execute SQL query for PhotoAlbum table. |
static java.awt.Image |
executeQueryPhotoThumb(int _photoID)
|
static SongData[] |
executeQuerySong(java.lang.String _sql)
Execute SQL query for Song table. |
static int |
executeUpdateCD(CDData _cdData)
Execute SQL update for CD table. |
static int |
executeUpdateInterpret(int _interpretID,
java.lang.String _interpretName)
Execute SQL update for interpret table. |
static int |
executeUpdateMusicAlbum(MusicAlbumData _maData)
Execute SQL update for music album table. |
static int |
executeUpdatePhoto(PhotoData _pd)
Execute SQL update for photo table. |
static int |
executeUpdatePhotoAlbum(PhotoAlbumData _pad)
Execute SQL update for photo album table. |
static int |
executeUpdatePhotoInfo(int _photoID,
java.lang.String _newInfo)
Execute SQL update for photo table. |
static int |
executeUpdatePhotoRating(int _photoID,
int _newRating)
Execute SQL update for photo table. |
static int |
executeUpdateSong(SongData _songData)
Execute SQL update for song table. |
static int |
existInterpret(java.lang.String _interpretName)
Try to find interpret name in DB. |
static int |
existMusicAlbum(java.lang.String _albumName)
Try to find music album name in DB. |
static int |
existPhotoAlbum(java.lang.String _albumName)
Try to find photo album name in DB. |
static int |
getAppColumnType(java.lang.String _appTableName,
java.lang.String _appColumnName)
Get app type ( APP_COLUMN_TYPE_) for specified app column. |
static cz.hdf.db.DBManager |
getDBManager()
Get DB manager |
static DataManagement |
getInstance()
Get singleton instance. |
static void |
initialize()
Initialize database model and connection to real database. |
static void |
initPreparedStatements()
Initialize prepared statements. |
static boolean |
isSupportedSQLUnion()
Is supported SQL union command in DB? |
static void |
upgradeDB(java.lang.String _modelVersion)
Upgrade/proceed changes from new DB model to DB. |
static void |
upgradeDBFrom03To04()
Upgrade/proceed changes from new DB model to DB. |
static void |
upgradeDBFrom04To05()
Upgrade/proceed changes from new DB model to DB. |
static void |
upgradeDBFrom05To06()
Upgrade/proceed changes from new DB model to DB. |
static void |
upgradeDBFromNullTo03()
Upgrade/proceed changes from new DB model to DB. |
| Methods inherited from class cz.hdf.cdnavigator.db.DBModel_0_6 |
|---|
getModel, getVersion |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
|---|
private static final DataManagement instance
public static final java.lang.String DATABASE_MODEL_FILE
public static final java.lang.String DATABASE_MODEL_VERSION
public static final java.lang.String DISC_TYPE_CD_DATA
public static final int DISC_TYPE_CD_DATA_INT
public static final java.lang.String DISC_TYPE_CD_AUDIO
public static final int DISC_TYPE_CD_AUDIO_INT
public static final java.lang.String DISC_TYPE_DVD_MOVIE
public static final int DISC_TYPE_DVD_MOVIE_INT
public static final java.lang.String DISC_TYPE_DVD_DATA
public static final int DISC_TYPE_DVD_DATA_INT
public static final java.lang.String APP_CD
public static final java.lang.String APP_MUSIC
public static final java.lang.String APP_PHOTO
public static final java.lang.String APP_CD_COLUMN_NUMBER
public static final java.lang.String APP_CD_COLUMN_TYPE
public static final java.lang.String APP_CD_COLUMN_HASHCODE
public static final java.lang.String APP_CD_COLUMN_BOX
public static final java.lang.String APP_CD_COLUMN_VOLUME
public static final java.lang.String APP_CD_COLUMN_INFO
public static final java.lang.String APP_CD_COLUMN_COVER
public static final java.lang.String APP_MUSIC_COLUMN_ALBUM_NAME
public static final java.lang.String APP_MUSIC_COLUMN_ALBUM_YEAR
public static final java.lang.String APP_MUSIC_COLUMN_ALBUM_GENRE
public static final java.lang.String APP_MUSIC_COLUMN_ALBUM_RATING
public static final java.lang.String APP_MUSIC_COLUMN_INTERPRET_NAME
public static final java.lang.String APP_MUSIC_COLUMN_SONG_NUMBER
public static final java.lang.String APP_MUSIC_COLUMN_SONG_NAME
public static final java.lang.String APP_MUSIC_COLUMN_SONG_FILE
public static final java.lang.String APP_MUSIC_COLUMN_SONG_RATING
public static final java.lang.String APP_MUSIC_COLUMN_SONG_GENRE
public static final java.lang.String APP_PHOTO_COLUMN_ALBUM_NAME
public static final java.lang.String APP_PHOTO_COLUMN_ALBUM_INFO
public static final java.lang.String APP_PHOTO_COLUMN_ALBUM_RATING
public static final java.lang.String APP_PHOTO_COLUMN_NUMBER
public static final java.lang.String APP_PHOTO_COLUMN_FILE
public static final java.lang.String APP_PHOTO_COLUMN_INFO
public static final java.lang.String APP_PHOTO_COLUMN_RATING
public static final java.lang.String APP_PHOTO_COLUMN_DATE
public static final java.lang.String APP_PHOTO_COLUMN_COLOR
public static final java.lang.String APP_PHOTO_COLUMN_THUMB
public static final java.lang.String APP_PHOTO_COLUMN_WIDTH
public static final java.lang.String APP_PHOTO_COLUMN_HEIGHT
public static final java.lang.String APP_PHOTO_COLUMN_SHUTTER_SPEED
public static final java.lang.String APP_PHOTO_COLUMN_APPERTURE
public static final java.lang.String APP_PHOTO_COLUMN_EXPOSURE
public static final java.lang.String APP_PHOTO_COLUMN_EXPOSURE_BIAS
public static final java.lang.String APP_PHOTO_COLUMN_ISO_SENSITIVITY
public static final java.lang.String APP_PHOTO_COLUMN_FOCAL_LENGTH
public static final java.lang.String APP_PHOTO_COLUMN_SUBJECT_DISTANCE
public static final java.lang.String APP_PHOTO_COLUMN_METERING_MODE
public static final java.lang.String APP_PHOTO_COLUMN_FLASH
public static final java.lang.String APP_PHOTO_COLUMN_WHITE_BALANCE
public static final java.lang.String APP_PHOTO_COLUMN_CAMERA
public static final java.lang.String SELECT_CD_PREFIX
public static final java.lang.String SELECT_PHOTO_ALBUM_PREFIX
public static final java.lang.String SELECT_PHOTO_PREFIX
public static final java.lang.String SELECT_MUSIC_ALBUM_PREFIX
public static final java.lang.String SELECT_SONG_PREFIX
public static final java.lang.String SELECT_INTERPRET_PREFIX
public static final int APP_COLUMN_TYPE_TEXT
public static final int APP_COLUMN_TYPE_NUMBER
public static final int APP_COLUMN_TYPE_BOOLEAN
public static final int APP_COLUMN_TYPE_DATE
public static final int APP_COLUMN_TYPE_RATE
public static final int APP_COLUMN_TYPE_GENRE
public static final int APP_COLUMN_TYPE_BOXES
public static final int APP_COLUMN_TYPE_CD_TYPE
private java.sql.PreparedStatement pstmtInsertCD
private java.sql.PreparedStatement pstmtInsertPhoto
private java.sql.PreparedStatement pstmtInsertPhotoAlbum
private java.sql.PreparedStatement pstmtInsertMusicAlbum
private java.sql.PreparedStatement pstmtInsertAlbumInterpret
private java.sql.PreparedStatement pstmtInsertSong
private java.sql.PreparedStatement pstmtInsertInterpret
private java.sql.PreparedStatement pstmtUpdateCD
private java.sql.PreparedStatement pstmtUpdatePhotoAlbum
private java.sql.PreparedStatement pstmtUpdatePhoto
private java.sql.PreparedStatement pstmtUpdateRating
private java.sql.PreparedStatement pstmtUpdateInfo
private java.sql.PreparedStatement pstmtUpdateMusicAlbum
private java.sql.PreparedStatement pstmtUpdateSong
private java.sql.PreparedStatement pstmtUpdateInterpret
private java.sql.PreparedStatement pstmtSelectMaxCDID
private java.sql.PreparedStatement pstmtSelectMaxPhotoID
private java.sql.PreparedStatement pstmtSelectMaxPhotoAlbumID
private java.sql.PreparedStatement pstmtSelectMaxMusicAlbumID
private java.sql.PreparedStatement pstmtSelectMaxSongID
private java.sql.PreparedStatement pstmtSelectMaxInterpretID
private java.sql.PreparedStatement pstmtQueryCDBoxes
private java.sql.PreparedStatement pstmtQueryAllCDs
private java.sql.PreparedStatement pstmtQueryAllPhotoAlbums
private java.sql.PreparedStatement pstmtQueryAllMusicAlbums
private java.sql.PreparedStatement pstmtQueryAllInterprets
private java.sql.PreparedStatement pstmtExistPhotoAlbum
private java.sql.PreparedStatement pstmtExistMusicAlbum
private java.sql.PreparedStatement pstmtExistInterpret
private java.sql.PreparedStatement pstmtSelectPhotoThumb
private cz.hdf.db.DBManager dbManager
private FullTextParse ftParse
private java.util.logging.Logger logger
| Constructor Detail |
|---|
public DataManagement()
| Method Detail |
|---|
public static DataManagement getInstance()
public static void initialize()
throws java.sql.SQLException
java.sql.SQLException - can not connect to DB
public static void initPreparedStatements()
throws java.sql.SQLException
java.sql.SQLExceptionpublic static cz.hdf.db.DBManager getDBManager()
private java.lang.String convertGenres(java.lang.String[] _genres)
_genres -
private java.lang.String[] convertGenres(java.lang.String _genres)
_genres -
public static java.lang.String executeQueryModelVersion()
public static CDData[] executeQueryCD(java.lang.String _sql)
throws java.sql.SQLException
SELECT_CD_PREFIX constant.
_sql - SQL select command
java.sql.SQLException - when SQL error occursSELECT_CD_PREFIX
public static java.lang.String[] executeQueryCDBoxes()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static PhotoAlbumData[] executeQueryPhotoAlbum(java.lang.String _sql)
throws java.sql.SQLException
SELECT_PHOTO_ALBUM_PREFIX constant.
_sql - SQL select command
java.sql.SQLException - when SQL error occursSELECT_PHOTO_ALBUM_PREFIX
public static PhotoData[] executeQueryPhoto(java.lang.String _sql)
throws java.sql.SQLException
SELECT_PHOTO_PREFIX constant.
_sql - SQL select command
java.sql.SQLException - when SQL error occursSELECT_PHOTO_PREFIX
public static MusicAlbumData[] executeQueryMusicAlbum(java.lang.String _sql)
throws java.sql.SQLException
SELECT_MUSIC_ALBUM_PREFIX constant.
_sql - SQL select command
java.sql.SQLException - when SQL error occursSELECT_MUSIC_ALBUM_PREFIX
public static SongData[] executeQuerySong(java.lang.String _sql)
throws java.sql.SQLException
SELECT_SONG_PREFIX constant.
_sql - SQL select command
java.sql.SQLException - when SQL error occursSELECT_SONG_PREFIX
public static java.lang.String[] executeQueryAllCDs()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static java.lang.String[] executeQueryAllPhotoAlbums()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static java.lang.String[] executeQueryAllMusicAlbums()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static java.lang.String[] executeQueryAllInterprets()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static CDData[] executeQueryFullTextCD(java.lang.String _fulltext)
throws java.sql.SQLException
SELECT_CD_PREFIX constant.
_fulltext - SQL select command
java.sql.SQLException - when SQL error occursSELECT_CD_PREFIX
public static PhotoData[] executeQueryFullTextPhoto(java.lang.String _fulltext)
throws java.sql.SQLException
SELECT_PHOTO_PREFIX constant.
_fulltext - SQL select command
java.sql.SQLException - when SQL error occursSELECT_PHOTO_PREFIX
public static SongData[] executeQueryFullTextSong(java.lang.String _fulltext)
throws java.sql.SQLException
SELECT_SONG_PREFIX constant.
_fulltext - SQL select command
java.sql.SQLException - when SQL error occursSELECT_SONG_PREFIX
public static java.awt.Image executeQueryPhotoThumb(int _photoID)
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static int existPhotoAlbum(java.lang.String _albumName)
throws java.sql.SQLException
_albumName - name
java.sql.SQLException - when SQL error occurs
public static int existMusicAlbum(java.lang.String _albumName)
throws java.sql.SQLException
_albumName - name
java.sql.SQLException - when SQL error occurs
public static int existInterpret(java.lang.String _interpretName)
throws java.sql.SQLException
_interpretName - name
java.sql.SQLException - when SQL error occurs
public static void executeInsertModelVersion()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static int executeInsertCD(CDData _cdData)
throws java.sql.SQLException
_cdData - new CD record data
java.sql.SQLException - when SQL error occurs
public static int executeInsertPhotoAlbum(PhotoAlbumData _paData)
throws java.sql.SQLException
_paData - new PhotoAlbum record data
java.sql.SQLException - when SQL error occurs
public static int executeInsertPhoto(PhotoData _pData)
throws java.sql.SQLException
_pData - new PhotoAlbum record data
java.sql.SQLException - when SQL error occurs
public static int executeInsertMusicAlbum(MusicAlbumData _aData)
throws java.sql.SQLException
_aData - new MusicAlbum record data
java.sql.SQLException - when SQL error occurs
public static int executeInsertSong(SongData _sData)
throws java.sql.SQLException
_sData - new Song record data
java.sql.SQLException - when SQL error occurs
public static int executeInsertInterpret(java.lang.String _interpretName)
throws java.sql.SQLException
_interpretName - new interpret name
java.sql.SQLException - when SQL error occurs
public static int executeUpdateCD(CDData _cdData)
throws java.sql.SQLException
_cdData - new CD record data, data id shows to original record to update
java.sql.SQLException - when SQL error occurs
public static int executeUpdatePhotoAlbum(PhotoAlbumData _pad)
throws java.sql.SQLException
_pad - new photo album record data, data id shows to original record to update
java.sql.SQLException - when SQL error occurs
public static int executeUpdatePhoto(PhotoData _pd)
throws java.sql.SQLException
_pd - new photo record data, data id shows to original record to update
java.sql.SQLException - when SQL error occurs
public static int executeUpdatePhotoRating(int _photoID,
int _newRating)
throws java.sql.SQLException
_photoID - _pd new photo record data, data id shows to original record to update_newRating -
java.sql.SQLException - when SQL error occurs
public static int executeUpdatePhotoInfo(int _photoID,
java.lang.String _newInfo)
throws java.sql.SQLException
_photoID - _pd new photo record data, data id shows to original record to update_newInfo -
java.sql.SQLException - when SQL error occurs
public static int executeUpdateMusicAlbum(MusicAlbumData _maData)
throws java.sql.SQLException
_maData - new music album record data, data id shows to original record to update
java.sql.SQLException - when SQL error occurs
public static int executeUpdateSong(SongData _songData)
throws java.sql.SQLException
_songData - new song record data, data id shows to original record to update
java.sql.SQLException - when SQL error occurs
public static int executeUpdateInterpret(int _interpretID,
java.lang.String _interpretName)
throws java.sql.SQLException
_interpretID - id shows to original record to update_interpretName - new name
java.sql.SQLException - when SQL error occurs
public static int executeDeleteCD(int _cdid)
throws java.sql.SQLException
_cdid - cd id to delete
java.sql.SQLException - when SQL error occurs
public static int executeDeletePhotoAlbum(int _paid)
throws java.sql.SQLException
_paid - photo album id to delete
java.sql.SQLException - when SQL error occurs
public static int executeDeletePhoto(int _pid)
throws java.sql.SQLException
_pid - photo id to delete
java.sql.SQLException - when SQL error occurs
public static int executeDeleteMusicAlbum(int _maid)
throws java.sql.SQLException
_maid - music album id to delete
java.sql.SQLException - when SQL error occurs
public static int executeDeleteSong(int _sid)
throws java.sql.SQLException
_sid - song id to delete
java.sql.SQLException - when SQL error occurs
public static int executeDeleteInterpret(int _iid)
throws java.sql.SQLException
_iid - interpret id to delete
java.sql.SQLException - when SQL error occurs
public static void upgradeDB(java.lang.String _modelVersion)
throws java.sql.SQLException
_modelVersion -
java.sql.SQLException - when SQL error occurs
public static void upgradeDBFromNullTo03()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static void upgradeDBFrom03To04()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static void upgradeDBFrom04To05()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurs
public static void upgradeDBFrom05To06()
throws java.sql.SQLException
java.sql.SQLException - when SQL error occurspublic static boolean isSupportedSQLUnion()
Create two testing tables and execute query with union command on these tables. Then drop testing tables.
public static java.lang.String dbTableName2appName(java.lang.String _dbTableName)
_dbTableName - DB table name
public static java.lang.String dbNames2appColumnName(java.lang.String _dbTableName,
java.lang.String _dbColumnName)
_dbTableName - DB table name_dbColumnName - DB column name from table name
public static java.lang.String appNames2dbTableName(java.lang.String _appTableName,
java.lang.String _appColumnName)
_appTableName - readable application table name_appColumnName - readable application column name from table
public static java.lang.String appNames2dbColumnName(java.lang.String _appTableName,
java.lang.String _appColumnName)
_appTableName - readable application table name_appColumnName - readable application column name from table
public static java.lang.String[] appColumnNames(java.lang.String _appTableName)
_appTableName - readable application table name
public static int getAppColumnType(java.lang.String _appTableName,
java.lang.String _appColumnName)
APP_COLUMN_TYPE_) for specified app column.
_appTableName - app column table_appColumnName - app column
APP_COLUMN_TYPE_BOOLEAN,
APP_COLUMN_TYPE_DATE,
APP_COLUMN_TYPE_NUMBER,
APP_COLUMN_TYPE_TEXTpublic static void close()
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||