要是oracle多好，一句话搞定。
盐湖ssl适用于网站、小程序/APP、API接口等需要进行数据传输应用场景，ssl证书未来市场广阔！成为创新互联的ssl证书销售渠道，可以享受市场价格4-6折优惠！如果有意向欢迎电话联系或者加微信：028-86922220（备注：SSL证书合作）期待与您的合作！
既然是java，给你伪代码，你补充吧:
String getDeptName(int level，String dept){
if(level==0){
return dept;
}else if(level=10){
return "层数太大";
}else{
return getDeptName(level-1，dept-childDeptName);
}
}
JAVA 的列表 方式 迅雷的 是执行任务后定时排队列表
以下思路 ，
1）java.util.Timer.
2）ServletContextListener.
3)org.springframework.scheduling.timer.ScheduledTimerTask
1）java.util.Timer
这个方法应该是最常用的，不过这个方法需要手工启动你的任务：
Timer timer=new Timer();
timer.schedule(new ListByDayTimerTask(),10000,86400000);
这里的ListByDayTimerTask类必须extends TimerTask里面的run()方法。
2）ServletContextListener
这个方法在web容器环境比较方便，这样，在web server启动后就可以
自动运行该任务，不需要手工操作。
将ListByDayListener implements ServletContextListener接口，在
contextInitialized方法中加入启动Timer的代码，在contextDestroyed
方法中加入cancel该Timer的代码；然后在web.xml中，加入listener:
listener
listener-classcom.sysnet.demo.util.MyTimerTask/listener-class
/listener
3)org.springframework.scheduling.timer.ScheduledTimerTask
如果你用spring，那么你不需要写Timer类了，在schedulingContext-timer
.xml中加入下面的内容就可以了：
?xml version="1.0" encoding="UTF-8"?
!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" ""
beans
bean id="timer" class="org.springframework.scheduling.timer.TimerFactoryBean"
property name="scheduledTimerTasks"
list
ref local="MyTimeTask1"/
/list
/property
/bean
bean id="MyTimeTask" class="com.qq.timer.ListByDayTimerTask"/
bean id="MyTimeTask1" class="org.springframework.scheduling.timer.ScheduledTimerTask"
property name="timerTask"
ref bean="MyTimeTask"/
/property
property name="delay"
value10000/value
/property
property name="period"
value86400000/value
/property
/bean
/beans
下面给出方法2的一个例子供大家参考：
Java代码：
import java.util.Timer;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
public class MyTimerTask implements ServletContextListener{
private Timer timer = null;
@Override
public void contextDestroyed(ServletContextEvent event) {
// TODO Auto-generated method stub
timer.cancel();
event.getServletContext().log("定时器销毁");
System.out.println("停止备份程序……");
}
@Override
public void contextInitialized(ServletContextEvent event) {
//在这里初始化监听器，在tomcat启动的时候监听器启动，考试,大提示可以在这里实现定时器功能
timer = new Timer(true);
event.getServletContext().log("定时器已启动");//添加日志，可在tomcat日志中查看到
timer.schedule(new exportHistoryBean(event.getServletContext()),0,5*1000);//调用exportHistoryBean，0表示任务无延迟，5*1000表示每隔5秒执行任务，60*60*1000表示一个小时；
}
}
import java.util.Calendar;
import java.util.TimerTask;
import javax.servlet.ServletContext;
public class exportHistoryBean extends TimerTask
{
private static final int C_SCHEDULE_HOUR = 0;
private static boolean isRunning = false;
private ServletContext context = null;
public exportHistoryBean(ServletContext context)
{
this.context = context;
}
@Override
public void run()
{
Calendar c = Calendar.getInstance();
if(!isRunning)
{
if(C_SCHEDULE_HOUR == c.get(Calendar.HOUR_OF_DAY))
{
isRunning = true;
context.log("开始执行指定任务");
isRunning = false;
context.log("指定任务执行结束");
}
else
{
context.log("上一次任务执行还未结束");
}
}
}
}
web.xml里加入一下代码：
listener
listener-classcom.sysnet.demo.util.MyTimerTask/listener-class
/listener
1。sevice层：
/**
* 构建 点取筛取 树形动态菜单
* @return tree
* @throws BasicException
*/
public String buildTree()throws BasicException{
try {
StringBuffer xmlBuffer = new StringBuffer();
int a = 0;
xmlBuffer.append("d.add(0,-1,'input type=\"checkbox\" name=\"ckb\" id=\"0\" onClick=\"check(this.form.ckb)\" value=\"-1\"/全部');");
xmlBuffer.append("\n");
List list = getDao().findFundInvestType();
if(list!=nulllist.size()!=0){
int b = 0;
for(int i=0;ilist.size();i++){
FundInvestType bean = (FundInvestType)list.get(i);
String code = bean.getInvestCode();
// if is sencond
if(code.length()==2){
b++;
a=i;
xmlBuffer.append("d.add("+b+",0,'input type=\"checkbox\" name=\"ckb\" id=\"0"+b+"\" onClick=\"selectAll(this.form.ckb,this.id)\" value=\""+bean.getInvestCode()+"\" /b"+bean.getInvestName()+"/b','');");
xmlBuffer.append("\n");
}else if(code.length()==10){
//if is second
if(code.substring(2,10).equals("00000000")){
b++;
a=i;
xmlBuffer.append("d.add("+b+",0,'input type=\"checkbox\" name=\"ckb\" id=\"0"+b+"\" onClick=\"selectAll(this.form.ckb,this.id)\" value=\""+bean.getInvestCode()+"\"/b"+bean.getInvestName()+"/b','');");
xmlBuffer.append("\n");
}else{//if is third,it father is second
b++;
int k = a+1;
xmlBuffer.append("d.add("+b+","+k+",'input type=\"checkbox\" name=\"ckb\" id=\"ckb0"+k+"\" value=\""+bean.getInvestCode()+"\"/"+bean.getInvestName()+"','');");
xmlBuffer.append("\n");
}
}
}
}
return xmlBuffer.toString();
} catch (RuntimeException e) {
throw new BasicException(e.getMessage());
}
}
2。jsp页面：
%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %
%
String webapp=request.getContextPath()+"/fund";
%
html
head
meta http-equiv="Content-Type" content="text/html; charset=utf-8" /
title基金投资类型/title
link rel="stylesheet" type="text/css" href="%=webapp%/Pub/Style.css"
link rel="StyleSheet" href="%=webapp%/menu/dtree.css" type="text/css" /
SCRIPT LANGUAGE="JavaScript"
!-- Begin
var checkflag = "false";
function check(field) {
if (checkflag == "false") {
for (i = 1; i field.length; i++) {
field[i].checked = true;
field[i].disabled = true;
}
checkflag = "true";
}else {
for (i = 1; i field.length; i++) {
field[i].checked = false;
field[i].disabled=false;
}
checkflag = "false";
}
}
//------选中二级全选--------
var selectflag = "false";
function selectAll(field,j) {
if (selectflag == "false") {
for (i = 0; i field.length; i++) {
var b ="ckb"+j;
if(field[i].id==b){
field[i].checked = true;
field[i].disabled=true;
selectflag = "true";
}
}
}else {
for (i = 0; i field.length; i++) {
var b ="ckb"+j;
if(field[i].id==b||field[i].id==j){
field[i].checked = false;
field[i].disabled = false;
selectflag = "false";
}
}
}
}
//--------取消二级全选-------
function disabledAll(){
field = document.getElementById("myform");
for (i = 0; i field.length; i++) {
if(field[i].checked == true){
field[i].disabled = true;
checkflag = "false";
selectflag = "false";
}
}
}
//------取消选取--------
function cancelAll(field){
//field = myform.all;
field = document.getElementById("myform");
for (i = 0; i field.length; i++) {
field[i].checked = false;
field[i].disabled=false;
checkflag = "false";
selectflag = "false";
}
}
//单击提交页面
function onSubit(){
var txt = "";
//field = myform.all;
field = document.getElementById("myform");
for (i = 0; i field.length; i++) {
if(field[i].checked == truefield[i].disabled==false){
txt += field[i].value+".";
}
}
//alert("=="+txt);
//取得父窗口对象
var winOpen=window.opener;
winOpen.document.form.fundtype.value=txt;
window.close();
}
// End --
/script
/head
body onLoad="disabledAll()"
script type="text/javascript" src="%=webapp%/menu/dtree_2.js"/script
form name="myform" method="post" id="myform"
table width="250" border="0" cellspacing="0" cellpadding="5"
tr
td colspan="2"table width="100%" border=0 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF"
tr
td基金投资类型/td
/tr
tr
td
div class="dtree"
script type="text/javascript"
!--//
d = new dTree('d');
${tree}
document.write(d);
//--
/script
/div
/td
/tr
/table/td
/tr
tr height="25"
td width="86" height="0"align="center"a href="#" onClick="onSubit()"img src="%=webapp%/img/btn_sure.gif" width="51" height="21" border="0"/a/td
td width="144" height="0"a href="#" onClick="cancelAll()"img src="%=webapp%/img/btn_cancel.gif" width="51" height="21" border="0"/a/td
/tr
/table
/form
/body
/html
3。js文件：
// Node object
function Node(id, pid, name, url, title, target, icon, iconOpen, open) {
this.id = id;
this.pid = pid;
this.name = name;
this.url = url;
this.title = title;
this.target = target;
this.icon = icon;
this.iconOpen = iconOpen;
this._io = open || false;
this._is = false;
this._ls = false;
this._hc = false;
this._ai = 0;
this._p;
};
// Tree object
function dTree(objName) {
this.config = {
target : null,
folderLinks : true,
useSelection : true,
useCookies : true,
useLines : true,
useIcons : true,
useStatusText : false,
closeSameLevel : false,
inOrder : false
}
this.icon = {
root : './fund/menu/img/base.gif',
folder : './fund/menu/img/folder.gif',
folderOpen : './fund/menu/img/folderopen.gif',
node : './fund/menu/img/page.gif',
empty : './fund/menu/img/empty.gif',
line : './fund/menu/img/line.gif',
join : './fund/menu/img/join.gif',
joinBottom : './fund/menu/img/joinbottom.gif',
plus : './fund/menu/img/plus.gif',
plusBottom : './fund/menu/img/plusbottom.gif',
minus : './fund/menu/img/minus.gif',
minusBottom : './fund/menu/img/minusbottom.gif',
nlPlus : './fund/menu/img/nolines_plus.gif',
nlMinus : './fund/menu/img/nolines_minus.gif'
};
this.obj = objName;
this.aNodes = [];
this.aIndent = [];
this.root = new Node(-1);
this.selectedNode = null;
this.selectedFound = false;
this点抗 pleted = false;
};
// Adds a new node to the node array
dTree.prototype.add = function(id, pid, name, url, title, target, icon, iconOpen, open) {
this.aNodes[this.aNodes.length] = new Node(id, pid, name, url, title, target, icon, iconOpen, open);
};
// Open/close all nodes
dTree.prototype.openAll = function() {
this.oAll(true);
};
dTree.prototype.closeAll = function() {
this.oAll(false);
};
// Outputs the tree to the page
dTree.prototype.toString = function() {
var str = 'div class="dtree"\n';
if (document.getElementById) {
if (this.config.useCookies) this.selectedNode = this.getSelected();
str += this.addNode(this.root);
} else str += 'Browser not supported.';
str += '/div';
if (!this.selectedFound) this.selectedNode = null;
this点抗 pleted = true;
return str;
};
// Creates the tree structure
dTree.prototype.addNode = function(pNode) {
var str = '';
var n=0;
if (this.config.inOrder) n = pNode._ai;
for (n; nthis.aNodes.length; n++) {
if (this.aNodes[n].pid == pNode.id) {
var cn = this.aNodes[n];
cn._p = pNode;
cn._ai = n;
this.setCS(cn);
if (!cn.target this.config.target) cn.target = this.config.target;
if (cn._hc !cn._io this.config.useCookies) cn._io = this.isOpen(cn.id);
if (!this.config.folderLinks cn._hc) cn.url = null;
if (this.config.useSelection cn.id == this.selectedNode !this.selectedFound) {
cn._is = true;
this.selectedNode = n;
this.selectedFound = true;
}
str += this.node(cn, n);
if (cn._ls) break;
}
}
return str;
};
// Creates the node icon, url and text
dTree.prototype.node = function(node, nodeId) {
var str = 'div class="dTreeNode"' + this.indent(node, nodeId);
if (this.config.useIcons) {
if (!node.icon) node.icon = (this.root.id == node.pid) ? this.icon.root : ((node._hc) ? this.icon.folder : this.icon.node);
if (!node.iconOpen) node.iconOpen = (node._hc) ? this.icon.folderOpen : this.icon.node;
if (this.root.id == node.pid) {
node.icon = this.icon.root;
node.iconOpen = this.icon.root;
}
str += 'img id="i' + this.obj + nodeId + '" src="' + ((node._io) ? node.iconOpen : node.icon) + '" alt="" /';
}
if (node.url) {
str += 'a id="s' + this.obj + nodeId + '" class="' + ((this.config.useSelection) ? ((node._is ? 'nodeSel' : 'node')) : 'node') + '" href="' + node.url + '"';
if (node.title) str += ' title="' + node.title + '"';
if (node.target) str += ' target="' + node.target + '"';
if (this.config.useStatusText) str += ' onmouseover="window.status=\'' + node.name + '\';return true;" onmouseout="window.status=\'\';return true;" ';
if (this.config.useSelection ((node._hc this.config.folderLinks) || !node._hc))
str += ' onclick="javascript: ' + this.obj + '.s(' + nodeId + ');"';
str += '';
}
else if ((!this.config.folderLinks || !node.url) node._hc node.pid != this.root.id)
str += 'a href="javascript: ' + this.obj + '.o(' + nodeId + ');" class="node"';
str += node.name;
if (node.url || ((!this.config.folderLinks || !node.url) node._hc)) str += '/a';
str += '/div';
if (node._hc) {
str += 'div id="d' + this.obj + nodeId + '" class="clip" style="display:' + ((this.root.id == node.pid || node._io) ? 'block' : 'none') + ';"';
str += this.addNode(node);
str += '/div';
}
this.aIndent.pop();
return str;
};
// Adds the empty and line icons
dTree.prototype.indent = function(node, nodeId) {
var str = '';
if (this.root.id != node.pid) {
for (var n=0; nthis.aIndent.length; n++)
str += 'img src="' + ( (this.aIndent[n] == 1 this.config.useLines) ? this.icon.line : this.icon.empty ) + '" alt="" /';
(node._ls) ? this.aIndent.push(0) : this.aIndent.push(1);
if (node._hc) {
str += 'a href="javascript: ' + this.obj + '.o(' + nodeId + ');"img id="j' + this.obj + nodeId + '" src="';
if (!this.config.useLines) str += (node._io) ? this.icon.nlMinus : this.icon.nlPlus;
else str += ( (node._io) ? ((node._ls this.config.useLines) ? this.icon.minusBottom : this.icon.minus) : ((node._ls this.config.useLines) ? this.icon.plusBottom : this.icon.plus ) );
str += '" alt="" //a';
} else str += 'img src="' + ( (this.config.useLines) ? ((node._ls) ? this.icon.joinBottom : this.icon.join ) : this.icon.empty) + '" alt="" /';
}
return str;
};
// Checks if a node has any children and if it is the last sibling
dTree.prototype.setCS = function(node) {
var lastId;
for (var n=0; nthis.aNodes.length; n++) {
if (this.aNodes[n].pid == node.id) node._hc = true;
if (this.aNodes[n].pid == node.pid) lastId = this.aNodes[n].id;
}
if (lastId==node.id) node._ls = true;
};
// Returns the selected node
dTree.prototype.getSelected = function() {
var sn = this.getCookie('cs' + this.obj);
return (sn) ? sn : null;
};
// Highlights the selected node
dTree.prototype.s = function(id) {
if (!this.config.useSelection) return;
var cn = this.aNodes[id];
if (cn._hc !this.config.folderLinks) return;
if (this.selectedNode != id) {
if (this.selectedNode || this.selectedNode==0) {
eOld = document.getElementById("s" + this.obj + this.selectedNode);
eOld.className = "node";
}
eNew = document.getElementById("s" + this.obj + id);
eNew.className = "nodeSel";
this.selectedNode = id;
if (this.config.useCookies) this.setCookie('cs' + this.obj, cn.id);
}
};
// Toggle Open or close
dTree.prototype.o = function(id) {
var cn = this.aNodes[id];
this.nodeStatus(!cn._io, id, cn._ls);
cn._io = !cn._io;
if (this.config.closeSameLevel) this.closeLevel(cn);
if (this.config.useCookies) this.updateCookie();
};
// Open or close all nodes
dTree.prototype.oAll = function(status) {
for (var n=0; nthis.aNodes.length; n++) {
if (this.aNodes[n]._hc this.aNodes[n].pid != this.root.id) {
this.nodeStatus(status, n, this.aNodes[n]._ls)
this.aNodes[n]._io = status;
}
}
if (this.config.useCookies) this.updateCookie();
};
// Opens the tree to a specific node
dTree.prototype.openTo = function(nId, bSelect, bFirst) {
if (!bFirst) {
for (var n=0; nthis.aNodes.length; n++) {
if (this.aNodes[n].id == nId) {
nId=n;
break;
}
}
}
var cn=this.aNodes[nId];
if (cn.pid==this.root.id || !cn._p) return;
cn._io = true;
cn._is = bSelect;
if (this点抗 pleted cn._hc) this.nodeStatus(true, cn._ai, cn._ls);
if (this点抗 pleted bSelect) this.s(cn._ai);
else if (bSelect) this._sn=cn._ai;
this.openTo(cn._p._ai, false, true);
};
// Closes all nodes on the same level as certain node
dTree.prototype.closeLevel = function(node) {
for (var n=0; nthis.aNodes.length; n++) {
if (this.aNodes[n].pid == node.pid this.aNodes[n].id != node.id this.aNodes[n]._hc) {
this.nodeStatus(false, n, this.aNodes[n]._ls);
this.aNodes[n]._io = false;
this.closeAllChildren(this.aNodes[n]);
}
}
}
// Closes all children of a node
dTree.prototype.closeAllChildren = function(node) {
for (var n=0; nthis.aNodes.length; n++) {
if (this.aNodes[n].pid == node.id this.aNodes[n]._hc) {
if (this.aNodes[n]._io) this.nodeStatus(false, n, this.aNodes[n]._ls);
this.aNodes[n]._io = false;
this.closeAllChildren(this.aNodes[n]);
}
}
}
// Change the status of a node(open or closed)
dTree.prototype.nodeStatus = function(status, id, bottom) {
eDiv = document.getElementById('d' + this.obj + id);
eJoin = document.getElementById('j' + this.obj + id);
if (this.config.useIcons) {
eIcon = document.getElementById('i' + this.obj + id);
eIcon.src = (status) ? this.aNodes[id].iconOpen : this.aNodes[id].icon;
}
eJoin.src = (this.config.useLines)?
((status)?((bottom)?this.icon.minusBottom:this.icon.minus):((bottom)?this.icon.plusBottom:this.icon.plus)):
((status)?this.icon.nlMinus:this.icon.nlPlus);
eDiv.style.display = (status) ? 'block': 'none';
};
// [Cookie] Clears a cookie
dTree.prototype.clearCookie = function() {
var now = new Date();
var yesterday = new Date(now.getTime() - 1000 * 60 * 60 * 24);
this.setCookie('co'+this.obj, 'cookieValue', yesterday);
this.setCookie('cs'+this.obj, 'cookieValue', yesterday);
};
// [Cookie] Sets value in a cookie
dTree.prototype.setCookie = function(cookieName, cookieValue, expires, path, domain, secure) {
document.cookie =
escape(cookieName) + '=' + escape(cookieValue)
+ (expires ? '; expires=' + expires.toGMTString() : '')
+ (path ? '; path=' + path : '')
+ (domain ? '; domain=' + domain : '')
+ (secure ? '; secure' : '');
};
// [Cookie] Gets a value from a cookie
dTree.prototype.getCookie = function(cookieName) {
var cookieValue = '';
var posName = document.cookie.indexOf(escape(cookieName) + '=');
if (posName != -1) {
var posValue = posName + (escape(cookieName) + '=').length;
var endPos = document.cookie.indexOf(';', posValue);
if (endPos != -1) cookieValue = unescape(document.cookie.substring(posValue, endPos));
else cookieValue = unescape(document.cookie.substring(posValue));
}
return (cookieValue);
};
// [Cookie] Returns ids of open nodes as a string
dTree.prototype.updateCookie = function() {
var str = '';
for (var n=0; nthis.aNodes.length; n++) {
if (this.aNodes[n]._io this.aNodes[n].pid != this.root.id) {
if (str) str += '.';
str += this.aNodes[n].id;
}
}
this.setCookie('co' + this.obj, str);
};
// [Cookie] Checks if a node id is in a cookie
dTree.prototype.isOpen = function(id) {
var aOpen = this.getCookie('co' + this.obj).split('.');
for (var n=0; naOpen.length; n++)
if (aOpen[n] == id) return true;
return false;
};
// If Push and pop is not implemented by the browser
if (!Array.prototype.push) {
Array.prototype.push = function array_push() {
for(var i=0;iarguments.length;i++)
this[this.length]=arguments[i];
return this.length;
}
};
if (!Array.prototype.pop) {
Array.prototype.pop = function array_pop() {
lastElement = this[this.length-1];
this.length = Math.max(this.length-1,0);
return lastElement;
}
};
重庆分公司
重庆分公司
