public Kunde() {
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
connection = DriverManager.getConnection(url, user, password);
selectKunden = connection
.prepareStatement("SELECT RT.Logfile.l_ID, MGMT.Testcomponent.Name, MGMT.Testcases.Name, RT.Testdata.Summary, MGMT.Iteration.Name, MGMT.System.Name, MGMT.System.Version, RT.LOGFILE.FILE FROM MGMT.TESTCOMPONENT INNER JOIN MGMT.TESTCASES ON MGMT.Testcases.COMPONENT_ID = MGMT.Testcomponent.COMPONENT_ID INNER JOIN RT.Testdata ON MGMT.Testcases.TESTCASE_ID = RT.Testdata.TESTCASE_ID INNER JOIN RT.LOGFILE ON RT.Logfile.L_ID = RT.Testdata.LOGFILE_ID INNER JOIN RT.TESTRUNS ON RT.TESTRUNS.TESTRUN_ID = RT.Testdata.TESTRUN_ID INNER JOIN MGMT.System ON MGMT.System.SYSTEM_ID = RT.TESTRUNS.SYSTEM_ID INNER JOIN MGMT.Iteration ON MGMT.Iteration.I_ID = RT.TESTRUNS.I_ID");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException x) {
x.printStackTrace();
}
}
public ResultSet getKunden(String suchWert, String suchWert2,
String suchWert3, String suchWert4, String suchWert5,
String suchWert6, String suchWert7) {
try {
if (suchWert == null) {
suchWert = "";
}
if (suchWert2 == null) {
suchWert2 = "";
}
if (suchWert3 == null) {
suchWert3 = "";
}
if (suchWert4 == null) {
suchWert4 = "";
}
if (suchWert5 == null) {
suchWert5 = "";
}
if (suchWert6 == null) {
suchWert6 = "";
}
if (suchWert7 == null) {
suchWert7 = "";
}
selectKunden = connection
.prepareStatement("SELECT RT.Logfile.l_ID, MGMT.Testcomponent.Name, MGMT.Testcases.Name, RT.Testdata.Summary, MGMT.Iteration.Name, MGMT.System.Name, MGMT.System.Version, RT.LOGFILE.FILE FROM MGMT.TESTCOMPONENT INNER JOIN MGMT.TESTCASES ON MGMT.Testcases.COMPONENT_ID = MGMT.Testcomponent.COMPONENT_ID INNER JOIN RT.Testdata ON MGMT.Testcases.TESTCASE_ID = RT.Testdata.TESTCASE_ID INNER JOIN RT.LOGFILE ON RT.Logfile.L_ID = RT.Testdata.LOGFILE_ID INNER JOIN RT.TESTRUNS ON RT.TESTRUNS.TESTRUN_ID = RT.Testdata.TESTRUN_ID INNER JOIN MGMT.System ON MGMT.System.SYSTEM_ID = RT.TESTRUNS.SYSTEM_ID INNER JOIN MGMT.Iteration ON MGMT.Iteration.I_ID = RT.TESTRUNS.I_ID INNER JOIN MGMT.ExecutionController ON MGMT.ExecutionController.e_ID = RT.Testruns.e_ID WHERE MGMT.Iteration.Name LIKE '%"
+ suchWert
+ "%' AND MGMT.System.Name LIKE '%"
+ suchWert2
+ "%' AND MGMT.System.Version LIKE '%"
+ suchWert3
+ "%' AND MGMT.Testcases.Name LIKE '%"
+ suchWert4
+ "%' AND MGMT.Testcomponent.Name LIKE '%"
+ suchWert5
+ "%' AND MGMT.ExecutionController.Hostname LIKE '%"
+ suchWert6
+ "%' AND MGMT.ExecutionController.OS LIKE '%"
+ suchWert7 + "%'");
resultSet = selectKunden.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return resultSet;
}
}%>
<%
Kunde kunde = new Kunde();
ResultSet kunden = kunde.getKunden(
request.getParameter("TabellenFilter"),
request.getParameter("TabellenFilter2"),
request.getParameter("TabellenFilter3"),
request.getParameter("TabellenFilter4"),
request.getParameter("TabellenFilter5"),
request.getParameter("TabellenFilter6"),
request.getParameter("TabellenFilter7"));
ResultSetMetaData rsmd = null;
rsmd = kunden.getMetaData();
int numberOfColumns = 0;
numberOfColumns = rsmd.getColumnCount();
%>
<table border="1">
<tr>
<%
try {
for (int i = 1; i <= numberOfColumns; i++) {
%>
<th><%=rsmd.getColumnLabel(i)%></th>
<%
}
%>
</tr>
<%
while (kunden.next()) {
%>
<tr>
<%
for (int i = 1; i <= numberOfColumns; i++) {
if (i != numberOfColumns) {
%>
<td><%=kunden.getString(i)%></td>
<%
} else {
%>
<td><a href="XML.jsp?xml=<%=kunden.getString("l_ID")%>">D</a>
</td>
</tr>
<%
}
}
}
} catch (SQLException e) {
}
%>
</table>