Query SQL Server

From MyWiki
Revision as of 11:39, 22 September 2014 by George2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
               // 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 one,two,three  from userdata  " );
              while(rs.next()) 
                   {
                    etc etc