Java 用jdbc连接数据库

Java 用jdbc连接数据库

准备

安装mysql

下载 mysql-connector-java-5.1.40-bin.jar驱动包

步骤

1. 创建jdbc项目

2. 导入mysql-connector-java-5.1.40-bin.ja包

3. 创建配置文件

jdbc.properties

user=root

password=1230

driverClass=com.mysql.jdbc.Driver

jdbcUrl=jdbc:mysql:///atguigu

 

 

1. 代码

 

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 = new    Properties();

        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;

        

    }

    public static void main(String[] args) throws IOException, SQLException {

        System.out.println(getConnection());

    }

}