004-DAO-gai

2013-6-28
Data Access Object
13
Softeem Consultancy Service
Hale Waihona Puke Abstract Factory (org.broadengate.jdbc.dao.af)
client.java Connection conn = DataSourceFactory.getDataSource().getConnection(); try { conn.setAutoCommit(false); CustomerDAO customerDAO = DAOFactory.getDAOFactory( DAOFactory.SQLSERVER).getCustomerDAO(conn); CustomerDTO customer = new CustomerDTO(); customer.setAddress("china"); customer.setId("1002"); customer.setName(“softeem"); customerDAO.add(customer); UserDAO userDAO = DAOFactory.getDAOFactory(DAOFactory.SQLSERVER).getUserDAO(co nn); …… mit();
DataSourceFactory.getDataSource().getConnection();
CustomerDTO customer = new CustomerDTO() ; customer.setAddress("china"); customer.setId("1002"); customer.setName("broadengate"); customerDAO.add(customer); customerDAO.delete("1001"); mit();
customerDAO.delete("1001"); mit();
2013-6-28 Data Access Object 5
Softeem Consultancy Service
2. Data Access Object Factory Strategies
– – Factory Method Abstract Factory
2013-6-28
Data Access Object
11
Softeem Consultancy Service
Abstract Factory (org.broadengate.jdbc.dao.af)
public class SQLServerDAOFactory extends DAOFactory { public CustomerDAO getCustomerDAO(Connection conn) { CustomerDAO customer = new CustomerSQLDAO(conn) ; return customer; }
CustomerDAO -conn : Connection Client +find(in id : String) : CustomerDTO +delete(in id : String) : int +add(in customer : CustomerDTO) : int +update(in customer : CustomerDTO) : int +findAll() : List +CustomerDAO(in conn : Connection) <<uses>>+CustomerDAO() <<接口>> ResultSet
2013-6-28
Data Access Object
12
Softeem Consultancy Service
Abstract Factory (org.broadengate.jdbc.dao.af)
public interface CustomerDAO { public CustomerDTO find(String id); public boolean edit(CustomerDTO customer); public boolean add(CustomerDTO customer); public boolean delete(String id); public List findAll(); }
Client
DAOFactory +getCustomerDAO(in conn : Connection) : CustomerDAO +getUserDAO(in conn : Connection) : UserDAO
CustomerSQLDAO CustomerDAO CustomerDTO -id : String -name : String -address : String -conn : Connection +add() +delete() +edit() +find() +findAll() UserSQLDAO UserDAO +add() +delete() +edit() +find() +findAll()
2013-6-28 Data Access Object 9
Softeem Consultancy Service
Abstract Factory
ConnectionFactory -datasource : DataSource +getConnection() : Connection PostgresDAOFacotry OracleDAOFacotry
CustomerDTO -id : String -name : String -address : String
2013-6-28
Data Access Object
4
Softeem Consultancy Service
1. Custom Data Access Object Strategy
2013-6-28
Data Access Object
3
Softeem Consultancy Service
1. Custom Data Access Object Strategy
ConnectionFactory -datasource : DataSource +getConnection() : Connection <<uses>> <<接口>> DataSource
Connection conn =
DataSourceFactory.getDataSource().getConnection();
try { CustomerDAO customerDAO = new CustomerDAO(conn); conn.setAutoCommit(false); CustomerDTO customer = new CustomerDTO() ; customer.setAddress("china"); customer.setId("1002"); customer.setName("broadengate"); customerDAO.add(customer);
2013-6-28
Data Access Object
7
Softeem Consultancy Service
Factory Method(org.broadengate.jdbc.dao.fm)
DAOFactory.java
public static CustomerDAO getCustomerDAO(Connection conn){ CustomerDAO customer = new CustomerDAO(conn) ; return customer; }
Client
DAOFactory +getCustomerDAO(in conn : Connection) : CustomerDAO +getUserDAO(in conn : Connection) : UserDAO
<<uses>>
CustomerDAO CustomerDTO -id : String -name : String -address : String -conn : Connection +find(in id : String) : CustomerDTO +delete(in id : String) : int +add(in customer : CustomerDTO) : int +update(in customer : CustomerDTO) : int +findAll() : List +CustomerDAO(in conn : Connection) +CustomerDAO() <<接口>> ResultSet
2013-6-28
Data Access Object
6
Softeem Consultancy Service
Factory Method
ConnectionFactory -datasource : DataSource +getConnection() : Connection <<uses>> <<接口>> DataSource