java code – Program Creek

Java code for connecting MS SQL Server by using SQL Server Authentication

February 11, 2014May 26, 2010 by ProgramCreek

First of all, You will need to add a jar file to your project library as SQL Server 2000 Driver for JDBC Service. My target is SQL Server 2000, it will require the jar file called “sqljdbc4.jar”. This is not supported on Microsoft website now, you can download it here. For other versions of SQL Server, here is the link of SQL Server 2000 Driver for JDBC Service.

The following is the code for connection MS SQL Server and select some records from a testing table.

Java code: Open IE browser and close it

September 23, 2013May 25, 2009 by ProgramCreek

I want to refresh my blog on Sohu to increase the visitor count. The following is the code for open IE browser and then close it. This will be done every 5 seconds, and in one day the count should be able to increase 3600*24/5 = 17280. So if you open your computer 10 days,Â the count will become 172800. That will be a nice number.