public class Database
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
DB_URL |
static java.lang.String |
DRIVER |
Constructor and Description |
---|
Database() |
Modifier and Type | Method and Description |
---|---|
void |
closeConnection() |
java.lang.Object[][] |
convertToTable(java.util.List<?> l) |
int |
countAll(java.lang.String tableName) |
boolean |
createTables() |
void |
insertAlbumQ(Album a) |
void |
insertBookQ(Book b) |
void |
insertMovieQ(Movie m) |
java.util.List<Album> |
selectAlbums() |
java.util.List<Album> |
selectAlbums(Album searchData) |
java.util.List<Book> |
selectBooks() |
java.util.List<Book> |
selectBooks(Book searchData) |
java.util.List<Movie> |
selectMovies() |
java.util.List<Movie> |
selectMovies(Movie searchData) |
<T> void |
updateQ(T obj) |
public static final java.lang.String DRIVER
public static final java.lang.String DB_URL
public boolean createTables()
public void insertBookQ(Book b) throws java.sql.SQLException
java.sql.SQLException
public void insertAlbumQ(Album a) throws java.sql.SQLException
java.sql.SQLException
public void insertMovieQ(Movie m) throws java.sql.SQLException
java.sql.SQLException
public java.util.List<Book> selectBooks()
public java.util.List<Album> selectAlbums()
public java.util.List<Movie> selectMovies()
public int countAll(java.lang.String tableName)
public <T> void updateQ(T obj) throws java.sql.SQLException
java.sql.SQLException
public java.lang.Object[][] convertToTable(java.util.List<?> l)
public void closeConnection()