<?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.cbh.dao.IStudent"><!--
<resultMap type="student" id="studentmap">
<id column="tid" property="id"/>
<result column="tname" property="name"/>
</resultMap> -->
<insert id="insertStudent" >
insert into
student1(name,age,score) values(#{name}, #{age}, #{score})
</insert>
<insert id="insertstudentCacheId" >
insert into
student1(name,age,score) values(#{name}, #{age}, #{score})
<selectKey resultType="int" keyProperty="id" order="AFTER">
select @@identity
</selectKey>
</insert>
<delete id="deleteStudent">
delete from student1 where id=#{xxx}
</delete>
<update id="updateStudent">
update student1 set name=#{name},age=#{age},score=#{score} where id=#{id}
</update>
<select id="selectAllStudent" resultType="student">
select id,name,age,score from student1
</select>
<select id="selectStudentById" resultType="student">
select id,name,age,score from student1 where id=#{hhh}
</select><select id="selectStudentsByName" resultType="student">
select id,name,age,score from student1 where name like '%' #{jjj} '%'
</select>
</mapper>
<?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>
<properties resource="jdbc_mysql.properties" />
<typeAliases>
<!-- <typeAlias type="com.cbh.beans.Student" alias="student"/> -->
<package name="com.cbh.beans"/>
</typeAliases>
<environments default="onlineEM">
<environment id="onlineEM">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/cbh/dao/mapper.xml" />
</mappers>
</configuration>