java程序仅给出数据库表 "Users"MSSQL的第一列

Question

我遇到一个问题，我连接到数据库，但无法检索超过第一列的内容，即使我的查询语句是“Select * from Users”下面是我的代码:

import java.sql.*;


public class Connecttodb {
public void dbConnect(String db_connect_string,String db_UserID,String db_UserPass)
{
    try{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection conn = DriverManager.getConnection(db_connect_string,db_UserID,db_UserPass);
        System.out.println("connected");
        Statement statement= conn.createStatement();
        String querystring = "SELECT * FROM Users";
        ResultSet rs = statement.executeQuery(querystring);
        while(rs.next()){
            System.out.println(rs.getString(1));
        }
    }catch(Exception e){
        e.printStackTrace();
    }
}

public static void main(String[] args) {
    // TODO Auto-generated method stub
    Connecttodb connServer= new Connecttodb();
    connServer.dbConnect("jdbc:sqlserver://TGOURDINE-PC\\SQLEXPRESS;databaseName=picture website", "tgourdine", "thomas");
}

}

结果只有第一列，UserID:

connected
1
2
3

我想要的结果如下:

connected
1 tgourdini thomas NULL NULL
2 Geoff     Marley NULL NULL
3 tara      Elaine NULL NULL

谢谢，

Answer 1

根据documentation getString(1) 将仅返回第一列。