1 package com.znker.jdbc;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 import java.sql.Statement;
 8 
 9 public class JDBCDemo {
10 
11     public static void main(String[] args) {
12         // 数据库连接的引用变量
13         Connection conn = null;
14 
15         // 加载数据库连接驱动
16         try {
17             Class.forName("com.mysql.jdbc.Driver");
18         } catch (ClassNotFoundException e) {
19             e.printStackTrace();
20         }
21 
22         // 获取一个数据库连接
23         try {
24             conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctest", "root", "1234");
25         } catch (SQLException e) {
26             e.printStackTrace();
27         }
28         
29         // 查询语句
30         String sql = "select id, name, email from CustomerTb1";
31 
32         try {
33             // 创建一个语句
34             Statement stmt = conn.createStatement();
35             // 执行一个查询，获得一个结果集
36             ResultSet rs = stmt.executeQuery(sql);
37             
38             // 遍历并输出结果集，结果集是一个带游标的数组
39             while (rs.next()) {
40                 int id = rs.getInt(1);
41                 String name = rs.getString(2);
42                 String email = rs.getString(3);
43 
44                 System.out.println(id + ", " + name + ", " + email);
45             }
46         } catch (SQLException e) {
47             e.printStackTrace();
48         } finally {
49             if (conn != null) {
50                 try {
51                     conn.close();
52                 } catch (SQLException e) {
53                     e.printStackTrace();
54                 }
55             }
56         }
57 
58     }
59 }