UserMapper.xml

     
         
              SELECT * FROM tb_user WHERE id = #{id};        
              SELECT * from tb_user where user_name=#{userName} AND password=#{password};            
      
               INSERT INTO tb_user(                                user_name,                                password,                                name,                                age,                                sex,                                birthday,                                created,                                updated                                )VALUES(                                #{userName},                                #{password},                                #{name},                                #{age},                                #{sex},                                #{birthday},                                NOW(),                                NOW()                                );            
              
      
               UPDATE tb_user            SET               user_name =#{userName},              password =#{password},              name =#{name},              updated =Now()        WHERE  id =#{id};            
              
      
               DELETE FROM tb_user WHERE id=#{id};