dao

Class UserDao

java.lang.Object

dao.AMysqlDao

dao.UserDao

All Implemented Interfaces:

IGenericDao<UserBean,java.lang.Integer>, IUserDao

public class UserDao
extends AMysqlDao
implements IUserDao

Constructor Summary

Constructors

Constructor and Description
UserDao()

Method Summary

Modifier and Type	Method and Description
UserBean	create(UserBean instance) Create new record from object instance and save into database
boolean	delete(UserBean instance) Delete record from database
java.util.List<UserBean>	getUsers() Get list of all users from database
UserBean	read(java.lang.Integer instance) Loading record from database to Bean object
UserBean	read(java.lang.String userName) Loading record from SQL to Bean object from user login
UserBean	update(UserBean instance) Update record

Methods inherited from class java.lang.Object

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

Constructor Detail

UserDao

public UserDao()
        throws java.lang.ClassNotFoundException,
               java.io.IOException

Throws:

java.lang.ClassNotFoundException

java.io.IOException

Method Detail

create

public UserBean create(UserBean instance)
                throws java.sql.SQLException

Description copied from interface: IGenericDao

Create new record from object instance and save into database

Specified by:

create in interface IGenericDao<UserBean,java.lang.Integer>

Parameters:

instance - Bean object

Returns:

Bean object

Throws:

java.sql.SQLException

read

public UserBean read(java.lang.Integer instance)
              throws java.sql.SQLException

Description copied from interface: IGenericDao

Loading record from database to Bean object

Specified by:

read in interface IGenericDao<UserBean,java.lang.Integer>

Parameters:

instance - (PK)

Returns:

Bean object

Throws:

java.sql.SQLException

read

public UserBean read(java.lang.String userName)
              throws java.sql.SQLException

Description copied from interface: IUserDao

Loading record from SQL to Bean object from user login

Specified by:

read in interface IUserDao

Returns:

Bean object

Throws:

java.sql.SQLException

update

public UserBean update(UserBean instance)
                throws java.sql.SQLException

Description copied from interface: IGenericDao

Update record

Specified by:

update in interface IGenericDao<UserBean,java.lang.Integer>

Parameters:

instance - Bean object

Returns:

Bean object

Throws:

java.sql.SQLException

delete

public boolean delete(UserBean instance)
               throws java.sql.SQLException

Description copied from interface: IGenericDao

Delete record from database

Specified by:

delete in interface IGenericDao<UserBean,java.lang.Integer>

Parameters:

instance - Bean object

Returns:

TRUE if object was deleted, FALSE otherwise

Throws:

java.sql.SQLException

getUsers

public java.util.List<UserBean> getUsers()
                                  throws java.sql.SQLException

Description copied from interface: IUserDao

Get list of all users from database

Specified by:

getUsers in interface IUserDao

Returns:

List of users

Throws:

java.sql.SQLException