数据库更新问题_Java Web开发

数据库更新问题

请各位大哥帮帮忙吧，写了一段对数据库的更新代码，代码如下：
<%
String user=request.getParameter("username");
Class.forName(strDBDriver).newInstance();

conn=DriverManager.getConnection(strDBURL,strDBUser,"");

address=new String(address.getBytes("iso-8859-1"),"gb2312");

prepareStmt=conn.prepareStatement("update rights set password=?, email=?,address=? where username='"+user+"'");
String passwd=request.getParameter("password");
prepareStmt.setString(1,"%"+passwd+"%");
String email=request.getParameter("email");
prepareStmt.setString(2,"%"+email+"%");
String address=request.getParameter("address");
prepareStmt.setString(3,"%"+address+"%");
prepareStmt.executeUpdate();
为何老出现这些错误：
org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 9 in the jsp file: /modi.jsp
Generated servlet error:
PrepareStatement cannot be resolved to a type

An error occurred at line: 11 in the jsp file: /modi.jsp
Generated servlet error:
address cannot be resolved

An error occurred at line: 11 in the jsp file: /modi.jsp
Generated servlet error:
prepareStmt cannot be resolved

搜索更多相关主题的帖子: 数据库

----------------解决方案--------------------------------------------------------
你的百分号是干什么的.....

是通配符吗????
----------------解决方案--------------------------------------------------------
两个问题:
1.address没有定义
2. prepareStmt的包没有导入
----------------解决方案--------------------------------------------------------
楼主怎么没有回复到底是不是这样呢？
----------------解决方案--------------------------------------------------------