spring+mysql+druid+jdbctemplate使用xml配置实现增删改查

选型

框架：spring
持久层：mysql+jdbcTemplate+druid
配置方式：beans.xml

domain层

package com.li.domain;

public class User {
   
    private int id;
    private String username;
    private String password;

    public int getId() {
   
        return id;
    }

    public void setId(int id) {
   
        this.id = id;
    }

    public String getUsername() {
   
        return username;
    }

    public void setUsername(String username) {
   
        this.username = username;
    }

    public String getPassword() {
   
        return password;
    }

    public void setPassword(String password) {
   
        this.password = password;
    }

    @Override
    public String toString() {
   
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

业务层

接口

package com.li.service;

import com.li.domain.User;

import java.util.List;

public interface UserService {
   
    //得到全部用户名信息
    List<User> getUserAll();
    //根据id得到一名用户信息
    User getUserById(int id);
    //添加一名用户信息
    void InsertUser(User user);
    //修改用户信息
    void updateUser(User user);
    //删除用户信息
    void deleteUser(int id);
}

实现类

package com.li.service.impl;

import com.li.dao.UserDao;
import com.li.dao.impl.UserDaoImpl;
import com.li.domain.User;
import com.li.service.UserService;

import java.util.List;

public class UserServiceImpl implements UserService {
   
    UserDao userDao;