import java.sql.*;
public class JTDSDemo {
public static void main(String[] args) {
String connectionString = "jdbc:jtds:sqlserver://localhost:1433/database_name";
String username = "your_username";
String password = "your_password";
try (Connection connection = DriverManager.getConnection(connectionString, username, password)) {
String sql = "SELECT * FROM employees";
try (Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql)) {
while (resultSet.next()) {
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println("Name: " + name + ", Age: " + age);
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
