Jsp页面在提交后回显内容不完全??
使用Tomcat
我有个Jsp页面在提交后数据库操作很慢 并且在回显给客户端时内容不完全
这是什么原因 希望有高手指导下 急需解决 马上就得交毕业设计了
该页面的一段代码:
<%
//-------------------------名词解释
System.out.println("名词解释");
String sqlno1="select * from tbkcconfig where kcid=" + kcid + " and category=1 and paperno=" + paperno;
ResultSet rsno1 = conn.executeUpdatableQuery(sqlno1);
rsno1.next();
int datano = rsno1.getInt("datano");
int datavalue = rsno1.getInt("datavalue");
rsno1.close();
if (datano != 0) {
String sqlmc="SELECT top " + datano + " tbtk.tmid, tbtk.title,tbtk.category, tbkc.kcid, tbkc.kcm, tbtk.chapter,tbtk.level,photo FROM tbkc, userdata , tbtk WHERE username='" + username + "' and userdata.tmid=tbtk.tmid and tbtk.kcid=tbkc.kcid and tbkc.kcid=" + kcid + " and ( tbtk.kao=1 or tbtk.kao=2 ) and category=1 and userdata.paperno=" + paperno + " order by tbtk.tmid";
ResultSet rsmc = conn.executeQuery(sqlmc);
if (rsmc.next()) {
%><table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" height="64">
<tr class="trh">
<td width="32" align="center" bgcolor="#799AE1" height="22">
<font color="#FFFFFF"><b>序号</b></font></td>
<td align="center" bgcolor="#799AE1" width="604" height="22">
<p align="center"><font color="#FFFFFF"><b>名词解释<span lang="en-us">(</span>共<%= datano %>题<span lang="en-us">,<%= datano*datavalue %></span>分<span lang="en-us">)</span></b></font></td>
</tr>
<%
int imc=1;
for(int mcno = 1; mcno <= datano; mcno++)
{
int rsmc_tmid = rsmc.getInt("tmid");
String textmc1 = "textmc" + rsmc_tmid;
if (request.getMethod().equals("POST"))
{
String sqlmc2="SELECT * FROM userdata where username='" + username + "' and tmid=" + rsmc_tmid + "and paperno=" + paperno;
ResultSet rsmc2 = conn.executeUpdatableQuery(sqlmc2);
rsmc2.next();
String textmc2= GetRequest(textmc1, request);
System.out.println("保存名词解释 答案:" + textmc2.trim());
rsmc2.updateString("uans", textmc2.trim());
rsmc2.updateRow();
rsmc2.close();
}
String sqlmc3="SELECT * FROM userdata where username='" + username + "' and tmid=" + rsmc_tmid + "and paperno=" + paperno;
ResultSet rsmc3 = conn.executeQuery(sqlmc3);
rsmc3.next();
String rsmc3_uans = rsmc3.getString("uans");
if(rsmc3_uans == null) rsmc3_uans = "";
%>
<tr class="trh1">
<td align="center" height="1" width="32"><%=imc%></td>
<td align="left" width="604" height="1"> <%=rsmc.getString("title")%>——(难度:<%
int level = rsmc.getInt("level");
if (level ==1 ) {
out.write( "容易");
}
if ( level ==2) {
out.write( "中等");
}
if ( level ==3) {
out.write( "较难");
}
if ( level ==4 ) {
out.write( "最难");
}
%>) <br><%
String photo = rsmc.getString("photo");
if (photo != null && !photo.equals("")) {
%> <center><br>
<img border="0" src="examimage/<%= photo %>">
</center>
<% }%><br>答:
<input type="text" name="<%=textmc1%>" size="80" value="<%=rsmc3_uans%>" onblur="this.className='inputnormalleft'" onfocus="this.className='inputedit';this.select()" class="inputnormalleft"><br> <br> </td>
</tr>
<%
System.out.println("名词解释 rsmc.next() " + imc);
rsmc3.close();
if (!rsmc.next()) break;
imc=imc+1;
}
rsmc.close();
%>
<tr>
<td align="center" bgcolor="#FFFFFF" height="21" width="640" colspan="2" bordercolor="#FFFFFF">
<span lang="en-us">
</span>
<input class="s02" type="submit" value="保存名词解释" name="B1" >
</td>
</tr>
</table> <br>
<% }%>
<% }%>
确定里面的for循环是执行了的 但是for循环之间的html内容却在循环几次后没再发给客户端了
望高手看看是代码问题 还是Tomcat配置哪有问题