jQuery : 判斷html text不可空白 (check html input tag value not null)

html

<form id="FROMTAG" name="form1" method="post">
<input type="text">

----------------------------------------------------------------

JavaScript

$("#FROMTAG").find(':input').each(function()
{
var ty = this.type;
var val = $(this).val();

if(ty=="text" && val=="")
{
alert("欄位不可空白");
return false;
}
});

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;
}