下拉列表中的值是从数据库中得到的，怎样实现取到下拉列表的值并查询数据库
sql语句：String sql="select * from xiaofei where regname like '%"+userid+"%' and xfdate=从下拉列表中取得的值";
select的语句：
<form name="form" method="post">
<div align="center">
<table width="959" height="524" border="0">
<tr>
<td height="37" colspan="6" align="right"><div align="center">请选择
</div>
<label>
<div align="center">
<select name="aaa" id="aaa" onChange="disSel();">
<%
request.setCharacterEncoding("gb2312");
String strError = null;
String userid=(String)session.getAttribute("user");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select distinct xfdate from xiaofei where regname like '%"+userid+"%' order by xfdate
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
请问大哥们这个sql 语句应该用Java里的那个数据库操作方法？ ......
我写了个jsp页面，然后改动了一下，改动的内容就是在jsp页面的js函数里加了个alert()语句，但是我访问这个页面时，死活都是原来页面的内容，我加了很多alert函数还是没改动前的页面内容；tomcat重启了，也重新部署这 ......
