使用Spring框架实现简单的用户管理系统讲解.docx

实验5 Spring与数据库一、实验目的1. 掌握在Spring中配置数据源的方法1. 掌握JdbcTemplate的使用方法二、实验器材1. 计算机三、实验内容使用Spring JdbcTemplate实现登录功能。具体要求如下：根据账号和密码进行登录操作，登录结果分为三种情况：1. 账号不存在2. 账号存在，但密码错误3. 账号密码都正确根据不同的登录结果，给出相应的提示信息。四、实验步骤编写User类package org.hrbust.experiment.entity;public class User {int ID;String userName;String password;public int getID() {return ID;}public void setID(int iD) {ID = iD;}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName = userName;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}}编写UserRowMapperpackage org.hrbust.experiment.service;import java.sql.ResultSet;import java.sql.SQLException;import org.hrbust.experiment.entity.User;import org.springframework.dao.DataAccessException;import org.springframework.jdbc.core.ResultSetExtractor;import org.springframework.jdbc.core.RowMapper;public class UserRowMapper implements RowMapper {public Object mapRow(ResultSet rs, int idx) throws SQLException {// TODO Auto-generated method stubUser u = new User();u.setID(rs.getInt(ID));u.setUserName(rs.getString(user_name));u.setPassword(rs.getString(password));return u;}}编写UserServicepackage org.hrbust.experiment.service;import java.util.ArrayList;import java.util.List;import org.hrbust.experiment.entity.User;import org.springframework.jdbc.core.JdbcTemplate;public class UserService {JdbcTemplate jdbcTemplate;public JdbcTemplate getJdbcTemplate() {return jdbcTemplate;}public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {this.jdbcTemplate = jdbcTemplate;}public int login(User user){if(this.getUserByName(user.getUserName()) != null){if(this.getUser(user.getUserName(), user.getPassword()) != null){return 0;}else{return 2;}}else{return 1;}}@SuppressWarnings(unchecked)public User getUserByName(String userName){String sql = select * from `User` where user_name=?;ListUser list = new ArrayListUser();list = (ListUser) this.jdbcTemplate.query(sql, new Object[]{userName}, new UserRowM