2013年7月31日 星期三

java eclipse JDK update JDK7_25 in linux

h3. Download SE for 64 bit for [oracle|http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html]

h3. Copy to directory and link
{code}
mv /home/Andy/IBMS/lib/jdk/jdk7_25/jdk1.7.0_25 /usr/java
unlink latest
unlink default
ln -s /usr/java/jdk1.7.0_25 latest
ln -s /usr/java/latest default
{code}


h3. Setup the run position
{code}
update-alternatives --install "/usr/bin/java" "javac" "/usr/java//jdk1.7.0_25/bin/javac" 1
update-alternatives --install "/usr/bin/javac" "javac" "/usr/java//jdk1.7.0_25/bin/javac" 1
update-alternatives --install "/usr/bin/javaws" "javaws" "/usr/java//jdk1.7.0_25/bin/javaws" 1

[root@localhost java]# update-alternatives --config java

有 3 程式提供 'java'。

  選擇        指令
-----------------------------------------------
   1           /usr/lib/jvm/jre-1.5.0-gcj/bin/java
*+ 2           /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java
   3           /usr/java//jdk1.7.0_25/bin/java

請輸入以保留目前的選擇[+],或輸入選擇號碼:3
[root@localhost java]# update-alternatives --config javac
[root@localhost java]# update-alternatives --config javaws
{code}

h3. Setting Eclipse used JDK7

Choose Window->Preference, then click following content



h3. Setting project replace jdk6 to jdk7

your_Project (click mouse right button)-> properties \-> java build path \-> edit









Reference:
[How do I install Oracle Java JDK 7?|http://askubuntu.com/questions/55848/how-do-i-install-oracle-java-jdk-7]
[Eclipse update|http://stackoverflow.com/questions/12588537/how-to-change-jdk-version-for-an-eclipse-project]


Reference:
[How do I install Oracle Java JDK 7?|http://askubuntu.com/questions/55848/how-do-i-install-oracle-java-jdk-7]

2013年7月29日 星期一

PSQL string concate

1. Solution:
A. Using || symbol
select account||lastname from user where account = 'andy';







B. write the function
create or replace function concate(text,text) RETURNS text AS $$ SELECT $1 || '' ||$2; $$ LANGUAGE 'sql';
select concate(account,lastname) from user where account = 'andy';




Reference:
a-better-concat-for-postgresql
How to concatenate strings of a string field in a PostgreSQL
wiki Postsql

2013年7月28日 星期日

Struts2 Version 2.3.15 HelloWorld Setting

1. Problem:
There are some different after struts2 2.1.3, e.g. the library and the strtus.xml, web.xml setting file


2. Solution:
A. Downlaod form struts-2.3.15.1-lib.zip

B. Use the following Basic library, and copy to WebContent/WEB-INF/lib:
asm-3.3.jar
asm-commons-3.3.jar
asm-tree-3.3.jar
commons-fileupload-1.3.jar
commons-io-2.0.1.jar
commons-lang-2.4.jar
commons-lang3-3.1.jar
commons-logging-1.1.3.jar
freemarker-2.3.19.jar
javassist-3.11.0.GA.jar
ognl-3.0.6.jar
struts2-core-2.3.15.1.jar
xwork-core-2.3.15.1.jar

C. Writing the web.xml, there we use the StrutsPrepareAndExecuteFilter

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    version="2.5">
   
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

D. Writing the struts.xml in Project_dir/Java Resource/src and write your action class
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
<constant name="struts.devMode" value="true" />
    <package name="default" extends="struts-default"> 
        <action name="hello" class="ibms.struts2.HelloWorldAction" method="execute">
            <result name="success">/HelloWorld.jsp</result>
        </action>
       
    </package>
</struts>


3. Reference
Difference between Struts 2 FilterDispatcher and StrutsPrepareAndExecuteFilter ?
struts2-hello-world-jsp-example-error