代码无法读取数据库所有数据，只能输出刚输入的那个数据，是不代码有问题，帮看下
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>投票</title>
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
String s_name=request.getParameter("name");
if(s_name == null){s_name="";}
String s_sex=request.getParameter("sex");
if(s_sex == null){s_sex="";}
String s_phone=request.getParameter("phone");
if(s_phone == null){s_phone="";}
%>
<%
String sql;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:vote","sa","jintian");
Statement stmt=conn.createStatement();
try{
sql="Insert Into vote(aname,asex,aphone) Values('"+s_name+"','"+s_sex+"','"+s_phone+"')";
stmt.executeUpdate(sql);
ResultSet rs;
rs=stmt.executeQuery("Select * From vote where aname='"+s_name+"'");
%>
<%
while(rs.next()){
%>
<table align="center" border="1" bordercolor="#000000">
<tr><td>姓名</td><td>性别</td><td>手机品牌</td>
<tr>
<td width="50"><%=rs.getString("aname")%></td>
<td width="50"><%=rs.getString("asex")%></td>
<td width="50"><%=rs.getString("aphone")%></td>
</tr>
</table>
<%
}
rs.close();
}
catch(Exception e){
out.println(e.getMessage());
}
stmt.close();
conn.close();
%>
</body>
</html>
------解决方案--------------------------------------------------------
楼上的 statement 他下面有关闭
是你这个 Select * From vote where aname='"+s_name+"' 语句的条件控制了
Select * From vote 这个不就是全部吗？
------解决方案--------------------------------------------------------