ibatis实现的CRUD(工厂+单例)

package service; public class AccountServiceFactory { private AccountServiceFactory() { } public static IAccountService getService() { return new AccountServiceImpl(); } }

工厂模式可以灵活的对JDBC和IBATIS的实现的装换

package persist; public class AccountDAOFactory { private AccountDAOFactory() { } public static IAccountDAO getDAO() { // return new AccountDAOJDBCImpl(); return new AccountDAOIBATISImpl(); } }

package persist; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class JdbcUtil { static { String driverName = "com.mysql.jdbc.Driver"; try { Class.forName(driverName); } catch (Exception e) { e.printStackTrace(); } } public static Connection getConnection() { Connection con = null; String url = "jdbc:mysql://localhost/test"; String user = "root"; String pwd = "root"; try { con = DriverManager.getConnection(url, user, pwd); } catch (Exception e) { e.printStackTrace(); } return con; } public static void close(ResultSet rs, Statement stmt, Connection con) { try { if (rs != null) rs.close(); } catch (Exception ex) { ex.printStackTrace(); } try { if (stmt != null) stmt.close(); } catch (Exception ex) { ex.printStackTrace(); } try { if (con != null) con.close(); } catch (Exception ex) { ex.printStackTrace(); } } }