MySQL tutorial--detailed explanation of the operation of connecting to the database through the configuration file

This article mainly introduces the relevant information about mysql connecting to the database through the configuration file. It is mainly the implementation of a single-case Hungry-style database connection method tool class. Friends who need it can refer to it

Mysql links the database through the configuration file

Configuration file jdbc.properties

##MySQL
driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\:///ake?useUnicode\=true&characterEncoding\=UTF-8
username=root
password=1234

##Oracle
#driver=oracle.jdbc.driver.OracleDriver
#url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
#username=scott
#password=tiger

Let’s talk about it briefly. The configuration file writes the database information of MySQL and Oracle. My database is mysql, so I commented out the Oracle configuration information.

The next step is a singleton (hungry Chinese style) tool class to obtain the database connection method

package Studying.d15;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class ConnUtils {
  private static Connection con = null;

  static{
    try {
      Properties p = new Properties();
      p.load( new FileInputStream("jdbc.properties") );
      String driver = p.getProperty("driver");
      String url = p.getProperty("url");
      String username = p.getProperty("username");
      String password = p.getProperty("password");
      System.out.println(url+","+driver);
      Class.forName(driver);
      con = DriverManager.getConnection(url, username, password);
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  public static Connection getConnection(){
    return con;
  }
}

The above is the detailed content of MySQL tutorial--detailed explanation of the operation of connecting to the database through the configuration file. For more information, please follow other related articles on the PHP Chinese website!