使用Spring框架实现简单的用户管理系统

《使用Spring框架实现简单的用户管理系统》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、实验5Spring与数据库一、实验目的1.掌握在Spring中配置数据源的方法1.掌握JdbcTemplate的使用方法二、实验器材1.计算机三、实验内容使用SpringJdbcTemplate实现登录功能。具体要求如下：根据账号和密码进行登录操作，登录结果分为三种情况：1.账号不存在2.账号存在，但密码错误3.账号密码都正确根据不同的登录结果，给出相应的提示信息。四、实验步骤编写Use「类packageorg.hrbust.experiment.entity;publicclassUser{intID;Stringuse

2、rName;Stringpassword;returnID;}publicvoidsetlD(intiD){ID=iD;}publicStringgetUserName(){returnuserName;}publicvoidsetUserName(StringuserName){this.userName=userName;}publicStringgetPassword(){returnpassword;}publicvoidsetPassword(Stringpassword){this.password=passw

3、ord;}}编写UserRowMapperpackageorg.hrbust.experiment.service;importjava.sql.ResultSet;importjava.sql.SQLException;importorg.hrbust.experiment.entity.User;importorg.springframework.dao.DataAccessException;importorg.springframework.jdbc.core.ResultSetExtractor;importor

4、g.springframework.jdbc.core.RowMapper;publicclassUserRowMapperimplementsRowMapper{publicObjectmapRow(ResultSetrs,intidx)throwsSQLException{//TODOAuto-generatedmethodstubUseru=newUser();u.setlD(rs.getlnt(nID"));u.setUserName(rs.getString(Huser_name"));u.setPassword

5、(rs.getString(”password”))；returnu;}}编写UserServicepackageorg.hrbust.experiment.service;importjava.util.ArrayList;importjava.util.List;importorg.hrbust.experiment.entity.User;importorg.springframework.jdbc.core.JdbcTemplate;publicclassUserService{JdbcTemplatejdbcTe

6、mplate;returnjdbcTemplate;}publicvoidsetJdbcTemplate(JdbcTemplatejdbcTemplate){this.jdbcTemplate=jdbcTemplate;}publicintlogin(Useruser){if(this.getUserByName(user.getUserName())!=null){if(this.getUser(user.getUserName(),user.getPassword())!=null){return0;}else{ret

7、urn2;}}else{return1;}}@SuppressWarnings(nunchecked11)Stringsql="select*from'User'whereuser_name二？”;Listlist=newArrayList();list=(List)this.jdbcTemplate.query(sql,newObject[]{userName},newUserRowMapper());if(list.isEmpty()){returnnull;}else{return

8、list.get(O);}}@SuppressWarnings(”unchecked”)publicUsergetUser(StringuserName,Stringpwd){Stringsql="select*from'User'whereuser_name二？and'password'=?u;Lis