cenhonggang86830
- 浏览: 45183 次
- 性别:
- 来自: 大连
-
最新评论
文章列表
将DIV显示在屏幕中间
- 博客分类：
- Java
/*设置客户端的高和宽*/
function getClientBounds(){
var clientWidth;
var clientHeight;
clientWidth = document.compatMode == "CSS1Compat" ? document.documentElement.clientWidth : document.body.clientWidth;
clientHeight = document.compatMode == "CSS1Compat" ? docume ...
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
& ...
ajaxAnywhere.showLoadingMessage = function() {
var img = document.getElementById("myImg");
if (img == null) {
img = document.createElement("img");
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; c ...
将Sequence统一加100000
- 博客分类：
- Oracle
select 'alter sequence ' || t1.sequence_name || ' increment by 100000 nocache;' from user_sequences t1union allselect 'select ' || t2.sequence_name || '.nextval from dual;' from user_sequences t2union allselect 'alter sequence ' || t3.sequence_name || ' increment by 100000 nocache;' from user_sequenc ...
private void downloadTeamFile(HttpServletResponse response, File file, String fileName) throws Exception { if (file == null) return; FileInputStream fileInputStream = new FileInputStream(file); DataInputStream dataInputStream = new DataInputStream(fileInputStream); OutputStream outputStream = ...
--查询30分钟前的数据select * from t as of timestamp sysdate - 1/24/2 where t.id = 999;
--以下命令需要在SQLPLUS中执行：--获取sql执行计划以及统计信息set autotrace traceonly explain statistics;
--以下命令需要能访问oracle服务器查看输出日志：--开启事件跟踪alter session set events '10046 trace name context forever,level 1';--关闭事件跟踪alter session set evevts ...
查询表属于的库和用户
- 博客分类：
- Oracle
select * from user_tables t where t.table_name = '表名'; --查询表是否属于当前数据库
select * from dba_segments t where t.segment_name = '表名'; --查询表属于哪个用户
<javascrip> function isclose(){ alert( "谢谢你的光临！ "); window.close(); return true; } </javascript> window.onUnload()= "script:isclose() "
<script language=javascript> function window.onbeforeunload() { if(event.clientX> docu ...
创建返回值为自定义表的函数
- 博客分类：
- Oracle
CREATE OR REPLACE FUNCTION 函数名() RETURN T_ERROR PIPELINED IS
BEGIN
PIPE ROW(V_ERROR); RETURN;END 函数名;
create or replace type t_error as table of varchar2(500);
利用 delete from chg_number; 时
找回方式
insert into chg_number select * from chg_number as of timestamp sysdate - 1/24/10; --1天/24小时/10分钟
利用truncate table chg_number;时
找回方式
利用 drop table chg_number; 时
找回方式
flashback table chg_number to before drop;
当前正在浏览的URL
- 博客分类：
- Java
public String getCurrentURL(HttpServletRequest request) {
String url = ""; if (request.getQueryString() != null) url = request .getRequestURL() .append("?") .append(request.getQueryString()) .toString(); else if (request.getRequestURL() != null) url = r ...
import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.List;import jxl.Cell;import jxl.Sheet;import jxl.Workbook;import jxl.read.biff.BiffException;public class ExcelImporter{public static v ...
import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.util.ArrayList; import java.util.List; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.Writabl ...
import java.util.*;public class Main{public static void main(String args[]){ArrayList al=new ArrayList();al.add(new Student(2,"aa"));al.add(new Student(1,"bb"));al.add(new Student(3,"dd"));al.add(new Student(3,"cc"));Collections.sort(al);Iterator it=al.iterator ...