package LinkMySQL;

 import java.sql.Connection;

 import java.sql.DriverManager;

 import java.sql.SQLException;

 public class LinkToMySQLImp

 {

     /*

      *java连接数据库

      *1.加载驱动程序

      *2.数据库连接字符串

      *3.数据库登录名和密码

      *4.最后关闭。

      */

     private static final String URL="jdbc:mysql://localhost:3306/1.1?useSSL=false&serverTimezone=UTC";

     private static final String USER="root";

     private static final String PASSWORD="xcl123";

     public static void main(String args[])

     {//加载驱动

         try

         {

             Class.forName("com.mysql.cj.jdbc.Driver");

         }

         catch (ClassNotFoundException e)

         {

             System.out.println("未能成功加载驱动!");

             e.printStackTrace();

         }

         Connection coon=null;

         try {

             coon=DriverManager.getConnection(URL, USER, PASSWORD);

             System.out.println("获取数据库连接成功");

         }

         catch (SQLException e)

         {

             System.out.println("获取数据库连接失败");

             e.printStackTrace();

         }

         if(coon!=null)

         {

             try {

                 coon.close();

             }

             catch (SQLException e)

             {

                 e.printStackTrace();

                 coon=null;

             }

         }

     }

 }