ssm+easyui+sqlserver2008(增删改查实现)

这段是时间在学习ssm+esayui，看了网上很多例子，也试了试，结果出现很多问题，要么就是mapper映射错了，要么就是jar包版本不兼容的一些问题，因为我本地是sqlserver的数据库，在网上也没看到这和sqlserver数据库的，所以今天特地整理了一份sqlserver的，方便以后学习

废话不多说，直接上项目结构（ssm环境搭建我就不多说了，网上有很多例子）

1、项目结构

大家会看到有报错信息，这个是不用管的，应为我这个eclipse有时候会莫名的提示这个错误。

其中，controller包下存放控制层文件，dao下存放各个model类相关的数据库操作接口，bean下放置各种model类，mappers下放置各个dao对应的映射文件，service服务层就不说了，放置各种service接口，impl是其具体实现类。

2、web.xml配置

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"><display-name>TestDemo</display-name><welcome-file-list><welcome-file>index.html</welcome-file><welcome-file>index.htm</welcome-file><welcome-file>index.jsp</welcome-file><welcome-file>default.html</welcome-file><welcome-file>default.htm</welcome-file><welcome-file>default.jsp</welcome-file><welcome-file>login.jsp</welcome-file></welcome-file-list><servlet><servlet-name>springDispatcherServlet</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><!-- Map all requests to the DispatcherServlet for handling --><servlet-mapping><servlet-name>springDispatcherServlet</servlet-name><url-pattern>/</url-pattern></servlet-mapping><!-- needed for ContextLoaderListener --><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:applicationContext.xml</param-value></context-param><!-- Bootstraps the root web application context before servlet initialization --><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!--解决POST乱码问题--> <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、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"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"><import resource="myBatisContext.xml"/><import resource="daoContext.xml"/></beans>

4、daoContext.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.kun.dao.UserMapper"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
</beans>

5、db.properties 文件

db.user=sadb.password=123db.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriverdb.jdbcUrl=jdbc:sqlserver://localhost:1433;databaseName=demomaxActive=10initialSize=5

6、myBatisContext.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:tx="http://www.springframework.org/schema/tx"xmlns:aop="http://www.springframework.org/schema/aop"xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsdhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd"><!-- 导入资源文件 --><context:property-placeholder location="classpath:db.properties"/><!--1、阿里云数据源  --><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"><property name="defaultAutoCommit" value="false"/><property name="driverClassName" value="${db.driverClass}"/><property name="url" value="${db.jdbcUrl}"/><property name="username" value="${db.user}"/> <property name="password" value="${db.password}"/><property name="filters" value="stat" /><property name="maxActive"><value>${maxActive}</value></property><property name="initialSize"><value>${initialSize}</value></property></bean><!--2、配置SqlSessionFactory --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><!-- 自动扫描mapper目录，省掉手动配置映射文件--> <property name="mapperLocations" value="classpath:com/kun/mapper/*.xml" /><property name="configurationProperties"><props><prop key="databaseType">oracle</prop></props></property></bean><!--3、事务 --><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><!-- 配置事务传播特性 --><tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="save*" propagation="REQUIRED" /><tx:method name="delete*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><tx:method name="insert*" propagation="REQUIRED" /><tx:method name="*" read-only="true" /></tx:attributes></tx:advice>    <!-- 切点 --><aop:config><aop:pointcut id="point-cut" expression="execution(* com.kun.service..*.*(..))" /><aop:advisor advice-ref="txAdvice" pointcut-ref="point-cut" /></aop:config></beans>

7、springmvc.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:mvc="http://www.springframework.org/schema/mvc"xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsdhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd"><!-- 扫描Spring注解 --><context:component-scan base-package="com.kun.*"/><!--启动springmvc注解  --><mvc:annotation-driven/><!-- 指定静态资源(.css,.js)不由前端控制器处理 --><mvc:default-servlet-handler/><!-- 视图解析器 --><bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/"/><property name="suffix" value=".jsp"/></bean><!-- 文件上传解析器 --><bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"><property name="defaultEncoding" value="utf-8"/><property name="maxUploadSize" value="209715200"/><property name="resolveLazily" value="true"/></bean><!-- 解决使用@ResponseBody 的中文乱码。 -->      <bean class="com.kun.controller.UTF8StringBeanPostProcessor"></bean>  </beans>

8、功能实现

a、登录

b、主界面

c、增加

d、修改

e、删除

详细的html

login.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %><%@include file="/tag.jsp" %><html><head>    <title>登录</title>    <%@include file="/header.jsp" %>    <script>        function login() {            var username = $("#username").textbox("getValue");            var pass = $("#pass").textbox("getValue");            $.ajax({                type: "POST",                url: "/TestDemo/u/login",                data: {username: username, pass: pass},                dataType: 'json',                success: function (result) {                    if (result.success) {                        window.location.href = "show.jsp";                    }else{                    $.messager.alert("系统提示", "用户名或密码错误");                    }                }            });        }    </script></head><body><div style="width:600px;margin:150px auto;">    <div class="easyui-panel" title="欢迎登录"         style="width:500px;height:300px;padding:10px;text-align:center; overflow:hidden;"         data-options="closable:false,collapsible:false,minimizable:false,maximizable:false">        <form id="loginForm" method="post">            <table style="margin:50px auto;">                <input type="hidden" name="id">                <tr>                    <td></td>                    <td><label>登录名:</label></td>                    <td><input class="easyui-textbox" type="text" id="username" name="username"                               data-options="required:true,value:'123'"/></td>                    <td></td>                </tr>                <tr>                    <td></td>                    <td><label>密 码:</label></td>                    <td><input class="easyui-passwordbox" type="text" id="pass" name="pass"                               data-options="required:true,value:'123'"/></td>                    <td></td>                </tr>                <tr style="height: 20px;"></tr>                <tr>                    <td colspan="4" align="center">                        <a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-save'"                           onclick="javascript:login()">登录</a>                    </td>                </tr>            </table>        </form>    </div></div></body></html>

show.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"    pageEncoding="utf-8"%>    <%@include file="/tag.jsp" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>首页</title><%@include file="/header.jsp" %><script type="text/javascript">    var url;    function searchUser() {        $("#dg").datagrid('load', {            "username" : $("#s_userName").val()        });    }    function openUserAddDialog() {        $("#dlg").dialog("open").dialog("setTitle", "添加用户信息");        url = "${pageContext.request.contextPath}/u/add";    }    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}/u/add?id=" + row.id;    }        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 resetValue() {        $("#username").val("");        $("#pass").val("");        $("#zsxm").val("");        $("#email").val("");        $("#phone").val("");        $("#rolename").combobox("setValue", "");    }    function closeUserDialog() {        $("#dlg").dialog("close");        resetValue();    }    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}/u/delete", {                    ids : ids                }, function(result) {                    if (result.success) {                        $.messager.alert("系统提示", "数据已成功删除！");                        $("#dg").datagrid("reload");                    } else {                        $.messager.alert("系统提示", "数据删除失败，请联系系统管理员！");                    }                }, "json");            }        });    }</script></head><body style="margin: 1px">    <table id="dg" title="用户管理" class="easyui-datagrid" fitColumns="true"        pagination="true" rownumbers="true"        url="${pageContext.request.contextPath}/u/select" 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="pass" width="50" align="center">密码</th>                <th field="zsxm" 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"                onkeydown="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="pass" name="pass"                            class="easyui-validatebox" required="true" /> <span                            style="color: red">*</span>                        </td>                    </tr>                    <tr>                        <td>真实姓名：</td>                        <td><input type="text" id="zsxm" name="zsxm"                            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></body></html>

UserController.java：

package com.kun.controller;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.json.JSONObject;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestParam;import org.springframework.web.bind.annotation.ResponseBody;import com.google.gson.Gson;import com.kun.bean.UserInfo;import com.kun.service.IUserService;import net.sf.json.JSONArray;@Controller@RequestMapping("u")//activity访问名称public class UserAction {private Gson gson=new Gson();@Autowiredprivate IUserService service;@Autowiredprivate HttpServletRequest request;@Autowiredprivate HttpServletResponse response;JSONObject jsonObject = new JSONObject();int result=0;//登录@RequestMapping("login")//方法访问地址@ResponseBody//返回中文数据private String login(UserInfo info){try {response.setContentType("text/plain;charset=UTF-8"); boolean b=service.Login(info);if(b){jsonObject.put("success", true);}else{jsonObject.put("success", false);}ResponseUtil.write(response, jsonObject);return null;} catch (Exception e) {e.printStackTrace();}return null;}@RequestMapping("add")//方法访问地址@ResponseBody//返回中文数据private String adduser(UserInfo u){try {response.setContentType("text/plain;charset=UTF-8"); if(u.getId()==0){result=service.Add(u);}else{result=service.update(u);}if(result>0){jsonObject.put("success", true);}else{jsonObject.put("success", false);}ResponseUtil.write(response, jsonObject);return null;} catch (Exception e) {e.printStackTrace();}return null;}//分页查询@RequestMapping("select")@ResponseBody//返回中文数据public String list(@RequestParam(value="page",required=false) String page,@RequestParam(value="rows",required=false) String rows,UserInfo user) throws Exception{//String pages=request.getParameter("page");//String rowss=request.getParameter("rows");JSONObject jsonObject = new JSONObject();PageBeanUtils beanUtils=new PageBeanUtils(Integer.parseInt(page), Integer.parseInt(rows));Map<String, Object> map=new HashMap<String, Object>();map.put("username",StringUtil.like(user.getUsername()));map.put("start", beanUtils.getStart());map.put("size", beanUtils.getPagesize());List<UserInfo> uinfo=service.SelectShow(map);Long total=service.getTotal(map);JSONObject result=new JSONObject();JSONArray arrays=JSONArray.fromObject(uinfo);result.put("rows",arrays);result.put("total", total);ResponseUtil.write(response, result);return null;}@RequestMapping("delete")@ResponseBody//返回中文数据private String delete(@RequestParam(value="ids") String uid){try {response.setContentType("text/plain;charset=UTF-8");String[] ids=uid.split(",");for(String id:ids){result=service.delete(id);result=result++;}if(result>0){jsonObject.put("success", true);}else{jsonObject.put("success", false);}ResponseUtil.write(response, jsonObject);return null;} catch (Exception e) {e.printStackTrace();}return null;}}

UTF8StringBeanPostProcessor.java

package com.kun.controller;import java.nio.charset.Charset;  import java.util.ArrayList;  import java.util.List;    import org.springframework.beans.BeansException;  import org.springframework.beans.factory.config.BeanPostProcessor;  import org.springframework.http.MediaType;  import org.springframework.http.converter.StringHttpMessageConverter;    /**   * 解决spring MVC3 中@ResponseBody的中文乱码问 */    public class UTF8StringBeanPostProcessor implements BeanPostProcessor {        public Object postProcessAfterInitialization(Object bean, String beanName) throws BeansException {            if (bean instanceof StringHttpMessageConverter) {                MediaType mediaType = new MediaType("text", "plain", Charset.forName("UTF-8"));                List<MediaType> types = new ArrayList<MediaType>();                types.add(mediaType);                ((StringHttpMessageConverter) bean).setSupportedMediaTypes(types);            }            return bean;        }            public Object postProcessBeforeInitialization(Object bean, String beanName) throws BeansException {            return bean;        }    }  

StringUtil.java

package com.kun.controller;/** * 字符串工具 *  * @author Administrator * */public class StringUtil {/** * 判断是否为空 */public static boolean isEmpty(String str) {if (str == null || "".equals(str.trim())) {return true;} else {return false;}}/** * 模糊查询 */public static String like(String str){if(isEmpty(str)){return null;}else{return "%"+str+"%";}}}

ResponseUtil.java

package com.kun.controller;import java.io.PrintWriter;import javax.servlet.http.HttpServletResponse;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();    }}

PageBeanUtils.java

package com.kun.controller;/** * 分页Model类 *  * @author Administrator * */public class PageBeanUtils {private int page;// 第几页private int pagesize;// 每页记录数private int start;// 起始页public PageBeanUtils(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;}}

UserMapper.java

package com.kun.dao;import java.util.List;import java.util.Map;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import com.kun.bean.UserInfo;public interface UserMapper {boolean login(UserInfo u);List<UserInfo> SelectShow(Map<String, Object> map);int addUser(UserInfo u);Long getTotal(Map<String, Object> map);int update(UserInfo u);int delete(String id);}

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.kun.dao.UserMapper" > <resultMap type="com.kun.bean.UserInfo" id="UserResult">        <result property="id" column="id" />        <result property="username" column="username" />        <result property="pass" column="pass" />        <result property="zsxm" column="zsxm" />        <result property="email" column="email" />        <result property="phone" column="phone" />        <result property="rolename" column="rolename" />    </resultMap><!-- 登录 --> <select id="login" parameterType="com.kun.bean.UserInfo" resultType="boolean"> select count(*) from userinfo where  username=#{username} and pass=#{pass} </select> <!-- 分页查询 --> <select id="SelectShow" parameterType="com.kun.bean.UserInfo" resultMap="UserResult">   SELECT TOP ${size} * FROM userinfo WHERE (id NOT IN(SELECT TOP ${start} id FROM userinfo ORDER BY id))             <if test="username!=null and username!='' ">                and username like #{username} ORDER BY id            </if> <!-- <if test="start!=null and size!=null">   SELECT TOP ${size} * FROM userinfo WHERE (id NOT IN(SELECT TOP (${size} * ${start}) id FROM userinfo ORDER BY id))ORDER BY id </if> --> </select>  <select id="getTotal" parameterType="com.kun.bean.UserInfo" resultType="Long">        select count(*) from userInfo        <where>            <if test="username!=null and username!='' ">                username like #{username}            </if>        </where>    </select>    <!-- 添加 -->    <insert id="addUser" parameterType="com.kun.bean.UserInfo">    insert into userinfo values(#{username},#{pass},#{zsxm},#{email},#{phone},#{rolename})    </insert>    <!-- 修改 -->    <update id="update" parameterType="com.kun.bean.UserInfo">    update userinfo    <set>    <if test="username!=null and username!=''" >username=#{username},</if>    <if test="pass!=null and pass!=''" >pass=#{pass},</if>    <if test="zsxm!=null and zsxm!=''" >zsxm=#{zsxm},</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>        <!-- 删除 -->    <delete id="delete" parameterType="String">    delete from userinfo where id=#{id}    </delete></mapper>

IUserService.java

package com.kun.service;import java.util.List;import java.util.Map;import com.kun.bean.UserInfo;public interface IUserService {boolean Login(UserInfo u);public int Add(UserInfo u);public int update(UserInfo u);public List<UserInfo> SelectShow(Map<String, Object> map);public Long getTotal(Map<String, Object> map);public int delete(String id);}

UserServiceImpl.java

package com.kun.service.impl;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.kun.bean.UserInfo;import com.kun.dao.UserMapper;import com.kun.service.IUserService;@Servicepublic class UserServiceImpl implements IUserService{@Autowiredprivate UserMapper mapper;//public boolean Login(UserInfo u) {////调用持久层//return mapper.selectUser(u);//}public int Add(UserInfo u) {return mapper.addUser(u);}public List<UserInfo> SelectShow(Map<String, Object> map) {return mapper.SelectShow(map);}public Long getTotal(Map<String, Object> map) {return mapper.getTotal(map);}public boolean Login(UserInfo u) {return mapper.login(u);}public int update(UserInfo u) {return mapper.update(u);}public int delete(String id) {return mapper.delete(id);}}

最后献上我的pox.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/maven-v4_0_0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.kun</groupId>  <artifactId>TestDemo</artifactId>  <packaging>war</packaging>  <version>0.0.1-SNAPSHOT</version>  <dependencies><!-- spring面向切面编程 --><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>4.1.7.RELEASE</version><exclusions><exclusion><groupId>commons-logging</groupId><artifactId>commons-logging</artifactId></exclusion></exclusions></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aspects</artifactId><version>4.1.7.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aop</artifactId><version>4.1.7.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>4.1.7.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>4.1.7.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>4.1.7.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-orm</artifactId><version>4.1.7.RELEASE</version></dependency><!-- 必须要有 --><dependency><groupId>org.aopalliance</groupId><artifactId>com.springsource.org.aopalliance</artifactId><version>1.0.0</version></dependency><dependency><groupId>org.aspectj</groupId><artifactId>com.springsource.org.aspectj.weaver</artifactId><version>1.6.8.RELEASE</version></dependency><!-- ==================spring引入完毕======================== --><!-- myBatis --><!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.4.2</version></dependency><!-- springmyBatis适配包 --><!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.0</version></dependency><!-- MySql驱动包 --><!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><!-- <dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.41</version></dependency> --><!-- sqlserver驱动包 --><dependency><groupId>com.microsoft.sqlserver</groupId><artifactId>sqljdbc4</artifactId><version>4.0</version></dependency><!-- oracle驱动包 --><!-- <dependency><groupId>com.oracle</groupId><artifactId>ojdbc6</artifactId><version>11.2.0.1.0</version><packaging>jar</packaging></dependency> --><!-- mybatis generator逆向工程对应数据库生成实体类 --><!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core --><dependency><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-core</artifactId><version>1.3.5</version></dependency><!-- 数据库连接池c3p0 --><!-- https://mvnrepository.com/artifact/c3p0/c3p0 --><dependency><groupId>c3p0</groupId><artifactId>c3p0</artifactId><version>0.9.1</version></dependency><!-- 阿里巴巴的数据库连接池 --><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.0.16</version></dependency><!-- ==============jstl servlet-api junit================== --><!-- https://mvnrepository.com/artifact/jstl/jstl --><dependency><groupId>jstl</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api --><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>3.0.1</version><scope>provided</scope></dependency><!-- https://mvnrepository.com/artifact/junit/junit --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency><!-- 文件过滤 --><dependency><groupId>commons-fileupload</groupId><artifactId>commons-fileupload</artifactId><version>1.3.1</version></dependency><!-- https://mvnrepository.com/artifact/commons-pool/commons-pool --><dependency><groupId>commons-pool</groupId><artifactId>commons-pool</artifactId><version>1.6</version></dependency><!-- https://mvnrepository.com/artifact/commons-logging/commons-logging --><dependency><groupId>commons-logging</groupId><artifactId>commons-logging</artifactId><version>1.1.1</version></dependency><dependency><groupId>commons-lang</groupId><artifactId>commons-lang3</artifactId><version>3.1</version></dependency><dependency><groupId>ezmorph</groupId><artifactId>ezmorph</artifactId><version>1.0.6</version></dependency><dependency><groupId>json-lib</groupId><artifactId>json-lib</artifactId><version>2.1</version></dependency><dependency><groupId>commons-collections</groupId><artifactId>commons-collections</artifactId><version>3.1</version></dependency><!-- 添加json支持ajax --><!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind --><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.8.8</version></dependency><dependency><groupId>org.apache.commons</groupId><artifactId>commons-io</artifactId><version>2.5</version><scope>compile</scope><optional>false</optional></dependency></dependencies></project>

希望对小伙伴们有帮助