Shulou(Shulou.com)06/02 Report--

This article is about how to use mirror source to connect to mysql5.7 database in java. I think it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it.

1. First of all, build a database at random, and create a dynamic 2.5web project in eclipse.

2. Build a uitls package

Package utils

Import com.alibaba.druid.pool.DruidDataSourceFactory

Import com.sun.org.apache.bcel.internal.generic.NEW

Import javax.sql.DataSource

Import java.io.IOException

Import java.io.InputStream

Import java.sql.Connection

Import java.sql.SQLException

Import java.util.Properties

/ * *

* the JDBC utility class uses Durid connection pooling

, /

Public class JDBCUtils {

Private static DataSource ds

Static {

Try {

/ / 1. Load configuration file

Properties pro = new Properties ()

/ / load the configuration file using ClassLoader to get the byte input stream

InputStream is = JDBCUtils.class.getClassLoader () .getResourceAsStream ("druid.properties")

Pro.load (is)

/ / 2. Initialize connection pooling object

Ds = DruidDataSourceFactory.createDataSource (pro)

} catch (IOException e) {

E.printStackTrace ()

} catch (Exception e) {

E.printStackTrace ()

}

}

/ * *

* get connection pool object

, /

Public static DataSource getDataSource () {

Return ds

}

/ * *

* get the connection Connection object

, /

Public static Connection getConnection () throws SQLException {

Return ds.getConnection ()

}

Public static void main (String args []) throws SQLException {

System.out.println ("connection successful" + new JDBCUtils () .getConnection ())

}

}

3. Create a text under src named durid.properties. The contents are as follows

DriverClassName=com.mysql.jdbc.Driver

Url=jdbc:mysql://localhost:3306/db_food?useUnicode=true&characterEncoding=utf-8

Username=root

Password=123456

InitialSize=5

MaxActive=10

MaxWait=3000

4. Finally, the output of this string indicates that you are connecting to ok.

The above is how to use the mirror source in java to connect to the mysql5.7 database. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.