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表示返回的記錄條數