<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Sugar_521的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Sugar_521</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Sugar_521]]></copyright><item><title><![CDATA[EXCEL导入]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/75091737</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/75091737</guid><author>Sugar_521</author><pubDate>Thu, 13 Jul 2017 20:23:31 +0800</pubDate><description><![CDATA[废话不多说，直接上代码：


Workbook workbook=null;
//			XSSFWorkbook workBook=null;
			try{
				try {
					workbook=WorkbookFactory.create(new FileInputStream("c:\\test.excel"));
				} catch (InvalidFormatExce]]></description><category></category></item><item><title><![CDATA[数据库端防止并发的SQL语句 插入时就判断是否存在]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/70064610</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/70064610</guid><author>Sugar_521</author><pubDate>Tue, 11 Apr 2017 17:37:23 +0800</pubDate><description><![CDATA[insert into `aaa` (
  `APP_TYPE_ID`,
  `APP_TIME_ID`,
  `CREATE_USER`,
  `APPOINTMEN_DATE`
) 
select 
  "2C8F50808C3B49B1A9DDA467AEA1D475",
  "F982F0AF7DB54A87BA8F3CE189A6E66F",
  "55aaec489ea9458b99c]]></description><category></category></item><item><title><![CDATA[js  去除数组中的空值以及数组判断是否有重复数据]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/69668852</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/69668852</guid><author>Sugar_521</author><pubDate>Sat, 08 Apr 2017 15:02:34 +0800</pubDate><description><![CDATA[1、判断是否有重复数据

		function isRepeat(array){  
			var hash = {};  
			for(var i in array) {  
				if(array[i]!=""){
					if(hash[array[i]])  
						return true;  
					hash[array[i]] = true;  
				}  
		]]></description><category></category></item><item><title><![CDATA[easyui 合并单元格]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/63267119</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/63267119</guid><author>Sugar_521</author><pubDate>Sat, 18 Mar 2017 19:56:57 +0800</pubDate><description><![CDATA[function MergeCells(tableID, fldList) {
        var Arr = fldList.split(",");
        var dg = $('#' + tableID);
        var fldName;
        var RowCount = dg.datagrid("getRows").length;
        var ]]></description><category></category></item><item><title><![CDATA[javax.mail 发送邮件]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/53893372</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/53893372</guid><author>Sugar_521</author><pubDate>Tue, 27 Dec 2016 10:20:59 +0800</pubDate><description><![CDATA[import java.io.IOException;
import java.util.Properties;

import javax.mail.Message;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.ma]]></description><category></category></item><item><title><![CDATA[java后台跨域上传]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/53744106</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/53744106</guid><author>Sugar_521</author><pubDate>Mon, 19 Dec 2016 17:10:03 +0800</pubDate><description><![CDATA[前段时间在做ajaxfileupload的跨域上传功能，因为是手机端的上传，所以不能使用swfupload插件，就用了ajaxfileupload的方式，但是跨域问题一直没有解决，所以就拐了个弯儿，先上传到本地，再在java的后台实现。具体代码如下：
	private static final String url="http://XXXX";
	
	public static String u]]></description><category></category></item><item><title><![CDATA[java等比例压缩图片]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/53743761</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/53743761</guid><author>Sugar_521</author><pubDate>Mon, 19 Dec 2016 17:01:30 +0800</pubDate><description><![CDATA[public static void resizeImage(String srcImgPath,int width, int height) throws IOException { String subfix = "jpg"; subfix = srcImgPath.substring(srcImgPath.lastIndexOf(".")+1,srcImgPath.length()); St]]></description><category></category></item><item><title><![CDATA[mysql插入数据之从一个表到另一张表]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/53212802</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/53212802</guid><author>Sugar_521</author><pubDate>Fri, 18 Nov 2016 09:46:33 +0800</pubDate><description><![CDATA[将一张表中的数据迁移到另一张表，
SQL语句如下：
insert into 表名（字段1，字段2....) select 字段1，字段2 from 表名。
注意：字段值的类型要对应。]]></description><category></category></item><item><title><![CDATA[java打包下载]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/53037797</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/53037797</guid><author>Sugar_521</author><pubDate>Fri, 04 Nov 2016 18:35:21 +0800</pubDate><description><![CDATA[近段时间在做一个项目，其中有一个功能是需要将用户填的信息以及上传的附件等进行打包下载。于是乎，网上各种找资料，现将成果分享如下：
//这段代码是将文件打包
	public void zipDownLoadAttachment(ModelAndView mav, HttpServletRequest request,Map result,HttpServletResponse response,S]]></description><category></category></item><item><title><![CDATA[zTree 异步加载]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/9121679</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/9121679</guid><author>Sugar_521</author><pubDate>Tue, 18 Jun 2013 16:30:11 +0800</pubDate><description><![CDATA[最近在写一个zTree 异步加载的小例子，纠结了两三天，终于给纠结出来了！现将经验及代码分享如下： 	
		var curMenu = null, zTree_Menu = null;
		var setting = {
			async:{
				autoParam:["menuid"],//异步加载时自动提交父节点参数
				dataType:"json",//提交参数的数据类型]]></description><category></category></item><item><title><![CDATA[Wabacus的使用方法]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/9082403</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/9082403</guid><author>Sugar_521</author><pubDate>Thu, 13 Jun 2013 12:23:05 +0800</pubDate><description><![CDATA[去年毕业，刚参加工作不久，新到的一家公司，被通知项目要用新的框架，Wabacus，后上网下帮助文档，看demo自行学习！发现该框架简单易懂，上手很快。至于Wabacus的意义及用法，大家可以在百度百科上去详细了解，那里说得挺清楚的。接下来我简单介绍一下Wabacus的使用方法。（现在已经更新到4.0，很快4.1也就新鲜出炉啦。）
1、先将框架所需要的包及框架自带的配置文件拷的项目中去，具体可参照]]></description><category></category></item><item><title><![CDATA[将多行数据合并为一行]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/8746765</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/8746765</guid><author>Sugar_521</author><pubDate>Mon, 01 Apr 2013 15:25:39 +0800</pubDate><description><![CDATA[oracle语法：
  select country,wmsys.wm_concat(city) as city from test group      bycountry
 
mysql语法：
select country,GROUP_CONCAT(city order by city separator",") as city from test GROUP BY country]]></description><category></category></item><item><title><![CDATA[org.apache.jasper.JasperException: Unable to compile class for JSP: (无法编译jsp)]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/8509546</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/8509546</guid><author>Sugar_521</author><pubDate>Wed, 16 Jan 2013 15:11:50 +0800</pubDate><description><![CDATA[郁闷啊。。今天在做一个小练习的时候，遇到org.apache.jasper.JasperException: Unable to compile class for JSP: 

An error occurred at line: 9 in the jsp file: /dologin.jsp
username cannot be resolved
6: 	//鑾峰彇瀵嗙爜
7: 	String]]></description><category></category></item><item><title><![CDATA[ExtJs4.0 分页]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/7957675</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/7957675</guid><author>Sugar_521</author><pubDate>Sat, 08 Sep 2012 11:52:27 +0800</pubDate><description><![CDATA[邻近毕业了。。最后要用extjs4.0做前台，后台用ssh框架做一个OA办公系统。。在做项目之前，根本没接触过extjs，最近一直在研究extjs4.0 desktop的项目。等成功之后，会给大家分享一下。
先写个分页的例子吧（注：采用的是extjs MVC模式）
首先是一个Model层。（类似于定义了一个java类）

定义了一个类，一些字段，字段的名字跟数据库表中的字段名相对应。]]></description><category></category></item><item><title><![CDATA[三大主流数据库加载驱动的URL及连接字符串（sqlserver,mysql,oracle)]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/7837322</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/7837322</guid><author>Sugar_521</author><pubDate>Tue, 07 Aug 2012 00:09:35 +0800</pubDate><description><![CDATA[1，sqlserver（纯java连接）:
加载驱动：com.microsoft.sqlserver.jdbc.SQLServerDriver
建立连接：jdbc:sqlserver://localhost:1433;DatabaseName="数据库名",用户名,密码
 
1.1 sqlserver（桥连接的方式）
加载驱动：sun.jdbc.odbc.JdbcOdbcDriver]]></description><category></category></item><item><title><![CDATA[hibernate连接存储过程]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/7706470</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/7706470</guid><author>Sugar_521</author><pubDate>Sun, 01 Jul 2012 13:02:27 +0800</pubDate><description><![CDATA[曾经老师让我为我们班同学讲Hibernate连接存储过程。于是，我课下上网查资料，一周时间，也没查出个所以然来。不过，网上的jdbc连接存储过程倒还不少。最后得以一师兄真传，终将hibernate连接存储过程给搞清楚了。现将成果分享给大家。供大家参考。
示例做得比较简单，一个表district，表中有两个字段，一个id,一个name.增删改查的存储过程如下：

用hibernate调用存储过]]></description><category></category></item><item><title><![CDATA[hibernate中的关联关系的配置]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/7705388</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/7705388</guid><author>Sugar_521</author><pubDate>Sat, 30 Jun 2012 18:57:10 +0800</pubDate><description><![CDATA[1、实体之间的关系主要有：关联关系，泛化关系。
2、对象关系映射的配置（多对一），如图所示：

3、一对多的配置，如图所示：

 

4、在一对多的关系中可以设置cascade（级联）和inverse（反转）属性进行优化。
   （1）cascade的取值有：all,save-update,delete,none.
   （2）inverse的取值有：true,false.(注：]]></description><category></category></item><item><title><![CDATA[Hibernate入门]]></title><link>https://blog.youkuaiyun.com/Sugar_521/article/details/7705378</link><guid>https://blog.youkuaiyun.com/Sugar_521/article/details/7705378</guid><author>Sugar_521</author><pubDate>Sat, 30 Jun 2012 18:52:39 +0800</pubDate><description><![CDATA[1、持久化是将程序中的数据在瞬时状态和持久状态间转换的机制。
2、hibernate的配置文件如图所示：

3、常用的主键生成策略：increment,identity,sequence,native,assigned.
4、hibernate对数据库的两种查询操作：Object load(class c,Serializable id)     Object get(Class c,Se]]></description><category></category></item></channel></rss>