import java.sql.*;

public class Test {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");

        // 使用我自己的數(shù)據(jù)庫 test
        String url = "jdbc:mysql://localhost:3306/test";
        
        // 數(shù)據(jù)庫的用戶名和密碼
        String username = "root";
        String password = "root";


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


        Statement statement = connection.createStatement();

        // SQL語句，使用我自己的test數(shù)據(jù)庫下的 boss 表
        String sql = "SELECT * FROM boss";

        ResultSet resultSet = statement.executeQuery(sql);

        // 需要與自己的數(shù)據(jù)庫里的表結(jié)構(gòu)相對應(yīng)
        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();
    }
}