JSP EL 顯示成功與否

如果web.xml內的version是2.5
即
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"
id="WebApp_ID" version="2.5"

就要在jsp前加上
.... pageEncoding="UTF-8" isELIgnored="false"

2.4版的就不用因為EL預設就是ingore為false
web-app id="WebApp_ID" version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"

Mysql在Linux從安裝到啟動和開機時自動啟動服務的設定

Mysql 在 Linux 系統中開啟服務的方式
如果是以binary檔,也就是下載mysql-5.1.48-linux-i686-glibc23.tar.gz
以下是設定流程：
1.解壓到/usr/local/mysql下
＃tar -xz -f mysql-5.1.48-linux-i686-glibc23.tar.gz -C /usr/local/mysql
此時mysql的主目錄（以下用mysql_home稱之）會是：/usr/local/mysql/mysql-5.1.48-linux-i686-glibc23

2.新增mysql group , 並建立一個mysql user於該group內
＃ groupadd mysql
# useradd mysql -g mysql
3.在mysql_home的support-files內複製檔案到/etc
# cp mysql_home/support-files/my-medium.cnf /etc/my.cnf

4. 到mysql_home,然後執行初始化DB的工作（內容請參閱手冊）
# ./scripts/mysql_install_db --user=mysql

5.設定一些權限（mysql_home內）
# chown -R root .
# chown -R mysql data

# chown -R mysql data/.
# chgrp -R mysql .

6.啟動看看
# /usr/local/mysql/bin/mysqld_safe --user=mysql &
如果看到mysql ended 等的字就是失敗,快去看一下log
7.如果成功用命令修改root預設為空的密碼
# mysql_home/bin/mysqladmin -u root password yourpassword

8.接下來設定開機啟動mysql服務
# cp mysql_home/support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 700 /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on

9.修改/etc/rc.d/init.d/mysqld的內容（斜體部份是要填入的）
basedir=/usr/local/mysql/mysql-5.1.48-linux-i686-glibc23
datadir=/usr/local/mysql/mysql-5.1.48-linux-i686-glibc23/data

10.之後就可以用
service mysqld start 來啟動
service mysqld stop 來關閉或
mysql_home/bin/./mysqladmin -u root -p shutdown

另一種方式,附加在rc.local內
[root @hostname /root]# vi /etc/rc.d/rc.local
/usr/local/apache/bin/apachectl start
/mysql＿home/mysql.server start

oracle backup

backup control file :
SQL> alter database backup controlfile to trace;
it will generate sid_ora_XXXX.trc at "C:\oracle\product\10.2.0\admin\orcl\udump"

backup tablespace and datafile file:
SQL> spool c:\work_dump/spoolback.txt
SQL> select * from dba_tablespaces;
SQL> select * from dba_data_files;
SQL> spool off;
SQL> exit

DB dump :
C:\Documents and Settings\Administrator>exp system/oracle full=y file="c:/work_d
ump/joseph_'yourDate'.dump" statistics=none inctype=complete
in Linux 'yourDate' can be "date+%Y%m%d%H%M%S"

So we have three file and backup it up to another disk !

LockMode in DAO of Hibernate

public ProfileVO getProfilebyLoginIdLockMode(final String loginId){
ProfileVO vo = null;
List list = (List)this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(org.hibernate.Session session) throws HibernateException, SQLException {
Criteria cri=session.createCriteria(ProfileVO.class,"p");
cri.add(Restrictions.eq("p.loginId", loginId)).setLockMode(LockMode.FORCE);
return cri.list();
}
});

if(list.size()>0){
vo = (ProfileVO)list.get(0);
}
return vo;
}

do not use the following method , because it will get a new persistent context and lock will be failure !

...
Session session = this.getHibernateTemplate().getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from ProfileVO p where p.loginId='"+loginId+"'").setLockMode("p", LockMode.FORCE);
List list1 = query.list();

if(list1.size()>0){
vo = (ProfileVO)list1.get(0);
}
tx.commit();
session.close();

jquery getJSON

Jquery的1.4版之後在處理JSON和之前版本有差異
這次就是在處理時是用單引號，但1.4之後強制跟正規的JSON走(要用雙引號)，
所以若用單引號會發現 $.getJSON的callback會沒有作用
請參閱

Quartz在Spring中指定方法並帶參數

< id="jobDetailBean" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
< name="targetObject">
< bean="synSellingDataJob">
< /property >
< name="targetMethod">
<>execute
< /property >
< name="arguments">
<>
< type="java.lang.String ">Joseph< /value >
< type="java.lang.String">I love you< /value >
< /list >
< /property >

< /bean >

code :

public void execute(Object[] obj){
....
}

生活記事7-11 i-bon好方便

今年四月幫小可換駕照，到7-11一切搞定!
準備 : 身份證正反影本、舊駕照正反影本、照片一張、現金(換照錢、影印、掃描)兩百五六十吧~忘了
先去i-bon選擇換照的項目，會印出來、然後把以上的東西都貼上去，掃描傳送出去就完成了 !
身份證影本和照片都可以再利用 !
過幾天新照就會寄過來了~~而且照片還是彩色的喔 ! 真cool ! 方便 ! 讚啦 !