jsp跳转有，单位编号默认为0哪里错误

Question

问题遇到的现象和发生背景

问题相关代码，请勿粘贴截图

```java
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>

<title>Insert title here</title>

修改一条教师信息

<% String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String dbURL="jdbc:sqlserver://LAPTOP-PCRUUGIM:1433;DatabaseName=study2"; String userName="sa"; String userPwd="123456"; try{ Class.forName(driverName); }catch(Exception e){ e.printStackTrace(); out.println("加载驱动失败!
");} String teid=request.getParameter("teid"); String id=request.getParameter("id"); try{ Connection dbConn=DriverManager.getConnection(dbURL,"sa","123456"); Statement statement = dbConn.createStatement(); ResultSet rs=statement.executeQuery("select * from teacher where teid='"+teid+"'"); while(rs.next()){ %>

教师号:<input value="<%=teid%" type="text" name="Teid" />>

姓 名:<input value="<%=rs.getString(2)" type="text" name="Tename" />>

性 别: >男 >女

学 位:<input value="<%=rs.getString(4)" type="text" name="Tedegree" />>

职 称:<input value="<%=rs.getString(5)" type="text" name="Tejob" />>

年 龄:<input value="<%=rs.getString(6)%" type="text" name="Teage" />>

单位编号: <%Connection conn = DriverManager.getConnection(dbURL,"sa","123456"); Statement state = conn.createStatement(); ResultSet rse = state.executeQuery("select * from study2.dbo.unit"); while (rse.next()) { %>> <%=rse.getString(1)%>(<%=rse.getString(2)%>) <%} }; }catch(Exception e){e.printStackTrace(); out.print("SQL Server连接失败! ");}%>

<input value="修改" type="submit" />

```java

运行结果及报错内容

我的解答思路和尝试过的方法

我想要达到的结果

单位编号跳转时，单位编号不变

Answer 1

用缓存