aspose file tools*
The moose likes JDBC and the fly likes jdbc with microsoft SQl Server 2008 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc with microsoft SQl Server 2008" Watch "jdbc with microsoft SQl Server 2008" New topic
Author

jdbc with microsoft SQl Server 2008

Rajeev Kumarjamshedpur
Greenhorn

Joined: Apr 27, 2009
Posts: 5
hi
I am wrinting a simple java code that communicate with microsoft SQL Server 2008

and after this set classpath of sqljdbc4.jar
and after this i comile the program i got following error
C:\Documents and Settings\r6876046\Desktop>javac Test.java
Test.java:7: package com.microsoft.sqlserver.jdbc does not exist
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQ
LServerDriver());
^
1 error


here is my source code

import java.sql.*;
class Test
{
public static void main(String[] args) throws Exception
{
// Register the driver
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
// Establish connection with the Database
Connection con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433:10.87.1.4","sa","jeffrey");
//cfreate a sql statement
Statement stmt=con.createStatement();
//Execute the stmt
ResultSet rs=stmt.executeQuery("select * from studentinfo");
//all row of student table are in rs Now retrive column data from rs and display
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
//System.out.println(rs.getInt(1));
System.out.println("===================================");
}
// close the connection
con.close();
}
}


Please help me about this and where i need to change and how i achive the goal please guide me properly i am waiting for Your Response


thanks In Advance

Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3825

Use,


to load and register the driver class with the DriverManager.


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc with microsoft SQl Server 2008