<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ABCJIECBA的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ABCJIECBA</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ABCJIECBA]]></copyright><item><title><![CDATA[查询数据库指定表是否存在]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/50622958</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/50622958</guid><author>ABCJIECBA</author><pubDate>Tue, 02 Feb 2016 11:31:21 +0800</pubDate><description><![CDATA[MYSQL：
            select count(*) as tabcount from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='dbname()' and TABLE_NAME='tablename‘

 MSSQL：
            select count(*) as tabcount from tempdb.]]></description><category></category></item><item><title><![CDATA[数据库删除表语句]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/50592511</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/50592511</guid><author>ABCJIECBA</author><pubDate>Wed, 27 Jan 2016 11:13:39 +0800</pubDate><description><![CDATA[判断表存在，执行删除表操作：

mySql：
drop table if exists  tablename


Oracle：
BEGIN 
    EXECUTE IMMEDIATE 'DROP TABLE tablename';
    EXCEPTION WHEN OTHERS THEN NULL;
END;


SQLServer：
IF EXISTS ( S]]></description><category></category></item><item><title><![CDATA[去除list的重复元素]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/47398155</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/47398155</guid><author>ABCJIECBA</author><pubDate>Mon, 10 Aug 2015 14:28:48 +0800</pubDate><description><![CDATA[public class TestMain {

    public static void main(String[] args) {
        List students = new ArrayList();
        students.add(new Student("1", "zhangsan", "20"));
        students.add(new S]]></description><category></category></item><item><title><![CDATA[Dialog模态窗口调用]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/39179279</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/39179279</guid><author>ABCJIECBA</author><pubDate>Wed, 10 Sep 2014 11:40:37 +0800</pubDate><description><![CDATA[var url = "${pageContext.request.contextPath}/group!findById.action?group.id="+idAll;
  window.showModalDialog(url,null,"dialogwidth:850px;dialogheight:550px; toolbar=no,top=200,left=200, menubar=no,]]></description><category></category></item><item><title><![CDATA[Spring 配置定时器]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/39178619</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/39178619</guid><author>ABCJIECBA</author><pubDate>Wed, 10 Sep 2014 11:06:27 +0800</pubDate><description><![CDATA[各个时间可用值如下：
秒 0-59 , - * /
分 0-59 , - * /
小时 0-23 , - * /
日 1-31 , - * ? / L W C
月 1-12 or JAN-DEC , - * /
周几 1-7 or SUN-SAT , - * ? / L C #
年 (可选字段) empty, 1970-2099 , - * /
可用值详细分析如下：
“*”——字]]></description><category></category></item><item><title><![CDATA[Mybatis动态传表名（同样适用于动态传表字段）]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/39178465</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/39178465</guid><author>ABCJIECBA</author><pubDate>Wed, 10 Sep 2014 10:50:37 +0800</pubDate><description><![CDATA[//设置map参数，innerTable，outTable对应的表名
public String sendDetail(){
  pager = getStartPager();
  if( null !=msg && msg.equals("succ")){
   map.put("innerTable","bs_sent_inner" );  
   map.put("outTabl]]></description><category></category></item><item><title><![CDATA[JSP上传文件到指定位置]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/12616357</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/12616357</guid><author>ABCJIECBA</author><pubDate>Fri, 11 Oct 2013 14:27:31 +0800</pubDate><description><![CDATA[复制上传文件，上传文件到服务器指定位置，注意，提交表单需要制定enctype的类型。具体代码如下：
Servlet 代码：
 /** 直接取上传的File */
 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOExcepti]]></description><category></category></item><item><title><![CDATA[com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax.....]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/8745277</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/8745277</guid><author>ABCJIECBA</author><pubDate>Mon, 01 Apr 2013 10:27:14 +0800</pubDate><description><![CDATA[### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for]]></description><category></category></item><item><title><![CDATA[Ext.ux.form.ItemSelector数据项超出高度时，出现滚动条(转)]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84395843</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84395843</guid><author>ABCJIECBA</author><pubDate>Wed, 27 Feb 2013 09:59:11 +0800</pubDate><description><![CDATA[
使用过【Ext.ux.form.ItemSelector】的扩展地球人都知道，这个组件还是比较好用的，然而数据项过多超过它显示高度时
 
，就有两个自带的问题
 
一、多余的数据项就不显示，这个问题到歌谷、百度一搜就知道了，修改ext-all.css，结果Y轴就出现滚动条。 

 
 


Html代码  
1..x-fieldset-body {    
2.    ...]]></description><category></category></item><item><title><![CDATA[JS Json对象转化成字符串对象( 例：json =[{id:1} ,{id:2}] 转化“[{id:1} ,{id:2}] ”)]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7987341</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7987341</guid><author>ABCJIECBA</author><pubDate>Mon, 17 Sep 2012 13:59:17 +0800</pubDate><description><![CDATA[/******      json =[{id:1} ,{id:2}] 转化“[{id:1} ,{id:2}] ”  *****/
jsonToString =function(obj) {
      if (obj == undefined) {
          return "";
      }
      var r = [];
      if (typeof obj]]></description><category></category></item><item><title><![CDATA[jQuery-Draggable参数介绍]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7711727</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7711727</guid><author>ABCJIECBA</author><pubDate>Tue, 03 Jul 2012 13:57:16 +0800</pubDate><description><![CDATA[默认设置值：
$.extend($.ui.draggable, {
version: “1.7.1″,
eventPrefix: “drag”,
defaults: {
addClasses: true,
appendTo: “parent”,
axis: false,
cancel: “:input,option”,
connectToSortable: false,
con]]></description><category></category></item><item><title><![CDATA[Jquery获取元素的父容器对象]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7709082</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7709082</guid><author>ABCJIECBA</author><pubDate>Mon, 02 Jul 2012 17:02:23 +0800</pubDate><description><![CDATA[例：获取id为a的img标签的
$("#a").parent().attr("id");]]></description><category></category></item><item><title><![CDATA[Ext JS框架入门]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7641244</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7641244</guid><author>ABCJIECBA</author><pubDate>Thu, 07 Jun 2012 11:20:55 +0800</pubDate><description><![CDATA[Ext JS框架入门
一、概述：
ExtJS可以用来开发RIA也即富客户端的AJAX应用，是一个用javascript写的，主要用于创建前端用户界面，是一个与后台技术无关的前端ajax框架。
功能丰富，无人能出其右。
无论是界面之美，还是功能之强，ext的表格控件都高居榜首。
单选行，多选行，高亮显示选中的行，拖拽改变列宽度，按列排序，这些基本功能ExtJS轻量级实现。
自动生成行号，]]></description><category></category></item><item><title><![CDATA[JS--事件]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84182617</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84182617</guid><author>ABCJIECBA</author><pubDate>Mon, 09 Apr 2012 11:37:26 +0800</pubDate><description><![CDATA[1.js退出当前页面，一般常用于做系统登录的退出：
 
  confirm(&quot;.....&quot;)，出现确定，取消弹出框，点击“确定”自动返回true，否则返回false(默认返回到当前页，取消该事件)，参数是弹出框自定义的的提示信息
 
例：
 
 function logout(){
        if(confirm(&quot;退出登录？&quot;)){
        window.locat...]]></description><category></category></item><item><title><![CDATA[页面图片浮动左右滑动效果实现案例 ]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84182614</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84182614</guid><author>ABCJIECBA</author><pubDate>Mon, 09 Apr 2012 11:35:09 +0800</pubDate><description><![CDATA[
[img]http://dl.iteye.com/upload/attachment/0066/2240/73d1eb83-9286-3c7e-80fa-3d0fb6e422c6.jpg[/img]
核心代码：
 
1.css：16sucai.css
 
html,body {
  height: 100%;
  margin: 0px;
  padding: 0px;
 }...]]></description><category></category></item><item><title><![CDATA[JS--事件]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7440048</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7440048</guid><author>ABCJIECBA</author><pubDate>Mon, 09 Apr 2012 11:11:09 +0800</pubDate><description><![CDATA[1.js退出当前页面，一般常用于做系统登录的退出：
  confirm(".....")，出现确定，取消弹出框，点击“确定”自动返回true，否则返回false(默认返回到当前页，取消该事件)，参数是弹出框自定义的的提示信息
例：
 function logout(){
       if(confirm("退出登录？")){
       window.location = "/log]]></description><category></category></item><item><title><![CDATA[页面图片浮动左右滑动效果实现案例]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7398699</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7398699</guid><author>ABCJIECBA</author><pubDate>Tue, 27 Mar 2012 14:11:41 +0800</pubDate><description><![CDATA[核心代码：
1.css：16sucai.css
html,body {
 height: 100%;
 margin: 0px;
 padding: 0px;
}
a {outline: none;}
img{ border:0;}
a img {vertical-align: top;}
a img.last {margin-right: 0; }
.box {
 wid]]></description><category></category></item><item><title><![CDATA[JS前端验证(验证页面属性格式) ]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84170757</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84170757</guid><author>ABCJIECBA</author><pubDate>Mon, 19 Mar 2012 10:11:44 +0800</pubDate><description><![CDATA[@param:做验证的正则表达式
 
/^([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+@([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+\.[a-zA-Z]{2,3}$/; 验证邮箱格式
 
/^[1][358]\d{9}$/;  验证手机号码
 
/^[0-9]{6}$/;验证邮政编码
 
/^\d+((\.?\d+)|(\...]]></description><category></category></item><item><title><![CDATA[JS前端验证(验证页面属性格式)]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7345219</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/7345219</guid><author>ABCJIECBA</author><pubDate>Mon, 12 Mar 2012 15:38:22 +0800</pubDate><description><![CDATA[@param:做验证的正则表达式
/^([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+@([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+\.[a-zA-Z]{2,3}$/; 验证邮箱格式
/^[1][358]\d{9}$/;  验证手机号码
/^[0-9]{6}$/;验证邮政编码
/^\d+((\.?\d+)|(\d*))$/;验证Dou]]></description><category></category></item><item><title><![CDATA[正则表达式---手机，邮箱，固定电话格式的验证 ]]></title><link>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84087906</link><guid>https://blog.youkuaiyun.com/ABCJIECBA/article/details/84087906</guid><author>ABCJIECBA</author><pubDate>Wed, 23 Nov 2011 17:53:02 +0800</pubDate><description><![CDATA[
 
   function check(){
     var flag=true;
     
      var myreg = /^([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+@([a-zA-Z0-9]+[_|\_|\.]?)*[a-zA-Z0-9]+\.[a-zA-Z]{2,3}$/;//邮箱格式的验证
      var reg= /^[1][...]]></description><category></category></item></channel></rss>