日记2014.6.23

  1.

2014-6-23 21:45:54 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException: Unable to compile class for JSP: 


An error occurred at line: 67 in the jsp file: /showuser.jsp
Duplicate local variable db
64: <hr>
65: <center> <h2 >我的资料</h2><hr>
66: <%
67: DB db=new DB();
68: if(session.getAttribute("username")!=null)
69: {

70: if(session.getAttribute("msg")!=null)

解决方法：删除67: DB db=new DB();

2.

select * from user where username='z'
2014-6-23 22:01:06 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet RegServlet threw exception
java.sql.SQLException: Column count doesn't match value count at row 1

这句话的意思是你所存储的数据与数据库表的字段类型定义不相匹配.
看看你的字段类型是否正确, 是否越界, 有无把一种类型的数据存储到另一种数据类型中.