George2 at 11:39, 22 September 2014

2014-09-22T11:39:42Z

George2: Created page with " // Connecting to SQL Server 2008 Class.forName ("com.microsoft.sqlserver.jdbc.SQLServerDriver");..."

2014-09-22T11:39:08Z

Created page with "<source lang="java"> // Connecting to SQL Server 2008 Class.forName ("com.microsoft.sqlserver.jdbc.SQLServerDriver");..."

New page

<source lang="java">

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

</source>

@@ Line 8: / Line 8: @@
                 stmt = conn.createStatement();
-                rs = stmt.executeQuery("SELECT acc_dept,acc_cardno,stu_level_code,csu_username,email_address  from userdata  " );
+                rs = stmt.executeQuery("SELECT one,two,three  from userdata  " );
                while(rs.next())
+                    {

Query SQL Server - Revision history

George2 at 11:39, 22 September 2014

George2: Created page with " // Connecting to SQL Server 2008 Class.forName ("com.microsoft.sqlserver.jdbc.SQLServerDriver");..."