创建一个mybatis dao模板来动态执行任何查询

public interface UserDAO {
    User getUserById(int id);
    List<User> getAllUsers();
    void insertUser(User user);
    void updateUser(User user);
    void deleteUser(int id);
}

<mapper namespace="com.example.dao.UserDAO">
    <select id="getUserById" resultType="com.example.model.User">
        SELECT * FROM users WHERE id = #{id}
    </select>
    <select id="getAllUsers" resultType="com.example.model.User">
        SELECT * FROM users
    </select>
    <insert id="insertUser">
        INSERT INTO users (id, name, age) VALUES (#{id}, #{name}, #{age})
    </insert>
    <update id="updateUser">
        UPDATE users SET name = #{name}, age = #{age} WHERE id = #{id}
    </update>
    <delete id="deleteUser">
        DELETE FROM users WHERE id = #{id}
    </delete>
</mapper>

spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase
spring.datasource.username=root
spring.datasource.password=123456

@Repository
public class UserDAOImpl implements UserDAO {

    @Autowired
    private SqlSession sqlSession;

    @Override
    public User getUserById(int id) {
        return sqlSession.selectOne("com.example.dao.UserDAO.getUserById", id);
    }

    @Override
    public List<User> getAllUsers() {
        return sqlSession.selectList("com.example.dao.UserDAO.getAllUsers");
    }

    @Override
    public void insertUser(User user) {
        sqlSession.insert("com.example.dao.UserDAO.insertUser", user);
    }

    @Override
    public void updateUser(User user) {
        sqlSession.update("com.example.dao.UserDAO.updateUser", user);
    }

    @Override
    public void deleteUser(int id) {
        sqlSession.delete("com.example.dao.UserDAO.deleteUser", id);
    }
}