Overview (FAQ5)


Try this is a pattern for LOOP/READNEXT on a collection without sucking down all the data in 1

Connection conn1=DriverManager.getConnection("")
stmt1 = conn1.createStatement();
rs1 = stmt1.executeQuery("SELECT * FROM department)
while (rs1.next())


To get a list of installed apps in windows 7- in case of a complete system re-build.

1. Open command prompt with admin rights. That is, type in cmd either in Start menu search box or in Run dialog box and hit Ctrl + Shift +Enter to open the command prompt with admin rights.Alternatively you can also go to All Programs > Accessories and right-click on Command Prompt and select Run as administrator.

2. Click continue button if you get User Account Control (UAC) Prompt.

3. Here in the Command Prompt, type WMIC and hit enter. Once you type hit enter to see below message.

dos prompt

4. Next, you need to type the following command:

/output:C:\InstallList.txt product get name,version

wmic prompt

Where ā€œCā€ is the drive letter where Windows will store the installed applications list. You can also change the name of the output file and drive letter if you want to modify the output location. Also note that this trick should work in Windows 2000 & XP operating systems without problems.

This gem copied from: http://www.intowindows.com & the following from : http://www.helpdeskgeek.com


People with little or no Windows knowledge are often scared when wein support ask them to:

"open the Command Prompt as Administrator". To do this in Windows 7 or Windows Vista, enter ā€œcmdā€ (without the quotes) in the Search Programs and Files box on the Start menu. The cmd.exeprogram should automatically be highlighted in the Programs section of the results. Press Ctrl + Shift + Enter to opencmd.exe as Administrator.

cmd prompt

You can also open the Command Prompt as Administrator in Windows 7 or Windows Vista by opening All Programs | Accessories on the Start menu. Right-click on the Command Prompt shortcut and select Run as administrator from the popup menu.

cmd prompt

If you are using Windows XP, open All Programs | Accessories on the Start menu. Right-click on the Command Promptshortcut and select Run as from the popup menu.

win xp cmd prompt

run as dialog

uac dialog


Kaspersky EndPoint Software Download

Use this link to download the current version of Kaspersky Endpoint.