使用selenium获取数据库行(Phpmyadmin)数据表

Question

我刚认识硒司机。如何从数据库表中获取行数据。我试过以下代码:我的数据库名为"demodatabase“，表名为"state”，行id为2。

package com.db;

import java.sql.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;



public class DbConnection {

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

        /*------connection url----*/
        String dbUrl= "jdbc:mysql://localhost/demodatabase";

        /*------dbUsername----*/
        String dbUsername= "root";

        /*------dbPassword----*/
        String dbPassword= "";

        /*------db query---*/
        String query= "select * from states where id=2";

        /*-----load Mysql jdbc driver------*/
        Class.forName("com.mysql.jdbc.Driver");


        /*----Get connection to DB*/
        Connection con = DriverManager.getConnection(dbUrl, dbUsername, dbPassword);

        //create statement object
        Statement stmt = con.createStatement();

        //send sql query to database
        ResultSet rs= stmt.executeQuery(query);


        // while loop to get ResultSet all rows data
        while(rs.next()){
            String state =rs.getString("2");
            System.out.println(state);
        }

        //Close db connection

        con.close();
    }

}

数据库表截图

http://i.stack.imgur.com/dcaGc.png

使用上面的代码和数据库截图，.I只获取id=2和列2的数据，即Jharkhand，但是我想要第2行的所有数据。

Answer 1

在上面的代码中，您没有得到表的第二行的列值。

请参阅以下代码

包装com.db；

import java.sql.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;



public class DbConnection {

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

        /*------connection url----*/
        String dbUrl= "jdbc:mysql://localhost/demodatabase";

        /*------dbUsername----*/
        String dbUsername= "root";

        /*------dbPassword----*/
        String dbPassword= "";

        /*------db query---*/
        String query= "select * from states where id=2";

        /*-----load Mysql jdbc driver------*/
        Class.forName("com.mysql.jdbc.Driver");


        /*----Get connection to DB*/
        Connection con = DriverManager.getConnection(dbUrl, dbUsername, dbPassword);

        //create statement object
        Statement stmt = con.createStatement();

        //send sql query to database
        ResultSet rs= stmt.executeQuery(query);


        // while loop to get ResultSet all rows data
        while(rs.next()){

            //Store columns state,country,created,modified as separate strings 

            //(pls chk spellings of column name and also datatypes of the column if it is int change it to (rs.getInt) before running)

            String state =rs.getString("name");
            String country =rs.getString("country_id");
            String created_DATE= rs.getString("created");
            String modified_DATE=rs.getString("modified");
            System.out.println(state);
            System.out.println(country);
            System.out.println(created_DATE);
            System.out.println(modified_DATE);
        }

        //Close db connection

        con.close();
    }

}

希望这能帮助you...Kindly在不起作用的情况下恢复正常