스프링MVC : iBatis, MyBatis

 

* mybatis-config.xml

<configuration>
	
	<typeAliases>
		<package name="com.ps.wsol"/>
	</typeAliases>

</configuration>

 

* 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.ps.wsol.mapper.UserMapper">
	
	<select id="listUser" resultType="UserVO">
	<![CDATA[
		SELECT useridx, userid, userpw, username, useremail, userdatereg, userdatemod 
		FROM wsuser 
		ORDER BY useridx DESC 
	]]>
	</select>
	
	
	<select id="detailUser" resultType="UserVO">
		SELECT * FROM wsuser WHERE userid = #{userid} 
	</select>
	
	
	<insert id="insertUser">
	<![CDATA[
		INSERT INTO wsuser (
			userid, 
			userpw, 
			username, 
			useremail, 
			userdatereg 
			) 
		VALUES (
			#{userid}, 
			#{userpw},
			#{username},  
			#{useremail}, 
			now() 
			)
	]]>
	</insert>
	
	
	<update id="updateUser">
	<![CDATA[
		UPDATE wsuser SET 
			userpw		= #{userpw}, 
			username	= #{username},
			useremail	= #{useremail},
			userdatemod	= now() 
		WHERE userid = #{userid} 
	]]>
	</update>
	
	
	<delete id="deleteUser">
		DELETE FROM wsuser WHERE userid = #{userid} 
	</delete>
	
</mapper>