EL取得ContextPath

${pageContext.request.contextPath}

SimpleTagSupport中取得ServletRequest物件

HttpServletRequest req = (HttpServletRequest)((PageContext)this.getJspContext()).getRequest();

如何讀取/WEB-INF和/WEB-INF/classes中的檔案

1. (適用/WEB-INF目錄下,及其所有子目錄下的檔案)
    File f=new File(application.getRealPath("/WEB-INF/123.txt"));

2. (適用/WEB-INF/classes目錄下檔案)
    this.getClass().getClassLoader().getResourceAsStream("123.txt");

[筆記] XSLT & Java

[筆記] XSLT

[筆記] JAXP (Java API for XML Parsing) (SAX與DOM)

[筆記]XML文件驗證機制

Quartz Java Schedule Framework 筆記

Quartz Java Schedule Framework 筆記

Quartz使用JDBCDatasoruceTX使用tomcat datasource設置檔範例

Quartz使用JDBCDatasoruceTX使用tomcat datasource設置檔範例
[quartz.properties]

# Default Properties file for use by StdSchedulerFactory
# to create a Quartz Scheduler Instance, if a different
# properties file is not explicitly specified.
#

org.quartz.scheduler.instanceName = DefaultQuartzScheduler
org.quartz.scheduler.rmi.export = false
org.quartz.scheduler.rmi.proxy = false
org.quartz.scheduler.wrapJobExecutionInUserTransaction = false

org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount = 10
org.quartz.threadPool.threadPriority = 5
org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread = true

org.quartz.jobStore.misfireThreshold = 60000

# org.quartz.jobStore.class = org.quartz.simpl.RAMJobStore
org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.CloudscapeDelegate
org.quartz.jobstore.dataSource = MailerJ
org.quartz.jobStore.useProperties = true
org.quartz.dataSource.MailerJ.jndiURL = java:comp/env/jdbc/JMailer
org.quartz.jobStore.dataSource = MailerJ

CachedRowSet .. 'populate before calling' 錯誤訊息

故事是這樣的....


使用
CachedRowSet crs=new CachedRowSetImpl();
crs.setPageSize(2);
crs.populate(resultSetObj);
while(crs.nextPage())
{
while(crs.next())
{ //... do something here }
}
竟然出現"'populate before calling' "錯誤訊息,貓的咧,一時間還撒某帳...

原來...
若是使用populate來塞資料給RowSet是無法使用分頁功能的,
原因在於換到下頁時,RowSet無法像是用setCommand去再做一次查詢....

所以說,最好的解決方法就是改用
crs.executeQuery(conn); //conn是自己先前先取得的Connection物件

Java Mail API筆記簡報,GMail範例

JavaMail API個人筆記,
並有Gmail SMTP發信範例程式

JDBC insert CLOB欄位

1. 若為String可轉為StringReader物件...

     String s="String content字串";
     StringReader sr=new StringReader(s);

3. prepare statement

     Connection con = ds.getConnection();
     String sql="insert testTable(colClob) values (?) ";
     PreparedStatement pstmt=con.prepareStatement(sql);

2. 將該Reader寫入暫存檔

      tmp=File.createTempFile("tmpInsertClob_", null);
      BufferedWriter writer=new BufferedWriter(new FileWriter(tmp));
      BufferedReader reader=new BufferedReader((Reader)insertVals.get(i));

      //StringWriter用來計算字數用
      StringWriter strW=new StringWriter();
      int contentLength=0;      
      int data=0;
      while((data=reader.read())!=-1)
        {
   writer.write(data);
   strW.write(data);
 }
      strW.close();
      contentLength=strW.toString().length();
      strW=null;
      writer.close();       
      reader.close();
      BufferedReader reader2=new BufferedReader(new FileReader(tmp));
      
      pstmt.setCharacterStream(i+1,reader2,contentLength);
      

3. 執行

     pstmt.executeUpdate();

4.關閉來源串流

    reader2.close();

Struts 1.2 筆記簡報

struts教戰實務讀後筆記:

[筆記簡報] JDBC RowSet API

[筆記簡報] JDBC RowSet API

Apache AXIS 簡介

Web Service可以像Java Object般來封裝與發佈，就靠AXIS了，以下是小弟參考官方安裝文件所製作的入門簡介簡報:

利用JACOB操作COM來轉換DOC為HTML

輕鬆架起Java連接COM對象的橋梁

javascript實用技巧:動態建立<select><option>下拉選單

//取得<select>物件
var sel=document.getElementById('selProductNum') ;

//clear all
var len=sel.options.length;
for(var j=0;j<len;j++)
{ sel.options[0] = null; }

//add option
var prodNumArr=prodNums.split(",");
for(var i=0;i<prodNumArr.length;i++)
{ sel.options[i+1]=new Option(prodNumArr[i],prodNumArr[i]); }

// set which one option is selected
sel.options.selectedIndex=1;

併! 併! 併!

呵呵 今天ITHome最吸引我的兩則新聞
昇陽10億美金買下開放源碼資料庫MySQL
甲骨文85億美元現金買下BEA

科技界大吃小時有所聞，併入也不會是壞事！
但想想JAVA DB、和OC4J的處境應該會越來越尷尬吧！

SimpleTagSupport中取得HttpServletRequest方法

HttpServletRequest req = (HttpServletRequest)((PageContext)this.getJspContext()).getRequest();

RowSet tutorial & JDBC Develpoer Guide

Rowset Tutorial:
http://java.sun.com/j2se/1.5/pdf/jdbc-rowset-tutorial-1.5.0.pdf

JDBC Develpoer Guide:
http://java.sun.com/javase/6/docs/technotes/guides/jdbc/index.html