??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲国产日韩精品,九九热hot精品视频在线播放,久久99视频http://www.aygfsteel.com/mashiguang/马快跑zh-cnSat, 17 May 2025 04:24:46 GMTSat, 17 May 2025 04:24:46 GMT60开发常用文?/title><link>http://www.aygfsteel.com/mashiguang/archive/2011/08/11/356336.html</link><dc:creator>mashiguang</dc:creator><author>mashiguang</author><pubDate>Thu, 11 Aug 2011 15:05:00 GMT</pubDate><guid>http://www.aygfsteel.com/mashiguang/archive/2011/08/11/356336.html</guid><description><![CDATA[spring2.5-reference.pdf<a ><br />http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=d9d1668c0b162f26d115a49e0b308e4f</a><br /><br />deerjet src.zip<br /><a >http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=c859c9a30c5f19e2732255e81a4f0c36</a><br /><br />jQueryAPI-100214.chm<br /><a >http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=c64a572a16f169ac6db829a3122c4279</a> <br /><br />hibernate_annotations.pdf<br /><a >http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=88bd4e31848fda5ca2e65b6fc19df73f</a><br /><br />hibernate_reference.pdf<br /><a >http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=603986150b7056ce617289370197ea9a</a><br /><br />HQL与Criteria对照.pdf<br /><a >http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=c2805f9d49171f6165baa528a29774c7</a> <br /><br />oracle~程艺术.pdf<br /><a >http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=0c39f09f81f674ef67016482a224a025</a><br /><br />_Noracle10g pl_sql~程.pdf<br /><a >http://m0.mail.sina.com.cn/apps/netdisk/download.php?id=455bb7bbfeff510ee66acafe6c8f035b</a><img src ="http://www.aygfsteel.com/mashiguang/aggbug/356336.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/mashiguang/" target="_blank">mashiguang</a> 2011-08-11 23:05 <a href="http://www.aygfsteel.com/mashiguang/archive/2011/08/11/356336.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>hibernate DetachedCriteria的?/title><link>http://www.aygfsteel.com/mashiguang/archive/2011/08/11/356334.html</link><dc:creator>mashiguang</dc:creator><author>mashiguang</author><pubDate>Thu, 11 Aug 2011 14:50:00 GMT</pubDate><guid>http://www.aygfsteel.com/mashiguang/archive/2011/08/11/356334.html</guid><description><![CDATA[<div style="border-bottom: #cccccc 1px solid; border-left: #cccccc 1px solid; padding-bottom: 4px; background-color: #eeeeee; padding-left: 4px; width: 98%; padding-right: 5px; font-size: 13px; word-break: break-all; border-top: #cccccc 1px solid; border-right: #cccccc 1px solid; padding-top: 4px"><!--<br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--><span style="color: #0000ff">public</span><span style="color: #000000"> PageModel</span><span style="color: #000000"><</span><span style="color: #000000">CrmWarning</span><span style="color: #000000">></span><span style="color: #000000"> query(PageModel</span><span style="color: #000000"><</span><span style="color: #000000">CrmWarning</span><span style="color: #000000">></span><span style="color: #000000"> pageModel)<br />            </span><span style="color: #0000ff">throws</span><span style="color: #000000"> Exception {<br />        Assert.notNull(pageModel);<br />        <br />        DetachedCriteria dc </span><span style="color: #000000">=</span><span style="color: #000000"> DetachedCriteria.forClass(CrmWarning.</span><span style="color: #0000ff">class</span><span style="color: #000000">);<br />        <br />        </span><span style="color: #008000">/*</span><span style="color: #008000"><br />         * d查询条g<br />         * ?dc.add(Restrictions.like("key", "%"+pageModel.getCondition("key")+"%"));<br />         * <br />         * </span><span style="color: #008000">*/</span><span style="color: #000000"><br />        </span><span style="color: #0000ff">if</span><span style="color: #000000"> (</span><span style="color: #0000ff">null</span><span style="color: #000000"> </span><span style="color: #000000">!=</span><span style="color: #000000"> pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">warnLevel</span><span style="color: #000000">"</span><span style="color: #000000">)) {<br />            dc.add(Restrictions.eq(</span><span style="color: #000000">"</span><span style="color: #000000">warnLevel</span><span style="color: #000000">"</span><span style="color: #000000">, pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">warnLevel</span><span style="color: #000000">"</span><span style="color: #000000">)));<br />        }<br />        </span><span style="color: #0000ff">if</span><span style="color: #000000"> (StringUtils.isNotBlank((String)pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">detail</span><span style="color: #000000">"</span><span style="color: #000000">))) {<br />            dc.add(Restrictions.like(</span><span style="color: #000000">"</span><span style="color: #000000">detail</span><span style="color: #000000">"</span><span style="color: #000000">, </span><span style="color: #000000">"</span><span style="color: #000000">%</span><span style="color: #000000">"</span><span style="color: #000000">+</span><span style="color: #000000">pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">detail</span><span style="color: #000000">"</span><span style="color: #000000">)</span><span style="color: #000000">+</span><span style="color: #000000">"</span><span style="color: #000000">%</span><span style="color: #000000">"</span><span style="color: #000000">));<br />        }<br />        </span><span style="color: #0000ff">if</span><span style="color: #000000"> (StringUtils.isNotBlank((String)pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">warnDate</span><span style="color: #000000">"</span><span style="color: #000000">))) {<br />            </span><span style="color: #008000">/*</span><span style="color: #008000"><br />             * warnDate格式是yyyy-MM-ddQ这里改成查询这一天的预警<br />             * Restrictions.sqlRestriction()允许写原生sql的方式完成特D需求,如下<br />             * </span><span style="color: #008000">*/</span><span style="color: #000000"><br />            dc.add(Restrictions.sqlRestriction(</span><span style="color: #000000">"</span><span style="color: #000000">to_char(time_start,'yyyy-MM-dd') = '</span><span style="color: #000000">"</span><span style="color: #000000"> </span><span style="color: #000000">+</span><span style="color: #000000"> pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">warnDate</span><span style="color: #000000">"</span><span style="color: #000000">) </span><span style="color: #000000">+</span><span style="color: #000000"> </span><span style="color: #000000">"</span><span style="color: #000000">'</span><span style="color: #000000">"</span><span style="color: #000000">));<br />        }<br />        </span><span style="color: #0000ff">if</span><span style="color: #000000"> (</span><span style="color: #0000ff">null</span><span style="color: #000000"> </span><span style="color: #000000">!=</span><span style="color: #000000"> pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">templateId</span><span style="color: #000000">"</span><span style="color: #000000">)) {<br />            </span><span style="color: #008000">/*</span><span style="color: #008000"><br />             * q里的templateId是模板的主键id,查询时应该{换成模板对象<br />             * </span><span style="color: #008000">*/</span><span style="color: #000000"><br />            CrmWarnTemplate warnTemplate </span><span style="color: #000000">=</span><span style="color: #000000"> </span><span style="color: #0000ff">new</span><span style="color: #000000"> CrmWarnTemplate();<br />            warnTemplate.setTemplateId((Long)pageModel.getCondition(</span><span style="color: #000000">"</span><span style="color: #000000">templateId</span><span style="color: #000000">"</span><span style="color: #000000">));<br />            dc.add(Restrictions.eq(</span><span style="color: #000000">"</span><span style="color: #000000">crmWarnTemplate</span><span style="color: #000000">"</span><span style="color: #000000">, warnTemplate));<br />        }<br />        <br />        dc.addOrder(Order.asc(</span><span style="color: #000000">"</span><span style="color: #000000">crmWarnTemplate</span><span style="color: #000000">"</span><span style="color: #000000">));<br />        dc.addOrder(Order.desc(</span><span style="color: #000000">"</span><span style="color: #000000">timeStart</span><span style="color: #000000">"</span><span style="color: #000000">));<br />        <br />        pageModel.setDateList(warningDao.query(dc, pageModel.getFirstNote(), pageModel.getNumInPage()));<br />        pageModel.setTotal(warningDao.count(dc));<br />        <br />        </span><span style="color: #0000ff">return</span><span style="color: #000000"> pageModel;<br />    }</span></div><img src ="http://www.aygfsteel.com/mashiguang/aggbug/356334.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/mashiguang/" target="_blank">mashiguang</a> 2011-08-11 22:50 <a href="http://www.aygfsteel.com/mashiguang/archive/2011/08/11/356334.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>hibernate手动l装pojohttp://www.aygfsteel.com/mashiguang/archive/2011/08/11/hibernate_pojo_manual.htmlmashiguangmashiguangThu, 11 Aug 2011 14:25:00 GMThttp://www.aygfsteel.com/mashiguang/archive/2011/08/11/hibernate_pojo_manual.htmlpackage com.jl.dao.bookplatform.impl;

import java.util.List;

import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.transform.Transformers;
import org.springframework.dao.DataAccessException;

import com.jl.dao.baseDao.GenericDao;
import com.jl.dao.bookplatform.ProductItemDao;
import com.jl.entity.bookplatform.CrmProduct;
import com.jl.entity.bookplatform.CrmProductItem;
import com.jl.entity.bookplatform.ProductItemConfig;

public class ProductItemDaoImpl extends GenericDao<CrmProductItem, Long> implements ProductItemDao {

    
    
public List<ProductItemConfig> getProductItemConfigs(Long productId, Long planetypeId) throws DataAccessException{
        String sql 
= "select chi.charge_item_id \"chargeItemId\"," +
                
" chi.charge_item \"chargeItem\"," +
                
" chi.charge_unit \"chargeUnit\"," +
                
" cpi.product_id \"productId\"," +
                
" cpi.product_item_id \"productItemId\"," +
                
" cpi.sale_planetype_id \"salePlanetypeId\"," +
                
" cpi.inland_price \"inlandPrice\"," +
                
" cpi.outland_price \"outlandPrice\"" +
                
" from (select * from crm_charge_item chi2 where chi2.if_regular = 1) chi left join crm_product_item cpi" +
                
" on cpi.charge_item_id = chi.charge_item_id " +
                
" and cpi.product_id = ?" +
                
" and cpi.sale_planetype_id = ?" +
                
" order by chi.charge_item_id";
        
        Session session 
= getSession();
        Query query 
= session.createSQLQuery(sql)
            .addScalar(
"chargeItemId", Hibernate.LONG)
            .addScalar(
"chargeItem",Hibernate.STRING)
            .addScalar(
"chargeUnit",Hibernate.STRING)
            .addScalar(
"productId",Hibernate.LONG)
            .addScalar(
"productItemId",Hibernate.LONG)
            .addScalar(
"salePlanetypeId",Hibernate.LONG)
            .addScalar(
"inlandPrice",Hibernate.DOUBLE)
            .addScalar(
"outlandPrice",Hibernate.DOUBLE)
            .setResultTransformer(Transformers.aliasToBean(ProductItemConfig.
class))
            .setParameter(
0, productId)
            .setParameter(
1, planetypeId);
        
        List
<ProductItemConfig> configs = query.list();
        
        
return configs;
    }

    
public List<CrmProductItem> getProductItem(CrmProduct product) throws DataAccessException {
        
        String hql 
= "from CrmProductItem cpi where cpi.crmProduct = ?";
        Session session 
= getSession();
        Query query 
= session.createSQLQuery(hql).setParameter(0, product);
        
        List
<CrmProductItem> items = query.list();
        
return items;
    }
    
    
public void copy(Long productId_dest,Long productId_orig,String createMan) throws DataAccessException {
        String sql 
= "insert into crm_product_item " +
                
" select hibernate_sequence.nextval," +
                
" ?," +
                
" cpi.charge_item_id," +
                
" cpi.sale_planetype_id," +
                
" cpi.inland_price," +
                
" cpi.outland_price," +
                
" ?," +
                
" sysdate" +
                
" from crm_product_item cpi" +
                
" where cpi.product_id = ?";
        
        Session session 
= getSession();
        Query sqlQuery 
= session.createSQLQuery(sql)
                        .setParameter(
0, productId_dest)
                        .setParameter(
1, createMan)
                        .setParameter(
2, productId_orig);
        sqlQuery.executeUpdate();
    }
    
    
}


mashiguang 2011-08-11 22:25 发表评论
]]>
tomcat eclipseq程调试http://www.aygfsteel.com/mashiguang/archive/2011/02/26/345245.htmlmashiguangmashiguangSat, 26 Feb 2011 09:39:00 GMThttp://www.aygfsteel.com/mashiguang/archive/2011/02/26/345245.htmlhttp://www.aygfsteel.com/mashiguang/comments/345245.htmlhttp://www.aygfsteel.com/mashiguang/archive/2011/02/26/345245.html#Feedback2http://www.aygfsteel.com/mashiguang/comments/commentRss/345245.htmlhttp://www.aygfsteel.com/mashiguang/services/trackbacks/345245.html 直接?tomcat_home%\bin下徏立tomcat_debug.bat文gQ内容如下:

cd %CATALINE_HOME%/bin
set JPDA_ADDRESS=8787
set JPDA_TRANSPORT=dt_socket
set CATALINA_OPTS=-server -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8787
startup

需要远E调试时从tomcat_debug.bat启动?br />
2Qeclipse调试
选择菜单"Run>Debug..."Q弹出窗口里右键点击"Remote Java Application"Q选择"New"Q如图:


点击"Debug"按钮Q开始远E调试,当程序运行到断点ӞEclipse会捕获到?br />

有关普通java app的远E调试可以参考http://blog.chenlb.com/2010/07/eclipse-remoting-debug-java-app.html

mashiguang 2011-02-26 17:39 发表评论
]]>
jQuery validate 日期比较 自定义验证方?/title><link>http://www.aygfsteel.com/mashiguang/archive/2011/02/17/344518.html</link><dc:creator>mashiguang</dc:creator><author>mashiguang</author><pubDate>Thu, 17 Feb 2011 02:34:00 GMT</pubDate><guid>http://www.aygfsteel.com/mashiguang/archive/2011/02/17/344518.html</guid><wfw:comment>http://www.aygfsteel.com/mashiguang/comments/344518.html</wfw:comment><comments>http://www.aygfsteel.com/mashiguang/archive/2011/02/17/344518.html#Feedback</comments><slash:comments>9</slash:comments><wfw:commentRss>http://www.aygfsteel.com/mashiguang/comments/commentRss/344518.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/mashiguang/services/trackbacks/344518.html</trackback:ping><description><![CDATA[<div style="border-bottom: #cccccc 1px solid; border-left: #cccccc 1px solid; padding-bottom: 4px; background-color: #eeeeee; padding-left: 4px; width: 98%; padding-right: 5px; font-size: 13px; word-break: break-all; border-top: #cccccc 1px solid; border-right: #cccccc 1px solid; padding-top: 4px"><span style="color: #0000ff"><!</span><span style="color: #ff00ff">DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"</span><span style="color: #0000ff">></span><span style="color: #000000"><br /> </span><span style="color: #0000ff"><</span><span style="color: #800000">HTML</span><span style="color: #0000ff">></span><span style="color: #000000"><br />  </span><span style="color: #0000ff"><</span><span style="color: #800000">HEAD</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">TITLE</span><span style="color: #0000ff">></span><span style="color: #000000"> New Document </span><span style="color: #0000ff"></</span><span style="color: #800000">TITLE</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">META </span><span style="color: #ff0000">NAME</span><span style="color: #0000ff">="Generator"</span><span style="color: #ff0000"> CONTENT</span><span style="color: #0000ff">="EditPlus"</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">META </span><span style="color: #ff0000">NAME</span><span style="color: #0000ff">="Author"</span><span style="color: #ff0000"> CONTENT</span><span style="color: #0000ff">=""</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">META </span><span style="color: #ff0000">NAME</span><span style="color: #0000ff">="Keywords"</span><span style="color: #ff0000"> CONTENT</span><span style="color: #0000ff">=""</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">META </span><span style="color: #ff0000">NAME</span><span style="color: #0000ff">="Description"</span><span style="color: #ff0000"> CONTENT</span><span style="color: #0000ff">=""</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">script </span><span style="color: #ff0000">type</span><span style="color: #0000ff">="text/javascript"</span><span style="color: #ff0000"> src</span><span style="color: #0000ff">="jquery-1.4.2.js"</span><span style="color: #0000ff">></</span><span style="color: #800000">script</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">script </span><span style="color: #ff0000">type</span><span style="color: #0000ff">="text/javascript"</span><span style="color: #ff0000"> src</span><span style="color: #0000ff">="jquery.validate.js"</span><span style="color: #0000ff">></</span><span style="color: #800000">script</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   </span><span style="color: #0000ff"><</span><span style="color: #800000">SCRIPT </span><span style="color: #ff0000">LANGUAGE</span><span style="color: #0000ff">="JavaScript"</span><span style="color: #0000ff">></span><span style="background-color: #f5f5f5; color: #000000"><br />   </span><span style="background-color: #f5f5f5; color: #000000"><!--</span><span style="background-color: #f5f5f5; color: #000000"><br />     jQuery(</span><span style="background-color: #f5f5f5; color: #0000ff">function</span><span style="background-color: #f5f5f5; color: #000000">(){        <br />         jQuery.validator.methods.compareDate </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> </span><span style="background-color: #f5f5f5; color: #0000ff">function</span><span style="background-color: #f5f5f5; color: #000000">(value, element, param) {<br />             </span><span style="background-color: #f5f5f5; color: #008000">//</span><span style="background-color: #f5f5f5; color: #008000">var startDate = jQuery(param).val() + ":00";补全yyyy-MM-dd HH:mm:ss格式</span><span style="background-color: #f5f5f5; color: #008000"><br /> </span><span style="background-color: #f5f5f5; color: #000000">            </span><span style="background-color: #f5f5f5; color: #008000">//</span><span style="background-color: #f5f5f5; color: #008000">value = value + ":00";</span><span style="background-color: #f5f5f5; color: #008000"><br /> </span><span style="background-color: #f5f5f5; color: #000000">            <br />             </span><span style="background-color: #f5f5f5; color: #0000ff">var</span><span style="background-color: #f5f5f5; color: #000000"> startDate </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> jQuery(param).val();<br />             <br />             </span><span style="background-color: #f5f5f5; color: #0000ff">var</span><span style="background-color: #f5f5f5; color: #000000"> date1 </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> </span><span style="background-color: #f5f5f5; color: #0000ff">new</span><span style="background-color: #f5f5f5; color: #000000"> Date(Date.parse(startDate.replace(</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">-</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">, </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">/</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">)));<br />             </span><span style="background-color: #f5f5f5; color: #0000ff">var</span><span style="background-color: #f5f5f5; color: #000000"> date2 </span><span style="background-color: #f5f5f5; color: #000000">=</span><span style="background-color: #f5f5f5; color: #000000"> </span><span style="background-color: #f5f5f5; color: #0000ff">new</span><span style="background-color: #f5f5f5; color: #000000"> Date(Date.parse(value.replace(</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">-</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">, </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">/</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">)));<br />             </span><span style="background-color: #f5f5f5; color: #0000ff">return</span><span style="background-color: #f5f5f5; color: #000000"> date1 </span><span style="background-color: #f5f5f5; color: #000000"><</span><span style="background-color: #f5f5f5; color: #000000"> date2;<br />         };<br />         <br />         jQuery(</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">#form1</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">).validate({<br />             focusInvalid:</span><span style="background-color: #f5f5f5; color: #0000ff">false</span><span style="background-color: #f5f5f5; color: #000000">,<br />             rules:{<br />                 </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">timeStart</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">:{<br />                     required: </span><span style="background-color: #f5f5f5; color: #0000ff">true</span><span style="background-color: #f5f5f5; color: #000000"><br />                 },<br />                 </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">timeEnd</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">: {<br />                     required: </span><span style="background-color: #f5f5f5; color: #0000ff">true</span><span style="background-color: #f5f5f5; color: #000000">,<br />                     compareDate: </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">#timeStart</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000"><br />                 }<br />             },<br />             messages:{<br />                 </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">timeStart</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">:{<br />                     required: </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">开始时间不能ؓI?/span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000"><br />                 },<br />                 </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">timeEnd</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">:{<br />                     required: </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">l束旉不能为空</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">,<br />                     compareDate: </span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000">l束日期必须大于开始日?</span><span style="background-color: #f5f5f5; color: #000000">"</span><span style="background-color: #f5f5f5; color: #000000"><br />                 }<br />             }<br />         });<br />     });<br />   </span><span style="background-color: #f5f5f5; color: #008000">//</span><span style="background-color: #f5f5f5; color: #008000">--></span><span style="background-color: #f5f5f5; color: #008000"><br /> </span><span style="background-color: #f5f5f5; color: #000000">  </span><span style="color: #0000ff"></</span><span style="color: #800000">SCRIPT</span><span style="color: #0000ff">></span><span style="color: #000000"><br />  </span><span style="color: #0000ff"></</span><span style="color: #800000">HEAD</span><span style="color: #0000ff">></span><span style="color: #000000"><br /> <br />  </span><span style="color: #0000ff"><</span><span style="color: #800000">BODY</span><span style="color: #0000ff">></span><span style="color: #000000"><br />  </span><span style="color: #0000ff"><</span><span style="color: #800000">form </span><span style="color: #ff0000">id</span><span style="color: #0000ff">="form1"</span><span style="color: #ff0000"> name</span><span style="color: #0000ff">="form1"</span><span style="color: #ff0000"> method</span><span style="color: #0000ff">="post"</span><span style="color: #ff0000"> action</span><span style="color: #0000ff">="demo.html"</span><span style="color: #0000ff">></span><span style="color: #000000"><br />    </span><span style="color: #0000ff"><</span><span style="color: #800000">p</span><span style="color: #0000ff">></span><span style="color: #000000">timeStart:<br />      </span><span style="color: #0000ff"><</span><span style="color: #800000">input </span><span style="color: #ff0000">name</span><span style="color: #0000ff">="timeStart"</span><span style="color: #ff0000"> type</span><span style="color: #0000ff">="text"</span><span style="color: #ff0000"> id</span><span style="color: #0000ff">="timeStart"</span><span style="color: #ff0000"> value</span><span style="color: #0000ff">="2011-02-17 10:00:00"</span><span style="color: #0000ff">></span><span style="color: #000000"> yyyy-MM-dd HH:mm:ss<br />    </span><span style="color: #0000ff"></</span><span style="color: #800000">p</span><span style="color: #0000ff">></span><span style="color: #000000"><br />    </span><span style="color: #0000ff"><</span><span style="color: #800000">p</span><span style="color: #0000ff">></span><span style="color: #000000">timeEnd:<br />      </span><span style="color: #0000ff"><</span><span style="color: #800000">input </span><span style="color: #ff0000">name</span><span style="color: #0000ff">="timeEnd"</span><span style="color: #ff0000"> type</span><span style="color: #0000ff">="text"</span><span style="color: #ff0000"> id</span><span style="color: #0000ff">="timeEnd"</span><span style="color: #ff0000"> value</span><span style="color: #0000ff">="2011-02-17 9:00:00"</span><span style="color: #0000ff">></span><span style="color: #000000"> yyyy-MM-dd HH:mm:ss<br />    </span><span style="color: #0000ff"></</span><span style="color: #800000">p</span><span style="color: #0000ff">></span><span style="color: #000000"><br />    </span><span style="color: #0000ff"><</span><span style="color: #800000">p</span><span style="color: #0000ff">></span><span style="color: #000000"><br />      </span><span style="color: #0000ff"><</span><span style="color: #800000">input </span><span style="color: #ff0000">type</span><span style="color: #0000ff">="submit"</span><span style="color: #ff0000"> name</span><span style="color: #0000ff">="Submit"</span><span style="color: #ff0000"> value</span><span style="color: #0000ff">="提交"</span><span style="color: #0000ff">></span><span style="color: #000000"><br />    </span><span style="color: #0000ff"></</span><span style="color: #800000">p</span><span style="color: #0000ff">></span><span style="color: #000000"><br />  </span><span style="color: #0000ff"></</span><span style="color: #800000">form</span><span style="color: #0000ff">></span><span style="color: #000000"><br />   <br />  </span><span style="color: #0000ff"></</span><span style="color: #800000">BODY</span><span style="color: #0000ff">></span><span style="color: #000000"><br /> </span><span style="color: #0000ff"></</span><span style="color: #800000">HTML</span><span style="color: #0000ff">></span><span style="color: #000000"><br /> </span></div> <img src ="http://www.aygfsteel.com/mashiguang/aggbug/344518.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/mashiguang/" target="_blank">mashiguang</a> 2011-02-17 10:34 <a href="http://www.aygfsteel.com/mashiguang/archive/2011/02/17/344518.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>关于Oracle一个汉字代表几个字节的问题Q{Q?/title><link>http://www.aygfsteel.com/mashiguang/archive/2011/01/21/343313.html</link><dc:creator>mashiguang</dc:creator><author>mashiguang</author><pubDate>Fri, 21 Jan 2011 04:49:00 GMT</pubDate><guid>http://www.aygfsteel.com/mashiguang/archive/2011/01/21/343313.html</guid><wfw:comment>http://www.aygfsteel.com/mashiguang/comments/343313.html</wfw:comment><comments>http://www.aygfsteel.com/mashiguang/archive/2011/01/21/343313.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/mashiguang/comments/commentRss/343313.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/mashiguang/services/trackbacks/343313.html</trackback:ping><description><![CDATA[<p>在Oracle定义变量Ӟ常有VARCHAR2 (3 Char)或者VARCHAR2 (10 Byte)的数据类型,那么3char或?0Byte到底代表几个汉字Q几个字W呢Q上ơ外公司一同事讨论q个问题Q一下没l解释清楚,所以下来以后整理如下:</p> <p>ȝQ?br /> 当NLS_CHARACTERSET=AL32UTF8ӞQ?br /> NLS_LENGTH_SEMANTICS=BYTEӞ一个汉字代表三个字?br /> NLS_LENGTH_SEMANTICS=CHARӞ一个汉字代表一个字?br /> 当NLS_CHARACTERSET=US7ASCIIӞ字符集ؓ单字节)<br /> NLS_LENGTH_SEMANTICS=BYTEӞ一个汉字代表两个字?br /> NLS_LENGTH_SEMANTICS=CHARӞ一个汉字代表两个字?/p> <p>现象:<br /> select * from nls_database_parameters;<br /> ….      …………..<br /> NLS_CHARACTERSET        AL32UTF8</p> <p>…..</p> <p>NLS_LENGTH_SEMANTICS BYTE</p> <p>….</p> <p>NLS_NCHAR_CHARACTERSET      AL16UTF16</p> <p>NLS_RDBMS_VERSION      10.2.0.4.0<br />  </p> <p>SQL> alter session set nls_length_semantics='BYTE';</p> <p>SQL> create table nls_byte(c1 varchar2(7));</p> <p>SQL> insert into nls_byte values('试?);</p> <p> insert into nls_byte values('试?)</p> <p> ORA-12899: ?"SYS"."NLS_BYTE"."C1" 的值太?(实际? 9, 最大? 7)</p> <p>SQL> insert into nls_byte values('试a');</p> <p> 1 row inserted<br />  <br /> SQL> select table_name,column_name,t.DATA_TYPE,t.DATA_LENGTH,t.CHAR_USED from user_tab_columns t where table_name='NLS_BYTE';</p> <p> TABLE_NAME COLU DATA_TYP DATA_LENGTH CHAR_USED</p> <p>---------- ---- -------- ----------- ---------</p> <p>NLS_BYTE   C1   VARCHAR2           7 B<br />    <br /> NLS_LENGTH_SEMANTICS allows you to specify the length of a column datatype in terms of CHARacters rather than in terms of BYTEs. Typically this is when using an AL32UTF8 or other varying width NLS_CHARACTERSET database where one character is not always one byte. While using CHAR semantics has as such no added value in a 7/8 bit characterset it's fully supported so any application code / table setup using CHAR can also be used in a 7/8bit characterset like US7ASCII/WE8MSWIN1252.<br /> This parameter is a 9i (and up) feature and is not available in older releases</p> <p>译q来是:q个参数允许列的数据单位设为字W而不是byte.q个问题会在字符集设为UTF8的时候出? 此参数在9i以上版本有效.</p> <p>NLS_LENGTH_SEMANTICS 讄.</p> <p>1.      NLS_DATABASE_PARAMETERS中的值是在数据库创徏的时候确定的,一般都为BYTE</p> <p>2.     此参数可以以 “ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR scope=both”方式修改,但是需要重启数据库才能生效.</p> <p>3.     也可?#8221; ALTER SESSION SET NLS_LENGTH_SEMANTICS=CHAR”使对当前session生效.</p> <p>4.     此参数可以在10G以上版本?在环境变量或注册表中讄(注意需要大?,讑֮后从当前客户端启动的所有会话都采用新的取?</p> <p>5.     修改后只Ҏ(gu)建的列生?对于已有的列没有作用</p> <p>6.     新徏或升UDB时用BYTE,否则XDB或dba_tables会出现问?</p> <p>7.     NLS_LENGTH_SEMANTICS对sys用户下的对象无效.</p> <p>8.     如果对于7/8bit的字W集,设ؓbyte/char意义不大,因ؓ无论是char和byte都对应一个byte.</p> <p>试:</p> <p>一.在当前session中修Ҏ(gu)参数</p> <p> SQL> alter session set nls_length_semantics='char';</p> <p> Session altered</p> <p> SQL> create table nls_char(c1 varchar2(7),c2 varchar2(7));</p> <p> Table created</p> <p> SQL> desc nls_char</p> <p>Name Type        Nullable Default Comments</p> <p>---- ----------- -------- ------- --------</p> <p>C1   VARCHAR2(7) Y                       </p> <p>C2   VARCHAR2(7) Y                       </p> <p> SQL> insert into nls_char values('试?,'试试试');</p> <p> 1 row inserted  </p> <p>如果对于alter system,效果是一L(fng)</p> <p>?对于已经存在的表,</p> <p> SQL> desc nls_byte</p> <p>Name Type             Nullable Default Comments</p> <p>---- ---------------- -------- ------- --------</p> <p>C1   VARCHAR2(7 BYTE) Y                       </p> <p>SQL> alter table nls_byte modify c1 varchar2(7 char);</p> <p> Table altered</p> <p> SQL> desc nls_byte</p> <p>Name Type        Nullable Default Comments</p> <p>---- ----------- -------- ------- --------</p> <p>C1   VARCHAR2(7) Y                       </p> <p> SQL> insert into nls_byte values('试?);</p> <p> 1 row inserted<br />  <br /> 1.      exp/imp : 不能直接导入,因ؓ会采用source table的徏表方式在target db里徏?即目标库设的gؓchar.</p> <p>*可以预先在目标库中以char方式</p> <p>*然后导入,指定参数ignore=y</p> <p>  2. Alter table</p> <p>     alter table "<owner>"."<table>" modify "<column>" char (10 char);</p> <p>      创徏脚本,修改列设?</p> <p> ?</p> <p>Bug-3611750, ora-01450 online rebuild of index fails, 可以在重建烦引前指定byte, 10.2.0.5以上已经修复</p> <p>Bug 1488174 UNICODE: ALTER SYSTEM SET NLS_LENGTH_SEMANTICS DOESN'T<br /> TAKE EFFECT, 用此语句修改?实际上不起作?需要重启才能生? 但是如果用alter session方式x生效,不用重启.</p> <p>q一步测?在另一个字W集设ؓus7ascii的DB讄此参?/p> <p>SQL> select * from nls_database_parameters</p> <p>6          NLS_CHARACTERSET  US7ASCII</p> <p>SQL> alter session set nls_length_semantics=byte;</p> <p>Session altered.</p> <p>SQL> create table nls_byte(c1 varchar2(7));</p> <p>Table created.</p> <p>SQL> insert into  nls_byte values('试试');</p> <p>insert into  nls_byte values('试试')</p> <p>ERROR at line 1:</p> <p>ORA-12899: value too large for column "TEA"."NLS_BYTE"."C1" (actual: 8,</p> <p>maximum: 7)</p> <p>SQL> desc nls_byte</p> <p> Name                        Null?    Type</p> <p> -------------------------------</p> <p> C1                                   VARCHAR2(7)</p> <p>SQL> alter session set nls_length_semantics=char;</p> <p>Session altered.</p> <p>SQL> create table nls_char(c1 varchar2(7));</p> <p>Table created.</p> <p>SQL> insert into  nls_char values('试试');</p> <p>insert into  nls_char values('试试')</p> <p>ERROR at line 1:</p> <p>ORA-12899: value too large for column "TEA"."NLS_CHAR"."C1" (actual: 8,</p> <p>maximum: 7)</p> <p>SQL> desc nls_char</p> <p> Name                        Null?    Type</p> <p> ----------------------------------------- -------- -------------------</p> <p>C1                                  VARCHAR2(7)<br />   <br />  可以看出,在字W集为单字节的情况下,无论取何?汉字都是以二个字节的方式存在?</p> <p> </p> <br /> 本文转自http://www.wudeyao.com/post-69.html <img src ="http://www.aygfsteel.com/mashiguang/aggbug/343313.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/mashiguang/" target="_blank">mashiguang</a> 2011-01-21 12:49 <a href="http://www.aygfsteel.com/mashiguang/archive/2011/01/21/343313.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>java.util.ConcurrentModificationExceptionhttp://www.aygfsteel.com/mashiguang/archive/2010/12/08/340034.htmlmashiguangmashiguangWed, 08 Dec 2010 01:47:00 GMThttp://www.aygfsteel.com/mashiguang/archive/2010/12/08/340034.htmlhttp://www.aygfsteel.com/mashiguang/comments/340034.htmlhttp://www.aygfsteel.com/mashiguang/archive/2010/12/08/340034.html#Feedback0http://www.aygfsteel.com/mashiguang/comments/commentRss/340034.htmlhttp://www.aygfsteel.com/mashiguang/services/trackbacks/340034.html ?
for(Object obj : list){
    .remove(obj);
}

最好像下面q样?
for (Iterator it = list.iterator(); it.hasNext();) {
......
it.remove();
}

(d20160420)
如果foreach的同旉要add elementQ就不能使用iterator了,最好重新启用一个新的list暂存新的集合元素?img src ="http://www.aygfsteel.com/mashiguang/aggbug/340034.html" width = "1" height = "1" />

mashiguang 2010-12-08 09:47 发表评论
]]>
jquery.boxy.js扩展 (0.1.40) http://www.aygfsteel.com/mashiguang/archive/2010/09/14/331998.htmlmashiguangmashiguangTue, 14 Sep 2010 09:30:00 GMThttp://www.aygfsteel.com/mashiguang/archive/2010/09/14/331998.htmlhttp://www.aygfsteel.com/mashiguang/comments/331998.htmlhttp://www.aygfsteel.com/mashiguang/archive/2010/09/14/331998.html#Feedback17http://www.aygfsteel.com/mashiguang/comments/commentRss/331998.htmlhttp://www.aygfsteel.com/mashiguang/services/trackbacks/331998.html阅读全文

mashiguang 2010-09-14 17:30 发表评论
]]>
hello cashttp://www.aygfsteel.com/mashiguang/archive/2009/12/07/304958.htmlmashiguangmashiguangMon, 07 Dec 2009 01:50:00 GMThttp://www.aygfsteel.com/mashiguang/archive/2009/12/07/304958.htmlhttp://www.aygfsteel.com/mashiguang/comments/304958.htmlhttp://www.aygfsteel.com/mashiguang/archive/2009/12/07/304958.html#Feedback4http://www.aygfsteel.com/mashiguang/comments/commentRss/304958.htmlhttp://www.aygfsteel.com/mashiguang/services/trackbacks/304958.html使用cas?/span>sso helloword

因ؓ工作需要接触到ssoQ据知目前多?/span>sso使用耉?/span>cas实现Q且发现使用cas真的是很单就可以做出一个单点登录系l来Q?/span>casq提供丰富的扩展功能Q对于扩展功能日后再l细研究Q这里只使用cas做一?/span>hello world来记录本人的学习q程Q如有幸被高人看刎ͼq望指出弊病Q不吝赐教?/span>

在?/span>cas之前最好对数字证书有所了解Q不了解也没有关p,跟着我的步骤也一样可以跑的通?/span>

准备工作

需要的文gQ?/span>

ü         Jdk6

ü         Tomcat

ü         cas-server-3.3.2

ü         cas-client-3.1.9

证书

下面?/span>keytool命o的一些常用方法,先在q里认识一下它们,一会儿会用的到?/span>

使用keytool命o生成密钥?/span>

keytool -genkey -alias tomcat -keyalg RSA -dname "CN=pcma, OU=vanceinfo, O=vanceinfo, L=haidian, S=beijing, C=CN" -keystore c:"keystore5.jks

CNQ主机名

OUQ组l单?/span>

OQ组l?/span>

LQ地?/span>

SQ城?/span>

CQ国?br />
如果需要指定密钥有效期Q添?validity 365卛_Q单位是天,如:
keytool -genkey -alias tomcat -keyalg RSA -dname "xxxxx" -keystore xxxxx -validity 365

导出证书

keytool -export -file c:/server5.crt -alias tomcat -keystore c:"keystore5.jks

证书导入到客户?/span>jdk

keytool -import -keystore "D:"Java"jdk1.6.0_14"jre"lib"security"cacerts" -file c:/server5.crt -alias tomcat

从密钥库中删除指定别名的证书

keytool -delete -noprompt -alias tomcat -keystore E:"apache-tomcat-6.0.20_2"conf"keystore2.jks

查看密钥库中的证?/span>

keytool -list -v -keystore c:"keystore5.jks

配置tomcat

使用keytool命o生成密钥库?/span>

配置%tomcat_home%/conf/server.xml?/span>tomcat支持SSL协议Qƈ指定密钥库?/span>

<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"

               maxThreads="150" scheme="https" secure="true"

               clientAuth="false" sslProtocol="TLS" keystorePass="mashiguang"

                        keystoreFile="${catalina.home}/conf/keystore5.jks"/>

部vcas server

解压~?/span>cas-server-3.3.2-release.zip文gQ在modules目录里找?/span>cas-server-webapp-3.3.2.war文gQ这是一个做好了?/span>cas服务端,我们做的sso helloword可以直接使用Q只需?/span>cas-server-webapp-3.3.2.war改了个简单点的名字,?/span>cas.warQ然后部|到tomcat卛_?/span>

览器访?/span>https://pcma:8443/casQ如果打开昄的是cas默认的登录页面,则表C服务端已部|完毕?/span>

客户端?/span>cas client

新徏两个web工程Q用于模拟单点登录系l中的客L(fng)Qƈ?/span>cas-client-3.1.9"modules里的jar包放?/span>web工程lib目录下,是主要的?/span>cas-client-core-3.1.9.jar文gQ把spring2.5也放?/span>lib目录下?/span>

Web.xml文g

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.4"

       xmlns="http://java.sun.com/xml/ns/j2ee"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee

       http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

       <context-param> 

        <param-name>contextConfigLocation</param-name> 

        <param-value> 

            /WEB-INF/config/casContext.xml  

        </param-value> 

    </context-param> 

    <listener> 

        <listener-class> 

            org.springframework.web.context.ContextLoaderListener  

        </listener-class> 

    </listener> 

    <!-- 负责用户认证 --> 

    <filter> 

        <filter-name>CAS Authentication Filter</filter-name> 

        <filter-class>org.jasig.cas.client.authentication.AuthenticationFilter</filter-class> 

        <!-- CAS login 服务地址--> 

        <init-param> 

            <param-name>casServerLoginUrl</param-name> 

            <param-value>https://pcma:8443/cas/login</param-value> 

        </init-param> 

        <init-param> 

            <param-name>renew</param-name> 

            <param-value>false</param-value> 

        </init-param> 

        <init-param> 

            <param-name>gateway</param-name> 

            <param-value>false</param-value> 

        </init-param> 

        <!-- 客户端应用服务地址--> 

        <init-param> 

            <param-name>serverName</param-name> 

            <param-value>http://pcma:8081</param-value> 

        </init-param> 

    </filter> 

    <!--负责Ticket校验--> 

    <filter> 

        <filter-name>CAS Validation Filter</filter-name> 

        <filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class> 

        <init-param> 

            <param-name>targetBeanName</param-name> 

            <param-value>cas.validationfilter</param-value> 

        </init-param> 

    </filter> 

    <filter-mapping> 

        <filter-name>CAS Authentication Filter</filter-name> 

        <url-pattern>/*</url-pattern> 

    </filter-mapping> 

    <filter-mapping> 

        <filter-name>CAS Validation Filter</filter-name> 

        <url-pattern>/*</url-pattern> 

    </filter-mapping> 

</web-app>

casContext.xml文g

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"

              "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>

<bean id="cas.validationfilter" class="org.jasig.cas.client.validation.Cas10TicketValidationFilter"> 

        <property name="ticketValidator"> 

            <ref bean="cas10TicketValidator"/> 

        </property> 

        <property name="useSession"> 

            <value>true</value> 

        </property> 

        <!-- 客户端应用服务地址--> 

        <property name="serverName"> 

            <value>http://pcma:8081</value> 

        </property> 

        <property name="redirectAfterValidation"> 

            <value>true</value> 

        </property> 

    </bean> 

    <bean id="cas10TicketValidator" class="org.jasig.cas.client.validation.Cas10TicketValidator"> 

    <!-- q里参数?/span>cas服务器的地址--> 

        <constructor-arg index="0" value="https://pcma:8443/cas" /> 

    </bean> 

</beans> 

新徏index.jsp文g

 <body>

   hello sso<br>

   <a >sso2</a>q个地址是另外一台机器上?/span>sso客户?/span>

 </body>

上面?/span>web.xml?/span>casContext.xml?/span>index.jsp是两个客L(fng)中的一个,另一个要Ҏ(gu)实际情况修改?/span>

最后不要忘记客L(fng)?/span>jdk要?/span>keytool命o导入证书文g?/span>

启动tomcatQ测试器讉Khttp://pcma:8081/ssoQ出?/span>casd面Q输入相同的用户名和密码卛_dQ登录成功后面自动跌{?/span>http://pcma:8081/ssoQ这时点击页面上?/span>sso2链接Q就可以自动dq蟩转到sso2应用?/span>

如果输入用户名密码后提示下面的异常,是因为部|客L(fng)?/span>jdk没有导入证书文g的原因?/span>

javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target


源码

http://www.aygfsteel.com/Files/mashiguang/sso.zip



mashiguang 2009-12-07 09:50 发表评论
]]>
oracel dbms_jobs的?/title><link>http://www.aygfsteel.com/mashiguang/archive/2008/07/14/214768.html</link><dc:creator>mashiguang</dc:creator><author>mashiguang</author><pubDate>Mon, 14 Jul 2008 08:56:00 GMT</pubDate><guid>http://www.aygfsteel.com/mashiguang/archive/2008/07/14/214768.html</guid><wfw:comment>http://www.aygfsteel.com/mashiguang/comments/214768.html</wfw:comment><comments>http://www.aygfsteel.com/mashiguang/archive/2008/07/14/214768.html#Feedback</comments><slash:comments>6</slash:comments><wfw:commentRss>http://www.aygfsteel.com/mashiguang/comments/commentRss/214768.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/mashiguang/services/trackbacks/214768.html</trackback:ping><description><![CDATA[  <p><span style="font-family: 宋体">最q公司客户反映有些页面运行速度太慢Q通过对系l代码的分析Q发现排行榜功能是罪祸首,因ؓ数据量太大,每次h面都计一ơ排行榜Q的耗时费力?/span></p> <p><span style="font-family: 宋体">其实可以让数据库自己计算排行榜,q把计算l果保存C个单独的表里去,q个表只用来保存排行榜的数据Q数据量很小Q然后所有的排行榜查询都?/span>select<span style="font-family: 宋体">q个表?/span></p> <p><span style="font-family: 宋体">计算排行榜的功能我们可以写成一个存储过E,但是排行榜的数据不是一成不变的Q还需要不时的调用q个存储q程才行Q?/span>oracle<span style="font-family: 宋体">为我们提供了</span>dbms_jobs<span style="font-family: 宋体">?/span></p> <p>oracel dbms_jobs<span style="font-family: 宋体">包可以提交作业到作业队列中,q个包中q提供其它一些函数管理以前提交的作业Q如对作业进行修攏V禁止或删除{操作?/span></p> <p><span style="font-family: 宋体">常用函数Q?/span></p> <p>submit()<span style="font-family: 宋体">Q提交作业到作业队列?/span></p> <p>isumbit()<span style="font-family: 宋体">Q?/span></p> <p>remove()<span style="font-family: 宋体">Q从作业队列中删除作业?/span></p> <p>change()<span style="font-family: 宋体">Q改变已有作业的参数?/span></p> <p>what()<span style="font-family: 宋体">Q改变作业要执行的代码?/span></p> <p>next_date()<span style="font-family: 宋体">Q改变作业下一ơ执行时间?/span></p> <p>interval()<span style="font-family: 宋体">Q改变作业执行的旉间隔?/span></p> <p>broken()<span style="font-family: 宋体">Q暂停执行作业?/span></p> <p>run()<span style="font-family: 宋体">Q强制执行作业?/span></p> <p><span style="font-family: 宋体">最常用?/span>submit()<span style="font-family: 宋体">函数Q?/span></p> <p>dbms_jobs.submit(</p> <p>       job out binary_integer,</p> <p>       what in varchar2,</p> <p>       next_date in date default sysdate,</p> <p>       interval in varchar default null,</p> <p>       no_parse in boolean default false,</p> <p>       instance in binary_integer default any_instance,</p> <p>       force in boolean default false</p> <p>);</p> <p>submit<span style="font-family: 宋体">函数参数Q?/span></p> <p>job<span style="font-family: 宋体">Q作业的作业P是个输出参数Q所以调?/span>submit<span style="font-family: 宋体">函数Ӟq个参数要指定一个已存在的变量?/span></p> <p>what<span style="font-family: 宋体">Q作业要执行的代码,一般是存储q程?/span></p> <p>next_date<span style="font-family: 宋体">Q下一ơ作业运行的日期?/span></p> <p>interval<span style="font-family: 宋体">Q?span style="color: red"><span style="font-family: 宋体">作业执行的间隔时_q个参数默认值是</span>null<span style="font-family: 宋体">Q?/span></span></span><span style="font-family: 宋体"><span style="color: red">也就?/span></span><span style="color: red">what</span><span style="color: red; font-family: 宋体">指定的代码只?/span><span style="color: red">next_date</span><span style="color: red; font-family: 宋体">q一旉执行一ơ?/span></p> <p>no_parse<span style="font-family: 宋体">Q默认值是</span>false<span style="font-family: 宋体">Q当参数值是</span>false<span style="font-family: 宋体">Q提交作业时对</span>what<span style="font-family: 宋体">指定的代码进行语法分析;当参数值是</span>true<span style="font-family: 宋体">Q第一ơ运?/span>what<span style="font-family: 宋体">指定代码时才q行语法分析?/span></p> <p>instance<span style="font-family: 宋体">Q指明运行作业的数据库实例?/span></p> <p>force<span style="font-family: 宋体">Q如果是</span>true,instance<span style="font-family: 宋体">可以是Q何正敎ͼ如果?/span>false<span style="font-family: 宋体">Q?/span>instance<span style="font-family: 宋体">指定的实例必L在运行?/span></p> <p><span style="font-family: 宋体">CZQ?/span></p> <p>var jobno number;</p> <p>begin</p> <p>dbms_job.submit(:jobno,'p_xxx_taxis;',trunc(sysdate)+(18/24),'trunc(sysdate+1,''hh'')');--<span style="font-family: 宋体">每天</span>18<span style="font-family: 宋体">Ҏ(gu)?/span></p> <p>commit;</p> <p>end;</p> <p><span style="font-family: 宋体">上面q段话要?/span> <span style="font-family: 宋体">命oH口</span> <span style="font-family: 宋体">下运?/span>,<span style="font-family: 宋体">如在</span>pl/sql developer<span style="font-family: 宋体">里面?/span>--><span style="font-family: 宋体">新键</span>--><span style="font-family: 宋体">命oH口</span></p> <p><span style="font-family: 宋体">q样׃在每天的</span>18<span style="font-family: 宋体">Ҏ(gu)行存储过E?/span>p_xxx_taxis<span style="font-family: 宋体">。在我这?/span>p_xxx_taxis<span style="font-family: 宋体">执行的是计算排行榜的d?/span></p> <img src ="http://www.aygfsteel.com/mashiguang/aggbug/214768.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/mashiguang/" target="_blank">mashiguang</a> 2008-07-14 16:56 <a href="http://www.aygfsteel.com/mashiguang/archive/2008/07/14/214768.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss> <footer> <div class="friendship-link"> <a href="http://www.aygfsteel.com/" title="狠狠久久亚洲欧美专区_中文字幕亚洲综合久久202_国产精品亚洲第五区在线_日本免费网站视频">狠狠久久亚洲欧美专区_中文字幕亚洲综合久久202_国产精品亚洲第五区在线_日本免费网站视频</a> </div> </footer> վ֩ģ壺 <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ʯ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ͳ</a>| <a href="http://" target="_blank">ͤ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ƽ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ͳ</a>| <a href="http://" target="_blank">ɽ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">Ϫ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ƽ</a>| <a href="http://" target="_blank">ն</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">½</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ݶ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">żҸ</a>| <a href="http://" target="_blank">Ϫ</a>| <a href="http://" target="_blank">ȫ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body>