<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<html>
<head><title>用户注册成功</title></head>
<body>
<%@ include file="convert.jsp" %>
<%
Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String strConn="jdbc:sqlserver://localhost:1433;DatabaseName=ShopSystem";
String strUser="sa";
String strPassword="123456";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
String a_name=Bytes(request.getParameter("a_name"));
String a_pass=Bytes(request.getParameter("a_pass"));
String a_header=Bytes(request.getParameter("a_header"));
String a_phone=Bytes(request.getParameter("a_phone"));
String a_email=Bytes(request.getParameter("a_email"));
String strSql="insert into admin values(?,?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(strSql);
pstmt.setString(1,a_name);
pstmt.setString(2,a_pass);
pstmt.setString(3,a_header);
pstmt.setString(4,a_phone);
pstmt.setString(5,a_email);
int intTemp=pstmt.executeUpdate();
if(intTemp!=0)
{
out.println( "<center><h3>" + "用户注册成功" + "</h3></center>");
}
else
{
out.println( "<center><h3>" + "用户注册失败" + "</h3></center>");
}
String strSql2="SELECT TOP 1 a_name,a_pass,a_header,a_phone,a_email FROM admin WHERE a_name=? order by a_email desc";
PreparedStatement pstmt2=conn.prepareStatement(strSql2);
pstmt2.setString(1,"red");
ResultSet rs=pstmt2.executeQuery();
%>
<table border="1" align="center">
<tr>
<th>用户名称</th>
<th>用户密码</th>
<th>用户头像</th>
<th>联系电话</th>
<th>用户邮箱</th>
</tr>
<%while(rs.next()){%>
<tr bgcolor="lightblue">
<td><%=rs.getString("a_name") %></td>
<td><%=rs.getString("a_pass") %></td>
<td><%=rs.getString("a_header") %></td>
<td><%=rs.getString("a_phone") %></td>
<td><%=rs.getString("a_email") %></td>
</tr>
<% }%>
</table>
<%
pstmt.close();
pstmt2.close();
conn.close();
}
catch(Exception e)
{
out.println(e.toString());
}
%>
</body>
</html>
用户注册时，往数据库插入数据，怎么用preparedstatement查询我刚插入的数据并显示出来？
求大神！！！！！
------解决思路----------------------
查询时传参不对？
String strSql2="SELECT TOP 1 a_name,a_pass,a_header,a_phone,a_email FROM admin WHERE a_name=? order by a_email desc";
PreparedStatement pstmt2=conn.prepareStatement(strSql2);
pstmt2.setString(1,"red"); //这里不应该是a_name吗
当然首先要保证那张表有数据