1.Using preparedstatement to set params for char type in where clause,
it wouldn't return the correct result.
We should use the method trim to deal with it .
such as "select count(1) from STOCKINFKEYCHAR where trim(stockcode) =?"
2. Use oralce preparedstatement to setnull in where clause , it won't do effect .
We need to use "is null" to replase it