DAO j2SE?Different?
Hello, I am trying to create a persistance framework for my POJO`s.
I have run the example of dao at http://access1.sun.com/codesamples/DataAccessObject.html,here its Ok.
But is this all or the best in calling business methods.Its seems to just create a source of data.It does not transfer to a Business object to create connection and a DAO to get connection.I want to create a solid understanding of doing this DAO just with J2SE.
I want to have a GUI to >controller to>BO to> Dao.
Or is this unneccessary?
Thank You
[578 byte] By [
AndyAlean] at [2007-9-30 8:57:48]
Hi,I am trying to link the DataTapFactory to inplement this interperation.I`m a bit confused to how to arrange it.Please Help
public class UserBO {
private ConnectionPool pool;
public UserBO() {
pool = ConnectionPool.getInstance();
//Get connection
/**DataTap source = DataTapFactory.getDataSourceAccessor
*(dbType, url, username, password, driverName);
**/
}
public User getUser(String userId) throws UserException {
Connection con = null;
try {
con = pool.getConnection(true);
/**I need something like
* dataAccess.setConnectionPool(connPool);
* DataTap dataSource = (DataTap)dataAccess; //This line is my problem
* return dataSource;
**/
UserDAO userDAO = new UserDAO(con);
return userDAO.findByPrimaryKey(userId);
The DAO
public class UserDAO {
private Connection con;
public UserDAO(Connection con) {
this.con = con;
}
Tutorial spec on TapFactory
public class DataTapFactory{
public static DataTap getDataSourceAccessor(String dbType, String url,
String uName, String pWord,
String driverName)
{
if(dbType.equals("MYSQL")){
ConnectionPool connPool = new
ConnectionPool(url,uName,pWord,driverName);
DataAccessObject dataAccess = new DataAccessObjectMYSQL();
dataAccess.setConnectionPool(connPool);
DataTap dataSource = (DataTap)dataAccess;
return dataSource;
}else if(dbType.equals("TXT")){
DataAccessObject dataAccess = new DataAccessObjectTXT();
DataTap dataSource = (DataTap)dataAccess;
return dataSource;
}
return null;
}
}
