JDBC连接数据库示例2（预编译）

1，导入依赖

        <!--连接数据库依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.24</version>
        </dependency>

2，编写代码

package com.lt.test;
import java.sql.*;

public class TestJdbc2 {
   public static void main(String[] args) throws Exception {
       //配置信息
       //useUnicode=true&characterEncoding=utf-8解决中文乱码问题
       String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8";
       String username = "root";
       String password = "123456";
       //1.加载驱动
       Class.forName("com.mysql.cj.jdbc.Driver");
       //2.连接数据库 connection代表数据库
       Connection connection = DriverManager.getConnection(url, username, password);
       //4.编写SQL
       String sql = "insert into users(id,`name`,password,email,birthday)values (?,?,?,?,?);";
       //4.预编译
       //Statement statement = connection.createStatement();
       PreparedStatement preparedStatement = connection.prepareStatement(sql);
       //5.执行SQL语句
       preparedStatement.setInt(1,5);
       preparedStatement.setString(2,"周七");
       preparedStatement.setString(3,"123456");
       preparedStatement.setString(4,"22700079@qq.com");
       preparedStatement.setDate(5, new Date(new java.util.Date().getTime()));

       int i = preparedStatement.executeUpdate();
       if(i>0){
           System.out.println("插入成功！");
       }
       //6，关闭连接，释放资源（一定），先开后管
       preparedStatement.close();
       connection.close();
   }
}