How to remove line numbers from the copy pasted code in Notepad++

Hope many of us faced this issue while copy pasting the code. Along with the code, the line numbers will also be pasted. There are many ways to remove this line numbers from the code. In Notepad++, We can use regex ^\d+ in the Find and Replace option. But there is another handy way which is explained below.

Let's say we have a html code as below: 

1: <html>
2: <body>
3: <h1> HELLO PROGRAMMER </h1>
4: </body>
5: </html>

If We wish to remove the line numbers from 1 to 5, there is a handy way for this. Press the <Alt> key and Drag the mouse on the numbers with the left mouse button pressed. This will select the numbers alone. Thus we can delete the numbers easily with this feature in Notepad++.


resultSet.next() always returns “false”!!

You might be executing some query in your application and even though that you verified all the connection parameters like connection URL to the database, username and password, and the SQL statement that you fired, and that data also resides in the database in proper table. Yet resultSet.next() is always returning false. 

The retrieved resultSet actually points initially to a location before the actual data index, so with first resultSet.next() call, the resultSet pointer now points to the first fetched record in the database. This is ridiculous and had wasted more time. Actually I failed tocommit the data after inserting into the table. Without committing, that data never is written to the database schema. So check, did you really do a 

SQL> commit;

After scorching my head for over hours for these 7 characters of wisdom ( c-o-m-m-i-t-; ), I unleashed the forgotten thing: DML commands need to be committed/rolled-back for changes to take effect.

Thanks to : Little things worth stumbling upon!: resultSet.next() always returns “false”!!: 

Autofill Date in Excel Sheet columns

Hope everyone aware of filling Numeric values and filling Numeric series in Excel sheet(Microsoft). We can achieve filling Numeric values by just dragging the particular cell and filling Numeric Series by dragging the particular cell along pressing 'Ctrl' Key.

Filling Numeric value '1' from cells B2 to B11

Filling Numeric value '1' from cells B2 to B11

Filling Numeric series - '1 to 10' from cells B2 to B11

But what shall we do to fill Date values in excel columns.This can be achieved by dragging the cell by right clicking. You can choose either Day,Week,Month and Year.

Step-1

Step-2

Reference: http://www.techrepublic.com/article/use-excels-autofill-to-generate-a-series-of-dates/

Visit the Typing Test and try!

Why should Main method in Java carry public static and void in its syntax always?

public static void main(String args[])

Every java programmer wondered to follow the syntax for main method as mentioned above. This is the reason behind the syntax. 

Why public - The access specifier of Main method is said to be public so that main method can be called outside of the class . This makes sure that JVM can easily access and execute the main method.

Why static - Main method is declared static so that JVM can call the main method with out creating instance for it. [While JVM tries to execute java program, it does not know how to create instance as there is no standard constructor defined for Main class].

Why void  - This is to make sure that Main method is not returning any values.

Cheers! Happy coding!