用配置文件相关
用户初始信息设置 ou-sysconfig.xml 附件文件设置
eform-config.xml 通知通告附件
Im-diractionary.xml
数据库相关
恢复数据库时Character set 'utf-8' is not a compiled
提示D:\\Program Files\\MySQL\\MySQL Server 5.0\\bin\\mysql: Character set 'utf-8' is not a compiled character set and is not specified in the 'C:\\mysql\\\\share\\charsets\\Index.xml' file 解决
加--default-character-set=utf8
\Files\\MySQL\\MySQL Server 5.0\\bin\\mysql\-h localhost -uroot -proot --default-character-set=utf8 caiji 部署后无法访问模块 数据库恢复时有几个视图容易有问题,需要单独恢复 `ditie`.`vw_table_view` AS select sql_no_cache `tables`. `keyan`.`vw_table_view` AS select sql_no_cache `tables`. 这种被指定的库名要改成当前库名 另建数据库时不起作用 恢复数据库时有错误,应该是数据库名被写死了,被备份出来了,修改sql文件 例如 /*!50001 VIEW `keyan`.`vw_field_comment` AS select sql_no_cache `columns`.`TABLE_NAME` AS `TABLE_NAME`,`columns`.`COLUMN_NAME` AS `COLUMN_NAME`,`columns`.`COLUMN_COMMENT` AS `COMMENTS` from `information_schema`.`columns` where (`columns`.`TABLE_SCHEMA` = _utf8'keyan') */; `keyan`.`vw_field_comment`,要把前面的keyan改掉就行了 当出现改库名的时候就要这样 只能用editplus修改 修改数据库连接 D:\\jboss-4.2.3.GA_keyan\\server\\default\\deploy\\root.war\\WEB-INF\\chx-config.xml D:\\jboss-4.2.3.GA_keyan\\server\\default\\deploy\\eflow-oracle-ds.xml http://localhost:8080/root/license.jspappportal.jsp appportlets.jsp default.jsp 路径配置 \\WEB-INF\\eform-config.xml 路径配置 \\WEB-INF\\website-config.xml 在root.war下 eflow/root D:\\jboss-4.2.3.GA_mysql\\server\\default\\deploy\\jbossjca-service.xml jboss-4.2.3.G\\server\\default\\deploy\\xxxx-ds.xml E:\\jboss-4.2.3.GA_demo\\server\\default\\deploy\\root.war\\WEB-INF\\chx-config.xml 控制面版下，java->java-〉查看1.6和1.4的钩取掉，只留1.5的 控制面版下，java->常规-〉临时文件设置-〉删除 \\root.war\\eflow ../DbformAction.do?actionType=add&systemid=jzgl&subsysid=jzgl&formid=jzgl&modid=jzgl 跳转相关 添加的url连接 /root/DbformAction.do?actionType=add&systemid=xmgl&subsysid=xmlx&formid=xmxx&modid=xmlbgr&actionid=action2 编辑 /root/DbformAction.do?eformid=2&actionType=edit&eformsystemid=xzcdc&eformsubsysid=jbzk&eformmodid=saomiao&eformactionid=action2 导航不要首页 top.jsp <%=cn.com.chx.eform.bo.app.SystemBo.getMySystem(request,true,true)%> <%=cn.com.chx.eform.bo.app.SystemBo.getMySystem(request,false,true)%> 登陆后转向 dispatch.jsp //parent.location.href=\ parent.location.href=\ ----------------------------------------------------------------------------------------- 柱饼图 portal配置 portal门户系统 portallet设计 E:\\厂商资料\\柱图设置 数据源中配置 select count(a) as EFLOWVALUE,acasdemic as COLUMNKEY from demo_portal group by academic select DEPARTNAE,COUNT(USERNAME),PROJECTNUM,PAPERTNUM,RSCREPORTNUM,BOOKRESULTSNUM,PATENTSNUM, WINNERSNUM,CONFERENCENUM from vm_depstatistics select `d`.`DEPARTNAME` AS `DEPARTNAME`,count(`u`.`USERNAME`) AS `count(u.USERNAME)`,(select count(0) AS `count(*)` from (`dproject` `p` join `ou_user` `u`) where ((`p`.`ProjectChargePerson` = `u`.`USERNAME`) and (`u`.`DEPARTCODE` = `d`.`CODE`))) AS `ProjectNum`,(select count(0) AS `count(*)` from (`paper` `l` join `ou_user` `u`) where ((`u`.`USERNAME` = convert(`l`.`PapFirstAuthor` using utf8)) and (`u`.`DEPARTCODE` = `d`.`CODE`))) AS `papertNum`,(select count(0) AS `count(*)` from (`researchreport` `r` join `ou_user` `u`) where ((`u`.`USERNAME` = convert(`r`.`RshAllAuthors` using utf8)) and (`u`.`DEPARTCODE` = `d`.`CODE`))) AS `rscreportNum`,(select count(0) AS `count(*)` from (`bookresults` `b` join `ou_user` `u`) where ((`u`.`USERNAME` = convert(`b`.`BkSupervisedTheAuthor` using utf8)) and (`u`.`DEPARTCODE` = `d`.`CODE`))) AS `bookresultsNum`,(select count(0) AS `count(*)` from (`patentlist` `z` join `ou_user` `u`) where ((`u`.`USERNAME` = convert(`z`.`PtPatentInventor` using utf8)) and (`u`.`DEPARTCODE` = `d`.`CODE`))) AS `patentsNum`,(select count(0) AS `count(*)` from (`winnerslist` `w` join `ou_user` `u`) where ((`u`.`USERNAME` = convert(`w`.`WnrAwardWinningAuthor` using utf8)) and (`u`.`DEPARTCODE` = `d`.`CODE`))) AS `winnersNum`,(select count(0) AS `count(*)` from (`conferencelist` `c` join `ou_user` `u`) where ((`u`.`USERNAME` = convert(`c`.`CfeMeetingPerson` using utf8)) and (`u`.`DEPARTCODE` = `d`.`CODE`))) AS `conferenceNum` from (`ou_department` `d` left join `ou_user` `u` on((`u`.`DEPARTCODE` = `d`.`CODE`))) group by `d`.`DEPARTNAME` ----------------------------------------------------------------------------------------- 用户默认口令12345678 ----------------------------------------------------------------------------------------- 传参数 departname1=Tpartname% ----------------------------------------------------------------------------------------- 您几经添加了这个portlet 选择授权为登陆时有这情况，改成手工授权就好了 Title修改 Kyxx.jsp直接修改.jsp文件 appportal.jsp Portal首页无效果 后台portal设计模板CSS加内容 Portal设置 select jbxx7 from jbxx where ProjectPesnID='%USERID%' Struts配置文件 struts-config.xml 登陆后首页 登陆后到首页 初始化首页 mysql类存放点 \\jboss-4.2.3.GA\\server\\default\\lib http://localhost/ou/Init.do 导入系统的xml F:\\厂商资料\\普巴\\OU导入系统 修改语句中mysql.sql，数据库名改成自己的视图 D:\\from王宁\\可执行sql\\mysqldata\\data\\mysql.sql 操作处注释掉 for (i=0;i out.println(\ if (map.get(\ var link=\ // 设置姓名单元格的文本颜色 map.put(\ } } 显示小计 importClass(Packages.cn.com.chx.bo.AppBo); var appBo=new AppBo(); // 初始化数据库操作对象 for (i=0;i var map = recordset.get(i); if((i+1) var map1 = recordset.get(i+1); } else { var map1 =recordset.get(0); } //按人取经费小计 var sql=\sum(projectallmoney) as totalmoney from dproject where projectchargeperson='\ group by projectchargeperson\ var list1=appBo.query(sql); //每人只第1条数据显示小计 if(!map.get(\ map.put(\ out.println(\ out.println(\