jsp动态查询条件

1. jsp中的<form action 动态参数 怎样根据条件跳转 具体问题：

每个button的onclick事件中写：
判断此次是什么操作。
document.getElementById('form1').action=''; //相应的jsp页面

2. JSP如何实现动态内容更新

var content ="<table id='tb1' width='95%'><tbody></br>"
var trList1="<tr class='title0'>"
+"<td>申请人</td>"
//+"<td>人均使用面积（平方米/人）</td>"
+"<td>0</td>"
+"<td>0-7.5</td>"
+"<td>7.5-10</td>"
+"<td>10-15</td>"
+"</tr>";
content=content+trList1;
for(var i=0;i<dataList.length;i++){
trList="<tr class='even0'>" ;
for(var j=0;j<param.length;j++){
paramName[j]=(dataList[0][param[j]]==null?"无数据":dataList[0][param[j]]);
trList+="<td id='"+i+""+j+"' align='center'>"+paramName[j]+"</td>"
}
trList+="</tr>"
content=content+trList;
}
content += "</tbody></table>";
document.getElementById("renjunTab").innerHTML=content;
}

这是个例子 你可以参考一下 但是你得思考一下 呵呵 祝你成功

3. JSP页面列表动态表的实现

一、在页面上用复选框进行复选，然后把信息写入到XML文件中。二、进行页面展示时候读取xml文件。三、使用反射机制调用类中的get方法四、页面上用标签输出动态表头。五、双重循环在页面上输出动态列。 写XML的struts2处理类：
public class DynamicTbAction extends MySuperAction { public String List(){

return "dynamicTbList";
}

public String set(){
UserVO userVO = (UserVO)session.get("loginUser");
String path = request.getRealPath("/")+"sysconfig\\DynamicTable";
path = path.replace("\\", "/")+"/" + userVO.getUsername()+".xml";
String[] attributes = request.getParameterValues("publicAttribute");
if(attributes.length!= 0){
Element rootElement = new Element("tables");
Element tableElt = new Element("table");
Element tabInx = new Element("publicAttribute");
tableElt.addContent(tabInx);
for (int i = 0; i < attributes.length; i++) {
String attr = attributes[i];
String[] attrs = attr.split(",");
Element attrElement = new Element("column");
attrElement.setAttribute("name", attrs[0]);
attrElement.setAttribute("value", attrs[1]);
tabInx.addContent(attrElement);
}
rootElement.addContent(tableElt);
Document doc = new Document(rootElement);
XMLOutputter out = new XMLOutputter();
String xmlStr = out.outputString(doc);
System.out.println(xmlStr);
System.out.println(path);
try {
out.output(doc, new FileOutputStream(path));
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
return List();
}
} struts2处理到页面的列表： public String List(){
UserVO userVO = (UserVO)session.get("loginUser");
String path = request.getRealPath("/")+"sysconfig\\DynamicTable";
path = path.replace("\\", "/")+"/" + userVO.getUsername()+".xml";
List<String> columnName = JDOMUtil.getColumnNames(path, "publicAttribute");
List<String> columnValue = JDOMUtil.getColumnValue(path, "publicAttribute");
Pagination pagination = systemconfigHelper.queryPageAttribute("from PublicAttributePO", page, 5, "select count(*) from PublicAttributePO");
List<PublicAttributeVO> list = pagination.getList();
List entityList = new ArrayList();
for (Iterator iterator = list.iterator(); iterator.hasNext();) {
PublicAttributeVO publicAttributeVO = (PublicAttributeVO) iterator
.next();
if ("0".equals(publicAttributeVO.getStatus())) {
publicAttributeVO.setStatus("失效");
} else {
publicAttributeVO.setStatus("有效");
}
List<Object> entity = new ArrayList<Object>();
for (Iterator iterator1 = columnValue.iterator(); iterator1.hasNext();) {
String value = (String) iterator1.next();
String methodName = "get" + value;
try {
String[] args={};
Object name = JDOMUtil.invokeMethod(publicAttributeVO, methodName, args);
entity.add(name);
} catch (Exception e) {
e.printStackTrace();
}
}
entityList.add(entity);
}

request.setAttribute("navigation", pagination.pageNavigator("attribute_List.action"));
request.setAttribute("attributeList", entityList);
request.setAttribute("columnName", columnName);
return "attributeList";
}帮助类JDomUtilpublic class JDOMUtil { public static List<String> getColumnNames(String path, String tableName) { List<String> names = new ArrayList<String>(); SAXBuilder saxBuilder = new SAXBuilder();
try {
Document document = saxBuilder.build(path);
Element rootElement = document.getRootElement();
List beanList = rootElement.getChild("table").getChild(tableName)
.getChildren();
for (Iterator iterator = beanList.iterator(); iterator.hasNext();) {
Element elt = (Element) iterator.next();
String name = elt.getAttributeValue("name");
names.add(name);
String value = elt.getAttributeValue("value");
}
} catch (JDOMException e1) {
e1.printStackTrace();
} catch (IOException e1) {
e1.printStackTrace();
}
return names;
} public static List<String> getColumnValue(String path, String tableName) { List<String> values = new ArrayList<String>();
SAXBuilder saxBuilder = new SAXBuilder();
try {
Document document = saxBuilder.build(path);
Element rootElement = document.getRootElement();
List beanList = rootElement.getChild("table").getChild(tableName)
.getChildren();
for (Iterator iterator = beanList.iterator(); iterator.hasNext();) {
Element elt = (Element) iterator.next();
String value = elt.getAttributeValue("value");
values.add(value);
}
} catch (JDOMException e1) {
e1.printStackTrace();
} catch (IOException e1) {
e1.printStackTrace();
}
return values;
} public static Object invokeMethod(Object methodObject, String methodName,
Object[] args) throws Exception {
Class ownerClass = methodObject.getClass();
Class[] argsClass = new Class[args.length];
for (int i = 0, j = args.length; i < j; i++) {
argsClass[i] = args[i].getClass();
}
Method method = ownerClass.getMethod(methodName, argsClass);
return method.invoke(methodObject, args);
}}

4. jsp网页动态获取数据

lz的意思是动态显示ul li吗？

<%
A a = (A)request.getAttribute("XX");
for (A aa:a){
%>
<ul>
<li>
<%= aa.getOwner() %>
</li>
<li>
<%= aa.getTableName%>
</li>

</ul>
<%
}
%>

用这样的foreach循环就可以了 这只是个例子 具体版的你看你的需求和代码权

5. jsp实现动态查询sql

貌似说着没啥难度,写着有些问题
<tr>
<%
String[] sid;//成绩表的SQL语句
//rs是科目表的所有回结果集
int i=0;
ResultSet[] rl;

while(rs.next()){
%>
<td><%=rs.get……%></td>//输出答结果集rs
<%
sid[i]="select * from 成绩表 where 与科目表关联的列="+rs.getInt;
rl[i]=st.executeQuery(sid[i]);
i++;
}%>
</tr>
<%
for(int j=0;j<i;j++){
%>
<tr>
<%
for(int k=0;k<i;k++){
<td><%=rl[k].getString(j)%></td>
<%}%>
</tr>
<%
}
%>

这样就差不多行了

6. 在jsp中如何用下拉菜单实现动态查询 在线等。

ajax 要是PHP的我能帮你写.

7. 用jsp执行sql语句发生问题& jquery查询动态xml得到的结果错误。

mysql 不支持top
select * from tablename limit 0,10
这里0表示从第1条记录开始，10表示返回的记录条数