JDBC连接数据库

简介

编写步骤

public static void main(String[] args) throws Exception {
        //JDBC
        //1.注册驱动
        Class.forName("com.mysql.jdbc.Driver");

        //2.获取连接
        String url = "jdbc:mysql://127.0.0.1:3306/itcast";
        String username = "root";
        String password = "123456";
        Connection conn = DriverManager.getConnection(url, username, password);

        //3.定义sql语句
        String sql = "update account set money = 2000 where name = '李四';";

        //4.获取执行sql的对象 Statement
        Statement stmt = conn.createStatement();

        //5.执行sql
        int count = stmt.executeUpdate(sql);//收影响行数

        //6.打印处理结果
        System.out.println(count);

        //7.释放资源
        stmt.close();
        conn.close();
    }

API详解

DriverManager

1.注册驱动

2.获取数据库连接

Connection conn = DriverManager.getConnection(url, username, password);

Connection

数据库连接对象

1.获取执行sql的对象

2.管理事务

Statement

执行sql语句

ResultSet

package com.itzjl;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

/*
* JDBC API PreporedStatement (防止sql注入)
* */
public class JDBCDemo5_ResulSet {
    public static void main(String[] args) throws Exception {
        //声明Array集合
        ArrayList<Account> list = new ArrayList<>();

        //JDBC
        //1.注册驱动
//        Class.forName("com.mysql.jdbc.Driver");

        //2.获取连接
        String url = "jdbc:mysql://127.0.0.1:3306/itcast?useSSL=false&allowPublicKeyRetrieval=true";
        String username = "root";
        String password = "123456";
        Connection conn = DriverManager.getConnection(url, username, password);

        //3.定义sql语句
        String sql = "select * from account;";

        //4.获取执行sql的对象 Statement
        Statement stmt = conn.createStatement();

        //5.执行sql
        ResultSet rs = stmt.executeQuery(sql);

        //6.处理结果
        while (rs.next()){
            String name =  rs.getString("name");
            int monry = rs.getInt(2);
            Account account = new Account(name,monry);
            list.add(account);
            System.out.println(account);
        }

        //7.释放资源
        rs.close();
        stmt.close();
        conn.close();

        for (int i = 0; i < list.size(); i++) {
            System.out.println(list.get(i));
        }
    }
}

PreparedStatement

 

数据库连接池

DataSourxe

Druid（德鲁伊）连接池

链接步骤：

        //1.导入jar包
        //2.定义配置文件
        //3.加载配置
        Properties prop = new Properties();
        prop.load(new FileInputStream("src/druid.properties"));
        //4.获取连接池对象
        DataSource dataSource = DruidDataSourceFactory.createDataSource(prop);
        //5.获取连接
        Connection conn = dataSource.getConnection();

配置文件

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/itcast?useSSL=false&allowPublicKeyRetrieval=true
username=root
password=123456
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
#最大等待时间
maxWait=3000