今日任务:
1.企业员工添加删除、部门添加编辑删除
实际:
完成70%
收获:
1.如何将企业信息表里面的id和name合并到部门表里面来?
用 union
select ep.id as id, ep.enterpriseName as name from enterprise ep
union
select d.id as id, d.departmentName as name from department d
2.input type=radio 实现赋值取值,利用jQuery绑定单击事件
$("input[type='radio']").bind("click", function(e){
var theEvent = window.event || e;
var theObj = theEvent.target || theEvent.srcElement;
var selectedValue = $(this).val();
if (selectedValue == "0")
{
$('input[name="' + theObj.name + '"][value="1"]').removeAttr("checked");
$('input[name="' + theObj.name + '"][value="0"]').attr("checked", true);
}
else
{
$('input[name="' + theObj.name + '"][value="0"]').removeAttr("checked");
$('input[name="' + theObj.name + '"][value="1"]').attr("checked", true);
}
});
// 打开Dialog时让后台传递过来的值处于选中状态
$('input[name=Sex][value="' + rowData.Sex + '"]').attr("checked", true);
// 提交时获取选中的值
Sex : $("input[name='Sex'][checked]").val();
3.mysql函数,先开启函数支持:
set Global log_bin_trust_function_creators=1;
然后写函数
cast(rootId as CHAR); concat(sTemp,',',sTempChd);
SELECT group_concat(id) INTO sTempChd FROM treeNodes where FIND_IN_SET(pid,sTempChd)>0;
eg:查询所有子节点,包括自己
Drop Function if exists getChildList
CREATE FUNCTION getChildList (rootId INT)
RETURNS varchar(1000)
BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = '$';
SET sTempChd =cast(rootId as CHAR);
WHILE sTempChd is not null DO
SET sTemp = concat(sTemp,',',sTempChd);
SELECT group_concat(id) INTO sTempChd FROM treeNodes where FIND_IN_SET(pid,sTempChd)>0;
END WHILE;
RETURN sTemp;
END
//调用
select getChildList(10081);
// 输出 '$,10081,10086'
分享到:
相关推荐
赠送jar包:jakarta.xml.bind-api-2.3.3.jar; 赠送原API文档:jakarta.xml.bind-api-2.3.3-javadoc.jar; 赠送源代码:jakarta.xml.bind-api-2.3.3-sources.jar; 赠送Maven依赖信息文件:jakarta.xml.bind-api-...
赠送jar包:jakarta.xml.bind-api-2.3.3.jar; 赠送原API文档:jakarta.xml.bind-api-2.3.3-javadoc.jar; 赠送源代码:jakarta.xml.bind-api-2.3.3-sources.jar; 赠送Maven依赖信息文件:jakarta.xml.bind-api-...
赠送jar包:jakarta.xml.bind-api-2.3.2.jar; 赠送原API文档:jakarta.xml.bind-api-2.3.2-javadoc.jar; 赠送源代码:jakarta.xml.bind-api-2.3.2-sources.jar; 赠送Maven依赖信息文件:jakarta.xml.bind-api-...
java运行依赖jar包
赠送jar包:jakarta.xml.bind-api-2.3.2.jar; 赠送原API文档:jakarta.xml.bind-api-2.3.2-javadoc.jar; 赠送源代码:jakarta.xml.bind-api-2.3.2-sources.jar; 赠送Maven依赖信息文件:jakarta.xml.bind-api-...
bind-9.3.6-4.P1.el5.i386.rpm bind-chroot-9.3.6-4.P1.el5.i386.rpm bind-devel-9.3.6-4.P1.SEL5_4.2.i386.rpm bind-libs-9.3.6-4.P1.el5.i386.rpm bind-utils-9.3.6-4.P1.el5_5.3.i386.rpm caching-nameserver-7.3...
bind-9.9.4-29.el7.x86_64.rpm rhel-server-7.2-x86_64 丢失文件的小伙伴可以下载来补全。。
标签:core、bind、xml、sun、jar包、java、API文档、中文版; 使用方法:解压翻译后的API文档,用浏览器打开“index.html”文件,即可纵览文档内容。 人性化翻译,文档中的代码和结构保持不变,注释和说明精准翻译...
atomic-boost-1.70.0.tar.gz boostorg-beast-boost-1.70.0.tar.gz boostorg-bimap-boost-1.70.0.tar.gz boostorg-bind-boost-1.70.0.tar.gz boostorg-build-boost-1.70.0.tar.gz boostorg-callable_traits-boost-...
jar包,官方版本,自测可用
atomic-boost-1.70.0.tar.gz boostorg-beast-boost-1.70.0.tar.gz boostorg-bimap-boost-1.70.0.tar.gz boostorg-bind-boost-1.70.0.tar.gz boostorg-build-boost-1.70.0.tar.gz boostorg-callable_traits-boost-...
Linux redhat5_4 DNs服务器配置安装包 system-config-bind-4.0.3-4.el5.noarch.rpm
bind-9.3.0.tar.gz bind-9.3.0.tar.gz bind-9.3.0.tar.gz
jibx-bind-1.2.jar jibx-run-1.2.jar jsr311-api-1.1.1.jar juli-6.0.16.jar log4j-1.2.15.jar mail-1.4.jar mex-1.7.4-impl.jar neethi-3.0.3.jar stax2-api-3.1.1.jar tribes-6.0.16.jar woden-core-1.0M10.jar ...
mysql5.7arm64.zip mysql5.7在麒麟arm64架构下的deb安装包 1.安装deb文件 dpkg -i *.deb 安装过程中会要求你设置的mysql的root密码 2.修改/etc/my.cnf datadir = /data01/MPP/mysql/data bind-address=0.0.0.0 skip-...
atomic-boost-1.70.0.tar.gz boostorg-beast-boost-1.70.0.tar.gz boostorg-bimap-boost-1.70.0.tar.gz boostorg-bind-boost-1.70.0.tar.gz boostorg-build-boost-1.70.0.tar.gz boostorg-callable_traits-boost-...
#先启动各节点 #组成集群 redis-5.0.14/src/redis-cli --cluster create 192.168.129.98:7000 192.168.129.99:7003 192.168.129.99:7002 192.168.129.126:7005 192.168.129.126:7004 192.168.129.98:7001 --cluster-...
java的工具包,javax.xml.bind.jar,javax.xml.ws-3.0-prelude-embedded-m2,javax.jws-3.0-prelude-embedded-m2
jar包,官方版本,自测可用
linux RedHat5-4 DNS bind-chroot-9.3.6-4.P1.el5.i386.rpm DNs服务器配置安装包