Class JdbcSongDAO

java.lang.Object

info.ejava.examples.db.jpa.songs.dao.JdbcSongDAO

@Component
@DependsOnDatabaseInitialization
public class JdbcSongDAO
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
(package private) static enum	JdbcSongDAO.Dialect

Field Summary

Fields

Modifier and Type	Field	Description
private final DataSource	dataSource
private JdbcSongDAO.Dialect	dialect

Constructor Summary

Constructors

Constructor	Description
JdbcSongDAO()

Method Summary

Modifier and Type	Method	Description
void	create(Song song)
void	deleteAll()
void	deleteById(int id)
boolean	existsById(int id)
Song	findById(int id)
void	init()
private int	nextId(Connection conn)
private void	setId(Song song, int id)
void	update(Song song)

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

dataSource

private final DataSource dataSource

dialect

private JdbcSongDAO.Dialect dialect

Constructor Details

JdbcSongDAO

public JdbcSongDAO()

Method Details

init

@PostConstruct
public void init()

existsById

public boolean existsById(int id)
                   throws SQLException

Throws:

SQLException

findById

public Song findById(int id)
              throws SQLException

Throws:

SQLException

create

public void create(Song song)
            throws SQLException

Throws:

SQLException

nextId

private int nextId(Connection conn)
            throws SQLException

Throws:

SQLException

setId

private void setId(Song song,
 int id)

update

public void update(Song song)
            throws SQLException

Throws:

SQLException

deleteById

public void deleteById(int id)
                throws SQLException

Throws:

SQLException

deleteAll

public void deleteAll()
               throws SQLException

Throws:

SQLException