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

Java prepares to connect to the database with jdbc

Install mysql

Download the mysql-connector-java-5.1.40-bin.jar driver package

To create a jdbc project import mysql-connector-java-5.1.40-bin.ja package to create a configuration file

Jdbc.properties

User=root

Password=1230

DriverClass=com.mysql.jdbc.Driver

JdbcUrl=jdbc:mysql:///atguigu

Code

Import java.io.IOException

Import java.io.InputStream

Import java.util.Properties

Import java.sql.DriverManager

Import java.sql.SQLException

Import com.mysql.jdbc.Connection

Public class JDBCTools {

Public JDBCTools () {

}

Public static Connection getConnection () throws IOException, SQLException {

Connection conn = null

Properties properties = newProperties ()

InputStream inStream = JDBCTools.class.getClassLoader ()

.getResourceAsStream ("jdbc.properties")

Properties.load (inStream)

String user = properties.getProperty ("user")

String password = properties.getProperty ("password")

String driverClass = properties.getProperty ("driverClass")

String jdbcUrl = properties.getProperty ("jdbcUrl")

Conn = (Connection) DriverManager.getConnection (jdbcUrl,user,password)

Return conn

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.