1》驗(yàn)證碼：產(chǎn)生的隨機(jī)數(shù)要放到session里
2》用select top5 * from art 出錯(cuò) 游標(biāo)狀態(tài)無(wú)效：去除括號(hào)里的
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
3》數(shù)據(jù)庫(kù)連接池：雖然包含了<%@include file="conn.jsp"%>但還是要在文件里聲明
<%! ResultSet rs=null;%>
<%! Statement stmt=null;%>
否則會(huì)出現(xiàn) rs/stmt cannot be resolved
4》中文寫(xiě)入ACCESS數(shù)據(jù)庫(kù)為什么是 ？？： 只要加
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》出現(xiàn)錯(cuò)誤
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 能讓記錄集能夠前后移動(dòng)
6》錯(cuò)誤為：
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)
解決方法：
一行代碼可以換行寫(xiě)，一個(gè)String的內(nèi)容是不能換幾行寫(xiě)的，寫(xiě)成
String sql="insert into pageinfo(num,typeid,seno,eno,wdate,ano)" +
"values('"+num+"','"+typeid+"','"+seno+"','"+eno+"','"+wdate+"','"+ano+"') ";