JDBC连接mySQL进行学生信息的查询和插入

1.在数据库中新建表格（做简单的插入）

CREATE DATABASE student; CREATE TABLE studentinfo( id INT PRIMARY KEY, id_name VARCHAR(20), gender VARCHAR(20), age INT); INSERT INTO studentinfo(id,id_name,gender,age)VALUES(001,"join","male",19); INSERT INTO studentinfo(id,id_name,gender,age)VALUES(002,"mark","male",20); INSERT INTO studentinfo(id,id_name,gender,age)VALUES(003,"lily","female",18); INSERT INTO studentinfo(id,id_name,gender,age)VALUES(004,"Jerry","female",19); SELECT *FROM studentinfo;

2.在idea导入驱动文件，在下面链接中已介绍具体下载jar包方法https://blog.csdn.net/LemonYaQian/article/details/108921167 下载完毕后导入idea 在SRC下可以新建Lib包，将下载的驱动文件复制在此导入即可。 3.jdbc连接数据库的类

package com.stu; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import static java.sql.DriverManager.getConnection; public class Jdbc { public static void main(String[] args) throws Exception { Connection con = null; Statement state = null; ResultSet rs = null; try { String driverClassName = "com.mysql.cj.jdbc.Driver"; String URL = "jdbc:mysql://localhost:3306/student?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC"; String username = "root"; String password = "wyq123"; Class.forName(driverClassName);//加载驱动 con = getConnection(URL, username, password);//调用驱动的参数获得连接 state = con.createStatement();//得到Statement对象 rs = state.executeQuery("SELECT *FROM studentinfo");//调用Statement的结果集查询 System.out.println(rs); while (rs.next()) {//解析结果集 int id = rs.getInt("id"); String id_name = rs.getString("id_name"); String gender = rs.getString("gender"); int age = rs.getInt("age"); System.out.println(id + "," + id_name + "," + gender + "," + age); } int aInt = state.executeUpdate("insert into studentinfo values(007,'marry','female',20)"); System.out.println(); System.out.println(aInt); } catch (Exception e) { e.printStackTrace(); } finally { if (rs != null) rs.close(); if (state != null) state.close(); if (con != null) con.close(); } } }

这里注意避坑：

MySQL 8.0 以上版本驱动包版本：

Class.forName("com.mysql.cj.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC");

MySQL 8.0 以下版本驱动包版本：

Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student);