Connect to SQl

[vahidbakhtiary]

hi
i need to a sample code for connect to sql 2008 for fetch data
please help me
thanks

[Fubarable]

This is not a very good question for a forum since surely Google will find you sample code, and then if you have any problems understanding the concepts a better question for this site would be to ask about your points of confusion or about any errors in your code attempts.

[vahidbakhtiary]

thanks for your answer
i try this code :

import java.sql.*;


public class ConnectURL {

public static void main(String[] args)
{
DB db = new DB();
db.dbConnect("jdbc:sqlserver://localhost:1433/test", "sa", "123" );
}
}
class DB{
public void dbConnect( String db_connect_string,
String db_userid,
String db_password)
{
try{
Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
Connection conn = DriverManager.getConnection(
db_connect_string,
db_userid,
db_password);
System.out.println( "connected" );
}
catch( Exception e ){
e.printStackTrace();
}
}
};
but i meet error
please help me

[JosAH]

but i meet error
please help me

Oh dear; and now you want us to guess which error? I'll start: does the error start with an S?

kind regards,

Jos

[vahidbakhtiary]

i have 2 question :
do my code is correct
and
i get this error :
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at DB.dbConnect(ConnectURL.java:18)
at ConnectURL.main(ConnectURL.java:9)

[JosAH]

i have 2 question :
do my code is correct
and
i get this error :
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Either you misspelled that class name or that class is not on your classpath.

kind regards,

Jos

[vahidbakhtiary]

thanks for your answer

please if possible show me how to connect to sql and fetch records

thanks

[doWhile]

Step 1, see post 6. Step 2: get the driver to your database. Step 3: add the driver to your classpath when your run the program. Step 4: verify the correct name of your driver. Steps 2, 3, and 4 can be greatly aided by the use of your favorite web search engine.

[vahidbakhtiary]

thanks for your answer
i'm a .Net programmer
and i'm a new java programmer

if possible show me with cod

[DarrylBurke]

No. This is a forum, not a free coding service. As already said, there are tons of code samples to be found on the internet.

Also go through the following:
Forum Rules
Guide For New Members
BB Code List - Java Programming Forum

db

[vahidbakhtiary]

i try this code :

String driverName = "com.sql.jdbc.Driver";
try
{
Class.forName(driverName);
}
catch (Exception e)
{

System.err.println(e.getMessage());
}
and meet this error :
com.sql.jdbc.Driver
please help me

[JosAH]

i try this code :

String driverName = "com.sql.jdbc.Driver";
...

How strange, because first you had:

Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );

You do have to make up your mind; which one is it?

kind regards,

Jos

[Fubarable]

I'm guessing that he's just trying to use with random code downloaded from the internet, that he doesn't yet have a database per se.

[DarrylBurke]

i try this code :

String driverName = "com.sql.jdbc.Driver";
try
{
Class.forName(driverName);
}
catch (Exception e)
{

System.err.println(e.getMessage());
}
and meet this error :
com.sql.jdbc.Driver
please help me

I gave you a link to the forum section about using code tags. So, are you being obstinate or just plain lazy?

db

[Tolls]

Microsoft's MSDN site has plenty of examples of connecting to SQLServer using JDBC, including what you need to do to get it to work.
In fact the first few links on a decent web search are all MSDN articles on it.
As a .NET programmer I'm sure you are aware of MSDN, so why you have chosen to come here first is slightly bizarre to say the least.