这个程序本应该出现输入界面,但登陆页面后 ,而是提示下载一个文件,这个到底是为什么,大家帮忙找找,谢谢了
<%@page language="java" contenttype="text/html ;charset=gb2312" import="java.sql.*"%><html>
<body>
<table border=2>
<form action="e231.jsp" method="post">
<tr>
<td colspan=3>请输入学生的姓名:</td>
<td><input type=text name="stuname" value="" /></td>
</tr>
<tr>
<td colspan=4><input type="submit" /></td>
</tr>
</form>
</table>
<%
String name1=request.getParameter("stuname");
if(name1==null)
return;
out.print(name1);
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try{
//1。装入JDBC驱动器
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//2。建立与数据库的连接
con = DriverManager.getConnection("jdbc:odbc:Student", "sa", "sa");
//3。查询数据库
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM 学籍 where 姓名 like '%"+name1+"%'");
//4。处理结果集
%>
<table>
<tr>
<td>学号</td><td>姓名</td><td>性别</td><td>班级</td>
</tr>
<%
while(rs.next()){
String id=rs.getString(1) ;
String name=rs.getString(2);
String sex=rs.getString(3);
String aclass=rs.getString(4);
%>
<tr>
<td><%=id%></td>
<td><%=name%></td>
<td><%=sex%></td>
<td><%=aclass%></td>
</tr>
<%
}
}
catch(ClassNotFoundException e){
System.out.println("驱动器无法找到!"+ e.getMessage());
}
catch(SQLException e){
System.out.println("访问数据库出错!" + e.getMessage());
}
finally{
//关闭与数据库的连接,注意:顺序不可改变
try{
rs.close();
}
catch(Exception e){}
try{
stmt.close();
}
catch(Exception e){}
try{
con.close();
}
catch(Exception e){}
} %>
</table>
</body>
</html>
<%@page language="java" contenttype="text/html ;charset=gb2312" import="java.sql.*"%><html>
<body>
<table border=2>
<form action="e231.jsp" method="post">
<tr>
<td colspan=3>请输入学生的姓名:</td>
<td><input type=text name="stuname" value="" /></td>
</tr>
<tr>
<td colspan=4><input type="submit" /></td>
</tr>
</form>
</table>
<%
String name1=request.getParameter("stuname");
if(name1==null)
return;
out.print(name1);
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try{
//1。装入JDBC驱动器
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//2。建立与数据库的连接
con = DriverManager.getConnection("jdbc:odbc:Student", "sa", "sa");
//3。查询数据库
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM 学籍 where 姓名 like '%"+name1+"%'");
//4。处理结果集
%>
<table>
<tr>
<td>学号</td><td>姓名</td><td>性别</td><td>班级</td>
</tr>
<%
while(rs.next()){
String id=rs.getString(1) ;
String name=rs.getString(2);
String sex=rs.getString(3);
String aclass=rs.getString(4);
%>
<tr>
<td><%=id%></td>
<td><%=name%></td>
<td><%=sex%></td>
<td><%=aclass%></td>
</tr>
<%
}
}
catch(ClassNotFoundException e){
System.out.println("驱动器无法找到!"+ e.getMessage());
}
catch(SQLException e){
System.out.println("访问数据库出错!" + e.getMessage());
}
finally{
//关闭与数据库的连接,注意:顺序不可改变
try{
rs.close();
}
catch(Exception e){}
try{
stmt.close();
}
catch(Exception e){}
try{
con.close();
}
catch(Exception e){}
} %>
</table>
</body>
</html>
return;
请问下你这里return之后,后面代码都不执行乐吗
<%@page language="java" contenttype="text/html ;charset=gb2312" import="java.sql.*"%><html>
<body>
<table border=2>
<form action="e231.jsp" method="post">
<tr>
<td colspan=3>请输入学生的姓名:</td>
<td><input type=text name="stuname" value="" /></td>
</tr>
<tr>
<td colspan=4><input type="submit" /></td>
</tr>
</form>
</table>
<%
String name1=request.getParameter("stuname");
if(name1!=null)
{
out.print(name1);
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try{
//1。装入JDBC驱动器
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//2。建立与数据库的连接
con = DriverManager.getConnection("jdbc:odbc:Student", "sa", "sa");
//3。查询数据库
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM 学籍 where 姓名 like '%"+name1+"%'");
//4。处理结果集
%>
<table>
<tr>
<td>学号</td><td>姓名</td><td>性别</td><td>班级</td>
</tr>
<%
while(rs.next()){
String id=rs.getString(1) ;
String name=rs.getString(2);
String sex=rs.getString(3);
String aclass=rs.getString(4);
%>
<tr>
<td><%=id%></td>
<td><%=name%></td>
<td><%=sex%></td>
<td><%=aclass%></td>
</tr>
<%
}
}
catch(ClassNotFoundException e){
System.out.println("驱动器无法找到!"+ e.getMessage());
}
catch(SQLException e){
System.out.println("访问数据库出错!" + e.getMessage());
}
finally{
//关闭与数据库的连接,注意:顺序不可改变
try{
rs.close();
}
catch(Exception e){}
try{
stmt.close();
}
catch(Exception e){}
try{
con.close();
}
catch(Exception e){}
}
%>
</table>
<%
}
%>
</body>
</html>