Package com.product.jdbc.dbutil;
Import java.sql.Connection;
Import Java.sql.DriverManager;
Import java.sql.SQLException;
public class Democonn {
Connection conn = null;
static {
try {
Class.forName ("Com.microsoft.sqlserver.jdbc.SQLServerDriver");//Load Database driver
SYSTEM.OUT.PRINTLN ("Database driver loading succeeded!!! --sqlserver ");
} catch (ClassNotFoundException e) {
E.printstacktrace ();
}
}
Public Connection Democonn () {
String url = "jdbc:sqlserver://213-pc:1433; Databasename=movie ";
String userName = "sa";
String PassWord = "123";
try {
conn = drivermanager.getconnection (URL, userName, passWord);//Get Database connection
IF (conn! = null) {
SYSTEM.OUT.PRINTLN ("Database connection succeeded!!! --sqlserver ");
}
} catch (SQLException e) {
E.printstacktrace ();
}
Return conn;//returns the Connection object
}
public static void Main (string[] args) {
Democonn democonn = new Democonn ();//Create Democonn Object
Connection conn = Democonn.democonn ();
}
}
Connecting in this way requires importing the Sqljdbc4.jar jar package.
URL format: jdbc:sqlserver://[servername[\instancename][:p ortnumber]][;p roperty=value[;p Roperty=value]
The default port for SQL Server is 1433, but I am installing R2, which uses a dynamic port.
View method: SQL Server Configuration manager->sqlserver Protocol->tcp/ip->ip address (scroll to the last port, the TCP dynamic port is changed to 1433, we can also change to another port)
Connect sqlserver2008 r2/sqlserver2008 with Java