1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

import java.sql.*;

public class Test {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        Class.forName("com.mysql.jdbc.Driver");

        // 使用我自己的数据库 test

        String url = "jdbc:mysql://localhost:3306/test";

        // 数据库的用户名和密码

        String username = "root";

        String password = "root";

        Connection connection = DriverManager.getConnection(url, username, password);

        Statement statement = connection.createStatement();

        // SQL语句，使用我自己的test数据库下的 boss 表

        String sql = "SELECT * FROM boss";

        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("age = " + resultSet.getObject("age"));

        }

        resultSet.close();

        statement.close();

        connection.close();

    }

}