ITeye博客

luogen33的博客

luogen33 · 共 48 篇文章

perl操作数组

#!/usr/bin/perl -w #test the string print "hello" ." ". "world!\n"; #字符串连接 print "hello" x 4 . "\n"; print "ha" x (2+3) . "\n"; print "12ggdd" * 3 ."\n"; #启用告警时,即#!/usr/bin/perl -w时,程序提示告警信息. #计算从1到100的所有奇数相加. $num=1; #$sum=0; while ($num < 100){ $sum+=$num; #print $num ."\n"; $num+=2; } print $sum…

2011-09-06 23:34 · 评论(0)

bash操作数组

#!/bin/bash declare -a colors; echo "Enter your favorite colors (septated from each other by space)."; read -a colors; #get the length of array element_count=${#colors}; index=0; #all over the array. echo "------all over the array------"; #the No1. method. echo "---the No1. method ----"; while do e…

2011-09-06 23:31 · 评论(0)

dblink常用方法

dblink常用方法: 创建dblink -- Create database link create public database link XMDS_KF connect to L2105 using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.17.99)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =inomc) ) )'; 2.查询制定用户的dblink select * from dba_objects where dba_ob…

2011-09-06 23:27 · 评论(0)

数据库分页

数据库分页: mysql: select * from A limit startRow,endRow oracle: select b.* from (select a.*,rownum as linenum from (select * from A) a where rownum<= endRow) b where linenum >= startRow Hibernate分页 Query q = session.createQuery("from Cat as c");; q.setFirstResult(20000);; q.setMaxResults(100);; List l …

2011-09-06 23:25 · 评论(0)

java从文件尾部读文件

package read.file.form.emd; import java.io.FileNotFoundException; import java.io.IOException; import java.io.RandomAccessFile; public class ReadFileFromEndUtils { public static void main(String args) { System.out.println(getUsefulStr("d:/file.txt", 1024, "machine")); System.out.println(getVersion(g…

2011-09-01 00:44 · 评论(0)

java 解析zip中的xml

import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.Enumeration; import java.util.Iterator; import java.util.List; import java.util.zip.ZipEntry; import java.util.zip.ZipFile; import org.dom4j.Document; import org.dom4j.DocumentException; import org.…

2011-08-31 08:19 · 评论(0)

dblink实现存储过程远程调用

步骤 : --创建DBLink create public database link testLink connect to l2108 identified by websms using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.17.98)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = inomc)))'; --实现远程调用(查询远程表corpmember) select * from corpmember@testLink; --…

2011-08-22 15:56 · 评论(0)

oracle 函数

-- 判断V网类型 SELECT LENGTH(P_TYPE) INTO V_LEN FROM DUAL; IF V_LEN != 1 THEN P_RETVAL := 1002; -- V网类型不合法 RETURN; END IF; select NVL(REGEXP_SUBSTR(P_TYPE, ''), '-1') into V_ISCORPIDEXISTS from dual; IF V_ISCORPIDEXISTS = -1 THEN P_RETVAL := 1002; -- V网类型不合法 return; END IF;

2011-08-16 11:23 · 评论(0)

oracle 分页(存储过程实现)

--开始编写分页的过程 create or replace procedure fenye(tableName in varchar2, pageSize in number, --每页显示记录数 pageNow in number, myRows out number, --总记录数 myPageCount out number, --总页数 p_cursor out sys_refcursor) is --定义sql语句 字符串 v_sql varchar2(1000); --定义2个整数 v_begin number := (pageNow - 1) * pageSize + 1; v…

2011-08-11 15:12 · 评论(0)

oracle plsql 游标

create or replace procedure test_proc is v_corpid corpinfo.corpid%type := '16000000001%'; vv corpinfo%rowtype; --定义游标 cursor one is select * from corpinfo where corpinfo.corpid like v_corpid; begin --遍历游标1 open one; loop fetch one into vv; exit when one%notfound; dbms_output.put_line(vv.corpid || '…

2011-08-11 14:35 · 评论(0)

oracle常用命令

-- 查看表空间 SELECT UPPER(F.TABLESPACE_NAME) "表空间名", D.TOT_GROOTTE_MB "表空间大小(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)", TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100, 2), '990.99') "使用比%", F.TOTAL_BYTES "空闲空间(M)", F.MAX_BYTES "最大块(M)" FROM (SELECT TABLESPACE_NAME, ROU…

2011-08-11 10:02 · 评论(0)

c shell(匹配)

匹配: 写法1. #!/bin/sh aa="aabbb"; bb="aab"; if ];then echo "aaaaaaaaaaaaaa"; else echo "bbbbbbbbbbbbbb"; fi ~ 写法2. #!/bin/sh aa="aabbb"; bb="aab"; if ];then echo "aaaaaaaaaaaaaa"; else echo "bbbbbbbbbbbbbb"; fi ~

2011-07-13 17:40 · 评论(0)

Perl 中流程控制语句

--------------------------- 一、循环语句 ---------------------------- 1.for 语句: 例子:计算从1到10,所有正整数的和. $sum=0; for($i=1;$i<=10;$i++){ $sum+=$i; } print $sum . "\n"; 2.foreach语句: 例子1、:计算从1..100,所有正整数的和. $sum=0; foreach(1..100){ $sum+=$_; } print $sum . "\n"; 例子2、:计算从1..5,所有正整数的和. $sum=0; foreach(1..100){ $su…

2011-07-13 00:02 · 评论(0)

suse linux定时任务

步骤: 1.用vi编写要执行的shell脚本t.sh : 例如: #!/bin/bash echo "I love you !" >>/home/luogen30/Desktop/t.txt (注:该脚本是向t.txt文件中append一句话.) 在命令终端输入: crontab -e 弹出命令编辑窗口. 编辑如下命令: * * * * /home/luogen30/Desktop/t.sh (每秒钟 执行一次t.sh.) 4.在命令终端 执行:cron restart , 重启定时任务. 5.查看已经编写的定时任务: 在命令终端输入:crontab -l 备注: 一个 crontab 文件…

2011-06-30 00:39 · 评论(1)

oracle中exception处理

有关于异常处理的3个知识点: 1.EXCEPTION_INT编译指示 功能是将某命名异常同某特定Oracle错误关联起来. 主用用来捕捉某特定异常错误,而不是通过OTHERS来处理. 语法:PROGMA EXCEPTION_INIT(exception_name,oracle_error_number) SQL> SQL> DECLARE 2 expa EXCEPTION; 3 PRAGMA EXCEPTION_INIT(expa,-6502); 4 vn NUMBER(1); 5 BEGIN 6 vn:=24; 7 EXCEPTION 8 WHEN expa THEN 9 dbms_out…

2011-06-25 00:48 · 评论(0)