2019
eclipse啟動不了，出現“Java was started but returned exit code=13......”對話方塊
參考: https://zhidao.baidu.com/question/224582151.html
從path環境變數, "最前面" 加入以下:
%JAVA_HOME%\bin;%JAVA_HOME%\lib;
=============
2018年
1. 連線舊的 oracle 9i , 可能要把jdk降為1.4 版
include jxl
3. 單支程式, 請在project 先設定好 外部jar位置。在程式上按右鍵， Run as/ java application
public static void main(String[] args) {
String fileName = "1.xls";
String url = "jdbc:oracle:thin:@xxx.xxx.xxx.xxx:PORT:ServerName";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conDB = DriverManager.getConnection(url, username, userpwd);
}
catch( Exception ex )
{
System.out.println("db error--");
}
try {
WritableWorkbook workbook = Workbook.createWorkbook(new File(fileName));
WritableSheet sheetDetail = workbook.createSheet(sheetName,0);
WritableFont.FontName titleFontName = WritableFont.createFont("標楷體");
WritableFont columnNameFont = new WritableFont(titleFontName, 12);
WritableCellFormat colAllThin = new WritableCellFormat(columnNameFont);
colAllThin.setBorder(Border.ALL, BorderLineStyle.THIN);
colAllThin.setAlignment(Alignment.CENTRE);
colAllThin.setVerticalAlignment(VerticalAlignment.CENTRE);
colAllThin.setWrap(true);
stmt = conDB.createStatement();
query = "select * from XXXX WHERE ROWNUM < 11 order by xx desc";
//--System.out.println("query--"+query);
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
xx1 =rs.getString("xx1");
sheetDetail.addCell(new Label(0,rowCnt,xx1,colAllThin));
rowCnt ++;
}
workbook.write();
workbook.close();
}catch(Exception e)
{
System.out.println(e);
}
}
=================
<以下 2007/03/25 撰寫>
Eclipse 桌面捷徑設定: (日幣符號請自己取代為反斜線)
D:\eclipse-SDK-3.1M4-win32\eclipse\eclipse.exe -vm D:\jdk142\jre\bin\javaw -vmargs -Xmx256M
參考資料:
JSTL:
http://www.ice.ntnu.edu.tw/~swanky/scwcd/SCWCD_Study_Guide.htm
----------------
Hibernate
The element is semi-deprecated, and are now preferred. is preferred to . is preferred to .
Blob and Clob support
using lazy=”true”, that is now the default
http://www.hibernate.org/250.html
many-to-many︰多對多在數據庫中也是常見的數據模型，像用戶與組，用戶與權限等。
http://www.cnblogs.com/jailu/archive/2006/06/30/439789.aspx
在many-to-many的中間表中配置索引： http://eyejava.javaeye.com/blog/post/275423
http://letle.javaeye.com/blog/78530
Hibernate 3中的formula：http://dev2dev.bea.com.cn/techdoc/20060109720.html
---------------------
Spring
http://caterpillar.onlyfun.net/Gossip/SpringGossip/FirstSpring.html
spring with hibernate bean:
class=”org.springframework.orm.hibernate3.LocalSessionFactoryBean”>
Spring MVC :
http://www.ibm.com/developerworks/tw/library/j-s-s-i/index.html
http://www.javajia.com/modules.php?op=modload&name=News&file=article&sid=1034&mode=thread&order=0&thold=0
---------------------
Ajax & DWR
http://www.wujianrong.com/archives/2006/12/dwr_2.html
Bean:
http://www.iteye.com/topic/51437#216206
--------------------
Display tag
http://displaytag.sourceforge.net/10/tagreference-displaytag-12.html
displaytag分頁及query
http://tw.myblog.yahoo.com/josephsmjpsmjp-josephsmjpsmjp/article?mid=1&prev=3&next=-1
--------------------
Struts & Tiles
http://caterpillar.onlyfun.net/Gossip/Struts/SetupTiles.htm
http://caterpillar.onlyfun.net/Gossip/Struts/XmlConfig.htm
-------------
AXIS
Apache Axis: http://www.xml.org.tw/XMLTool/display.asp?ID=20
--------------
WML
路徑: /opt/mdsp/portal/webapps/portal/apbw
~.wml
http://blog.csdn.net/inber/article/details/880710
-----------------
WAP
JSF: 在JSF頁面中利用標記插入tiles定義
路徑: /opt/mdsp/portal/webapps/portal/wap/mainpages
http://www.java3z.com/cwbwebhome/article/article1/cd1.html?id=70
Introducing WALL: a Library to Multiserve Applications on the Wireless Web
http://wurfl.sourceforge.net/java/tutorial.php
WALL Tutorial: WALL and JSTL(Java Standard Tag Library)
<wall:load_capabilities />
http://developer.openwave.com/dvl/tools_and_sdk/wurfl_and_wall/wall_and_jstl.htm
use the ‘load_capabilities’ tag to import all of the WURFL capability/value pairs into the JSTL EL. This is what makes the ${capabilities.capability_name} syntax possible.
留言列表
