<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.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DatabaseAccessThread implements Runnable {
private static final String DB_URL = "jdbc:jtds:sqlserver://localhost:1433/mydatabase";
private static final String DB_USER = "username";
private static final String DB_PASSWORD = "password";
public void run() {
Connection connection = null;
try {
connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
System.out.println(Thread.currentThread().getName() + " connected to database.");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");
while (resultSet.next()) {
System.out.println(Thread.currentThread().getName() + ": " + resultSet.getString("column1"));
}
resultSet.close();
statement.close();
connection.close();
System.out.println(Thread.currentThread().getName() + " disconnected from database.");
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
for (int i = 0; i < 5; i++) {
Thread thread = new Thread(new DatabaseAccessThread());
thread.start();
}
}
}
