SSM整合

1.Spring配置文件、Mybatis配置文件、SpringMVC配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
	http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context-3.2.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">

	<!-- 配置数据访问层和业务逻辑层包的扫描 -->
	<context:component-scan base-package="com.leisong.service.impl"></context:component-scan>
	<!--配置数据源-->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="com.mysql.jdbc.Driver"/>
		<property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/smbms?zeroDateTimeBehavior=convertToNull"/>
		<property name="user" value="root"/>
		<property name="password" value="123456"/>
	</bean>
	<!--配置SqlSessionFactory-->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	</bean>
	<!--自动扫描-->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.leisong.dao"></property>
	</bean>
</beans>
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<!-- 给类起别名 -->
	<typeAliases>

		<package name="com.leisong.domain" />
	</typeAliases>
</configuration>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        https://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd">
<!--开启注解扫描 -->
    <context:component-scan base-package="com.leisong"></context:component-scan>
    <!-- 视图解析器对象-->
    <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--开启springmvc框架的注解支持-->
    <mvc:annotation-driven/>
    <!-- 全局异常 -->
    <bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
        <property name="exceptionMappings">
            <props>
                <prop key="java.lang.RuntimeException">
                    error
                </prop>
            </props>
        </property>
    </bean>
    <!--访问静态资源-->
    <mvc:resources mapping="/sta/**" location="/static/"></mvc:resources>
</beans>

2.web.xml


<web-app>
  <display-name>Archetype Created Web Application</display-name>
  <!-- 加载Spring的配置文件 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext-jdbc.xml</param-value>
  </context-param>
  <!-- 配置监听器 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
<!--配置springmvc的前端控制器-->
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:springmvc.xml</param-value>
    </init-param>
    <!-- 配置启动的优先级 -->
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  <!-- 配置解决中文乱码的过滤器-->
  <filter>
    <filter-name>characterEncodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>characterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

3.数据访问层及其映射文件

package com.leisong.dao;

import com.leisong.domain.Role;

import java.util.List;

public interface RoleDao {

    //查询所有的角色
    public List<Role> getRoleList();
}

package com.leisong.dao;

import com.leisong.domain.User;

import java.util.Date;
import java.util.List;

public interface UserDao {
	//查询指定用户
	public User getLoginUser(String  userCode, String password)throws Exception;

	//查询所有的用户列表
	public List<User> getUserList(String userName,int roleId);

	//查看某个人的信息
	public User getUserById(String id);

	//修改某个人的信息
	public void updateByUserId(String userName,String userPassword,int gender,Date birthday,String phone,String address,String id);

	//添加用户
	public int add(User user);

	//删除
	public int deleteById(String id);
}

``

```java
package com.leisong.dao;

import com.leisong.domain.User;

import java.util.Date;
import java.util.List;

public interface UserDao {
	//查询指定用户
	public User getLoginUser(String  userCode, String password)throws Exception;

	//查询所有的用户列表
	public List<User> getUserList(String userName,int roleId);

	//查看某个人的信息
	public User getUserById(String id);

	//修改某个人的信息
	public void updateByUserId(String userName,String userPassword,int gender,Date birthday,String phone,String address,String id);

	//添加用户
	public int add(User user);

	//删除
	public int deleteById(String id);
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.leisong.dao.UserDao">
    <select id="getLoginUser" resultType="user">
        select * from smbms_user where userCode=#{arg0} and userPassword=#{arg1}
  </select>
    <select id="getUserList" resultType="user">
        select u.*,r.roleName from smbms_user u,smbms_role r where u.userName like #{arg0} and u.userRole=#{arg1}
    </select>
    <select id="getUserById" resultType="user" parameterType="String">
        select u.* from smbms_user u where u.id=#{id}
    </select>
    <update id="updateByUserId" >
        update  smbms_user u set userName=#{arg0},userPassword=#{arg1},gender=#{arg2},birthday=#{arg3},phone=#{arg4},address=#{arg5} where u.id=#{arg6}
    </update>

</mapper>

4.业务逻辑层

package com.leisong.service;

import com.leisong.domain.Role;

import java.util.List;

public interface RoleService {

    //查询所有的角色
    public List<Role> findRoleList();
}

package com.leisong.service;

import com.leisong.domain.User;

import java.util.Date;
import java.util.List;

public interface UserService {
	public User findUser(String userCode, String password);

	//查询所有的用户列表
	public List<User> findUserList(String userName,int roleId);

	//查看某个人的信息
	public User findUserById(String id);

	//修改某个人的信息
	public void updateByUserId(String userName,String userPassword,int gender,Date birthday,String phone,String address,String id);

	//添加用户
	public int save(User user);

	//删除
	public int deleteById(String id);
}

package com.leisong.service.impl;

import com.leisong.dao.RoleDao;
import com.leisong.domain.Role;
import com.leisong.service.RoleService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service("roleService")
public class RoleServiceImpl implements RoleService {

    @Resource
    private RoleDao roleDao;
    public RoleDao getRoleDao() {
        return roleDao;
    }
    public void setRoleDao(RoleDao roleDao) {
        this.roleDao = roleDao;
    }
    @Override
    public List<Role> findRoleList() {
        return roleDao.getRoleList();
    }

}

package com.leisong.service.impl;

import com.leisong.dao.UserDao;
import com.leisong.domain.User;
import com.leisong.service.UserService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.Date;
import java.util.List;

@Service("userService")
public class UserServiceImpl implements UserService {

	@Resource
	private UserDao userdao;

	public UserDao getUserdao() {
		return userdao;
	}

	public void setUserdao(UserDao userdao) {
		this.userdao = userdao;
	}

	@Override
	public User findUser(String userCode, String password) {
		User user = null;
		try {
			user = userdao.getLoginUser(userCode, password);
		} catch (Exception e) {
			e.printStackTrace();
		}

		return user;
	}

	@Override
	public List<User> findUserList(String userName, int roleId) {
		return userdao.getUserList(userName, roleId);
	}

	@Override
	public User findUserById(String id) {
		return userdao.getUserById(id);
	}

	@Override
	public void updateByUserId( String userName, String userPassword,
							  int gender, Date birthday, String phone, String address,String id) {
		userdao.updateByUserId(userName, userPassword, gender, birthday, phone, address,id);
	}

	@Override
	public int save(User user) {
		return userdao.add(user);
	}

	@Override
	public int deleteById(String id) {
		return userdao.deleteById(id);
	}

}

6.控制器

package com.leisong.controller;


import com.leisong.domain.Role;
import com.leisong.domain.User;
import com.leisong.service.RoleService;
import com.leisong.service.UserService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import javax.validation.Valid;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Controller
@RequestMapping("/user")
public class UserController {

    @Resource
    UserService us=null;
    @Resource
    RoleService rs=null;

    //登录
    @RequestMapping(value="/login.html")
    public String dologin(String username,String password,HttpServletRequest request,HttpSession session){
        //调用业务逻辑层
        User user=us.findUser(username, password);
        if(user==null){
			/*request.setAttribute("errors", "用户名密码不正确");
			return "login";*/
            throw new RuntimeException("用户名密码不正确....");
        }else{
            System.out.println("控制器user用户的值:"+user.getUserName());
            session.setAttribute("currentUser", user);
            //return "main";
            return "redirect:/user/main.html";
        }

    }

    //定义跳转到主页面的处理器
    @RequestMapping(value="/main.html")
    public String doMain(){
        return "main";
    }

    //定义局部异常处理
/*	@ExceptionHandler(value=RuntimeException.class)
	public String handlerException(RuntimeException e,HttpServletRequest request){
		request.setAttribute("e", e);
		return "login";
	}*/
//查询所有的用户列表
    @RequestMapping(value="/findUserList.html" )
    public String findUserList(@RequestParam(value="userName",required=false)String userName,@RequestParam(value="roleId",required=false,defaultValue="0")int roleId,Model model){
        List<User> list=us.findUserList(userName, roleId);
        System.out.println("接受到的用户名:"+userName);
        List<Role> roleList=rs.findRoleList();
        model.addAttribute("userList",list);
        model.addAttribute("queryUserName",userName);
        model.addAttribute("queryroleId",roleId);
        model.addAttribute("roleList",roleList);
        return "userList";
    }

    @RequestMapping(value="/getUserById.html/{uid}")
    public String findByUserId(@PathVariable(value="uid") String id,Model model){
        User user=us.findUserById(id);
        model.addAttribute("u",user);
        return "userInfo";
    }

    //修改
    @RequestMapping(value="/updateUserById.html/{id}")
    public String updateUserById(@PathVariable(value="id") String id, Model model){
        User user=us.findUserById(id);
        model.addAttribute("u",user);
        return "updateUser";
    }

    //真正完成修改操作
    @RequestMapping(value="/update.html",method=RequestMethod.POST)
    //public String updateUser(String id,String userCode,String userName,String userPassword,int gender,Date birthday,String phone,String address,Model model){
    public String updateUser(User user,Model model){
        System.out.println(user.getUserName());
        us.updateByUserId(user.getUserName(), user.getUserPassword(), user.getGender(), user.getBirthday(), user.getPhone(), user.getAddress(),user.getId().toString());
        return "redirect:/user/findUserList.html";
    }
    //定义跳转到添加用户页面的路由
    @RequestMapping(value="userAdd.html")
    public String add(User user){
        return "userAdd";
    }

    @RequestMapping(value="userAdd1.html")
    public String add1(User user){
        return "userAdd1";
    }



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值