mybatis小结

application.xml

<context:property-placeholder location="config.properties" />-----------加载properties文件

<bean id="c3p0DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"-----配置据库属性
destroy-method="close">

</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">----读取mybatis.xml配置文件

<property name="dataSource" ref="c3p0DataSource" />
<property name="configLocation" value="MyBatis-Configuration.xml" />
</bean>

MyBatis-Configuration.xml

<configuration>  
    <typeAliases>  
        <typeAlias alias="user" type="daisy.com.Student"/>  
    </typeAliases>       
    <!-- 指定映射文件 -->  
    <mappers>  
        <mapper resource="StudentDaoMapper.xml" />  
    </mappers>  
</configuration> 

映射文件

<?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="daisy.com.StudentMapper">
  <parameterMap type="daisy.com.Student" id="parameterMapStudent">
    <parameter property="id"/>
    <parameter property="name"/>
    <parameter property="classId"/>
  </parameterMap>
  
  <resultMap type="daisy.com.Student" id="resultMapStudent">
    <result property="id" column="id"/>
    <result property="name" column="name"/>
    <result property="classId" column="classId"/>
  </resultMap>
  
  <insert id="insertStudent" parameterMap="parameterMapStudent">
    INSERT INTO Student(id,name,classId)
    VALUES(?,?,?)
  </insert>
  <select id="countAll" resultType="int">
        select count(*) c  from Student;
  </select>
  <select id="getAllStudent"  resultMap="resultMapStudent">
    SELECT * FROM Student
  </select>
  <select id="getById" parameterType="int" resultMap="resultMapStudent">
    SELECT * FROM Student
    WHERE id=#{value}
  </select>
  <delete id="deleteStudent" parameterType="int">
    DELETE FROM Student 
    WHERE id=#{value}
  </delete>
  <update id="updateStudent" parameterType="java.util.Map">
    UPDATE Student
    SET name=#{name}
    WHERE id=#{id}
  </update>
</mapper>