Spring.xml

<util:properties id="db" location="classpath:jdbc.properties"/>

<context:component-scan base-package="com.xms" />

<mvc:annotation-driven />

<!-- 声明DataSource -->

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

<property name="driverClassName" value="#{db.driver}" />

<property name="url" value="#{db.url}" />

<property name="username" value="#{db.user}"/>

<property name="password" value="#{db.password}"/>

</bean>

<!-- 导入SpringJDBC -->

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">

<!-- 引入数据源 -->

<!--

<property name="dataSource" ref="dataSource"></property>

-->

<constructor-arg>

<ref bean="dataSource"/>

</constructor-arg>

</bean>

<!-- 实例化dao和service接口 -->

<bean id="loginDao" class="com.xms.dao.LoginDaoImpl">

<!-- 注入Spring的jdbcTemplate -->

<property name="jdbcTemplate" ref="jdbcTemplate"></property>

</bean>

<bean id="loginService" class="com.xms.service.loginServiceImpl">

<property name="loginDao" ref="loginDao"></property>

</bean>

<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<property name="prefix" value="/WEB-INF/jsp/" />

<property name="suffix" value=".jsp" />

</bean>

jdbc.properties

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://127.0.0.1:3306/xmscode?useUnicode=true&characterEncoding=utf8

user=root

password=1234

controller:

@Controller

@RequestMapping("login")

public class LoginController {

private LoginService loginService;

public LoginService getLoginService() {

return loginService;

}

public void setLoginService(LoginService loginService) {

this.loginService = loginService;

}

@RequestMapping("tologin")

public String toLogin(){

return "login";

}

@RequestMapping("login")

public String login(User user, HttpServletRequest request) throws Exception{

//该行报错 loginService为null

User u = loginService.checkInfo(user);

HttpSession session = request.getSession();

session.setAttribute("nickname", u.getNickname());

return "index";

}

}

dao接口：

public interface LoginDao {

//根据email查找User

public User findUserByEmail(User user) throws Exception;

}

daoImpl:

@Repository

public class LoginDaoImpl implements LoginDao {

private JdbcTemplate jdbcTemplate;

public JdbcTemplate getJdbcTemplate() {

return jdbcTemplate;

}

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {

this.jdbcTemplate = jdbcTemplate;

}

public User findUserByEmail(User user) throws Exception {

User u = null;

String sql = "select * from xc_user where email=?";

Object[] params = new Object[]{user.getEmail()};

u = jdbcTemplate.queryForObject(sql, (RowMapper<User>) new User(), params);

return u;

}

}

service接口：

@Service

public interface LoginService {

public User checkInfo(User user) throws Exception;

}

service实现类：

@Service

public class loginServiceImpl implements LoginService{

private LoginDao loginDao;

public LoginDao getLoginDao() {

return loginDao;

}

public void setLoginDao(LoginDao loginDao) {

this.loginDao = loginDao;

}

public User checkInfo(User user) throws Exception{

System.out.println("loginDao"+loginDao);

User u = null;

u = loginDao.findUserByEmail(user);

if(u==null){

//用户名错误

throw new EmailErrorException("用户名错误");

}else if(!u.getPassword().equals(user.getPassword())){

//密码错误

throw new PasswordErrorException("密码错误");

}else{

//用户名和密码正确

return u;

}

}

}