Question

how to connect java to sql server 2008..??
Can you help me in database connectivity ?

Answer 1

this might help:
www.java-tips.org/other-api-tips/jdbc/how-to-connect-microsoft-sql-server-using-jdbc.html

Answer 2

using JDBC . It help u out, to connect.

Answer 3

what is JDBC ? and how can get it ?

Answer 4

JDBC is an API for Java and You use it to connect Your application to a database. You can download the JDBC driver for SQL Server 2008 here (There are also instructions on how to install the drivers):
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=21599

Here is a detailed guide on MSDN how to connect to SQL Server database with JDBC:
http://msdn.microsoft.com/en-us/library/ee229549(v=sql.10)

Here is an example Java program that connects to a SQL Server 2008 database, executes a query and closes the connection (You need to change the connection string (dbUrl), the MSDN guide explains to what). :
http://pastebin.com/CcBprNmv

If something doesn't work try adding the driver jar file in the classpath.

Answer 5

thnx for help guyz.....