半个小时结贴

[xuefeifangpei]

一下代码实现本页面提交功能怎么查不出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>

[张海霖]

可以隐式的提交吧.

[喝酒吃肉]

在数据库中执行SQL语句能取出吗

[xuefeifangpei]

xxx=school.getString("SchoolID");
out.print(xxx);
}
school.close();
%>可以打印出xxx

[xuefeifangpei]

哪个把不用submit提交而是自动提交搞定高分给你

[newste]

String SchoolName=request.getParameter("SchoolName");
if (SchoolName==null)
SchoolName="%";

[mtou]

不提交就不能访问服务器端的数据库,除非修改成不用按钮提交,可以用事件,
当<input type="text" name="SchoolName" value="xx">
标签"schoolname"发生变化的时候,提交

[newste]

试试看这样可以不可以
<%@ 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); //取所有的学校结果集
int i=0;
while (school.next()){
xxx[i]=school.getString("SchoolID");

}
school.close();
%>

<%for(int j=0;j<xxx.length;j++){%>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">学校编号为:</div>
</td>
<td bgcolor="#33FFCC" width="79%"<%=xxx[j]%></td>
<%}%>

[xuefeifangpei]

如果用onchange事件的该怎么写代码啊mtou(逆风

[lenoli]

不submit时不行的

[mtou]

<SCRIPT language=JavaScript>
function onchange()
{
document.form1.submit();
}

</SCRIPT>
<input type="text" name="SchoolName" value="xx" onchange="javascritp:onchange()">

[mtou]

当这样做肯定会影响效率,最好不要用onchange事件,用onfocusout事件更好(失去角点事件)

[chancelin]

用iframe吧。