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:
JtdsSqlServerJdbcConnection.java - jTDS JDBC Connection Example
How to create a JDBC connection to SQL Server database using the jTDS JDBC driver? I want to see a Java program example.
✍: FYIcenter.com
If you have a SQL Server running on your local computer with TCP/IP protocol turned on and listening on port 1433, you can use the following example, JtdsSqlServerJdbcConnection.java, to learn how to create a JDBC connection:
// Copyright (c) 2016 FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; import java.sql.DatabaseMetaData; // Example of jTDS JDBC connection to SQL Server public class JtdsSqlServerJdbcConnection { public static void main(String [] args) throws Exception { // Build the jTDS JDBC connection URL String url = "jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter"; Connection con = DriverManager.getConnection(url); System.out.println("JDBC connection and database server information:"); DatabaseMetaData meta = con.getMetaData(); System.out.println("Database Product Name: " + meta.getDatabaseProductName()); System.out.println("Database Product Version: " + meta.getDatabaseProductVersion()); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("JDBC Major Version: " + meta.getJDBCMajorVersion()); System.out.println("JDBC Minor Version: " + meta.getJDBCMinorVersion()); // Close the connection 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 -cp C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerJdbcConnection.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerJdbcConnection JDBC connection and database server information: Database Product Name: Microsoft SQL Server Database Product Version: 12.00.2000 Driver Name: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase Driver Version: 1.3.1 JDBC Major Version: 3 JDBC Minor Version: 0
The output confirms that:
⇒ JtdsSqlServerJdbcUrl.java - jTDS JDBC Connection URL Example
⇐ SQL Server SQLEXPRESS Service for jTDS Test
2017-01-29, 2539🔥, 0💬
Popular Posts:
JDK 8 tools.jar is the JAR file for JDK 8 tools. It contains Java classes to support different JDK t...
XStream is a simple library to serialize objects to XML and back again. JAR File Size and Download L...
Jackson is "the Java JSON library" or "the best JSON parser for Java". Or simply as "JSON for Java"....
Jackson is "the Java JSON library" or "the best JSON parser for Java". Or simply as "JSON for Java"....
JDK 11 jdk.xml.dom.jmod is the JMOD file for JDK 11 XML DOM module. JDK 11 XML DOM module compiled c...