twitteruser部分开发

twitter部分开发（一）

TwitterUser

一、数据库

二、实体类

TwitterUser.java

package com.sddx.system.domain;

import com.sddx.common.core.domain.BaseEntity;

public class TwitterUser extends BaseEntity {
    private String user_id;
    private String name;
    private String screen_name;
    private String location;
    private String following;
    private String followers;

    public void setUser_id(String user_id){this.user_id = user_id;}
    public void setName(String name){this.name = name;}
    public void setScreen_name(String screen_name){this.screen_name = screen_name;}
    public void setLocation(String location){this.location = location;}
    public void setFollowing(String following){this.following =following;}
    public void setFollowers(String followers){this.followers = followers;}

    public String getUser_id(){return user_id;}
    public String getName(){return name;}
    public String getScreen_name(){return screen_name;}
    public String getLocation(){return location;}
    public String getFollowing(){return following;}
    public String getFollowers(){return followers;}
}

三、TwitterUserMapper

package com.sddx.system.mapper;

import com.sddx.system.domain.TwitterUser;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;

@Mapper
public interface TwitterUserMapper {

    public List<TwitterUser> getAllInfo(String tablename);
    
    public List<TwitterUser> selectTwitterUser(TwitterUser twitterUser);
    
    public List<TwitterUser> selectTwitterUserName(String name);
    
    public int deleteTwitterUser(String user_id);

}

四、TwitterUserService

package com.sddx.system.service;

import com.sddx.system.domain.TwitterUser;
import java.util.List;

public interface TwitterUserService {

    public List<TwitterUser> getAllInfo(String tablename);
    
    public List<TwitterUser> selectTwitterUser(TwitterUser twitterUser);
    
    public List<TwitterUser> selectTwitterUserName(String name);
    
    public int deleteTwitterUser(String user_id);
}

五、TwitterUserServiceImpl

package com.sddx.system.service.impl;

import com.sddx.system.domain.TwitterUser;
import com.sddx.system.mapper.TwitterUserMapper;
import com.sddx.system.service.TwitterUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class TwitterUserServiceImpl implements TwitterUserService {

    @Autowired
    TwitterUserMapper twitterUserMapper;

    @Override
    public List<TwitterUser> getAllInfo(String tableName) {
        return twitterUserMapper.getAllInfo(tableName);
    }

    @Override
    public List<TwitterUser> selectTwitterUser(TwitterUser twitterUser) {
        return twitterUserMapper.selectTwitterUser(twitterUser);
    }

    @Override
    public List<TwitterUser> selectTwitterUserName(String name) {
        return twitterUserMapper.selectTwitterUserName(name);
    }

    @Override
    public int deleteTwitterUser(String user_id) {
        return twitterUserMapper.deleteTwitterUser(user_id);
    }
}

六、TwitterUserController

package com.sddx.web.controller.system;

import com.sddx.common.annotation.Log;
import com.sddx.common.core.controller.BaseController;
import com.sddx.common.core.domain.AjaxResult;
import com.sddx.common.enums.BusinessType;
import com.sddx.system.domain.Demo;
import com.sddx.system.domain.TwitterUser;
import com.sddx.system.service.TwitterUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/twitteruser")
public class TwitterUserController extends BaseController {

    @Autowired
    TwitterUserService twitterUserService;

    @PostMapping("/{tableName}")
    public List<TwitterUser> getAllInfo(@PathVariable("tableName") String tableName){
        return twitterUserService.getAllInfo(tableName);
    }

    //查询全部
    @GetMapping("/list")
    public List<TwitterUser> selectTwitterUser(TwitterUser twitterUser) {
        return twitterUserService.selectTwitterUser(twitterUser);
    }

    // 查询 按名字
    @GetMapping(value = "/{name}")
    public List<TwitterUser> selectTwitterName(@PathVariable("name") String name) {
        return twitterUserService.selectTwitterUserName(name);
    }

    //删除
    @Log(title = "Demo", businessType = BusinessType.DELETE)
    @DeleteMapping("/{id}")
    public AjaxResult deleteTwitterUser(@PathVariable("id") String id)
    {
        return toAjax(twitterUserService.deleteTwitterUser(id));
    }

}

七、TwitterUserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sddx.system.mapper.TwitterUserMapper">

    <select id="getAllInfo" parameterType="String" resultType="TwitterUser">
        SELECT * FROM ${tableName}
    </select>

    <select id="selectTwitterUser" parameterType="TwitterUser" resultType="TwitterUser">
        select * from twitter_user
    </select>

    <select id="selectTwitterName" parameterType="String" resultType="TwitterUser">
        select * from twitter_user where name=#{name}
    </select>

    <delete id="deleteTwitterUser" parameterType="Integer" >
        delete from twitter_user where user_id = #{user_id}
    </delete>

</mapper>