半个小时结贴
一下代码实现本页面提交功能怎么查不出xxx的值?
如果不用submit按钮让输入学校名称后自动显示出学校编号该怎么写?
xixi.jsp
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="Show.DBconn" />
<%!
public String getStr1(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("gb2312");
String temp=new String(temp_t,"ISO8859-1");
return temp;
}
catch(Exception e)
{
e.printStackTrace();
return "无";
}
}
%>
<form name="form1" method="post" action="xixi.jsp">
<td>
请输入学校名称:
</td>
<input type="text" name="SchoolName" value="xx">
<input type="submit" value="submit">
</form>
<%!
String xxx;
%>
<%
String SchoolName=request.getParameter("SchoolName");
if (SchoolName==null)
SchoolName="";
//out.print(SchoolName);
String sql2;
sql2="select * from School where SchoolName='"+SchoolName+"' ";
//out.print(sql2);
ResultSet school=workM.executeQuery(sql2); //取所有的学校结果集
while (school.next()){
xxx=school.getString("SchoolID");
}
school.close();
%>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">学校编号为:</div>
</td>
<td bgcolor="#33FFCC" width="79%"<%=xxx%></td>