EasyUI Spring SpringMVC MyBatis开发环境搭建

赵海燕

于 2020-11-16 21:14:18 发布

阅读量247

点赞数

分类专栏： SSM EasyUI 文章标签： EasyUI SSM

本文链接：https://blog.csdn.net/cyberzhaohy/article/details/109729784

版权

SSM 同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

EasyUI

1 篇文章 0 订阅

订阅专栏

在网上看了一遍博客，写的很好，照着例子做了一遍，发现没有问题，结果看到下面的帖子，看到无数同学需要源代码，估计都是新手。于是笔者准备写完博客后，上传一下代码。

1、项目结构：

2、创建表SQL：

CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`trueName` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3、插入一条记录：

INSERT INTO `users` VALUES ('1', 'zhangsan', '123456', '1', '张三', null, null, null);

4、依赖：

net.sf.json-lib:json-lib:jar:2.4下载不了

添加如下代码

参考网址：https://blog.csdn.net/weixin_41907291/article/details/83714551

5.1、源代码：TestSpring

package com.liuhai.eshop;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.liuhai.eshop.domain.User;
import com.liuhai.eshop.service.UserService;

public class TestSpring {
   @Test
   public void TestUserService() throws Exception{
       @SuppressWarnings("resource")
       ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext.xml");
       UserService us=(UserService) ac.getBean("userService");
       User user=new User();
       user.setAge(1);
       user.setUserName("zhangsan");
       user.setPassword("123456");
       user.setTrueName("张三");
       us.add(user);
   }
}

5.2、源代码：UserController

package com.liuhai.eshop.controller;

import java.io.File;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

import org.apache.commons.io.FileUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
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.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.liuhai.eshop.domain.User;
import com.liuhai.eshop.service.UserService;
import com.liuhai.eshop.util.PageBean;
import com.liuhai.eshop.util.ResponseUtil;
import com.liuhai.eshop.util.StringUtil;

@Controller
@RequestMapping("/user")
public class UserController {
   private static Logger log=LoggerFactory.getLogger(UserController.class);
   @Resource
   private UserService userService;

   @RequestMapping("/showUser.do")
   public String toIndex(HttpServletRequest request,Model model){
       System.out.println("liuhaitest");
       return "showUser";
   }
   // /user/test.do?id=1
@RequestMapping(value="/test.do",method=RequestMethod.GET)
public String test(HttpServletRequest request,Model model){
int userId = Integer.parseInt(request.getParameter("id"));
System.out.println("userId:"+userId);
User user=null;
if (userId==1) {
user = new User();
user.setAge(11);
user.setId(1);
user.setPassword("123");
user.setUserName("javen");
}
log.debug(user.toString());
model.addAttribute("user", user);
return "index";
}
// /user/showUser.do?id=1
@RequestMapping(value="/showUser.do",method=RequestMethod.GET)
public String toindex(HttpServletRequest request,Model model){
int userId = Integer.parseInt(request.getParameter("id"));
System.out.println("userId:"+userId);
User user = this.userService.getUserById(userId);
log.debug(user.toString());
model.addAttribute("user", user);
return "showUser";
}

// /user/showUser2.do?id=1
@RequestMapping(value="/showUser2.do",method=RequestMethod.GET)
public String toIndex2(@RequestParam("id") String id,Model model){
int userId = Integer.parseInt(id);
System.out.println("userId:"+userId);
User user = this.userService.getUserById(userId);
log.debug(user.toString());
model.addAttribute("user", user);
return "showUser";
}

// /user/jsontype.do?id=1
@RequestMapping(value="/jsontype.do",method=RequestMethod.GET)
public @ResponseBody User getUserInJson(@RequestParam("id") String id,Map<String, Object> model){
int userId = Integer.parseInt(id);
System.out.println("userId:"+userId);
User user = this.userService.getUserById(userId);
log.info(user.toString());
return user;
}
// /user/jsontype2.do?id=1
@RequestMapping(value="/jsontype2.do",method=RequestMethod.GET)
public ResponseEntity<User> getUserInJson2(@RequestParam("id") String id,Map<String, Object> model){
int userId = Integer.parseInt(id);
System.out.println("userId:"+userId);
User user = this.userService.getUserById(userId);
log.info(user.toString());
return new ResponseEntity<User>(user,HttpStatus.OK);
}

//文件上传页面
@RequestMapping(value="/upload.do")
public String showUploadPage(){
return "file";
}
//文件上传
@RequestMapping(value="/doUpload.do",method=RequestMethod.POST)
public String doUploadFile(@RequestParam("file")MultipartFile file) throws IOException{
if (!file.isEmpty()) {
log.info("Process file:{}",file.getOriginalFilename());
}
FileUtils.copyInputStreamToFile(file.getInputStream(), new File("E:\\",System.currentTimeMillis()+file.getOriginalFilename()));
return "succes";
}
/**
* 用户管理页面
* @return
*/
@RequestMapping(value="/userManage.do")
public String userManagePage(){
return "userManage";
}
   /**
   * 添加或者修改
   * @param user
   * @param res
   * @return
   * @throws Exception
   */
   @RequestMapping("/save.do")
   public String save(User user,HttpServletResponse res) throws Exception{
       //操作记录条数，初始化为0
       int resultTotal = 0;
       if (user.getId() == null) {
           resultTotal = userService.add(user);
       }else{
           resultTotal = userService.update(user);
       }
       JSONObject jsonObject = new JSONObject();
       if(resultTotal > 0){ //说明修改或添加成功
           jsonObject.put("success", true);
       }else{
           jsonObject.put("success", false);
       }
       ResponseUtil.write(res, jsonObject);
       return null;
   }
   /**
   * 用户分页查询
   * @param page
   * @param rows
   * @param s_user
   * @param res
   * @return
   * @throws Exception
   */
   @RequestMapping("/list.do")
   public String list(@RequestParam(value="page",required=false) String page,@RequestParam(value="rows",required=false) String rows,User s_user,HttpServletResponse res) throws Exception{
       PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
       Map<String,Object> map=new HashMap<String,Object>();
       map.put("userName", StringUtil.formatLike(s_user.getUserName()));
       map.put("start", pageBean.getStart());
       map.put("size", pageBean.getPageSize());
       List<User> userList=userService.find(map);
       Long total=userService.getTotal(map);
       JSONObject result=new JSONObject();
       JSONArray jsonArray=JSONArray.fromObject(userList);
       result.put("rows", jsonArray);
       result.put("total", total);
       ResponseUtil.write(res, result);
       return null;
   }
   /**
   * 删除用户
   * @param ids
   * @param res
   * @return
   * @throws Exception
   */
   @RequestMapping("/delete.do")
   public String delete(@RequestParam(value="ids") String ids,HttpServletResponse res) throws Exception{
       String[] idStr = ids.split(",");
       JSONObject jsonObject = new JSONObject();
       for (String id : idStr) {
           userService.delete(Integer.parseInt(id));
       }
       jsonObject.put("success", true);
       ResponseUtil.write(res, jsonObject);
       return null;
   }
}

5.3、源代码：UserDao

package com.liuhai.eshop.dao;

import java.util.List;
import java.util.Map;

import com.liuhai.eshop.domain.User;
/**
* 用户DAO接口
* @author Administrator
*
*/
public interface UserDao {
   /**
   * 用户登录
   * @param user
   * @return
   */
   public User login(User user);
   /**
   * 查询所有用户
   * @return
   */
   public List<User> getAll();
   /**
   * 根据条件查询用户
   * @param user
   * @return
   */
   public User getUser(User user);
   /**
   * 删除用户
   * @param user
   * @return
   */
   public int delete(int id);
   /**
   * 更新用户
   * @param user
   * @return
   */
   public int update(User user);
   /**
   * 添加用户
   * @param user
   * @return
   */
   public int add(User user);
   /**
   * 用户查询
   * @param map
   * @return
   */
   public List<User> find(Map<String,Object> map);
   /**
   * 获取总记录数
   * @param map
   * @return
   */
   public Long getTotal(Map<String,Object> map);
   /**
   * 根据id查询用户
   * @param id
   * @return
   */
   public User getUserById(int id);
}

5.4、源代码：User

package com.liuhai.eshop.domain;

import java.io.Serializable;

/**
* 用户实体
* @author Administrator
*
*/
public class User implements Serializable{
   private static final long serialVersionUID = 1L;
   private Integer id;
   private String userName;
   private String password;
   private Integer age;
   private String trueName;
   private String email;
   private String phone;
   private String roleName;
   public Integer getId() {
       return id;
   }
   public void setId(Integer id) {
       this.id = id;
   }

   public Integer getAge() {
       return age;
   }
   public void setAge(Integer age) {
       this.age = age;
   }
   public String getPassword() {
       return password;
   }
   public void setPassword(String password) {
       this.password = password;
   }
   public String getUserName() {
       return userName;
   }
   public void setUserName(String userName) {
       this.userName = userName;
   }
   public String getTrueName() {
       return trueName;
   }
   public void setTrueName(String trueName) {
       this.trueName = trueName;
   }
   public String getEmail() {
       return email;
   }
   public void setEmail(String email) {
       this.email = email;
   }
   public String getPhone() {
       return phone;
   }
   public void setPhone(String phone) {
       this.phone = phone;
   }
   public String getRoleName() {
       return roleName;
   }
   public void setRoleName(String roleName) {
       this.roleName = roleName;
   }
}

6、配置文件：UserMapper.xml

<?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.liuhai.eshop.dao.UserDao">
   
<cache size="1024" flushInterval="60000" eviction="LRU" readOnly="false"></cache>

   <insert id="add" parameterType="com.liuhai.eshop.domain.User">
       insert into users values(null,#{userName},#{password},#{age},#{trueName},#{email},#{phone},#{roleName})
   </insert>
<resultMap id="userResultMap" type="com.liuhai.eshop.domain.User" >
<id property="id" column="id"/>
<result property="userName" column="userName"/>
<result property="password" column="password"/>
<result property="age" column="age"/>
<result property="trueName" column="trueName" />
       <result property="email" column="email" />
       <result property="phone" column="phone" />
       <result property="roleName" column="roleName" />
</resultMap>
<select id="getUserById" parameterType="Integer" resultMap="userResultMap">
   select * from users where id=#{id}
</select>
<select id="find" parameterType="com.liuhai.eshop.domain.User" resultMap="userResultMap">
   select * from users
   <where>
           <if test="userName!=null and userName!='' ">
               and userName like #{userName}
           </if>
       </where>
       <if test="start!=null and size!=null">
           limit #{start},#{size}
       </if>
</select>
<select id="getTotal" parameterType="Map" resultType="Long">
       select count(*) from users
       <where>
           <if test="userName!=null and userName!='' ">
               and userName like #{userName}
           </if>
       </where>
   </select>
   
   <delete id="delete" parameterType="Integer">
       delete from users where id = #{id}
   </delete>
   
   <update id="update" parameterType="com.liuhai.eshop.domain.User">
       update users
       <set>
           <if test="age != null and age != ''">age = #{age},</if>
           <if test="userName != null and userName != ''">userName = #{userName},</if>
           <if test="password != null and password != ''">password = #{password},</if>
           <if test="trueName != null and trueName != ''">trueName = #{trueName},</if>
           <if test="email != null and email != ''">email = #{email},</if>
           <if test="phone != null and phone != ''">phone = #{phone},</if>
           <if test="roleName != null and roleName != ''">roleName = #{roleName},</if>
       </set>
       where id = #{id}
   </update>
</mapper>

7.1、源代码：UserService

package com.liuhai.eshop.service;

import java.util.List;
import java.util.Map;
import com.liuhai.eshop.domain.User;

public interface UserService {
   public List<User> getAll();
   public User getUser(User user);
   public int delete(int id);
   public int update(User user);
   public int add(User user);
   public List<User> find(Map<String,Object> map);
   public Long getTotal(Map<String,Object> map);
   public User getUserById(int id);
}

7.2、源代码：UserServiceImpl

package com.liuhai.eshop.service.impl;

import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.liuhai.eshop.dao.UserDao;
import com.liuhai.eshop.domain.User;
import com.liuhai.eshop.service.UserService;
@Service(value="userService")
public class UserServiceImpl implements UserService {
   private UserDao userDao;
@Resource
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
   @Override
   public List<User> getAll() {
       return userDao.getAll();
   }

   @Override
   public User getUser(User user) {
       return userDao.getUser(user);
   }

   @Override
   public int delete(int id) {
       return userDao.delete(id);
   }

   @Override
   public int update(User user) {
       return userDao.update(user);
   }

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

   @Override
   public List<User> find(Map<String, Object> map) {
       return userDao.find(map);
   }

   @Override
   public Long getTotal(Map<String, Object> map) {
       return userDao.getTotal(map);
   }
   public User getUserById(int id){
       return userDao.getUserById(id);
   }
}

7.3、源代码：PageBean

package com.liuhai.eshop.util;
/**
* 分页Model类
* @author Administrator
*
*/
public class PageBean {
   private int page; // 第几页
   private int pageSize; // 每页记录数
   private int start; // 起始页
   public PageBean(int page, int pageSize) {
       super();
       this.page = page;
       this.pageSize = pageSize;
   }
   public int getPage() {
       return page;
   }
   public void setPage(int page) {
       this.page = page;
   }
   public int getPageSize() {
       return pageSize;
   }
   public void setPageSize(int pageSize) {
       this.pageSize = pageSize;
   }
   public int getStart() {
       return (page-1)*pageSize;
   }
}

7.4、源代码：ResponseUtil

package com.liuhai.eshop.util;

import java.io.PrintWriter;

import javax.servlet.http.HttpServletResponse;
/***
* 主要用于返回json数据
* @author Administrator
*/
public class ResponseUtil {
   public static void write(HttpServletResponse response,Object object)throws Exception{
       response.setContentType("text/html;charset=utf-8");
       PrintWriter out=response.getWriter();
       out.println(object);
       out.flush();
       out.close();
   }
}

7.5、源代码:StringUtil

package com.liuhai.eshop.util;
/***
* 字符串工具类
* @author Administrator
*
*/
public class StringUtil {
   /**
* 判断是否是空
* @param str
* @return
*/
public static boolean isEmpty(String str){
if(str==null||"".equals(str.trim())){
return true;
}else{
return false;
}
}

/**
* 判断是否不是空
* @param str
* @return
*/
public static boolean isNotEmpty(String str){
if((str!=null)&&!"".equals(str.trim())){
return true;
}else{
return false;
}
}

/**
* 格式化模糊查询
* @param str
* @return
*/
public static String formatLike(String str){
if(isNotEmpty(str)){
return "%"+str+"%";
}else{
return null;
}
}
}

8.1、配置文件：applicationContext.xml

<?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:aop="http://www.springframework.org/schema/aop"
   xmlns:context="http://www.springframework.org/schema/context"
   xmlns:tx="http://www.springframework.org/schema/tx"
   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
   
   <context:property-placeholder location="classpath:jdbc.properties"/>
   
   <context:component-scan base-package="com.liuhai.eshop.dao.impl,com.liuhai.eshop.service.impl"></context:component-scan>

   
   <tx:annotation-driven/>
   
   <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
       <property name="driverClass" value="${jdbc.driverclass}"></property>
       <property name="jdbcUrl" value="${jdbc.url}"></property>
       <property name="user" value="${jdbc.username}"></property>
       <property name="password" value="${jdbc.password}"></property>
       <property name="initialPoolSize" value="${c3p0.pool.size.init}"></property>
       <property name="minPoolSize" value="${c3p0.pool.size.min}"></property>
       <property name="maxPoolSize" value="${c3p0.pool.size.max}"></property>
       <property name="acquireIncrement" value="${c3p0.pool.size.increment}"></property>
   </bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />

<property name="mapperLocations" value="classpath:com/liuhai/eshop/mappers/*.xml"></property>
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
   <property name="basePackage" value="com.liuhai.eshop.dao"></property>
   <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
   
   <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
       <property name="dataSource" ref="dataSource"></property>
   </bean>
</beans>

8.2、配置文件：jdbc.properties

jdbc.driverclass=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/eshop
jdbc.username=root
jdbc.password=你的密码
c3p0.pool.size.max=10
c3p0.pool.size.min=2
c3p0.pool.size.init=3
c3p0.pool.size.increment=2

hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.show_sql=true
hibernate.hbm2ddl.auto=none

8.3、配置文件：log4j.properties

log4j.rootLogger=INFO,Console,File
#\u5B9A\u4E49\u65E5\u5FD7\u8F93\u51FA\u76EE\u7684\u5730\u4E3A\u63A7\u5236\u53F0
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out
#\u53EF\u4EE5\u7075\u6D3B\u5730\u6307\u5B9A\u65E5\u5FD7\u8F93\u51FA\u683C\u5F0F\uFF0C\u4E0B\u9762\u4E00\u884C\u662F\u6307\u5B9A\u5177\u4F53\u7684\u683C\u5F0F
log4j.appender.Console.layout = org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n

log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

#\u6587\u4EF6\u5927\u5C0F\u5230\u8FBE\u6307\u5B9A\u5C3A\u5BF8\u7684\u65F6\u5019\u4EA7\u751F\u4E00\u4E2A\u65B0\u7684\u6587\u4EF6
log4j.appender.File = org.apache.log4j.RollingFileAppender
#\u6307\u5B9A\u8F93\u51FA\u76EE\u5F55
log4j.appender.File.File = logs/ssm.log
#\u5B9A\u4E49\u6587\u4EF6\u6700\u5927\u5927\u5C0F
log4j.appender.File.MaxFileSize = 10MB
# \u8F93\u51FA\u6240\u4EE5\u65E5\u5FD7\uFF0C\u5982\u679C\u6362\u6210DEBUG\u8868\u793A\u8F93\u51FADEBUG\u4EE5\u4E0A\u7EA7\u522B\u65E5\u5FD7
log4j.appender.File.Threshold =INFO
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

8.4、配置文件：spring-mvc.xml

<?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:mvc="http://www.springframework.org/schema/mvc"
   xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">

   
   <context:component-scan base-package="com.liuhai.eshop.controller"></context:component-scan>

<bean id="mappingJacksonHttpMessageConverter"
class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>


<bean
class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
<property name="messageConverters">
<list>
<ref bean="mappingJacksonHttpMessageConverter" /> 
</list>
</property>
</bean>
   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
       <property name="prefix" value="/jsps/"></property>
       <property name="suffix" value=".jsp"></property>
   </bean>
   <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
       
       <property name="defaultEncoding" value="utf-8"></property>
       
       <property name="maxUploadSize" value="10485760000"></property>
       
       <property name="maxInMemorySize" value="40960"></property>
   </bean>
</beans>

9、依赖：
jquery-easyui-1.5.1，下载地址：https://www.jeasyui.com/download/v151.php
如果打不开，请翻墙！！！

10.1、源代码：file.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<h1>上传文件</h1>
<form method="post" action="../user/doUpload.do" enctype="multipart/form-data">
<input type="file" name="file"/>
<input type="submit" value="上传文件"/>

</form>
</body>
</html>

10.2、源代码：userManage.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'userManage.jsp' starting page</title>

   <meta http-equiv="pragma" content="no-cache">
   <meta http-equiv="cache-control" content="no-cache">
   <meta http-equiv="expires" content="0">
   <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
   <meta http-equiv="description" content="This is my page">
   <link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/jquery-easyui-1.5.1/themes/default/easyui.css">
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/jquery-easyui-1.5.1/themes/icon.css">
<script type="text/javascript" src="${pageContext.request.contextPath}/jquery-easyui-1.5.1/jquery.min.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/jquery-easyui-1.5.1/jquery.easyui.min.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/jquery-easyui-1.5.1/locale/easyui-lang-zh_CN.js"></script>
   <script type="text/javascript">
       var url;
       function openUserAddDialog() {
           $("#dlg").dialog("open").dialog("setTitle", "添加用户信息");
           url = "${pageContext.request.contextPath}/user/save.do";
       }
       function saveUser() {
           $("#fm").form("submit", {
               url : url,
               onSubmit : function() {
                   if ($("#roleName").combobox("getValue") == "") {
                       $.messager.alert("系统提示", "请选择用户角色！");
                       return false;
                   }
                   return $(this).form("validate");
               },
               success : function(result) {
                   var result = eval('(' + result + ')');
                   if (result.success) {
                       $.messager.alert("系统提示", "保存成功！");
                       resetValue();
                       $("#dlg").dialog("close");
                       $("#dg").datagrid("reload");
                   } else {
                       $.messager.alert("系统提示", "保存失败！");
                       return;
                   }
               }
           });
       }
       function searchUser() {
           $("#dg").datagrid('load', {
               "userName" : $("#s_userName").val()
           });
       }
       function resetValue() {
           $("#userName").val("");
           $("#password").val("");
           $("#trueName").val("");
           $("#email").val("");
           $("#phone").val("");
           $("#roleName").combobox("setValue", "");
       }
       function deleteUser() {
           var selectedRows = $("#dg").datagrid("getSelections");
           if (selectedRows.length == 0) {
               $.messager.alert("系统提示", "请选择要删除的数据！");
               return;
           }
           var strIds = [];
           for ( var i = 0; i < selectedRows.length; i++) {
               strIds.push(selectedRows[i].id);
           }
           var ids = strIds.join(",");
           $.messager.confirm("系统提示", "您确定要删除这<font color=red>"
                   + selectedRows.length + "</font>条数据吗？", function(r) {
               if (r) {
                   $.post("${pageContext.request.contextPath}/user/delete.do", {
                       ids : ids
                   }, function(result) {
                       if (result.success) {
                           $.messager.alert("系统提示", "数据已成功删除！");
                           $("#dg").datagrid("reload");
                       } else {
                           $.messager.alert("系统提示", "数据删除失败，请联系系统管理员！");
                       }
                   }, "json");
               }
           });
       }
       function openUserModifyDialog() {
           var selectedRows = $("#dg").datagrid("getSelections");
           if (selectedRows.length != 1) {
               $.messager.alert("系统提示", "请选择一条要编辑的数据！");
               return;
           }
           var row = selectedRows[0];
           $("#dlg").dialog("open").dialog("setTitle", "编辑用户信息");
           $("#fm").form("load", row);
           url = "${pageContext.request.contextPath}/user/save.do?id=" + row.id;
       }
   </script>
</head>

<body style="margin: 1px">
<table id="dg" title="用户管理" class="easyui-datagrid" fitColumns="true"
       pagination="true" rownumbers="true"
       url="${pageContext.request.contextPath}/user/list.do" fit="true"
       toolbar="#tb">
       <thead>
           <tr>
               <th field="cb" checkbox="true" align="center"></th>
               <th field="id" width="50" align="center">编号</th>
               <th field="userName" width="50" align="center">用户名</th>
               <th field="password" width="50" align="center">密码</th>
               <th field="trueName" width="50" align="center">真实姓名</th>
               <th field="email" width="50" align="center">邮件</th>
               <th field="phone" width="50" align="center">联系电话</th>
               <th field="roleName" width="50" align="center">角色</th>
           </tr>
       </thead>
   </table>
   <div id="tb">
       <a href="javascript:openUserAddDialog()" class="easyui-linkbutton"
           iconCls="icon-add" plain="true">添加</a> <a
           href="javascript:openUserModifyDialog()" class="easyui-linkbutton"
           iconCls="icon-edit" plain="true">修改</a> <a
           href="javascript:deleteUser()" class="easyui-linkbutton"
           iconCls="icon-remove" plain="true">删除</a>
       <div>
           用户名： <input type="text" id="s_userName" size="20"
               οnkeydοwn="if(event.keyCode == 13)searchUser()" /> <a
               href="javascript:searchUser()" class="easyui-linkbutton"
               iconCls="icon-search" plain="true">查询</a>
       </div>
       <div id="dlg-buttons">
           <a href="javascript:saveUser()" class="easyui-linkbutton"
               iconCls="icon-ok">保存</a> <a href="javascript:closeUserDialog()"
               class="easyui-linkbutton" iconCls="icon-cancel">关闭</a>
       </div>
       <div id="dlg" class="easyui-dialog"
           style="width: 730px;height:280px;padding:10px 10px;" closed="true"
           buttons="#dlg-buttons">
           <form method="post" id="fm">
               <table cellspacing="8px;">
                   <tr>
                       <td>用户名：</td>
                       <td><input type="text" id="userName" name="userName"
                           class="easyui-validatebox" required="true" /> <span
                           style="color: red">*</span>
                       </td>
                       <td>   </td>
                       <td>密码：</td>
                       <td><input type="password" id="password" name="password"
                           class="easyui-validatebox" required="true" /> <span
                           style="color: red">*</span>
                       </td>
                   </tr>
                   <tr>
                       <td>真实姓名：</td>
                       <td><input type="text" id="trueName" name="trueName"
                           class="easyui-validatebox" required="true" /> <span
                           style="color: red">*</span>
                       </td>
                       <td>   </td>
                       <td>邮箱：</td>
                       <td><input type="text" id="email" name="email"
                           validType="email" class="easyui-validatebox" required="true" /> <span
                           style="color: red">*</span>
                       </td>
                   </tr>
                   <tr>
                       <td>联系电话：</td>
                       <td><input type="text" id="phone" name="phone"
                           class="easyui-validatebox" required="true" /> <span
                           style="color: red">*</span>
                       </td>
                       <td>   </td>
                       <td>用户角色：</td>
                       <td><select name="roleName" class="easyui-combobox"
                           id="roleName" style="width: 154px;" editable="false"
                           panelHeight="auto">
                               <option value="">请选择角色</option>
                               <option value="系统管理员">系统管理员</option>
                               <option value="销售主管">销售主管</option>
                               <option value="客户经理">客户经理</option>
                               <option value="高管">高管</option>
                       </select> <span style="color: red">*</span>
                       </td>
                   </tr>
               </table>
           </form>
       </div>
   </div>
</body>
</html>

11.1、配置文件：web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" id="WebApp_ID" version="4.0">

<display-name>web 测试页面</display-name>

<context-param>
   <param-name>contextConfigLocation</param-name>
   <param-value>classpath:applicationContext.xml</param-value>
</context-param>

<filter>
   <filter-name>encodingFilter</filter-name>
   <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
   <async-supported>true</async-supported>
   <init-param>
       <param-name>encoding</param-name>
       <param-value>UTF-8</param-value>
   </init-param>
</filter>
<filter-mapping>
   <filter-name>encodingFilter</filter-name>
   <url-pattern>/*</url-pattern>
</filter-mapping>

<listener>
   <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<listener>
   <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>

<servlet>
   <servlet-name>springMVC</servlet-name>
   <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
   <init-param>
       <param-name>contextConfigLocation</param-name>
       <param-value>classpath:spring-mvc.xml</param-value>
   </init-param>
   <load-on-startup>1</load-on-startup>
   <async-supported>true</async-supported>
</servlet>
<servlet-mapping>
   <servlet-name>springMVC</servlet-name>
   
   <url-pattern>*.do</url-pattern>
</servlet-mapping>

<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.css</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.gif</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.png</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.jpg</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.js</url-pattern>
</servlet-mapping>
<welcome-file-list>
   <welcome-file>/index.jsp</welcome-file>
</welcome-file-list>

</web-app>

11.2、配置文件：pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
   <modelVersion>4.0.0</modelVersion>
   <groupId>com.liuhai</groupId>
   <artifactId>eshopSSM</artifactId>
   <version>0.0.1-SNAPSHOT</version>
   <packaging>war</packaging>

   <build>
       <sourceDirectory>src</sourceDirectory>
       <plugins>
           <plugin>
               <artifactId>maven-compiler-plugin</artifactId>
               <version>3.8.0</version>
               <configuration>
                   <source>1.8</source>
                   <target>1.8</target>
               </configuration>
           </plugin>
           <plugin>
               <artifactId>maven-war-plugin</artifactId>
               <version>3.2.1</version>
               <configuration>
                   <warSourceDirectory>WebContent</warSourceDirectory>
               </configuration>
           </plugin>
       </plugins>
   </build>

<dependencies>
       
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-webmvc</artifactId>
           <version>4.0.2.RELEASE</version>
       </dependency>
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-jdbc</artifactId>
           <version>4.0.2.RELEASE</version>
       </dependency>
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-tx</artifactId>
           <version>4.0.2.RELEASE</version>
       </dependency>
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-context-support</artifactId>
           <version>4.0.2.RELEASE</version>
       </dependency>
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-orm</artifactId>
           <version>4.0.2.RELEASE</version>
       </dependency>
       
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>5.1.17</version>
       </dependency>
       
       <dependency>
           <groupId>com.mchange</groupId>
           <artifactId>c3p0</artifactId>
           <version>0.9.5.2</version>
       </dependency>
       
       <dependency>
           <groupId>javax.servlet</groupId>
           <artifactId>jstl</artifactId>
           <version>1.2</version>
       </dependency>
       <dependency>
           <groupId>commons-io</groupId>
           <artifactId>commons-io</artifactId>
           <version>2.4</version>
       </dependency>
       
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.1.1</version>
       </dependency>
       
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis-spring</artifactId>
           <version>1.2.0</version>
       </dependency>
       
       <dependency>
           <groupId>org.codehaus.jackson</groupId>
           <artifactId>jackson-mapper-asl</artifactId>
           <version>1.9.4</version>
       </dependency>
       
       <dependency>
           <groupId>log4j</groupId>
           <artifactId>log4j</artifactId>
           <version>${log4j.version}</version>
       </dependency>
       <dependency>
           <groupId>org.slf4j</groupId>
           <artifactId>slf4j-api</artifactId>
           <version>${slf4j.version}</version>
       </dependency>
       <dependency>
           <groupId>org.slf4j</groupId>
           <artifactId>slf4j-log4j12</artifactId>
           <version>${slf4j.version}</version>
       </dependency>
       
       
       <dependency>
           <groupId>commons-fileupload</groupId>
           <artifactId>commons-fileupload</artifactId>
           <version>1.3.1</version>
       </dependency>
       <dependency>
           <groupId>commons-io</groupId>
           <artifactId>commons-io</artifactId>
           <version>2.4</version>
       </dependency>