错误:
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLDataException: Cannot determine value type from string 'id'
### The error may exist in mybatis/user.xml
### The error may involve user.getUserById-Inline
### The error occurred while setting parameters
### SQL: SELECT 'id', 'username', 'birthday', 'sex', 'address' FROM user WHERE id=?
### Cause: java.sql.SQLDataException: Cannot determine value type from string 'id'
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111)
错误原因:查询不当
<select id="getUserById" parameterType="int" resultType="com.mybatis.pojo.User">
SELECT 'id',
'username',
'birthday',
'sex',
'address'
FROM user WHERE id=#{id1}
</select>
应改为:
<select id="getUserById" parameterType="int" resultType="com.mybatis.pojo.User">
SELECT * FROM user WHERE id=#{id1}
</select>