JDBC
1.需要jar包mysql-connector-java-8.0.13.jar
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class Test { public static void main(String[] args) throws Exception { // System.out.println("Hello World!"); // 1.注册驱动 DriverManager.registerDriver(new com.mysql.jdbc.Driver()); // 2.获取连接 Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT", "root", "mysql"); // 3.获取操作数据库的预处理对象 PreparedStatement pstm = conn.prepareStatement("select * from student_info"); // 4.执行sql语句并夺取返回结果 ResultSet rs = pstm.executeQuery(); // 5.封装结果集 while (rs.next()){ System.out.println(rs.getString("name")); } //6.释放资源 rs.close(); pstm.close(); conn.close(); } }
2.数据库
3.运行如下