java如何用MySQL语句查询_如何使用 Java 来执行 SQL 查询-百度经验

下图显示了对该数据库的简单查询, 将结果填充到常规 Java 类型中：

@Testpublic void retrieveRows() throws SQLException{    Connection connection = DriverManager.getConnection(            "jdbc:mysql://localhost:3306/mytest",            "root",            "root");    Statement stmt = connection.createStatement();    ResultSet rs = stmt.executeQuery("select employee_number,name from employees");    Map employeeMap = new HashMap<>();    while (rs.next()) {        int employeeNumber = rs.getInt("employee_number");        String name = rs.getString("name");        employeeMap.put(employeeNumber,name);    }    Map expectedMap = new HashMap(){{        put(1,"Bob Smith");        put(2,"Alice Smith");    }};    System.out.println(expectedMap.equals(employeeMap));    rs.close();    stmt.close();}