You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
注释掉preparedStatement.setString(2, user.getUsername());,
当dao层的sql语句出错时,只会在后台报错,
例如,注册时只检测用户名以及邮箱是否已存在,
但是如果这两项没有问题,而是插入的sql语句有问题,没有成功注册,系统不会对用户提示注册失败,会直接跳转到登录界面:
java.sql.SQLException: No value specified for parameter 2
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:418)
at com.zhonghuasheng.musicstore.dao.impl.UserDAOImpl.create(UserDAOImpl.java:41)
at com.zhonghuasheng.musicstore.dao.impl.UserDAOImpl.create(UserDAOImpl.java:15)
at com.zhonghuasheng.musicstore.service.impl.UserServiceImpl.signUp(UserServiceImpl.java:49)
at com.zhonghuasheng.musicstore.action.user.RegisterAction.doPost(RegisterAction.java:50)
The text was updated successfully, but these errors were encountered:
注释掉preparedStatement.setString(2, user.getUsername());,
当dao层的sql语句出错时,只会在后台报错,
例如,注册时只检测用户名以及邮箱是否已存在,
但是如果这两项没有问题,而是插入的sql语句有问题,没有成功注册,系统不会对用户提示注册失败,会直接跳转到登录界面:
java.sql.SQLException: No value specified for parameter 2
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:418)
at com.zhonghuasheng.musicstore.dao.impl.UserDAOImpl.create(UserDAOImpl.java:41)
at com.zhonghuasheng.musicstore.dao.impl.UserDAOImpl.create(UserDAOImpl.java:15)
at com.zhonghuasheng.musicstore.service.impl.UserServiceImpl.signUp(UserServiceImpl.java:49)
at com.zhonghuasheng.musicstore.action.user.RegisterAction.doPost(RegisterAction.java:50)
The text was updated successfully, but these errors were encountered: