普巴笔记

用配置文件相关

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

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

创建系统

创建子系统

子系统号不能用中文

新建表单

新建页面

点设计，进入页面

设置设置域

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

导入字段

选择数据库中的表

页面模板设计

制作后发布

流程设计好后创建模块，返回首页即可看见功能

返回首页即可看到系统

模块设置中增加操作

操作设置

授权

选行后加传值操作 操作-行自定义操作->

var tagid=runtime.getDoKey(); out.println(\”)

或

var ids = runtime.getSelected(); //取得选定的数据的ID；

var jbxxid=runtime.getDoKey(); out.println(\

var sql=\var ls = appBo.query(sql); if(ls!=null&&ls.size()>0) {

var chunming=ls.get(0).get(\}

out.println(\

out.println(\

每功能都进行的校验 struts-config-eform.xml

type=\ name=\ scope=\ input=\

cn.com.chx.util.Login lg = (cn.com.chx.util.Login) request.getSession(false).getAttribute(\ String usercode=(String)lg.id; 取得数据库操作对象

cn.com.chx.bo.AppBo appBo = new cn.com.chx.bo.AppBo(); String fwsql=\ ou_user where code='\ fwlist=appBo.query(fwsql);

HashMap htmap=(HashMap)fwlist.get(0); String strSex=(String)htmap.get(\ String strid=(String)htmap.get(\ //out.println(\ //out.close(); if (strSex==null||strSex.length()==0) { out.println(\您的信息尚不完善,请填写用户基本信息后使用系统!!!');\ out.println(\&subsysid=kyry&formid=yhb&modid=grzl&actionid=action1&eformid=\ }

记录集定制作

>> 微观经济数据农户调查 >> 农户家庭基本情况 >> 模块属性 ->>修改

select * from caiji_nonghu where (depid like 'TPTID%%') or ('TPTID%'='default') 或用查询定制,但那个要写很多查询语句

记录设定村功能代码

var tagid=runtime.getDoKey(); out.println(\

var ls=appBo.query(\ caiji_nonghu where id='\if(ls!=null && ls.size()>0){

var nonghu9=ls.get(0).get(\户主姓名 var nonghu10=ls.get(0).get(\农户代码 var year=ls.get(0).get(\调查年份 }

out.println(\out.println(\out.println(\//查询设置表

var caijinset=appBo.query(\ caijin_set where userid='\if(caijinset!=null && caijinset.size()>0) //如果存在改用户信息 { var sql=\caijin_set set nonghuname='\where userid='\} else { var sql=\into caijin_set (nonghuname,nonghucode,nonghuyear,userid)

values('\}

appBo.runSQL(sql); out.println(\

表单后台脚本新增

var ls=appBo.query(\ caijin_set where userid='\if(ls!=null && ls.size()>0){

var nonghu9=ls.get(0).get(\户主姓名 var nonghu10=ls.get(0).get(\农户代码 var year=ls.get(0).get(\调查年份 }

out.println(\out.println(\out.println(\

objTable.put(\objTable.put(\objTable.put(\

根部门修改

ou_organize表

http://127.0.0.1:8086/root/license.jsp

定制查询

var sql=\待审核'\runtime.setSQL(sql);

您的信息尚不完善

您的信息尚不完善,请填写用户基本信息后使用系统

\\eform\\data\\list.jsp

select * from caijin_c where ((depid like 'TPTID%%') or ('TPTID%'='default')) and Htype='面积数量'

工作流编辑器打开出错

Jdk使用1.5*版本即可

values('\}

appBo.runSQL(sql); out.println(\

表单后台脚本新增

var ls=appBo.query(\ caijin_set where userid='\if(ls!=null && ls.size()>0){

var nonghu9=ls.get(0).get(\户主姓名 var nonghu10=ls.get(0).get(\农户代码 var year=ls.get(0).get(\调查年份 }

out.println(\out.println(\out.println(\

objTable.put(\objTable.put(\objTable.put(\

根部门修改

ou_organize表

http://127.0.0.1:8086/root/license.jsp

定制查询

var sql=\待审核'\runtime.setSQL(sql);

您的信息尚不完善

您的信息尚不完善,请填写用户基本信息后使用系统

\\eform\\data\\list.jsp

select * from caijin_c where ((depid like 'TPTID%%') or ('TPTID%'='default')) and Htype='面积数量'

工作流编辑器打开出错

Jdk使用1.5*版本即可

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