Difference between revisions of "Query SQL Server"

               // 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