我的spring是3.2，mybatis是3.4

1 引入user libarary，我的jar文件如下

//spring mvc core

springMVC\spring-web-3.2..RELEASE.jar

springMVC\spring-webmvc-3.2..RELEASE.jar

//spring core

spring3.2core\commons-logging-1.2.jar

spring3.2core\spring-beans-3.2..RELEASE.jar

spring3.2core\spring-context-3.2..RELEASE.jar

spring3.2core\spring-core-3.2..RELEASE.jar

spring3.2core\spring-expression-3.2..RELEASE.jar   //spring自己的表达式语言，如果不用可以不添加

//mybatis core

mybatis3.4core\asm-5.2.jar

mybatis3.4core\cglib-3.2..jar

mybatis3.4core\commons-logging-1.2.jar

mybatis3.4core\log4j-1.2..jar

mybatis3.4core\mybatis-3.4..jar

//DBconnector

MySQLConnector\c3p0-0.9.1.2.jar

MySQLConnector\mysql-connector-java-5.1.-bin.jar

//translation

springTx\spring-jdbc-3.2..RELEASE.jar

springTx\spring-tx-3.2..RELEASE.jar

//AOP

springAOP\aopalliance.jar

springAOP\aspectjrt.jar

springAOP\aspectjweaver.jar

springAOP\spring-aop-3.2..RELEASE.jar

//mybatis spring
mybatisSpring\mybatis-spring-1.3.1.jar

//json
json\jackson-core-asl-1.9.2.jar
json\jackson-mapper-asl-1.9.2.jar

2 创建表文件t_student

CREATE TABLE t_student(

id INT PRIMARY KEY AUTO_INCREMENT,

NAME VARCHAR() NOT NULL,

age INT());

3 创建实体类Student

package com.huitong.entity;

public class Student {

    private Integer sid;

    private String sname;

    private Integer sage;

    public Integer getSid() {

        return sid;

    }

    public void setSid(Integer sid) {

        this.sid = sid;

    }

    public String getSname() {

        return sname;

    }

    public void setSname(String sname) {

        this.sname = sname;

    }

    public Integer getSage() {

        return sage;

    }

    public void setSage(Integer sage) {

        this.sage = sage;

    }

}

4配置实体类的映射文件StudentMapper.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.huitong.entity.Student">

    <resultMap type="com.huitong.entity.Student" id="studentMap">

        <id column="id" property="sid"/>

        <result column="name" property="sname"/>

        <result column="age" property="sage"/>

    </resultMap>

    <insert id="add" parameterType="com.huitong.entity.Student">

        INSERT INTO t_student(NAME, age) VALUES(#{sname},#{sage})

    </insert>

</mapper>

5 Student的 dao/service/action

//StudentDao

package com.huitong.dao;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import com.huitong.entity.Student;

public class StudentDao {

    private SqlSessionFactory sqlSessionFactory;

    public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {

        this.sqlSessionFactory = sqlSessionFactory;

    }

    public void add(Student stu) throws Exception{

        SqlSession sqlSession = sqlSessionFactory.openSession();

        sqlSession.insert(Student.class.getName() + ".add", stu);

        sqlSession.close();

    }

}

//StudentService

package com.huitong.service;

import com.huitong.dao.StudentDao;

import com.huitong.entity.Student;

public class StudentService {

    private StudentDao studentDao;

    public void setStudentDao(StudentDao studentDao) {

        this.studentDao = studentDao;

    }

    public void add(Student stu) throws Exception{

        studentDao.add(stu);

    }

}

//StudentAction

package com.huitong.action;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;

import com.huitong.entity.Student;

import com.huitong.service.StudentService;

@Controller

@RequestMapping(value="/student")

public class StudentAction {

    private StudentService StudentService;

    @Resource(name="studentService")

    public void setStudentService(StudentService studentService) {

        StudentService = studentService;

    }

    @RequestMapping(value="/register")

    public String register(Student stu, Model model) throws Exception{

        StudentService.add(stu);

        model.addAttribute("student", stu);

        return "success";

    }

}

6 mybatis的配置文件mybatis.xml

<?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>

    <mappers>

        <mapper resource="com/huitong/entity/StudentMapper.xml"/>

    </mappers>

</configuration>

7 spring/spring mvc配置到一个文件中spring.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:p="http://www.springframework.org/schema/p"

    xmlns:context="http://www.springframework.org/schema/context"

    xmlns:aop="http://www.springframework.org/schema/aop"

    xmlns:tx="http://www.springframework.org/schema/tx"

    xmlns:mvc="http://www.springframework.org/schema/mvc"

    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/tx

        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd

        http://www.springframework.org/schema/aop

        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd

        http://www.springframework.org/schema/mvc

        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">

        <!--  dataSource -->

        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

            <property name="driverClass" value="com.mysql.jdbc.Driver"></property>

            <property name="jdbcUrl" value="jdbc:mysql:///day17?useSSL=true"></property>

            <property name="user" value="root"></property>

            <property name="password" value=""></property>

            <property name="initialPoolSize" value=""></property>

            <property name="maxPoolSize" value=""></property>

            <property name="maxStatements" value=""></property>

            <property name="acquireIncrement" value=""></property>

        </bean>

        <!--  sessionFactory:datasource/xml配置文件 -->

        <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

            <property name="dataSource" ref="dataSource"></property>

            <property name="configLocation" value="classpath:mybatis.xml"></property>

        </bean>

        <!--  dao/service/action -->

        <bean id="studentDao" class="com.huitong.dao.StudentDao">

            <property name="sqlSessionFactory" ref="sessionFactory"></property>

        </bean>

        <bean id="studentService" class="com.huitong.service.StudentService">

            <property name="studentDao" ref="studentDao"></property>

        </bean>

        <!-- <bean id="studentAction" class="com.huitong.action.StudentAction">

            <property name="studentService" ref="studentService"></property>

        </bean> -->

        <!-- 使用扫描方式 -->

        <context:component-scan base-package="com.huitong.action"></context:component-scan>

        <!--  transaction -->

        <!-- 4.1 txManager -->

        <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

            <property name="dataSource" ref="dataSource"></property>

        </bean>

        <!-- 4.2 txAdvice -->

        <tx:advice id="txAdvice" transaction-manager="txManager">

            <tx:attributes>

                <tx:method name="get*" read-only="true"/>

                <tx:method name="query*" read-only="true"/>

                <tx:method name="*"/>

            </tx:attributes>

        </tx:advice>

        <!-- 4.3 AOP -->

        <aop:config>

            <aop:pointcut expression="execution(* com.huitong.service.*.*(..))" id="pt"/>

            <aop:advisor advice-ref="txAdvice" pointcut-ref="pt"/>

        </aop:config>

        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" >

            <property name="prefix" value="/jsp/"></property>

            <property name="suffix" value=".jsp"></property>

        </bean>

</beans>

说明：在spring.xml文件中，SqlSessionFactory说明了mybatis的配置文件位置。也对spring mvc进行了配置，指示了扫描哪些文件，视图处理器。其他的就是spring常规配置了。

对mapping映射器进行扫描方式。

如果项目比较大也可以将配置文件进行拆分。

8 web.xml中配置springmvc核心servlet：dispatcherservlet。字符编码过滤器:CharacterEncodingFilter

<?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_2_5.xsd" id="WebApp_ID" version="2.5">

    <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:spring.xml</param-value>

        </init-param>

    </servlet>

    <servlet-mapping>

        <servlet-name>DispatcherServlet</servlet-name>

        <url-pattern>*.action</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-</param-value>

        </init-param>

    </filter>

    <filter-mapping>

        <filter-name>CharacterEncodingFilter</filter-name>

        <url-pattern>/*</url-pattern>

    </filter-mapping>

</web-app>

最新文章

  1. .NET基础拾遗（3）字符串、集合和流
  2. C++ new和delete具体操作符是怎样的
  3. Java，Android 项目导入Eclipse常见错误
  4. windows WSABUF 结构在IOCP 中应用时两个成员变量的意义
  5. Hibernate day01笔记
  6. jqyery dataTable 基本用法
  7. STM32 USB CAN 学习笔记 - 共享RAM的用法
  8. jquery.idTabs使用方法
  9. 数据结构(左偏树，可并堆)：BNUOJ 3943 Safe Travel
  10. 那些我希望在一开始使用 Zsh(oh-my-zsh) 时就知道的
  11. Android 应用程序签名
  12. 更多RANK37
  13. ActiveMQ 入门helloworld
  14. 多个.txt文件合并到一个.txt文件中
  15. cxf整合spring中出现的错误
  16. RocketMQ源码 — 四、 Consumer 接收消息过程
  17. 关于 Cortex-M3 的双堆栈机制
  18. distribution 分发数据库 灾难恢复 备份恢复
  19. python2.7.9安装mysql-python模块
  20. PHP学习-类

热门文章

  1. [转]115个Java面试题和答案——终极列表（上）
  2. WPF Interaction框架简介（一）——Behavior
  3. 前端工业化工具Gulp初体验
  4. 封装log4cp p
  5. nginx服务器URL无法自动添加index.php
  6. easyui datagrid 动态生成列
  7. ecshop ecmall shopex
  8. 正规方程 Normal Equation
  9. FreeMarker最简单的例子（1）
  10. 【实践】用for-in 循环实现三联联动