错误:Incorrect integer value: 'dfyk' for column 'subjectNo' at row 1
错误代码:String sql ="insert into subject1 values(?,?,0)";
原因:(?,?,0) 如果第一个值为自增 占位符应该从第二个开始
正确:String sql ="insert into subject1 values(0,?,?)";
错误:java.sql.SQLException: Wrong number of parameters: expected 2, was given 1 Query:
SELECT * from employee,depart where employee.dep_id = depart.dep_id and depart.dep_id=? limit ?,3
Parameters: [0]
错误代码: sql+=" limit ?,3";
原因:没有追加currentPage
正确: sql+=" limit ?,3";
list.add(currentPage);
错误:javax.servlet.ServletException: java.lang.NoClassDefFoundError: javax/servlet/jsp/jstl/core/LoopTag
原因:缺少jar包
正确:
<dependency>
<groupId>javax.servlet.jsp.jstl</groupId>
<artifactId>jstl-api</artifactId>
<version>1.2</version>
</dependency>
错误:org.apache.ibatis.binding.BindingException: Type interface com.wanshi.mapper.UsersMapper is not known to the MapperRegistry.
原因:没有映射的xml
<mappers>
<mapper resource="mapper/UserinfoMapper.xml"/ <mapper resource="mapper/UsersMapper.xml"/>
</mappers>
错误:Users{userId=null, userName='null', sex='女', password='111'}
Users{userId=null, userName='null', sex='男', password='123'}
Users{userId=null, userName='null', sex='女', password='321'}
原因:数据库名字跟实体类名字不一致
正确:
方法1:直接改名字
方法2:起个别名
select user_id userId ,user_name userName,sex,password from users
起别名 前面的名字跟数据库保持一致,后面的跟实体类保持一致
方法3:
<resultMap id="users" type="com.wanshi.pojo.Users">
<!-- column:列名-来自于查询的虚拟结果集-->
<!-- property:成员变量名-来自于实体类的成员变量
变量名一致的不用写
-->
<id property="userId" column="user_id"></id>
<result
property="userName"column="user_name">
</result>
</resultMap>
<select id="getusersList" resultMap="users">
select * from users;
</select>
错误:
java.lang.NoSuchMethodException:servlet.EmpServlet.bootstrap.min.css(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
原因:
解析不了el表达式
解决方法:更改web.xml文件中的内容
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
</web-app>