1》驗證碼：產生的隨機數要放到session里
2》用select top5 * from art 出錯 游標狀態無效：去除括號里的
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
3》數據庫連接池：雖然包含了<%@include file="conn.jsp"%>但還是要在文件里聲明
<%! ResultSet rs=null;%>
<%! Statement stmt=null;%>
否則會出現 rs/stmt cannot be resolved
4》中文寫入ACCESS數據庫為什么是 ？？： 只要加
String title=request.getParameter("title");
title=new String(title.getBytes("ISO-8859-1"));
String neirong=request.getParameter("neirong");
neirong=new String(neirong.getBytes("ISO-8859-1"));
就OK了
5》出現錯誤
rs.last() An exception occurred processing JSP page
: stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE 能讓記錄集能夠前后移動
6》錯誤為：
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 16 in the jsp file: /biyesheji/nixie/addx.jsp
String literal is not properly closed by a double-quote
13: String eno=request.getParameter("eno");
14: String wdate=request.getParameter("wdate");
15: String ano=request.getParameter("ano");
16: String sql="insert into pageinfo(num,typeid,seno,eno,wdate,ano)
17: values('"+num+"','"+typeid+"','"+seno+"','"+eno+"','"+wdate+"','"+ano+"') ";
18: addx.executeUpdate(sql);
19: try{ sqlBean db =new sqlBean();
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:299)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
解決方法：
一行代碼可以換行寫，一個String的內容是不能換幾行寫的，寫成
String sql="insert into pageinfo(num,typeid,seno,eno,wdate,ano)" +
"values('"+num+"','"+typeid+"','"+seno+"','"+eno+"','"+wdate+"','"+ano+"') ";