Cacher is the code snippet organizer for pro developers

<?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.sdttttt.server.sdtttttnetty.dao.mapper.UserMapper">
    
    <insert id="createUser"
            keyProperty="id"
            useGeneratedKeys="true"
            parameterType="com.sdttttt.server.sdtttttnetty.dao.table.User">
        INSERT INTO user values(null , #{username} , #{password} , #{create_time} , #{update_time})
    </insert>

    <select id="selectUser"
            resultType="com.sdttttt.server.sdtttttnetty.dao.table.User"
            parameterType="com.sdttttt.server.sdtttttnetty.dao.table.User">
        SELECT * FROM user WHERE username = #{username} AND password = #{password}
    </select>

</mapper>