動(dòng)力節(jié)點(diǎn)小編來(lái)給大家舉例介紹一下最基本的增刪改查。

web.xml，主要用于配置Filter，Servlet，Lisenter等

<?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_3_1.xsd"
    version="3.1">
    <display-name>usermanage</display-name>
    <!-- 配置spring容器初始化監(jiān)聽器 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring/applicationContext*.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!-- 配置編碼的過(guò)濾器 -->
    <filter>
        <filter-name>encoding</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>utf8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encoding</filter-name>
        <!--攔截路徑 -->
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <!-- 配置DispatcherServlet -->
<servlet>
<servlet-name>usermanage</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/usermanage-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>usermanage</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
    <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-list>
</web-app>

usermanage-servlet.xml，對(duì)應(yīng)于Controller

主要步驟：配置注解驅(qū)動(dòng);開啟注解掃描;解決靜態(tài)資源的攔截問(wèn)題;配置視圖解析器

<?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:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
    <mvc:view-controller path="/user/users" view-name="users"/>
    <mvc:view-controller path="/user/page/add" view-name="user-add"/>
    <mvc:view-controller path="/user/page/edit" view-name="user-edit"/>
    <!-- 配置注解驅(qū)動(dòng)：替代推薦使用的注解映射器和適配器，提供對(duì)json的支持 -->
    <mvc:annotation-driven />    
    <!-- 開啟注解掃描，和spring是一樣的 -->
    <context:component-scan base-package="com.cn.usermanage.controller" />    
    <!-- 解決靜態(tài)資源被攔截的問(wèn)題 -->
    <mvc:default-servlet-handler/>        
    <!-- 配置視圖解析器 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>        
</beans>

applicationContext.xml 中需要配置(省略數(shù)據(jù)庫(kù)的配置文件)

<!-- 注解掃描 -->
    <context:component-scan base-package="com.cn.usermanage.service"/>
    <!-- 加載資源文件 -->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!-- 配置數(shù)據(jù)源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="${jdbc.user}" />
        <property name="password" value="${jdbc.password}" />
        <property name="jdbcUrl" value="${jdbc.url}" />
        <property name="driverClass" value="${jdbc.driver}" />    
    </bean>

applicationContext-mybatis.xml中需要配置，和利用mybatis操作數(shù)據(jù)庫(kù)相關(guān)

步驟：需要初始化SqlsessionFactory對(duì)象;配置Mapper接口的包掃描

<!-- spring初始化bean的方式： 1.無(wú)參構(gòu)造 2.靜態(tài)工廠方法 3.實(shí)例化工廠 4.工廠bean -->
    <bean id="sqlSessionFactory"
        class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 指定數(shù)據(jù)源 -->
        <property name="dataSource" ref="dataSource" />
        <!-- 指定全局配置文件 -->
        <property name="configLocation"
            value="classpath:mybatis/mybatis-config.xml"></property>
        <!-- 指定映射文件(不需要mybatis-config.xml中映射),利用通配符匹配任意目錄任意xml配置 -->
                <property name="mapperLocations" value="classpath:mybatis/mappers/**/*.xml"></property>
        <!-- 開啟別名掃描 -->
        <property name="typeAliasesPackage"
            value="com.cn.usermanage.pojo"></property>
    </bean>
                <!-- 配置mapper接口的包掃描 -->
     <mybatis-spring:scan
        base-package="com.cn.usermanage.mapper" />

mybatis-config.xml只需要配置行為參數(shù)即可

<settings>
        <setting name="mapUnderscoreToCamelCase" value="true" />
    </settings>

實(shí)體類對(duì)象User可以通過(guò)注解的方式對(duì)屬性進(jìn)行數(shù)據(jù)校驗(yàn),常用的注解如:

@Null 驗(yàn)證對(duì)象是否為 null

@NotNull 驗(yàn)證對(duì)象是否不為 null

@Size(min,max) 驗(yàn)證對(duì)象長(zhǎng)度是否在給定的范圍內(nèi)

@Past 驗(yàn)證 Date 和 Calendar 對(duì)象是否在當(dāng)前時(shí)間之前

@Future 驗(yàn)證 Date 和 Calendar 對(duì)象是否在當(dāng)前時(shí)間之后

@Pattern 驗(yàn)證 String 對(duì)象是否符合正則表達(dá)式的規(guī)則

@NotBlank 檢查字符串是不是 Null，被 Trim 的長(zhǎng)度是否大于0，只對(duì)字符串，且會(huì)去掉前后空格

@URL 驗(yàn)證是否是合法的 url

@Email 驗(yàn)證是否是合法的郵箱

User.java

public class User {
    private Long id;
    // 用戶名
    @NotNull
    @Length(min=6, max=20, message="用戶名長(zhǎng)度不合法")
    private String userName;
    // 密碼
    @JsonIgnore
    @NotNull
    @Length(min=6, max=20, message="用戶名長(zhǎng)度不合法")
    private String password;
    // 姓名
    @NotNull
    private String name;
    // 年齡
    @NotNull
    private Integer age;
    // 性別，1男性，2女性
    @NotNull
    private Integer sex;
    // 出生日期
    @NotNull
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @Past(message="生日必須是過(guò)去式")
    private Date birthday;
    // 創(chuàng)建時(shí)間
    private Date created;
    // 更新時(shí)間
    private Date updated;}

UserController.java

@Controller
@RequestMapping("user")
public class UserController {
    @Autowired
    private UserService userService;
    @RequestMapping("users")
    public String toUsers() {
        return "users";
    }
    @RequestMapping("list")
    @ResponseBody
    public Map<String, Object> queryUserAll() {
        Map<String, Object> map = new HashMap<>();
        // 查詢總條數(shù)
        Long total = this.userService.queryTotal();
        map.put("total", total);
        List<User> users = this.userService.queryUserAll();
        map.put("rows", users);
        return map;
    }
        
    @RequestMapping("save")
    @ResponseBody
    public Map<String, String>  saveUser(@Valid User user,BindingResult result)
    {
        Map<String,String> map=new HashMap<>();
        if(result.hasErrors())
        {
            //輸出到控制臺(tái)
            System.out.println(result.getAllErrors());            //status用于前端校驗(yàn)是否執(zhí)行成功
            map.put("status", "500");
            return map;           
        }
        //調(diào)用Service方法新增用戶信息
        Boolean flag=this.userService.saveUser(user);
        if(flag)
            map.put("status", "200");
        else 
            map.put("status", "500");
        return map;
    }       
    //修改    
    @RequestMapping("edit")
    @ResponseBody
    public Map<String, String>  editUser(@Valid User user)
    {
        Map<String,String> map=new HashMap<>();
        //調(diào)用Service方法新增用戶信息
        Boolean flag=this.userService.editUser(user);
        if(flag)
            map.put("status", "200");
        else 
            map.put("status", "500");
        return map;
    }        
    //刪除        
    @RequestMapping("delete")
    @ResponseBody
    public Map<String, String>  deleteUser(@RequestParam("ids")List<Long> ids )
    {
        Map<String,String> map=new HashMap<>();
        //調(diào)用Service方法新增用戶信息
        Boolean flag=this.userService.deleteUserByIds(ids);
        if(flag)
            map.put("status", "200");
        else 
            map.put("status", "500");
        return map;
    }
}