普巴笔记

用配置文件相关

用户初始信息设置 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(\

}

访问地址

http://localhost:8086/root/ admin/admin

导航条上的叫系统，左边叫子系统，具体功能叫模块 电子表单，

创建系统

创建子系统

子系统号不能用中文

新建表单

新建页面

点设计，进入页面

设置设置域

点修改可修改字段显示样式，下拉，复选等等

导入字段

选择数据库中的表

页面模板设计

本文来源：https://www.bwwdw.com/article/meg3.html