这是jsp里面的代码
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<%
Connection conn=null;
Statement stmt=null,stmttmp=null;
ResultSet rs=null,rstmp=null;
String SID=null;
String ID=null;
String xh=null;
String sql=null;
SID=request.getParameter("SID");
ID=request.getParameter("ID");
if(SID==null && ID==null)
out.println("请选择你要修改的学生学号");
else
{
if(SID!=null)
xh=SID;
if(ID!=null)
xh=ID;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e1){
out.println("加载数据库驱动程序出错:"+e1.getMessage());
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'register.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<center>
请添加以下信息:<br>
<hr>
<form action="modifyover.jsp" method="post">
<table border=0 width=30%>
<tr><td>学号:<%=xh %></td></tr>
<%
try{
conn=DriverManager.getConnection("jdbc:odbc:student");
stmt=conn.createStatement();
sql="select SN,SA,DN,s.SD from s,d where d.SD=s.SD and s.SID='"+xh+"'";
out.println(sql+"<br>");
rs=stmt.executeQuery(sql);
rs.next();
%>
<tr><td>姓名:<input type=text name=SN size=20 value="<%=rs.getString("SN") %>"></td></tr>
<tr><td>年龄:<input type=text name=SA size=4 value="<%=rs.getString("SA")%>"></td></tr>
<tr><td>院系:
<select name=SD>
<%
String rstDN=rstmp.getString("DN");
String rstSD=rstmp.getString("SD");
stmttmp=conn.createStatement();
sql="select * from d where DN!='"+rs.getString("DN")+"'";
rstmp=stmttmp.executeQuery(sql);
while(rstmp.next())
out.println("<option value=/""+rstSD+"/">"+rstDN+"</option>");
%>
<option value="<%=rstSD%>" selected><%=rstDN%></option>
</select></td></tr>
<tr><td><input type=submit name=ok value="修改 "> <input type=reset name=cancel value="重置"></td></tr>
</table>
<input type="hidden" name="xh" value="<%=xh %>">
</form>
</center>
</body>
</html>
<%
}
catch(Exception e2){
out.println("数据查询出错:"+e2.getMessage());
}
finally{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close();
}
}
%>
可是为什么实现完了就是这样的呢?
下面的两个按钮哪去了?
应该怎么改啊?