test.jsp代码：
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*;" errorPage=""%>
<html>
<head><title>员工管理</title></head>
<%! Connection con; %>
<%! ResultSet rs;%>
<%! Statement sql;%>
<body>
<div align="center"><font color="#000000" size="5">员工管理</font></div>
<table width="75%" border="1" cellpadding="1" align="center">
<tr>
<td width=30% align=center>编号</td>
<td width=30% align=center>姓名</td>
<td width=20% align=center>年龄</td>
<td width=20% align=center>选择</td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:aa","","");
sql=con.createStatement();
rs=sql.executeQuery("select * from CS");
while(rs.next()){
%>
<tr>
<td width=30% align=center><%=rs.getString(1)%></td>
<td width=30% align=center><%=rs.getString(2)%></td>
<td width=20% align=center><%=rs.getInt(3)%></td>
<td width=20% align=center><a href="text.jsp">选择</td>
</tr>
<%
}
rs.close();
sql.close();
con.close();
}catch(SQLException e){
}
%>
</table>
</body>
</html>
text.jsp代码：
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*;" errorPage=""%>
<html>
<head><title>选择页面</title></head>
<%!
String bianhao;
%>
<body>
<%
bianhao=request.getParameter("bianhao");
%>
<div align="center"><font size=10 color=blue>选择的编号为：<%=bianhao%>
</div>
</body>
</html>
数据库建立：
create table CS(
bianhao char(10) primary key,
xingming char(10),
nianling int,
)
insert into CS values('001','万股',16)
insert into CS values('002','凤凰',56)
insert into CS values('003','腾飞',23)
要求：当点击test.jsp中的“选择”超链接时，将选择的“bianhao”（就是对应的编号）传到text.jsp页面显示。