jsp连接数据库的问题，谁来帮帮我啊····

来源：互联网发布：centos 部署java web 编辑：程序博客网时间：2024/05/16 05:23

这是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">

</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();
}
}
%>

可是为什么实现完了就是这样的呢？

下面的两个按钮哪去了？

应该怎么改啊？