导包
<dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.28</version> </dependency> </dependencies>
测试
public class TestJDBC { public static void main(String[] args) throws ClassNotFoundException, SQLException { //配置信息 String url = "jdbc:mysql://localhost:3306/jdbcstudy?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSl=true"; String username = "root"; String password = "123456"; //加载驱动 Class.forName("com.mysql.jdbc.Driver"); //链接数据库 Connection connection = DriverManager.getConnection(url, username, password); //向数据库发送sql的对象statement:crud Statement statement = connection.createStatement(); //编写sql String sql = "select * from users"; //执行sql ResultSet resultSet = statement.executeQuery(sql); while (resultSet.next()) { System.out.println("id=" + resultSet.getObject("id")); System.out.println("name=" + resultSet.getObject("name")); System.out.println("password=" + resultSet.getObject("password")); System.out.println("email=" + resultSet.getObject("email")); System.out.println("birthday=" + resultSet.getObject("birthday")); } //关闭链接,释放资源,先开后关 resultSet.close(); statement.close(); connection.close(); } }
over