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();
}
}