<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[crystalis的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/crystalis</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; crystalis]]></copyright><item><title><![CDATA[javascript数组]]></title><link>https://blog.csdn.net/crystalis/article/details/38906321</link><guid>https://blog.csdn.net/crystalis/article/details/38906321</guid><author>crystalis</author><pubDate>Thu, 28 Aug 2014 22:29:41 +0800</pubDate><description><![CDATA[《javascript高级程序设计》
1：ECMAscript中的数组和其他语言中的数组的区别
   一：数组中每一项的类型
      ECMAscript中数组中每一项的类型任意
   二：数组的长度
      ECMAScript的数组的大小是可以动态调整的。
 
2：创建数组的方式
   一：对象字面量
  
       var colors = ["red", "]]></description><category></category></item><item><title><![CDATA[EL表达式...jstl标签]]></title><link>https://blog.csdn.net/crystalis/article/details/38303695</link><guid>https://blog.csdn.net/crystalis/article/details/38303695</guid><author>crystalis</author><pubDate>Wed, 30 Jul 2014 17:11:50 +0800</pubDate><description><![CDATA[1.问题
jsp 中${ } 是什么意思? 中的c:forEach 是什么写法，什么意思？



回答：]]></description><category></category></item><item><title><![CDATA[测试数据库的连接]]></title><link>https://blog.csdn.net/crystalis/article/details/38301471</link><guid>https://blog.csdn.net/crystalis/article/details/38301471</guid><author>crystalis</author><pubDate>Wed, 30 Jul 2014 15:32:14 +0800</pubDate><description><![CDATA[import java.util.Iterator;
import java.util.List;
import java.util.Map.Entry;
import java.util.Set;

import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
import com.jfinal.plugin.activerecord.dia]]></description><category></category></item><item><title><![CDATA[struts2读源码]]></title><link>https://blog.csdn.net/crystalis/article/details/38090555</link><guid>https://blog.csdn.net/crystalis/article/details/38090555</guid><author>crystalis</author><pubDate>Thu, 24 Jul 2014 19:06:45 +0800</pubDate><description><![CDATA[点击class文件可以查看源码了]]></description><category></category></item><item><title><![CDATA[使用JFreeChart生成饼图]]></title><link>https://blog.csdn.net/crystalis/article/details/38083295</link><guid>https://blog.csdn.net/crystalis/article/details/38083295</guid><author>crystalis</author><pubDate>Thu, 24 Jul 2014 13:34:58 +0800</pubDate><description><![CDATA[package net.hncu.jfreechart;

import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartFrame;
import org.jfree.chart.JFreeChart;
import org.jfree.data.general.DefaultPieDataset;

public class ]]></description><category></category></item><item><title><![CDATA[JavaScript计算器实例]]></title><link>https://blog.csdn.net/crystalis/article/details/26216705</link><guid>https://blog.csdn.net/crystalis/article/details/26216705</guid><author>crystalis</author><pubDate>Mon, 19 May 2014 09:45:46 +0800</pubDate><description><![CDATA[var calc = {
 first:0,
 second:0,
 init:function(){
  this.first = parseInt(document.getElementById("first").value);
  this.second = parseInt(document.getElementById("second").value);
 },
 setResult:f]]></description><category></category></item><item><title><![CDATA[用JavaScript批量访问HTML元素]]></title><link>https://blog.csdn.net/crystalis/article/details/26214929</link><guid>https://blog.csdn.net/crystalis/article/details/26214929</guid><author>crystalis</author><pubDate>Mon, 19 May 2014 09:31:06 +0800</pubDate><description><![CDATA[.important { color:#F00; font-weight:bold;} 



function test(){
	var testUL = document.getElementById("testUL");
	var listItems = testUL.getElementsByTagName("LI");
	for (var i=0; i<listItems.length;]]></description><category></category></item><item><title><![CDATA[用javascript修改html元素的class]]></title><link>https://blog.csdn.net/crystalis/article/details/26164053</link><guid>https://blog.csdn.net/crystalis/article/details/26164053</guid><author>crystalis</author><pubDate>Sun, 18 May 2014 19:48:37 +0800</pubDate><description><![CDATA[.testNormal { 
	border:1px solid black;
	}
.testOver {
	background:#999999;
	border:1px solid black; 
	font-weight:bold; 
	padding:3em;
	}


 
	function over(){
		var para = document.getElementById("t]]></description><category></category></item><item><title><![CDATA[connect by]]></title><link>https://blog.csdn.net/crystalis/article/details/26162177</link><guid>https://blog.csdn.net/crystalis/article/details/26162177</guid><author>crystalis</author><pubDate>Sun, 18 May 2014 18:46:53 +0800</pubDate><description><![CDATA[with sys_useras(
select1 userid,'top manager' username,null
 leaderid from dual
unionall
select20,'manager1',1from
 dual unionall
select30,'manager2',1from
 dual unionall
select201,'jeff' ,20f]]></description><category></category></item><item><title><![CDATA[对一个sql的理解]]></title><link>https://blog.csdn.net/crystalis/article/details/25555957</link><guid>https://blog.csdn.net/crystalis/article/details/25555957</guid><author>crystalis</author><pubDate>Sun, 11 May 2014 17:56:43 +0800</pubDate><description><![CDATA[select id,max(num),max(flag)keep(dense_rank last order by num) from table1
group by id]]></description><category></category></item><item><title><![CDATA[ORACLE日期时间函数大全]]></title><link>https://blog.csdn.net/crystalis/article/details/24737509</link><guid>https://blog.csdn.net/crystalis/article/details/24737509</guid><author>crystalis</author><pubDate>Tue, 29 Apr 2014 20:28:00 +0800</pubDate><description><![CDATA[Year:      
        yy two digits 两位年                显示值:07
        yyy three digits 三位年                显示值:007
        yyyy four digits 四位年                显示值:2007
            
        Month:   ]]></description><category></category></item><item><title><![CDATA[查看数据库中的表结构]]></title><link>https://blog.csdn.net/crystalis/article/details/23673863</link><guid>https://blog.csdn.net/crystalis/article/details/23673863</guid><author>crystalis</author><pubDate>Mon, 14 Apr 2014 13:47:06 +0800</pubDate><description><![CDATA[1：在pl sql dev 中是不可以使用des]]></description><category></category></item><item><title><![CDATA[从表中取值作为列]]></title><link>https://blog.csdn.net/crystalis/article/details/21935025</link><guid>https://blog.csdn.net/crystalis/article/details/21935025</guid><author>crystalis</author><pubDate>Mon, 24 Mar 2014 10:08:57 +0800</pubDate><description><![CDATA[WITH test AS(
SELECT '20140101' work_date,'AA' status,'B201' grid,'037' device FROM dual UNION ALL
SELECT '20140103' work_date,'CC' status,'B201' grid,'037' device FROM dual UNION ALL
SELECT '20140301]]></description><category></category></item><item><title><![CDATA[oracle树形数据汇总]]></title><link>https://blog.csdn.net/crystalis/article/details/21694849</link><guid>https://blog.csdn.net/crystalis/article/details/21694849</guid><author>crystalis</author><pubDate>Fri, 21 Mar 2014 09:31:28 +0800</pubDate><description><![CDATA[1：原始数据


2：执行sql语句
UPDATE test_t T1
   SET T1.VAL = (SELECT DECODE(SUM(VAL), NULL, T1.val, SUM(VAL))
                   FROM test_t T2
                  WHERE T2.ID <> T1.ID
                    AN]]></description><category></category></item><item><title><![CDATA[Oracle 正则表达式函数-REGEXP_SUBSTR 使用例子]]></title><link>https://blog.csdn.net/crystalis/article/details/21482929</link><guid>https://blog.csdn.net/crystalis/article/details/21482929</guid><author>crystalis</author><pubDate>Tue, 18 Mar 2014 22:05:52 +0800</pubDate><description><![CDATA[5个参数

第一个是输入的字符串

第二个是正则表达式

第三个是标识从第几个字符开始正则表达式匹配。（默认为1）

第四个是标识第几个匹配组。（默认为1）

第五个是是取值范围：

i：大小写不敏感；

c：大小写敏感；

n：点号 . 不匹配换行符号；

m：多行模式；

x：扩展模式，忽略正则表达式中的空白字符。

 

全部测试数据

S]]></description><category></category></item><item><title><![CDATA[解析oracle的rownum]]></title><link>https://blog.csdn.net/crystalis/article/details/21299155</link><guid>https://blog.csdn.net/crystalis/article/details/21299155</guid><author>crystalis</author><pubDate>Sat, 15 Mar 2014 22:24:03 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/zjrstar/archive/2006/08/31/491090.html

本人最近在使用oracle的rownum实现分页显示的时候，对rownum做了进一步的分析和研究。现归纳如下，希望能给大家带来收获。
      对于rownum来说它是oracle系统顺序分配为从查询返回的行的编号，返回的第一行分配的是1，第二行是2，依此类推，这个]]></description><category></category></item><item><title><![CDATA[oracle中有关于字符串的问题。]]></title><link>https://blog.csdn.net/crystalis/article/details/20144069</link><guid>https://blog.csdn.net/crystalis/article/details/20144069</guid><author>crystalis</author><pubDate>Fri, 28 Feb 2014 16:31:19 +0800</pubDate><description><![CDATA[1：字符串
 EXECUTE IMMEDIATE 'alter table sys_form_detail add hidden char(5) default "false"' ;
刚开始的时候'false',执行这一句的时候就会报错，原因是由于 有两个单引号，那样子的话，程序就不能够识别出


报错信息如下：
Error: PLS-00103: 出现符号 "FALSE"在需要下列之]]></description><category></category></item><item><title><![CDATA[check 函数有关的流程图]]></title><link>https://blog.csdn.net/crystalis/article/details/19759943</link><guid>https://blog.csdn.net/crystalis/article/details/19759943</guid><author>crystalis</author><pubDate>Sun, 23 Feb 2014 15:46:50 +0800</pubDate><description><![CDATA[create or replace function check(
  v_s_date in DATE,
  v_amount in NUMBER,
  v_start_date in DATE,
  v_req_no in NUMBER,
  v_end_date in DATE
) Return char is Result char(100);
total_get number(12,4)]]></description><category></category></item><item><title><![CDATA[excuting]]></title><link>https://blog.csdn.net/crystalis/article/details/18942653</link><guid>https://blog.csdn.net/crystalis/article/details/18942653</guid><author>crystalis</author><pubDate>Wed, 05 Feb 2014 22:14:41 +0800</pubDate><description><![CDATA[如果一直在excuting，那就是你的代码有问题，进入死循环了]]></description><category></category></item><item><title><![CDATA[oracle中的错误信息]]></title><link>https://blog.csdn.net/crystalis/article/details/18365497</link><guid>https://blog.csdn.net/crystalis/article/details/18365497</guid><author>crystalis</author><pubDate>Thu, 16 Jan 2014 19:03:34 +0800</pubDate><description><![CDATA[呵呵~意思就是说 第一次执行的时候要next 初始化一下~
以后就可以current了




Variant conversion error for variable:v10
检查下看那个数值和其他的数据类型不一致,比如数据都是数字,那个数字中有其他字符,我也遇到过类似问题,我插入的数据都是数字,但是其中一个数字后面带个字母,改了就好了,仔细看看]]></description><category></category></item></channel></rss>