white knight

导航

 

2018年3月26日

摘要: @Configuration @EnableAsync @EnableScheduling public class CronConfig { @Autowired private ApiService apiService; @Scheduled(cron="0/5 * * * * ?") pub 阅读全文
posted @ 2018-03-26 13:50 white knight 阅读(126) 评论(0) 推荐(0) 编辑
 
摘要: @RequestMapping("/listByPage") public Page<Production> listByPage(int page, int size, String sortStr, boolean sortAscOrDesc, String searchObj) { Speci 阅读全文
posted @ 2018-03-26 13:49 white knight 阅读(304) 评论(0) 推荐(0) 编辑
 
摘要: user-select: text; -moz-user-select: text; -webkit-user-select: text; /*webkit浏览器*/ -ms-user-select: text; /*IE10*/ -khtml-user-select: text; /*早期浏览器* 阅读全文
posted @ 2018-03-26 11:32 white knight 阅读(258) 评论(0) 推荐(0) 编辑
 
摘要: ALTER TABLE table_name CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8; 阅读全文
posted @ 2018-03-26 11:29 white knight 阅读(347) 评论(0) 推荐(0) 编辑
 
摘要: function getCookie(c_name) { if (document.cookie.length > 0) { var c_start = document.cookie.indexOf(c_name + "="); if (c_start != -1) { c_start = c_s 阅读全文
posted @ 2018-03-26 11:29 white knight 阅读(97) 评论(0) 推荐(0) 编辑
 
摘要: @Entity @Table(name = "TABLE_NAME") @IdClass(PK.class) public class TableName implements Serializable{ @Id @Column(name="ID1") private String id1; @Id 阅读全文
posted @ 2018-03-26 11:15 white knight 阅读(105) 评论(0) 推荐(0) 编辑
 
摘要: @Entity @Table(name="TABLE_NAME") public class TableName implements Serializable { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE,generator="a 阅读全文
posted @ 2018-03-26 11:13 white knight 阅读(135) 评论(0) 推荐(0) 编辑
 
摘要: CREATE OR REPLACE PROCEDURE "PROCUDURE_NAME" (task_id NUMBER, deal_result out NUMBER, result_info out VARCHAR) AS BEGIN update TABLE_NAME set zzz ='z1' where ID = task_id; deal_result := 0; res... 阅读全文
posted @ 2018-03-26 11:11 white knight 阅读(137) 评论(0) 推荐(0) 编辑
 
摘要: grant all on *.* to databaseName@'ipAddress' identified by 'somePassword'; flush privileges; 阅读全文
posted @ 2018-03-26 11:09 white knight 阅读(94) 评论(0) 推荐(0) 编辑
 
摘要: alter user wms_user ACCOUNT UNLOCK 阅读全文
posted @ 2018-03-26 11:08 white knight 阅读(86) 评论(0) 推荐(0) 编辑
 
摘要: select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time; alter system kill se 阅读全文
posted @ 2018-03-26 11:07 white knight 阅读(140) 评论(0) 推荐(0) 编辑
 
摘要: select * from v$db_object_cache where locks > 0 and pins > 0 and type='PROCEDURE'; select b.sid,b.SERIAL#,a.OBJECT, 'alter system kill session ' || '' 阅读全文
posted @ 2018-03-26 11:06 white knight 阅读(2991) 评论(0) 推荐(0) 编辑
 
摘要: select wmsys.wm_concat(id) from table_name where id >= 5000 and id < 6000 阅读全文
posted @ 2018-03-26 11:05 white knight 阅读(509) 评论(0) 推荐(0) 编辑
 
摘要: select * from v$resource_limit; 阅读全文
posted @ 2018-03-26 11:05 white knight 阅读(246) 评论(0) 推荐(0) 编辑
 
摘要: dbms_output.put_line('code:' || sqlcode); dbms_output.put_line('errm:' || sqlerrm); dbms_output.put_line('lineno:' || dbms_utility.format_error_backtr 阅读全文
posted @ 2018-03-26 11:04 white knight 阅读(365) 评论(0) 推荐(0) 编辑
 
摘要: VM options -Dfile.encoding=UTF-8 阅读全文
posted @ 2018-03-26 11:02 white knight 阅读(97) 评论(0) 推荐(0) 编辑
 
摘要: mvn install:install-file -DgroupId=com.lowagie -DartifactId=itextasian -Dversion=1.0 -Dpackaging=jar -Dfile=iTextAsian.jar 阅读全文
posted @ 2018-03-26 11:02 white knight 阅读(162) 评论(0) 推荐(0) 编辑