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:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
