<dependency>
<groupId>net.sourceforge.jtds</groupId>
<artifactId>jtds</artifactId>
<version>1.3.1</version>
</dependency>
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JtdsExample {
private static final String DB_URL = "jdbc:jtds:sqlserver://localhost:1433/mydatabase";
private static final String DB_USERNAME = "username";
private static final String DB_PASSWORD = "password";
public static void main(String[] args) {
try {
Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JtdsExample {
public static void main(String[] args) {
try {
Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");
while (resultSet.next()) {
}
resultSet.close();
statement.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JtdsExample {
public static void main(String[] args) {
try {
Connection connection = DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
Statement statement = connection.createStatement();
statement.executeUpdate("INSERT INTO mytable (column1, column2) VALUES (value1, value2)");
statement.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
