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

学习内容：对user表进行增删改查

项目结构：

package wo.dao;import wo.domain.QueryVo;import wo.domain.User;import java.util.List;//用户得持久层接口public interface IUserDao {
       //查询所有用户    List
   
     findAll();    //保存方法    void saveUser(User user);    //更新用户    void updateUser(User user);    //根据id删除用户    void deleteUser(Integer userId);    //根据id查询用户信息    User findById(Integer userId);    //根据名称模糊查询用户信息    List
    
      findByName(String username);    //查询总用户数   int findTotal();   //根据queryVo中的条件查询用户    List
     
       findUserByVo(QueryVo vo);}
     
    
   

QueryVo

package wo.domain;public class QueryVo {
       private User user;    public User getUser() {
           return user;    }    public void setUser(User user) {
           this.user = user;    }}

IUSerDao.xml

    
       
        
          select * from user        
        
            
             
     
                  SELECT last_insert_id();        
             insert into user(username,address,sex,birthday)VALUE (#{
   username},#{
   address},#{
   sex},#{
   birthday});    
        
        
    
             UPDATE USER SET username=#{
   username},address=#{
   address},sex=#{
   sex},birthday=#{
   birthday}where id=#{
   id};    
        
        
    
             DELETE FROM  USER WHERE id=#{
   id};    
        
        
            SELECT * from user where id=#{
   id};        
        
            SELECT  * from user WHERE  username LIKE  #{
   name};        
        
            SELECT COUNT(id) FROM user;        
        
            SELECT  * from user WHERE  username LIKE  #{
   user.username};    
   

SqlMapConfig.xml

来自黑马java

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