Java数据库最小化连接创建

您可以像这样使用设计模式Singleton Connection：

1-创建一个类SingletonConnection.java如下所示：

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.EmptyStackException;public class SingletonConnection   {    private static Connection connection = null ;    static     {        try{ Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection         ("jdbc:mysql://localhost:3306/gestion_comptes","root","");        }catch(Exception ex)        {        }    }    public static Connection getConnection() throws Exception {        return connection;    }}

在其他班级中这样称呼它：

 public  class DaoImpl{        public Connection connection = SingletonConnection.getConnection();        public DaoImpl() throws Exception         { if(connection==null)     throw new Exception("impossible de se connecter à la base de données");        }}