67,513
社区成员
发帖
与我相关
我的任务
分享
package com.bbs.dao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import com.bbs.domain.LoginLog;
import com.bbs.domain.User;
import sun.print.resources.serviceui;
@Repository
public class LoginLogDAOImpl implements LoginLogDAO {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public void insertLoginLog(LoginLog loginLog){
String sql = "insert into t_login_log values(?,null)";
jdbcTemplate.update(sql,loginLog.getUser_id());
}
}
public User findUserByName(String account,String password) {
String sql = "SELECT * FROM t_user WHERE account = ? AND password = ?";
final User user = new User();
jdbcTemplate.query( sql, new Object[] {account,password}, new RowCallbackHandler() {
@Override
public void processRow(ResultSet rs) throws SQLException {
user.setId(rs.getInt("id"));
user.setAccount(rs.getString("account"));
user.setPassword(rs.getString("password"));
user.setCredits(rs.getInt("credits")+100);
}
});
return user;
}
package com.bbs.service;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDAO userDAO;
private LoginLogDAO loginLogDAO;
@Override
public boolean userRegist(User user) {
boolean flag = false;
if(user.getAccount().equals("")==false&&user.getPassword().equals("")==false){
int n = userDAO.insertUser(user);
if (n == 1) {
flag = true;
}
return flag;
} return flag;
}
@Override
public boolean userLogin(String account,String password){
boolean flag = false;
User user = userDAO.findUserByName(account,password);
LoginLog loginLog = new LoginLog(user.getId());
if(user.getId()!=null){
userDAO.updateUser(user);
loginLogDAO.insertLoginLog(loginLog);//就是这句加上会出错
flag = true;
}
return flag;
}
HTTP Status 500 - Request processing failed; nested exception is java.lang.NullPointerException
type Exception report
message Request processing failed; nested exception is java.lang.NullPointerException
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:981)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871)
javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause
java.lang.NullPointerException
com.bbs.service.UserServiceImpl.userLogin(UserServiceImpl.java:36)
com.bbs.web.UserController.logCheck(UserController.java:40)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871)
javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
note The full stack trace of the root cause is available in the Apache Tomcat/8.0.32 logs.