MS SQL 自動補零

Select Right('00' + Cast(ROW_NUMBER() OVER(order by 編號) as nvarchar(3)),3)

java 1.4.2 invoke 1.5 method

complation with 1.4.2 has no setAlwaysOnTop but run at 1.5 can use method invoke


try
    {
    JFrame test =new JFrame();
 Method setAlwaysOnTop = null;
 setAlwaysOnTop = test.getClass().getMethod("setAlwaysOnTop", new Class[] { Boolean.TYPE });
 setAlwaysOnTop.invoke(test, new Object[] { new Boolean(true) });
    }
    catch (Throwable  ....

JTable specified row

changeSelection(int rowIndex,int columnIndex,boolean toggle,boolean extend) 

toggle: false, extend: false. Clear the previous selection and ensure the new cell is selected.  

toggle: false, extend: true. Extend the previous selection to include the specified cell. 

toggle: true, extend: false. If the specified cell is selected, deselect it. If it is not selected, select it. 

toggle: true, extend: true. Leave the selection state as it is, but move the anchor index to the specified location. 

reference:
javaworld, java 1.4.2 api

JFrame title and Windows taskbar

new Thread(){
    public void run(){
        String status="";
        int num=100000000;
        for(int i=0;i < num ;i++){
            DecimalFormat df=new DecimalFormat("##.##");
            status=df.format((double)i/num*100);//percentage
            if(i%1000==0){
                SwingUtilities.invokeLater(new Runnable(){
                     public void run(){
                        frame.setTitle(status+"%");
                    }
               });
           }
       }
   }
}.start();

NetBeans use GTK style

netbeans --laf com.sun.java.swing.plaf.gtk.GTKLookAndFeel

or

/etc/netbeans.conf

netbeans_default_options=" ... --laf com.sun.java.swing.plaf.gtk.GTKLookAndFeel"

GPG Key Error

Q:
W: GPG error: http://ppa.launchpad.net intrepid Release: 由於沒有公鑰，下列簽名無法進行驗證： NO_PUBKEY 60D11217247D1CFF

A:
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 60D11217247D1CFF

Read HDFS File

FileSystem fs=FileSystem.get(new URI("hdfs://localhost:9000"),new Configuration());
FileStatus[] flist=fs.listStatus(new Path("input/"));

FSDataInputStream fsdatainput=fs.open(flist[0].getPath());
BufferedReader bfr=new BufferedReader(new InputStreamReader(fsdatainput));
while(bfr.ready())
{
System.out.println(bfr.readLine());
}

直接讀取比較省事!!