Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
SqlServerJdbcUrl.java - sqljdbc JDBC Connection URL Example
How to use port number and database name in the connection URL string for SQL Server database using the sqljdbc JDBC driver? I want to see a Java program example.
✍: FYIcenter.com
Here is a Java example that shows you how to specify port number, database name, and instance name in the connection URL string for SQL Server database using the sqljdbc JDBC driver:
// Copyright (c) 2016 FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; // Example of sqljdbc JDBC connection URL public class SqlServerJdbcUrl { public static void main(String [] args) throws Exception { // sqljdbc JDBC connection URL with required elements String url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter"; Connection con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); // sqljdbc JDBC connection URL with port number url = "jdbc:sqlserver://localhost:1433;user=sa;password=fyicenter"; con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); // sqljdbc JDBC connection URL with database (catalog) name url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter;database=master"; con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); } }
You can compile and run the above example in a command window as shown below:
C:\fyicenter>\local\jdk-1.8.0\bin\javac SqlServerJdbcUrl.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar SqlServerJdbcUrl JDBC connection URL: jdbc:sqlserver://localhost;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:sqlserver://localhost:1433;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:sqlserver://localhost;user=sa;password=fyicenter;database=master Connected to: master
Note that "master" is the default system database name in a newly installed SQL Server. You can create your database and change the JDBC connection to your database.
⇒ SQL Server Browser Service on Instances for sqljdbc Test
⇐ SqlServerJdbcConnection.java - sqljdbc JDBC Connection Example
2016-12-24, 1803🔥, 0💬
Popular Posts:
What Is commons-codec-1.4.jar? commons-codec-1.4.jar is the JAR file for Apache Commons Codec 1.4, w...
JRE 8 rt.jar is the JAR file for JRE 8 RT (Runtime) libraries. JRE (Java Runtime) 8 is the runtime e...
JLayer is a library that decodes/plays/converts MPEG 1/2/2.5 Layer 1/2/3 (i.e. MP3) in real time for...
How to download and install javamail-1_2.zip? The JavaMail API is a set of abstract APIs that model ...
What is jxl.jar 2.6.12? jxl.jar 2.6.12 is the JAR file for Java Excel API 2.6.12, which is a Java li...