连接12服务器,更新12
cd /opt/tomcat/apache-tomcat-7.0.81-8081/bin/
./shutdown.sh
rm -rf …/webapps/GDYD
./startup.sh
查看实时日志
tail -f -n 500 …/logs/catalina.out
做项目有两种顺序: 从前往后√ , 从后往前
1、先做列表页: (需要手动从数据库里面造假数据)
–进入列表页
–执行前端的方法 initDatagrid
$(function()){
})
select * from SYS_FUNCRIGHT(功能权限表)
select * from SYS_DATARIGHT(数据权限表)
select * from basic_department (部门表 )
select *from basic_usercorpdeprole_rel (用户-公司-部门-角色-岗位 关联表)
select * from sys_roleright_rel (角色数据权限关联表)
先在权限表中加完数据,然后用超级管理员账号添加权限
最后在select * from sys_dataright d order by d.data_right_id desc
中赋予权限
css样式 使div位于底部 .db{
position: absolute;bottom: 5px;left: 0;height: 30px;width: 100%;
}
实现table的下载
只要数据库中的年月日字段
condition.append(" and trunc(zf.deliver_date) = to_date('").append(startTime).append("','yyyy-mm-dd') ");
新增之前先删除 (包含的条件)
public void deleteAll(String corp_id) {
List param = new ArrayList();
String sql="update basic_danger_key_corp k set k.sync_operate=3 where k.corp_id=? ";
param.add(corp_id);
executSqlUpdate(sql, param);
}
-------------------------------------创建表-------------------------------------------------------------------------
– Create table
create table KHJF_JFBZ
(
Khjf_jfbz_id NUMBER(16) primary key ,
Khjf_jfbz_name NVARCHAR2(100),
Level_no CHAR(1),
Parent_id NUMBER(16),
type CHAR(1),
jfsx NUMBER(16),
jfxx NUMBER(16),
sync_operate CHAR(1) default 1,
sync_last_time DATE default sysdate
)
-------------------------------------创建序列-------------------------------------------------------------------------
/* Create sequence */
create sequence KHJF_JFBZ_SEQ
minvalue 1
maxvalue 99999999999999
start with 500
increment by 1
cache 20;
/*
KHJF_JFBZ 生产安全事故记分标准
代码 注释 数据类型 强制 默认值
Khjf_jfbz_id 主键ID NUMBER(16) TRUE
Khjf_jfbz_name 事故/事件后果 NVARCHAR2(100) FALSE
Level_no 级别(1,2) char(1) FALSE
Parent_id 父类id NUMBER(16) FALSE
type 类别(1事故2事件) char(1)
jfsx 记分标准上限 NUMBER
jfxx 记分标准下限 NUMBER
sync_operate 操作标记(1新增 2修改 3删除) CHAR(1) TRUE 1
sync_last_time 最后操作时间 DATE TRUE SYSDATE
*/
查看页面input框中鼠标移入事件$("#baseInfo input,#baseInfo select").each(function () {
$(this).attr(“title”, $(this).val());
})
优先执行数据库的语句
noticeDao.getCurrentSession().flush();
Map<String, String> qx = basicCorpService.getUserFunc(loginUserInfo.getUserId().toString(), "tzzyryglbj", "0");
String deps = qx.get("deps").toString();
String corps1 = qx.get("corps").toString();
List corpList = loginUserInfo.getCorpList();
//判断是否是部门级用户 部门级用户锁死归属公司
if (StringUtils.isNotEmpty(deps)) {
if (StringUtils.isEmpty(corps1)) {
if (corpList.size() == 1) {
HashMap o = (HashMap) corpList.get(0);
BigDecimal aa = (BigDecimal) o.get("CORP_ID");
String bb = (String) o.get("CORP_NAME");
map.put("dan", "1");
map.put("onecorpname", bb);
gsid= String.valueOf(aa);
}
}
}
下拉选择框初始时颜色为浅
style=“color: rgb(153, 153, 153)”
$("#type").css(‘color’, “#000”);
前端页面给某个id标签添加或者移除样式
$("#next1").attr("disabled", "true");
$("#next1").removeAttr("disabled");
是否包含字母
if (Character.isLetter(corpId.charAt(0))) {
corpId = corpId.substring(1);
}
获取某序列下的一个值
public String getTableSeq(String keySeq) {
String sql = "select " + keySeq + ".nextval from dual";
SQLQuery query = getCurrentSession().createSQLQuery(sql);
return query.uniqueResult() + "";
}
//layer树多选
check: {
enable: true,
–**-- chkStyle: ‘radio’,
radioType: ‘all’
},
//单选
check: {
enable: true,
--**-- chkStyle: 'checkbox',
chkboxType: { "Y": "", "N": "" }
},
//字符串不要第一位和最后一位
str = str.substring(1);
str = str.substring(0,str.length() - 1);
//查询状态 多条时按照严重的处理
(case when sysdate > zz.yxqz then
'3'
when sysdate > zz.yxqz - 30 then
'2'
else
'1'
end) as state
Math.ceil 向上取整
Math.round 向上或者向下取整
遍历List
List depList = darmDepDao.findAllDepartment(null, null);
StringBuffer deps = new StringBuffer();
if (depList != null && depList.size() > 0) {
for (int i = 0; i < depList.size(); i++) {
BasicDepartment dep = (BasicDepartment) depList.get(i);
deps.append(dep.getDepId());
if (i < depList.size() - 1) {
deps.append(",");
}
}
}
if (corpIds != null && !"".equals(corpIds.trim())) {}
查询正常 即将过期 已过期 数量
select g_state, count(g_state) as sl
from (select (case
when (sysdate > add_months(z.check_time, z.cycle)) then
3
when (sysdate > add_months(z.check_time, z.cycle - 1)) then
2
else
1
end) as g_state
from zyjk_zywhbg z
where z.sync_operate <> 3
and z.corp_id in (10000045))
group by g_state
前端列表页面 columns
{field: ‘PERCENT’, title: ‘完成比例’, width: ‘7%’, align: ‘center’,formatter:formatPercent},
function formatPercent(value, row, index){
if(row.TOTAL_COUNT!=null&&row.TOTAL_COUNT!=0){
return Math.floor(row.FINISH_COUNT*100/row.TOTAL_COUNT)+’%’;
}else{
return ‘0%’
}
}
查询数据库那张表被锁住了
SELECT object_name, machine, s.sid, s.serial#
FROM gv
l
o
c
k
e
d
o
b
j
e
c
t
l
,
d
b
a
o
b
j
e
c
t
s
o
,
g
v
locked_object l, dba_objects o, gv
lockedobjectl,dbaobjectso,gvsession s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;
解锁只需要杀掉进程即可
alter system kill session ‘13155, 43763’;
数据库添加外键关联
alter table GG_JS
add constraint PK_dasdddf foreign key (gg_fs_id)
references GG_FS (gg_fs_id) on delete cascade ;
delete from GG_JS jj where not exists(select gg.gg_fs_id from gg_fs gg where gg.gg_fs_id=jj.gg_fs_id);
禁用所有外键约束
select ‘alter table ‘||table_name||’ disable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’;
启动所有外键约束
select ‘alter table ‘||table_name||’ enable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’;
删除所有外键约束
select ‘alter table ‘||table_name||’ drop constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’;