Eclipse IDE
Installation and Authentication
1
Go to the Eclipse marketplace and install the Aikido Plugin

3
Try out an example
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class UserServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse res)
throws IOException {
String connStr = "jdbc:sqlserver://myserver.database.windows.net:1433;" +
"database=mydb;" +
"user=myuser;" +
"password=$uperSecret123!@#;" +
"encrypt=true;" +
"trustServerCertificate=false;" +
"loginTimeout=30;";
String username = req.getParameter("username");
String unsafeQuery = "SELECT * FROM users WHERE username = '" + username + "'";
try (Connection conn = DriverManager.getConnection(connStr);
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery(unsafeQuery)) {
// Convert ResultSet to JSON-like structure
List<Map<String, Object>> resultList = new ArrayList<>();
int columnCount = result.getMetaData().getColumnCount();
while (result.next()) {
Map<String, Object> row = new HashMap<>();
for (int i = 1; i <= columnCount; i++) {
row.put(result.getMetaData().getColumnName(i),
result.getObject(i));
}
resultList.add(row);
}
res.setStatus(200);
res.setContentType("application/json");
res.getWriter().write(new Gson().toJson(resultList));
} catch (Exception e) {
res.setStatus(500);
res.getWriter().write("Error: " + e.getMessage());
}
}
}Uninstall
Last updated
Was this helpful?

