albert's blog

2012/03/08

Autotab: jQuery auto-tabbing and filter plugin

Requirement

We have five input text fields in this page.

As we filled in 3 characters in dlv_unit(移送單位), system should automatically set focus to tax_cd(稅別).
As we filled in 2 characters in tax_cd(稅別) , system should automatically set focus to dlv_yr(移送年度).
As we filled in 3 characters in dlv_yr(移送年度) , system should automatically set focus to flg_tp(申報年度).
As we filled in 1 characters in flg_tp(申報年度), system should automatically set focus to serial_no(流水號).

Introduction

Autotab is a jQuery plugin that provides auto-tabbing and filtering on text fields in a form. Once the maximum number of characters has been reached within a defined text fields, the focus is automatically set to the defined target of the element.

Download

jQuery Autotab Plugin v1.1b (1867021)

Basic Usage

1. Include jquery.autotab.js in your HTML:
2. Add your text fields in your HTML, including an ID:

3. Initialize Autotab on your text fields with a ready() handler:

iReport : text alignment

Requirement
Utilize JasperReports to print name and adrress on envelope. Name and addess should print from top to down.

Concerning text alignment, iReport has three attributes:

textAlignment - Values allowed for the horizontal alignment are: Left, Center, Right and Justified. By default, horizontal alignment is set to Left.
verticalAlignment - Values allowed for the vertical alignment are: Top, Middle and Bottom. By default, vertical alignment is set to Top.
rotation - Values allowed for the text rotation are: None, Left, Right and UpsideDown. By default, text rotation is set to None.

Examples of combining horizontal alignment, vertical alignment and rotation in a element.
The resulting paragraph will be horizontally aligned left, vertically aligned top, and the text will flow from top to bottom.

Running this sample

2012/02/14

Apply IS_IGNORE_PAGINATION when export to CSV in JasperReports

Problem

I'm writing a report which needs to be exported to pdf and CSVformat.
when output format is CSV, it should be ignore pagination.
The screenshot as bellowing is wrong, it has pagination in CSVfile:

Solution
JasperReports provides IS_IGNORE_PAGINATION.
It is a fill-time parameter, therefore you'll have to set it when filling the report:


params.put(JRParameter.IS_IGNORE_PAGINATION, Boolean.TRUE);

JasperFillManager.fillReport(jasperReport, params, dataSource);

See...CSV file does not have pagination after set IS_IGNORE_PAGINATION to TRUE.

2012/02/06

20 Database Design Best Practices

Use well defined and consistent names for tables and columns (e.g. School, StudentCourse, CourseID ...).
Use singular for table names (i.e. use StudentCourse instead of StudentCourses). Table represents a collection of entities, there is no need for plural names.
Don’t use spaces for table names. Otherwise you will have to use ‘{‘, ‘[‘, ‘“’ etc. characters to define tables (i.e. for accesing table Student Course you'll write “Student Course”. StudentCourse is much better).
Don’t use unnecessary prefixes or suffixes for table names (i.e. use School instead of TblSchool, SchoolTable etc.).
Keep passwords as encrypted for security. Decrypt them in application when required.
Use integer id fields for all tables. If id is not required for the time being, it may be required in the future (for association tables, indexing ...).
Choose columns with the integer data type (or its variants) for indexing. varchar column indexing will cause performance problems.
Use bit fields for boolean values. Using integer or varchar is unnecessarily storage consuming. Also start those column names with “Is”.
Provide authentication for database access. Don’t give admin role to each user.
Avoid “select *” queries until it is really needed. Use "select [required_columns_list]" for better performance.
Use an ORM (object relational mapping) framework (i.e. hibernate, iBatis ...) if application code is big enough. Performance issues of ORM frameworks can be handled by detailed configuration parameters.
Partition big and unused/rarely used tables/table parts to different physical storages for better query performance.
For big, sensitive and mission critic database systems, use disaster recovery and security services like failover clustering, auto backups, replication etc.
Use constraints (foreign key, check, not null ...) for data integrity. Don’t give whole control to application code.
Lack of database documentation is evil. Document your database design with ER schemas and instructions. Also write comment lines for your triggers, stored procedures and other scripts.
Use indexes for frequently used queries on big tables. Analyser tools can be used to determine where indexes will be defined. For queries retrieving a range of rows, clustered indexes are usually better. For point queries, non-clustered indexes are usually better.
Database server and the web server must be placed in different machines. This will provide more security (attackers can’t access data directly) and server CPU and memory performance will be better because of reduced request number and process usage.
Image and blob data columns must not be defined in frequently queried tables because of performance issues. These data must be placed in separate tables and their pointer can be used in queried tables.
Normalization must be used as required, to optimize the performance. Under-normalization will cause excessive repetition of data, over-normalization will cause excessive joins across too many tables. Both of them will get worse performance.
Spend time for database modeling and design as much as required. Otherwise saved(!) design time will cause (saved(!) design time) * 10/100/1000 maintenance and re-design time.

2012/02/03

50 Most Frequently Used UNIX / Linux Commands (With Examples)

http://www.thegeekstuff.com/2010/11/50-linux-commands/

1. tar command

2. grep command

3. find command

4. ssh command

5. sed command

6. awk command

7. vim command

8. diff command

9. sort command

10. export command

11. xargs command

12. ls command

13. pwd command

14. cd command

15. gzip command

16. bzip2 command

17. unzip command

18. shutdown command

19. ftp command

20. crontab command

21. service command

22. ps command

23. free command

24. top command

25. df command

26. kill command

27. rm command

28. cp command

29. mv command

30. cat command

31. mount command

32. chmod command

33. chown command

34. passwd command

35. mkdir command

36. ifconfig command

37. uname command

38. whereis command

39. whatis command

40. locate command

41. man command

42. tail command

43. less command

44. su command

45. mysql command

46. yum command

47. rpm command

48. ping command

49. date command

50. wget command

ORA-12704: character set mismatch

Problem
As I execute this SQLstatement

1:  SELECT .....(ignore)  
2:      CASE   
3:        WHEN NIGT001.TAX_CD='15'  
4:          THEN (SELECT NIGT007.ADTR_NM  
5:             FROM NIGT007   
6:             WHERE NIGT001.PRST_ADTR_CD = NIGT007.ADTR_STAFF_CD(+) )  
7:       ELSE ''  
8:      END AS ADTR_NM  
9:  FROM NIGT001,NIGT013,NIGT007, ......(ignore)     
10:  WHERE ......(ignore)  
11:  ORDER BY .....(ignore)

It showed this error message

ORA-12704: 字元設定不符合
12704. 00000 - "character set mismatch"
*Cause: One of the following
- The string operands(other than an nlsparams argument) to an
operator or built-in function do not have the same character
set.
- An nlsparams operand is not in the database character set.
- String data with character set other than the database character
set is passed to a built-in function not expecting it.
- The second argument to CHR() or CSCONVERT() is not CHAR_CS or
NCHAR_CS.
- A string expression in the VALUES clause of an INSERT statement,
or the SET clause of an UPDATE statement, does not have the
same character set as the column into which the value would
be inserted.
- A value provided in a DEFAULT clause when creating a table does
not have the same character set as declared for the column.
- An argument to a PL/SQL function does not conform to the
character set requirements of the corresponding parameter.
*Action:
第 97 行, 資料欄: 133 發生錯誤

Root Cause
The problem result from NIGT007.ADTR_NM is NVARCHAR2.
But the case-when-else statement return empty string in else statement. The empty string is VARCHAR2.
That's why it complains "character set mismatch". What we need to do is do casting.

1:  SELECT .....(ignore)  
2:      CASE   
3:        WHEN NIGT001.TAX_CD='15'  
4:          THEN (SELECT NIGT007.ADTR_NM  
5:             FROM NIGT007   
6:             WHERE NIGT001.PRST_ADTR_CD = NIGT007.ADTR_STAFF_CD(+) )  
7:       ELSE CAST('' as NVARCHAR2(10))  --do cast here
8:      END AS ADTR_NM  
9:  FROM NIGT001,NIGT013,NIGT007,, ......(ignore)    
10:  WHERE ......(ignore)  
11:  ORDER BY .....(ignore)

2012/01/18

4 tips to improve performance of Java application with database

Java database performance tips 1:

Find out how many database calls you are making and minimize those believe it or not if you see performance in seconds than in most cases culprit is database access code. since connecting todatabase requires connections to be prepared, network round trip and processing on database side, its best to avoid databasecall if you can work with cached value. even if your application has quite dynamic data having a short time cache can save many database round trip which can boost your java applicationperformance by almost 20-50% based on how many calls got reduced.

Java database performance tips 2:

Check whether your database has indexed on columns if you are reading from database.

Java database performance tips 3:

Use PreparedStatement or Stored Procedure for executing query Prepared Statements are much faster than normal Statement object as database can pre-compile them and also cache there query plan.

Java database performance tips 4:

Use Connection Pool for holding Database Connections.

Reference: http://javarevisited.blogspot.com/2012/01/improve-performance-java-database.html

2012/01/17

Java Comparator Example

If you have a List of the employee objects then you need to use Collections.sort() method to sort the list holding employee objects. Below example will show how to write custom comparator. I’ve given three examples of custom comparators.

Employee Object

Next you need to define the custom comparator which will help you to sort by employee name, gender and age.

Name comparator

Gender Comparator

Age Comparator

Here is the main class which uses the comparator to sort the employee objects based on name, gender and age.

The default result is based your insertion order.

If you apply NameComarator

The result will be sorted based on name.

If you apply AgeComparator

The result will be sorted by age.

If you apply GenderComparator

The result will be sorted by gender

2012/01/15

5 Skills for Tech Leads

1) Development

You should be a developer, and a good one.

2) Release Management

Your main job is to resolve needs and roadblocks (not to make sure that people are following any methodology).

3) Product Management

Prioritize, that's all. Then, you just have to work on the most important tasks from your list (which will also be small ones if you did your homework).

4) Recruiting

Learn how to test people inside your team.

5) Managing People

Be honest and helpful.

http://blog.assembla.com/assemblablog/tabid/12618/bid/70857/5-Skills-for-Tech-Leads.aspx

2012/01/13

How Larry Page Changed Meetings At Google After Taking Over Last Spring

Every meeting must have one clear decision maker. If there's no decision maker -- or no decision to be made -- the meeting shouldn't happen.

No more than 10 people should attend.

Every person should give input, otherwise they shouldn't be there.

No decision should ever wait for a meeting. If a meeting absolutely has to happen before a decision should be made, then the meeting should be scheduled immediately.

2012/01/12

iReport 直式/橫式報表

需求
根據User所選擇要輸出橫式或直式的格式，分別輸出符合指定格式的報表

若user選擇列印格式為橫式

就輸出橫式報表

若user選擇列印格式為直式

就輸出直式報表

作法 - 橫式報表

由於iReport建立template後，default式Portrait，此時要手動去修改其page format

1. right click --> Page Format

2. Choose "Landscape" -- > OK

3. Change sucessfully

4. Drag and drop data field to template

作法 - 直式報表

1. Drag and drop data fields into template

2. Click each data field and go to change its property

3. Change "Rotation" property to "Right"

4. Check the result

Winners and Losers in Business Open-Source Software

Application Server/Web Server:

Trending Up: Node.js and NGINX
Trending Level: Tomcat and Apache HTTP Server
Trending Down: JBoss and GlassFish

Frameworks:

Trending Up: Rails
Trending Level: Spring, Grails, Struts
Trending down: (none)

Databases and Big Data:

Trending Up: HBase, Hadoop, MongoDB
Trending Level: MySQL, PostgreSQL
Trending Down: CouchDB

http://www.dzone.com/links/r/winners_and_losers_in_business_opensource_software.html

2012/01/08

How to create barcode in iReport

Here is a simple example to create barcode in iReport

Scenario
1. As user click "Preview" in iReport, it will show dialog to input
2. iReport will generate barcode in "Preview" mode

Process
1. File-->New