November 10th, 2008 
admin How to Connect Java with Sql Server :
1.import sql package
2.Give all the Supporting class in class.forName
3.Give Ipaddress or Computer Name in dburl or in getConnection
4.Use 1433 port Number as Default Port.
5.Give Username and Password in getConnection
6.Open the Connection using createStatement
7.Execute the query String using executeQuery Statement
8.Fetch the Record one by one Using ResultSet
9.Close the Connection
import java.sql.*;
public class sqlserverConnection
{
public static String dburl=”jdbc:mysql://localhost:1433”;
public static String username=”admin”;
public static String pwd=”pass”;
public static Connection con=null;
public static Statement stmt=null;
public static ResultSet rs=null;
public static void main(String[] args)
{
try {
Class.forName( “com.microsoft.jdbc.sqlserver.SQLServerDriver” );
con=DriverManager.getConnection(dburl,username,pwd);
stmt=con.createStatement();
rs=stmt.executeQuery(”SELECT * FROM demo”);
while(rs.next())
{
String name=rs.getString(1);
}
}
catch(SQLException sqlExcp)
{
sqlExcp.printStackTrace();
}
}
}
Popularity: 1% [?]
Posted in 
Tags: 
