Query SQL Server
From MyWiki
// Connecting to SQL Server 2008 Class.forName ("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn = DriverManager.getConnection ("jdbc:sqlserver://<server>:1433;databaseName=<db>;selectMethod=cursor", "<username>", "<password>"); System.out.println ("Database connection to Database established"); stmt = conn.createStatement(); rs = stmt.executeQuery("SELECT acc_dept,acc_cardno,stu_level_code,csu_username,email_address from userdata " ); while(rs.next()) { etc etc