JSP里select连动的怎么弄? 从数据库里取出数据放到 select 但是还是实现连动连动的目的也是为了取 select 里的值做为条件再查询数据库里的记录 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 唉!!这个问题还是ajax的问题啊,或者说是无刷新,或局部刷新的问题 如果LZ的这个操作不是很频繁的话,用AJAX吧。如果操作很频繁,用JS缓存一下输出,不每次都查数据库。 楼主可以写个javabean查找数据库结果放到list中,set到request中进行传递到jsp中去除进行迭代就行了 package com.sun.DAO.impl;import java.util.HashMap;import java.util.List;import java.util.Map;import org.hibernate.Query;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import com.sun.DAO.CatagoryDAO;import com.sun.bean.Catagory;public class CatagoryDAOImpl extends HibernateDaoSupport implements CatagoryDAO { @SuppressWarnings("unchecked") public Map getCatagoryChild(int pid) { Query query = this.getSession().createQuery("from Catagory where pid = ?").setParameter(0,pid); List list = query.list(); Map map = new HashMap(); Catagory catagory = null; for(int i = 0 ;i < list.size();i++){ catagory = (Catagory)list.get(i); map.put(catagory.getId(), catagory.getName()); } return map; } @SuppressWarnings("unchecked") public Map getCatagoryP() { Query query = this.getSession().createQuery("from Catagory c where c.pid = 0"); List list = query.list(); Map map = new HashMap(); Catagory catagory = null; for(int i = 0 ;i < list.size();i++){ catagory = (Catagory)list.get(i); System.out.println(catagory.getId()); map.put(catagory.getId(), catagory.getName()); } return map; }}package com.sun.service.impl;import java.util.Map;import com.sun.DAO.CatagoryDAO;import com.sun.service.CatagoryService;public class CatagoryServiceImpl implements CatagoryService { private CatagoryDAO catagoryDAO; public CatagoryDAO getCatagoryDAO() { return catagoryDAO; } public void setCatagoryDAO(CatagoryDAO catagoryDAO) { this.catagoryDAO = catagoryDAO; } public Map getCatagoryChild(int pid) { return this.catagoryDAO.getCatagoryChild(pid); } public Map getCatagoryP() { return this.catagoryDAO.getCatagoryP(); }} <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> <script src="dwr/interface/JsCatagory.js"></script> <script src="dwr/engine.js" /></script> <script src="dwr/util.js" /></script> <script type="text/javascript"> function loadChild(){ JsCatagory.getCatagoryChild(dwr.util.getValue('maincatagory'),function(data){ dwr.util.removeAllOptions("childcatagory"); dwr.util.addOptions("childcatagory", data); }); } function test(){ JsCatagory.getCatagoryP(function(data){ dwr.util.removeAllOptions("maincatagory"); dwr.util.addOptions("maincatagory", data); }); } </script> </head> <body onload="test();"> <select id="maincatagory" onchange="loadChild();"></select> <select id="childcatagory"></select> </body></html> <convert converter="bean" match="com.sun.sendMessage.WebMessage" /> - <create creator="spring" javascript="JsCatagory"> <param name="beanName" value="catagoryService" /> </create> <convert converter="bean" match="com.sun.bean.Catagory" /> spring+hibernate事务不起作用,为什么? 看看这段代码多美妙 JfreeChart中热点map的链接 乱码问题 java基础问题!高手进,。。。。。。。。 请问如何使用Struts2 输出ResultSet? struts2中上传文件是不是必须用struts2的标签库,能不能用Html的标签库 apache camel 中的activeMQ问题 nginx配置文件 动态写入 高分求助:tomcat运行一段时间后页面报连接不上数据库?急在线等 关于cmp管理ejb域的问题! tomcat部署项目时路径问题 关于依赖注解ssh怎样加抽象工厂
到jsp中去除进行迭代就行了
import java.util.List;
import java.util.Map;import org.hibernate.Query;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import com.sun.DAO.CatagoryDAO;
import com.sun.bean.Catagory;public class CatagoryDAOImpl extends HibernateDaoSupport implements CatagoryDAO { @SuppressWarnings("unchecked")
public Map getCatagoryChild(int pid) {
Query query = this.getSession().createQuery("from Catagory where pid = ?").setParameter(0,pid);
List list = query.list();
Map map = new HashMap();
Catagory catagory = null;
for(int i = 0 ;i < list.size();i++){
catagory = (Catagory)list.get(i);
map.put(catagory.getId(), catagory.getName());
}
return map;
}
@SuppressWarnings("unchecked")
public Map getCatagoryP() {
Query query = this.getSession().createQuery("from Catagory c where c.pid = 0");
List list = query.list();
Map map = new HashMap();
Catagory catagory = null;
for(int i = 0 ;i < list.size();i++){
catagory = (Catagory)list.get(i);
System.out.println(catagory.getId());
map.put(catagory.getId(), catagory.getName());
}
return map;
}}
package com.sun.service.impl;import java.util.Map;import com.sun.DAO.CatagoryDAO;
import com.sun.service.CatagoryService;public class CatagoryServiceImpl implements CatagoryService {
private CatagoryDAO catagoryDAO;
public CatagoryDAO getCatagoryDAO() {
return catagoryDAO;
} public void setCatagoryDAO(CatagoryDAO catagoryDAO) {
this.catagoryDAO = catagoryDAO;
} public Map getCatagoryChild(int pid) {
return this.catagoryDAO.getCatagoryChild(pid);
} public Map getCatagoryP() {
return this.catagoryDAO.getCatagoryP();
}}
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script src="dwr/interface/JsCatagory.js"></script>
<script src="dwr/engine.js" /></script>
<script src="dwr/util.js" /></script>
<script type="text/javascript">
function loadChild(){
JsCatagory.getCatagoryChild(dwr.util.getValue('maincatagory'),function(data){
dwr.util.removeAllOptions("childcatagory");
dwr.util.addOptions("childcatagory", data);
});
}
function test(){
JsCatagory.getCatagoryP(function(data){
dwr.util.removeAllOptions("maincatagory");
dwr.util.addOptions("maincatagory", data);
});
}
</script> </head>
<body onload="test();">
<select id="maincatagory" onchange="loadChild();"></select>
<select id="childcatagory"></select>
</body>
</html>
- <create creator="spring" javascript="JsCatagory">
<param name="beanName" value="catagoryService" />
</create>
<convert converter="bean" match="com.sun.bean.Catagory" />