springMvc-spring+jdbc实例.docx

SpringMVC + Spring + SpringJDBC整合您的评价:还行收藏该经验 SpringMVC +Spring+ SpringJDBC整合实例。文件结构：3S3（3Spring3.x）的整合大致如下：1）web.xml的配置： index.jsp org.springframework.web.util.IntrospectorCleanupListener spring org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:*applicationContext.xml 1 spring *.do setcharacter org.springframework.web.filter.CharacterEncodingFilter encoding utf-8 setcharacter /* 2）applicationContext.xml的配置：$jdbc.driverClassName$jdbc.url$jdbc.username$jdbc.password5301060506030truefalse3）perties的配置: jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql:/localhost:3306/test2jdbc.username=rootjdbc.password=1234564)perties的配置: log4j.rootLogger=DEBUG,A1# u8f93u51fau5230u63a7u5236u53f0 log4j.appender.A1=org.apache.log4j.ConsoleAppender log4j.appender.A1.layout=org.apache.log4j.PatternLayout log4j.appender.A1.layout.ConversionPattern=%dyyyy-MM-dd HH:mm:ss u65E5u5FD7u4FE1u606F %m%n5)User.javapackage com.model;import java.io.Serializable;SuppressWarnings(serial)public class User implements Serializable private int id;private String userName;private String password;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;public int getId() return id;public void setId(int id) this.id = id;6)UserController.java package com.controller;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.servlet.ModelAndView;import com.model.User;import com.service.UserService;Controllerpublic class UserComtroller Autowiredprivate UserService userService;RequestMapping(/user/loginView)public String loginView()return login;RequestMapping(/user/registerView)public String registerView()return register;RequestMapping(/user/login)public ModelAndView login(User user)ModelAndView mav = new ModelAndView();User u = userService.loginCheck(user);if(null=u)mav.setViewName(login);mav.addObject(errorMsg,用户名或密码有误！);return mav;elsemav.setViewName(success);mav.addObject(user, u);return mav;RequestMapping(/user/register)public ModelAndView register(User user)ModelAndView mav = new ModelAndView();if(userService.register(user)mav.setViewName(register_succ);return mav;elsemav.setViewName(register);mav.addObject(errorMsg,用户名已被占用，请更换！);return mav;7)UserService Interface package com.service;import com.model.User;public interface UserService public boolean register(User user);public User loginCheck(User user);8)UserServiceImp.java package com.service.implement;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.dao.UserDao;import com.model.User;import com.service.UserService;Servicepublic class UserServiceImpl implements UserService Autowiredprivate UserDao userDao;Overridepublic User loginCheck(User user) User u = userDao.findUserByUserName(user.getUserName();System.out.println(id=+u.getId()+, userName=+u.getUserName()+, password=+u.getPassword();if(user.getPassword().equals(u.getPassword()return u;elsereturn null;Overridepublic boolean register(User user) User u = userDao.findUserByUserName(user.getUserName();if(u.getId()=0)userDao.register(user);return true;elseSystem.out.println(id=+u.getId()+, userName=+u.getUserName()+, password=+u.getPassword();return false;9)UserDao Interface package com.dao;import com.model.User;public interface UserDao public void register(User user);public User findUserByUserName(final String userName);10)UserDaoImpl.java package com.dao.implement;import java.sql.ResultSet;import java.sql.SQLException;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowCallbackHandler;import org.springframework.stereotype.Repository;import com.dao.UserDao;import com.model.User;Repositorypublic class UserDaoImpl implements UserDao Autowiredprivate JdbcTemplate jdbcTemplate;Overridepublic void register(User user) String sqlStr = insert into user(uname,pwd) values(?,?);Object params = new Objectuser.getUserName(),user.getPassword();jdbcTemplate.update(sqlStr, params);Overridepublic User findUserByUserName(String userName) String sqlStr = select id,uname,pwd from user where uname=?;final User user = new User();jdbcTemplate.query(sqlStr, new ObjectuserName, new RowCallbackHandler() Overridepublic void processRow(ResultSet rs) throws SQLException user.setId(rs.getInt(id);user.setUserName(rs.getString(uname);user.setPassword(rs.getString(pwd););return user;11）单元测试：test/com.service.implement -UserServiceImplTest.javapackage com.service.implement;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import com.model.User;import com.service.UserService;RunWith(SpringJUnit4ClassRunner.class)ContextConfiguration(locations=/applicationContext.xml)public class UserServiceTest Autowiredprivate UserService userService;Testpublic void testLoginCheck()User user = new User();user.setUserName(ma