Can anyone please help to solve my problem below. My webpage has problem in displaying result position. The result should be display below my title. How do i solve it? Thank you so much!
<html>
<head>
<link rel="StyleSheet" type="text/css" href="${pageContext.request.contextPath}/myStyle.css">
<title>IPTV Profile Scan</title>
</head>
<body>
<form method="post">
<table border="1" width="100%" cellspacing="0" cellpadding="3" bgcolor="#6495ED" borderColorLight="#FFFFFF">
<tr>
<td width="15%"><b>
<font color="#FFFFFF" size="4">ADSL Number
<input name="ADSLNO" type="text" />
<input name="Submit" type="submit" value="Confirm" />
</font></b></td>
</tr>
</table>
</form>
<%
String ADSL = request.getParameter("ADSLNO");
if(ADSL!= null)
{
String connectionURL = "jdbc:mysql://10.152.31.82/poller";
Connection connection = null;
String buffer = "<div class='divTable'>";
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "dipadm", "dipadm123");
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("select DT, PROFILE, DS_BW, SNR_DW, AT_DW, UCE, MODEL, CRC, RETRAIN from scanProfileData where ADSLNO='" + ADSL + "' order by DT DESC;");
if (rs != null) {
buffer="<div class='divRowh'><div class='divCellDT'>DATE/TIME</div>" ;
buffer=buffer+"<div class='divCellPROFILE'>PROFILE</div>";
buffer=buffer+"<div class='divCellBANDWIDTH'>BANDWIDTH</div>";
buffer=buffer+"<div class='divCellSNR'>SNR</div>";
buffer=buffer+"<div class='divCellATTENUATION'>ATTENUATION</div>";
buffer=buffer+"<div class='divCellCRC'>CRC</div>";
buffer=buffer+"<div class='divCellUCE'>UCE</div>";
buffer=buffer+"<div class='divCellMODEL'>MODEL</div>";
buffer=buffer+"<div class='divCellRETRAIN'>RETRAIN</div></div>";
while(rs.next()){
buffer =buffer+"<div class='divRow'>"
+"<div class='divCellDTr'>"+rs.getString("DT")+"</div>"
+"<div class='divCellPROFILEr'>"+rs.getString("PROFILE")+"</div>"
+"<div class='divCellBANDWIDTHr'>"+rs.getString("DS_BW")+"</div>"
+"<div class='divCellSNRr'>"+rs.getString("SNR_DW")+"</div>"
+"<div class='divCellATTENUATIONr'>"+rs.getString("AT_DW")+"</div>"
+"<div class='divCellCRCr'>"+rs.getString("CRC")+"</div>"
+"<div class='divCellUCEr'>"+rs.getString("UCE")+"</div>"
+"<div class='divCellMODELr'>"+rs.getString("MODEL")+"</div>"
+"<div class='divCellRETRAINr'>"+rs.getString("RETRAIN")+"</div></div>";
}
}
buffer=buffer+"</div>";
response.getWriter().println(buffer);
}
%>
</body>
</html>
Ads
