教教我如何遍历这个数组
um.java |
————
package edu.j2ee;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
public class um {
public um() {}
public static String[] getMsg(){
String[] list = new String[4];
try{
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/book");
con = ds.getConnection();
stmt = con.prepareStatement("SELECT * FROM table1");
rs = stmt.executeQuery();
while(rs.next()) {
String n1 = rs.getString(1);
String n2 = rs.getString(2);
String n3 = rs.getString(3);
String n4 = rs.getString(4);
list[0] = n1;
list[1] = n2;
list[2] = n3;
list[3] = n4;
}
}
catch(Exception e){}
return list;
}
}
***********************************************************
us.java |
————
package edu.j2ee;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import edu.j2ee.um;
public class us extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException
{
response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter();
String[] array = new String[4];
out.print("<font color=\"003300\">"+array[0]+" "+array[1]+" "+array[2]+" "+array[3]+"</font>\r\n");
}
}
--------------------------
那对于servlet us.java中的数组array,如何做才能遍历一次呢,现在只能取到数据库最后一条数据,而不能全部获取.