半个小时结贴

xuefeifangpei 2004-09-09 11:10:13

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

...全文

83 点赞收藏 12

写回复

12 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

chancelin 2004-09-09

用iframe吧。

回复赞

mtou 2004-09-09

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

回复赞

mtou 2004-09-09

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

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

回复赞

lenoli 2004-09-09

不submit时不行的

回复赞

xuefeifangpei 2004-09-09

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

回复赞

newste 2004-09-09

试试看这样可以不可以
<%@ 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>
<%}%>

回复赞

mtou 2004-09-09

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

回复赞

newste 2004-09-09

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

回复赞

xuefeifangpei 2004-09-09

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

回复赞

xuefeifangpei 2004-09-09

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