QuestionAsk Questions?
Lee Siew Ling
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>
View Answers
Related Pages:
