1 import java.awt.List;
 2 import java.sql.Connection;
 3 import java.sql.DriverManager;
 4 import java.sql.SQLException;
 5 import java.util.ArrayList;
 6 
 7 //获取数据库的连接对象
 8 public class DButil {
 9     //声明一个数据库连接对象
10     private Connection connection = null;
11     private String url="jdbc:mysql://127.0.0.1:3306/mysql";
12     private String user="root";
13     private String password="123456";
14     private String drivername="com.mysql.jdbc.Driver";
15     
16     // 为外界提供一哥本类的对象
17     private static DButil instance = null;
18 
19     //第一步， 私有本类本类构造器
20     private DButil() {
21         try {
22             Class.forName(drivername);
23             connection=DriverManager.getConnection(url, user, password);
24             System.out.println("connection"+connection);
25         } catch (ClassNotFoundException e) {
26             e.printStackTrace();
27         } catch (SQLException e) {
28             e.printStackTrace();
29         } 
30     }
31     
32     
33 
34     public static DButil getInstance() {
35         if (instance == null) {
36             instance = new DButil();
37         }
38         return instance;
39     }
40     //外界想要的连接对象 就会调用此方法
41     public Connection getConnection() {
42         return this.connection;
43     }
44     
45     
46 
47 }