resultset对象如何获取当前行的某一列值，求大神指点指点啊，下面是代码

代码
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class VideolistServlet extends HttpServlet
{
  public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
    {
        PreparedStatement sql;
        String VideoName = request.getParameter("VideoName");
     response.setContentType("String/html");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
        String result_VideoName= null;
ResultSet rs;
        String uri = "jdbc:mysql://127.0.0.1/videopro";
        String selectsql = "SELECT * FROM `videopro`.`video` ";
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection(uri, "root", "123");
            sql = conn.prepareStatement(selectsql);
            rs = sql.executeQuery(selectsql);
           while (rs.next())
                  {VideoName=rs.getString("VideoName");
                    result_VideoName=VideoName;
                    out.println(result_VideoName);
                   }
            conn.close();
        }
        catch (Exception e)
        {
            System.out.print(e);
        }
        out.flush();
        out.close();
    }

}
这样运行的结果是把数据库里的一列值都给给读出来了，并且显示到一个listview当中了，我想把它们按行分开显示到listview当中，求大家指点指点哈，下面是我的数据库的列表
]

--------------------编程问答--------------------



import java.io.IOException;

import java.io.PrintWriter;

import java.sql.*;

import java.util.List;



import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;



public class VideolistServlet extends HttpServlet

{

  public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

        PreparedStatement sql;

        String VideoName = request.getParameter("VideoName");

        response.setContentType("String/html");

        response.setCharacterEncoding("utf-8");

        PrintWriter out = response.getWriter();

        String result_VideoName= null;

        ResultSet rs; 

        String uri = "jdbc:mysql://127.0.0.1/videopro";

        String selectsql = "SELECT * FROM `videopro`.`video` ";

        try{

            Class.forName("com.mysql.jdbc.Driver");

            Connection conn = DriverManager.getConnection(uri, "root", "123");

            sql = conn.prepareStatement(selectsql);

            rs = sql.executeQuery(); 

            while (rs.next()){

                    VideoName=rs.getString("VideoName");

                    String src = rs.getString("Src");

                    result_VideoName=VideoName;

                    out.println(result_VideoName + "\t" + src);

            }

            conn.close();

        }catch (Exception e){

            System.out.print(e);

        }

        out.flush();

        out.close();

    }       

}

不知道这个是不是你想要的 --------------------编程问答-------------------- 非常感谢你的指导，我调试调试 --------------------编程问答--------------------

运行完的结果是这样的，我想把它们每条对应到一个listview当中，不知道怎么弄，我找不到resulset选某一行的方法，求甚解啊 --------------------编程问答-------------------- 每行对应到一个LISTVIEW？是个什么意思？
你把每个字段都读出来，展现就完了不是吗？
建议你定义一个POJO对象，到前台完成展现 --------------------编程问答--------------------

封装到Bean里嘛。

补充：Java ,  Java相关