jdbc的基础查询

课程代码：

 1 package com.kuang.test;
 2 
 3 import java.sql.*;
 4 
 5 public class TestJdbc {
 6     public static void main(String[] args) throws ClassNotFoundException, SQLException {
 7         //配置信息
 8         String url="jdbc:mysql://10.10.18.6:3306/zhoutest?useUnicode=true&characterEncoding=utf-8";
 9         String username="root";
10         String password="root";
11 
12         //1 加载驱动
13         Class.forName("com.mysql.jdbc.Driver");
14         //2 连接数据库
15         Connection connection = DriverManager.getConnection(url, username, password);
16 
17         //3 向数据库发送sql的对象Statement : CRUD
18         Statement statement = connection.createStatement();
19 
20         //4 编写sql
21         String sql="select * from users";
22 
23         //5 执行sql
24         ResultSet rs = statement.executeQuery(sql);
25 
26         while(rs.next()){
27             System.out.println("id="+rs.getObject("id"));
28             System.out.println("name="+rs.getObject("name"));
29             System.out.println("password="+rs.getObject("password"));
30             System.out.println("email="+rs.getObject("email"));
31             System.out.println("birthday="+rs.getObject("birthday"));
32         }
33 
34         //6 关闭连接 先开后关
35         rs.close();
36         statement.close();
37         connection.close();
38     }
39 }
View Code

 

posted @ 2021-04-06 22:49  现在开始JAVA  阅读(40)  评论(0)    收藏  举报