Selenium之JDBC请求

Selenium之JDBC请求：

       Selenium怎样连接MySQL数据库：

       首先在Maven里添加依赖：

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.42</version>
</dependency>

如果是Gradle来构建的话：

compile 'mysql:mysql-connector-java:8.0.7-dmr'

现在要查询某个用户的手机号码：

public static void authenticationGuild() throws ClassNotFoundException, SQLException, InterruptedException {
    //封装获取普通用户手机号码的方法
    String driver = "com.mysql.jdbc.Driver";    //驱动程序名
    String url = "jdbc:mysql://127.0.0.1:3306/base";   //URL指向要访问的数据库名
    String user = "root";
    String password = "。。。。。。。。。。";
    java.sql.Connection con;
    String sql;
    String u_mobile_number = null;
    String telphone;

    Class.forName(driver);  //动态加载驱动程序
    con = DriverManager.getConnection(url, user, password);    //getConnection()方法连接数据库
    if (!con.isClosed())
        System.out.println("数据库连接成功！");
    Statement statement = con.createStatement();    //创建statement类对象，用来执行SQL语句
    sql = "SELECT u_mobile_number FROM base_user WHERE user_type = '0' ORDER BY user_id DESC LIMIT 1;";
    //普通用户
    ResultSet rs = statement.executeQuery(sql);     //ResultSet类，用来存放获取的结果集
    while (rs.next()) {
        u_mobile_number = rs.getString("u_mobile_number");  //获取u_mobile_number这一列的数据
        System.out.println(u_mobile_number);
    }
    rs.close();     //关闭ResultSet对象
    con.close();    //关闭数据库连接
    telphone = u_mobile_number;
}