jQuery : Ajax html

var div
var organ

$.ajax({
url: '/html/text/pages/Mean.jsp',
dataType: 'html',
type:'POST',
async:false,
data: { No: div, Size: organ },

error: function(xhr) {
alert('Ajax request 發生錯誤');
},
success: function(response) {
$("#ID").html($.trim(response));
        }
});

Jsp : 轉成csv (download csv)

<%@ page language="java" contentType="text/html; charset=BIG5" %>
<%@ page import="java.util.*" %>

<%
        ArrayList list = new ArrayList();

list =  from select database data (use map in list)
 
  String filename = "test.csv";

response.setContentType("APPLICATION/OCTET-STREAM");
response.setHeader("Content-Disposition", "attachment; filename=\"" + filename + "\"");
out.clear();

        out.write("COM1NAME,COM2NAME");

out.newLine();

if(list.size()>0 )
{
for(int i=0; i<list.size(); i++)
{
HashMap map = (HashMap)list.get(i);

out.write(map.get("COM1")+","+map.get("COM2") );
out.newLine();
}
}

%>

DB2 : 補0(padding 0)

price type is number

right(digits(price),10)

or

right(digits(cast(price as bigint)),14)

jQuery: checkbox readonly

readonly  :

$(":checkbox").click(function(e){ e.preventDefault(); });


remove readonly :

$(":checkbox").unbind('click');

Excel : 數字轉國字 (number transfer chinese)

JavaScript : 檢視附檔名 (check Filename Extension)

var csvfile = document.all.fileName.value.toUpperCase();

//判斷csv
if(csvfile.indexOf(".CSV") == -1)
{
alert('副檔名不正確');
return;
}

Java : 日期加減 (data addition and subtraction)

java.util.*
java.text.*


Calendar cal = Calendar.getInstance();

cal.add(Calendar.MONTH, -6); // 月份減6個月
cal.add(Calendar.MONTH,+3); // 月份加3個月
cal.add(Calendar.YEAR ,  ±N); // 年加減N個月
cal.add(Calendar.NOUR ,  ±N); // 時間加減N小時

String toDay =new SimpleDateFormat("yyyyMMdd").format(cal.getTime()) ;


//---------------------------------------------------------------//

由資料庫或字串日期 轉成date

String  fromDate = "20130801" ;  //由資料庫來或字串日期

SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd");
Date pDate =new Date();
pDate = df.parse( fromDate  );

cal.setTime(pDate);
cal.add(Calendar.DATE ,  1);  //日期加減方式同上