请大家帮忙！

传一个参数过去，每次select的时候按这个参数字段排序，很容易啊

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

参考一下：%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
    <title>查询</title>
</head><body>
<%
  ResultSet rs;
access.access_dbconnect as = new access.access_dbconnect();
String sql = "select * from user_info";
String condition = request.getParameter("condition");
if((condition != null) && (!condition.equals("")))
{
sql += " order by " + condition;
}
  out.println(sql);
  rs = as.executeQuery(sql);
  while(rs.next())
      {
%>
姓名：<%=rs.getString("name")%>
</p>
<% }
as.close();
%>
<hr><form name="select"><input type="button" name="xm" value="按姓名" onclick="xmselect()">
</form>
<script language="javascript">

</script>
</body>
</html>
参考一下：%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
    <title>查询</title>
</head><body>
<%
  ResultSet rs;
access.access_dbconnect as = new access.access_dbconnect();
String sql = "select * from user_info";
String condition = request.getParameter("condition");
if((condition != null) && (!condition.equals("")))
{
sql += " order by " + condition;
}
  out.println(sql);
  rs = as.executeQuery(sql);
  while(rs.next())
      {
%>
姓名：<%=rs.getString("name")%>
</p>
<% }
as.close();
%>
<hr><form name="select"><input type="button" name="xm" value="按姓名" onclick="xmselect()">
</form>
<script language="javascript">

</script>
</body>
</html>
Email:   [email protected]
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
    <title>²éÑ¯</title>
</head>
<form name="select2">
<input type="hidden" name="control" >
</form>
<body>
<%
  ResultSet rs;
access.access_dbconnect as = new access.access_dbconnect();
String sql = "select * from user_info";
String condition = request.getParameter("condition");
String control = request.getParameter("control");
out.println("control == " + control);
if(control == null || control.equals(""))
{
%>
<script language="javascript">
document.select2.control.value="desc";
</script>
<%
}
else
{
%>
<script language="javascript">
document.select2.control.value="";
</script>

<%

} if((condition != null) && (!condition.equals("")))
{
sql += " order by " + condition;
if((control != null))
{
sql += " " + control;

}

}

  out.println(sql);
  rs = as.executeQuery(sql);
  while(rs.next())
      {
%>
ÐÕÃû£º<%=rs.getString("name")%>
</p>
<% }
as.close();
%>
<hr><form name="select"><input type="button" name="xm" value="°´ÐÕÃû" onclick="xmselect()"></form>
<script language="javascript">

</script></body>
</html>