一个企业有多个部门,一个部门下面又有多个小部门,一个小部门下面有部门职员名单,像这样的树状显示结构在web中采用TreeView显示方法,有没有哪位高人告知小弟的具体做法,有代码最好了,谢谢了!!!
解决方案 »
- 帮我看看代码 jsp调用bean出错
- 急切!! 求hibernate的两个jar包
- 关于JSP虚拟主机租用的经验求教
- 给客户交货时遇到错误!急急急急急急急急急急急!!!!求高手指点(没有多少分了,请谅解)
- 求助 各位大虾帮忙解决用JSP编写上传下载功能
- 我也想要一个全的源码
- 关于HTML?
- 有谁配置成功过win2K下的apache_2.0.53+tomcat-5.5.8+jdk-1_5_0_02的jsp环境
- 菜鸟有问题:关于何如编译servlet和javabeans??!!!
- 如何获取ajax返回的data到span标签,又怎么获取span标签的内容
- 高分求助啊 一个不是那么复杂的问题 解决马上结贴
- 请问各位网友:如何用按钮控制定时器?
import java.sql.*;public class DeptBean
extends ParentBean {
StringBuffer outHtml;
public DeptBean() {
} public ResultSet getDeptByID(String id)
{
String sql;
sql="select SWJG_DM,SWJG_MC from ctais2.DM_SWJG where SWJG_DM='"+id+"'\n";
return this.selectRecord(sql);
} public ResultSet getDeptByParentID(String parentID)
{
String sql;
sql="select SWJG_DM,SWJG_MC,SJ_SWJG_DM from ctais2.DM_SWJG where SJ_SWJG_DM='"+parentID+"'\n";
//sql+="and SWJG_BZ in ('J','B')\n";
sql+="and XYBZ='Y'\n";
sql+="order by SWJG_DM\n";
return this.selectRecord(sql);
} public ResultSet getCzryByDept(String deptID)
{
String sql;
sql="select CZRY_DM,CZRY_MC,SWJG_DM from ctais2.DM_CZRY where SWJG_DM='"+deptID+"'\n" ;
sql+="and XYBZ='Y'\n";
return this.selectRecord(sql);
} //为了生成部门树
public String CreateNewTreeByDeptID(String id)
{
outHtml = new StringBuffer();
try {
outHtml.append("<script type='text/javascript'>\n");
outHtml.append("d = new MzTreeView('d');\n");
outHtml.append("d.setIconPath('/inv4/MzTreeView10/');\n"); ResultSet rs = getDeptByID(id);
if (rs.next()) {
outHtml.append("d.nodes['-1_"+rs.getString("SWJG_DM")+"'] = 'text:"+new String(rs.getString("SWJG_MC").getBytes("iso-8859-1"))
+";url:javascript:setSelValue(\"" + rs.getString("SWJG_DM") + "\",\""+new String(rs.getString("SWJG_MC").getBytes("iso-8859-1"), "gb2312")+"\",\"DEPARTMENT\")';\n");
AddNewChildNode(rs.getString("SWJG_DM"));
}
rs.close();
outHtml.append("document.write(d.toString());");
outHtml.append("</script>");
}
catch (Exception e) {
}
return outHtml.toString();
}public void AddNewChildNode(String parentId)
{
try {
ResultSet rs = getDeptByParentID(parentId);
while (rs.next()) {
outHtml.append("d.nodes['"+rs.getString("SJ_SWJG_DM")+"_"+rs.getString("SWJG_DM")+"'] = 'text:"+new String(rs.getString("SWJG_MC").getBytes("iso-8859-1"))
+";url:javascript:setSelValue(\"" + rs.getString("SWJG_DM") + "\",\""+new String(rs.getString("SWJG_MC").getBytes("iso-8859-1"), "gb2312")+"\",\"DEPARTMENT\")';\n");
AddNewChildNode(rs.getString("SWJG_DM"));
}
rs.close();
ResultSet rsCzry=getCzryByDept(parentId);
while(rsCzry.next())
{
outHtml.append("d.nodes['"+rsCzry.getString("SWJG_DM")+"_RY"+rsCzry.getString("CZRY_DM")+"'] = 'text:"+new String(rsCzry.getString("CZRY_MC").getBytes("iso-8859-1"))
+";url:javascript:setSelValue(\"" + rsCzry.getString("CZRY_DM") + "\",\""+new String(rsCzry.getString("CZRY_MC").getBytes("iso-8859-1"), "gb2312")+"\",\"EMPLOYEE\")';\n"); }
rsCzry.close();
}
catch (Exception e) {
System.err.println("SqlException:" + e.getMessage());
}
}}
在jsp中只要
<jsp:useBean id="dept" scope="page" class="inv4.com.DeptBean"></jsp:useBean>
<body><table>
<tr>
<td><%=dept.CreateNewTreeByDeptID(swjg) %> </td>
</tr>
<tr>