day108 - jdbc复习

jdbc复习

导包

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