Java Tip's - JOptionPane, JDBC call to SqlServer Stored Procedure

1. Introduction

I'm just gathering references to well done post and documentation about Java.

2. References

2.1. JOptionPane - Java MessageBox

• http://www.tiexpert.net/programacao/java/joptionpane.php
• http://docs.oracle.com/javase/7/docs/api/javax/swing/JOptionPane.html
• http://docs.oracle.com/javase/tutorial/uiswing/components/dialog.html
• http://stackoverflow.com/questions/8396870/joptionpane-yes-or-no-window

2.2. JDBC call to Sqlserver Stored Procedure with parameters

• http://stackoverflow.com/questions/6113674/how-do-i-execute-a-ms-sql-server-stored-procedure-in-java-jsp-returning-table-d

2.3. Reading and Writting Excel files using apache POI

• http://poi.apache.org/
• http://viralpatel.net/blogs/java-read-write-excel-file-apache-poi/
• http://stackoverflow.com/questions/10631423/how-to-read-from-first-to-last-row-in-excel-using-poi-in-java
• http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html
• http://stackoverflow.com/questions/4683828/hhmmss-xls-reading-using-apache-poi

2.4. JDBC Sqlserver Getting value of last AUTOINC sequence column inserted

• http://www.coderanch.com/t/534142/JDBC/databases/getGeneratedKeys-causing-exception

pstmt = conn.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
int insertCount = pstmt.executeUpdate(); // execute insert statement
System.out.println("Insert Count:" + insertCount);
ResultSet resultSet = pstmt.getGeneratedKeys();
if (resultSet != null && resultSet.next()) {
logId = resultSet.getLong(1);
}