import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
String url = "jdbc:sqlserver://localhost:1433;databaseName=YourDatabaseName";
String username = "YourUsername";
String password = "YourPassword";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url, username, password);
// ...
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
try {
String query = "SELECT * FROM YourTableName";
PreparedStatement statement = conn.prepareStatement(query);
ResultSet result = statement.executeQuery();
while (result.next()) {
int id = result.getInt("id");
String name = result.getString("name");
System.out.println("ID: " + id + ", Name: " + name);
}
result.close();
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
