本文共 652 字，大约阅读时间需要 2 分钟。

创建位置：必须和持久层接口在相同的包中。

   
       
        
           select * from user;        
            select  * from user where id = #{
   id};       
           
            
     
                 select last_insert_id();       
            insert into user(username,birthday,sex,address)values(#{
   username},#{
   birthday},#{
   sex},#{
   address});   
        
    
             update user set username = #{
   username}, birthday = #{
   birthday}, sex = #{
   sex}, address = #{
   address} where id = #{
   id}    
        
    
             delete from user where id=#{
   id};    
        
        
            select count(id) from user;    
   

转载地址：http://sciwi.baihongyu.com/