<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[iteye_8954的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/iteye_8954</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; iteye_8954]]></copyright><item><title><![CDATA[sql 中 exists 关键字的用法]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82511710</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82511710</guid><author>iteye_8954</author><pubDate>Thu, 30 May 2013 20:59:41 +0800</pubDate><description><![CDATA[
好久没发表博客了，今日偶有闲暇 仔细研究了一遍oracle中exists 的用法,整理了在一起， 记录在itieye,以防后忘。。。。嘎嘎
1. 关于数据首先做好数据的初始化工作
-- Create tablecreate table CUSTOMERS(  CID    NUMBER not null,  CNAME  VARCHAR2(50) not null)alter table ...]]></description><category></category></item><item><title><![CDATA[今天要放假咯]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82476483</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82476483</guid><author>iteye_8954</author><pubDate>Fri, 01 Feb 2013 15:23:33 +0800</pubDate><description><![CDATA[今天要放假咯，放年假咯！！！嘎嘎嘎]]></description><category></category></item><item><title><![CDATA[分页 连接查询]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82440191</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82440191</guid><author>iteye_8954</author><pubDate>Mon, 05 Nov 2012 15:31:57 +0800</pubDate><description><![CDATA[public PageObject bookList(PageParameter req, Map args) {

  String sql = &quot; select BID as ID,BNAME,BREMARK,BCOVER,USERNAME as CREATEDID,

TO_CHAR(CREATEDTIME,'YYYY-MM-DD HH24:MI:SS') as CREATEDTIM...]]></description><category></category></item><item><title><![CDATA[struts2标签的用法]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82436578</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82436578</guid><author>iteye_8954</author><pubDate>Mon, 22 Oct 2012 09:35:51 +0800</pubDate><description><![CDATA[
set标签 
set标签 用户将某个值 放入到指定的范围
 
&amp;lt;s:set value=&quot;#request.msgxxx&quot; var=&quot;xxx&quot;&amp;gt;
       &amp;lt;s:property value=&quot;#xxx&quot;&amp;gt;
&amp;lt;/s:set&amp;gt;
 
解释set标签，通过这个ognl表达式#request.msgxxx把值取出来
 
使用var关键字,在把这个..]]></description><category></category></item><item><title><![CDATA[ognl表达式标记符号的用法]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82436576</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82436576</guid><author>iteye_8954</author><pubDate>Mon, 22 Oct 2012 09:28:28 +0800</pubDate><description><![CDATA[
“#”的用法 
集合的投影（只输出部分属性）用法 collectionName.{expression}&amp;lt;br&amp;gt;
&amp;lt;s:iterator value=&quot;#request.personList.{name}&quot;&amp;gt;
       &amp;lt;s:property&amp;gt;
&amp;lt;/s:iterator&amp;gt;
-------------------------------...]]></description><category></category></item><item><title><![CDATA[选择哪个题库的哪道题 ]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82435510</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82435510</guid><author>iteye_8954</author><pubDate>Tue, 16 Oct 2012 20:05:54 +0800</pubDate><description><![CDATA[select tt.total ,ts.SubjectID ,TS.SUBJECT,tu.userid,tu.username  from tbSubjects ts  
inner join (  select count(TopicID) total ,subjectid from tbTopic GROUP BY SUBJECTID) tt on ts.SubjectID = tt.Sub...]]></description><category></category></item><item><title><![CDATA[spring注入通过注解方式实现]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82435226</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82435226</guid><author>iteye_8954</author><pubDate>Mon, 15 Oct 2012 15:02:11 +0800</pubDate><description><![CDATA[public class LoginForUserAction extends ActionSupportExtend {  @Autowired private TbUserService tbUserService;
 
}
public interface TbUserService {}
@Servicepublic class TbUserServiceImpl implemen...]]></description><category></category></item><item><title><![CDATA[测试在线考试系统]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82435223</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82435223</guid><author>iteye_8954</author><pubDate>Mon, 15 Oct 2012 14:50:11 +0800</pubDate><description><![CDATA[系统管理，有题型管理，岗位序列，和操作日志3个节点 ，其中题型管理有子个节点。
考试管理，有在线考试 和在线联系两个节点。
 通过对在线考试的节点，可以完成对试卷的增删改查。
          添加试卷，就是在在线考试这个节点中完成的。
   在添加试卷时，试卷有效时间 往前推一天，才能在前台的我的考试，未完成的考试列表中看见。    也就是说，我今天刚生成的试卷，默认有效时间是2012...]]></description><category></category></item><item><title><![CDATA[把Object[ ]作为 参数为传递出去]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82435148</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82435148</guid><author>iteye_8954</author><pubDate>Mon, 15 Oct 2012 09:26:51 +0800</pubDate><description><![CDATA[Object[] args1 = { userName, _base_user_organid,
 RText.Md5(passWord), userAlias, sex,
 status, experience,
 &quot;userAliasPY&quot;, joinWork, born, mobile, email,
 phone,CardID, perNo,workerSeriasNo,accou...]]></description><category></category></item><item><title><![CDATA[oracle 分组 row_number() ]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82434339</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82434339</guid><author>iteye_8954</author><pubDate>Wed, 10 Oct 2012 19:26:49 +0800</pubDate><description><![CDATA[create or replace view vw004_examineegrade asselect &quot;EGID&quot;,&quot;USERID&quot;,&quot;TPID&quot;,&quot;WLGID&quot;,&quot;EXTIMES&quot;,&quot;EXSTATE&quot;,&quot;EXB_TIME&quot;,   &quot;EXE_TIME&quot;,&quot;TESTTIME&quot;,&quot;OBJECTIVE&quot;,&quot]]></description><category></category></item><item><title><![CDATA[查询数值 类型然后返回字符串]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82412966</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82412966</guid><author>iteye_8954</author><pubDate>Fri, 28 Sep 2012 16:31:09 +0800</pubDate><description><![CDATA[String sql = &quot;select t.tpid,eg.egid,DATE_FORMAT(eg.exb_time,'%Y-%m-%d %H:%i') as EXB_TIME,t.papername,t.viewpaper,&quot; +        &quot;if(MINUTE(SEC_TO_TIME(eg.testtime))&amp;lt;&amp;gt;0,CONCAT(CONVERT(MINUTE(SEC_TO_...]]></description><category></category></item><item><title><![CDATA[复杂的decode()函数]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82412698</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82412698</guid><author>iteye_8954</author><pubDate>Thu, 27 Sep 2012 16:41:15 +0800</pubDate><description><![CDATA[select tt.ttid,tt.targettrain,DATE_FORMAT(tt.datecreated,'%Y-%m-%d %H:%i') datecreated,
ifnull(ttcount,0) ttcount,ifnull(joincount,0) joincount,ifnull(passcount,0) passcount,
round(     ifnull(joinc...]]></description><category></category></item><item><title><![CDATA[解决问题 贵在一剑封喉]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82412660</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82412660</guid><author>iteye_8954</author><pubDate>Thu, 27 Sep 2012 15:13:20 +0800</pubDate><description><![CDATA[Column 'ttid' in where clause is ambiguous
 
 多半是因为多表查询的时候几个表中同时出现了某个相同的列名，而在查询条件WHERE后面又没有指定是那个表，而引起的又或者是查询结果里面有两个相同的列名，而没有指定是哪个表，使用的时候可以这样，查询前面加表名可避免出现错误ambiguous 1. 含糊不清的 2. 引起歧义的
 
select dist...]]></description><category></category></item><item><title><![CDATA[在Action里往值栈中存放对象的方法]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82412520</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82412520</guid><author>iteye_8954</author><pubDate>Thu, 27 Sep 2012 00:31:43 +0800</pubDate><description><![CDATA[ActionContext.getContext().put(&quot;departmentList&quot;,departmentList);
是直接往 map栈中存放元素
Stack Context
Key                ValuedepartmentList      [cn.xiaoxian.domain.Department@8098]
&amp;lt;s:iterator value=...]]></description><category></category></item><item><title><![CDATA[iterator 迭代标签 在迭代map的时候的巧妙使用]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82412518</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82412518</guid><author>iteye_8954</author><pubDate>Wed, 26 Sep 2012 23:55:20 +0800</pubDate><description><![CDATA[List&amp;lt;Map&amp;lt;String,Object&amp;gt;&amp;gt; maps = new ArrayList&amp;lt;Map&amp;lt;String,Object&amp;gt;&amp;gt;();
 
Map&amp;lt;String,Object&amp;gt; map1 = new HashMap&amp;lt;String,Object&amp;gt;();
Person person1 = new Person();
pe...]]></description><category></category></item><item><title><![CDATA[date_format()函数的使用]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82412210</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82412210</guid><author>iteye_8954</author><pubDate>Wed, 26 Sep 2012 00:59:25 +0800</pubDate><description><![CDATA[String sql = &quot;select count(1) from tbweblog where userid=1 and date_format(curdate(),'%Y-%m-%d')=date_format(logintime,'%Y-%m-%d')&quot;;

一、判断文本是否为空

var jqObj = $(this);if(jqObj.text().trim()){ //tri...]]></description><category></category></item><item><title><![CDATA[jquery常用事件]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82412206</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82412206</guid><author>iteye_8954</author><pubDate>Wed, 26 Sep 2012 00:40:25 +0800</pubDate><description><![CDATA[bulr() 
 
触发每一个匹配元素的blur事件
 
这个函数会调用 绑定 blur事件的 所有函数 ，也包括浏览器的默认行为
 
通过返回false 可以防止浏览器的默认行为
。
blur 事件在元素失去焦点的时候 触发
 
$(&quot;p&quot;).blur();触发所有段落的blur()事件
 
blur(fn)
在每一个匹配元素的blur事件中绑定一个处理函数
 
$...]]></description><category></category></item><item><title><![CDATA[下拉列表]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82411857</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82411857</guid><author>iteye_8954</author><pubDate>Tue, 25 Sep 2012 01:09:09 +0800</pubDate><description><![CDATA[$.post(&quot;../CityServlet&quot;,null,function(data){
 var jsonObject = eval(&quot;(&quot;+data+&quot;)&quot;);
 for(var i=0; i&amp;lt;jsonObject.length;i++){    var pName = jsonObject[i].pname;  var $option = $(&quot;&amp;lt;option/&amp;gt;&quot;);...]]></description><category></category></item><item><title><![CDATA[被字符串"绑架"了的jsonObject ！]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82411854</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82411854</guid><author>iteye_8954</author><pubDate>Tue, 25 Sep 2012 00:35:20 +0800</pubDate><description><![CDATA[&amp;lt;script language=&quot;javascript&quot; &amp;gt;
 var str =&quot;alert('aaa')&quot;; //这是一个字符串 这个字符串 符合js的语法规则
 eval(str);//把符合js代码规则的字符串 转换成js代码&amp;lt;/script&amp;gt;
我一开始在后台 把jsonArrayObject 变成了字符串,在字符串
然后我在前台 再把这个字符串 通过使用...]]></description><category></category></item><item><title><![CDATA[hibernate基础]]></title><link>https://blog.youkuaiyun.com/iteye_8954/article/details/82411843</link><guid>https://blog.youkuaiyun.com/iteye_8954/article/details/82411843</guid><author>iteye_8954</author><pubDate>Mon, 24 Sep 2012 23:23:03 +0800</pubDate><description><![CDATA[1.创建Configuration类的实例，Configuration类的构造方法把默认文件路径下的hibernate.properties配置文件中
的配置信息读入到内存: Configuration config = new Configuration();
2.调用Configuration类的addClass(Customer.class)方法:
     config.addCla...]]></description><category></category></item></channel></rss>