使用工厂模式实现数据库连接.docxVIP

使用工厂模式（可以使用简单工厂、抽象工厂、工厂方法）实现系统支持多种类型数据库链接的方法[?标签：/z/Search.e?sp=S%E5%B7%A5%E5%8E%82%E6%A8%A1%E5%BC%8Fch=rainbow.wty.tag工厂模式,?/z/Search.e?sp=S%E5%B7%A5%E5%8E%82ch=rainbow.wty.tag工厂,?/z/Search.e?sp=S%E6%8A%BD%E8%B1%A1%E5%B7%A5%E5%8E%82ch=rainbow.wty.tag抽象工厂?]?/z/ShowUser.e?sp=aa444d1b49f02516bd7f5cff1f1fd88bch=rainbow.wty.nickname乀゛尘ゝ?2010-07-04 14:47满意答案?好评率：0%///z/Search.e?sp=S%E6%95%B0%E6%8D%AE%E5%BA%93%E8%BF%9E%E6%8E%A5ch=w.search.yjjlinkcid=w.search.yjjlink数据库连接接口package util;import java.sql.*;public interface DBConnection {?//获取连接对象?public Connection getcon();?//关闭/z/Search.e?sp=S%E6%95%B0%E6%8D%AE%E5%BA%93ch=w.search.yjjlinkcid=w.search.yjjlink数据库的链接?public void closed(ResultSet set, PreparedStatement pre, Connection con);}//mysql连接实现类package util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class DBConnectionMysqlIM implements DBConnection{?private final String DRIVER=com.mysql.jdbc.Driver;?private final String URL=jdbc:mysql://localhost:3306/angel;?public Connection getcon() {?Connection con=null;?try {?Class.forName(DRIVER);?con = DriverManager.getConnection(URL, root, root);?} catch (ClassNotFoundException e) {?// TODO Auto-generated catch block?e.printStackTrace();?} catch (SQLException e) {?// TODO Auto-generated catch block?e.printStackTrace();?}?return con;?}?public void closed(ResultSet set, PreparedStatement pre, Connection con) {?try {?if(set!=null){?set.close();?}?if(pre!=null){?pre.close();?}?if(con!=null){?con.close();?}?} catch (SQLException e) {?// TODO Auto-generated catch block?e.printStackTrace();?}??}}//sqlserver连接实现类package util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class DBConnectionSqlIM implements DBConnection {?private final String DRIVER = com.microsoft.sqlserver.jdbc.SQLServerDriver;?private final String URL = jdbc: