Controller+Service+DAO初试水

Controller+Service+DAO初试水

**因为本人之前一直接触Android的前端开发，可以说对于后台的一窍不通，几乎可以算的上的下白一个，怎么说现在很多人都为了高薪，去参加培训机构，去培训Android、IOS、HTML5，本人也是通过培训出来的，怎么说呢，有很多人对此褒贬不一，有的人说培训机构都是骗人的，他们都是为了盈利为主，其他的都不管；而有些人则不同意，反对这么说，他们说不管怎么样，自己确确实实的学了不少知识，了解了很多的知识，反正比以前强了好多。
而我呢，虽然对此也持有一些自己的见解，我认为肯定没有宣传的那么好，因为宣传嘛，要是说的太真了，反而不能 特别的吸引人。还有就是，不管说的再怎么好，都得需要你自己努力，你自己不努力再好的培训的培训机构也没有用。所以，我对此褒大于贬。
好了跑题了，下面讲一下我第一次android后台的代码。**

Controller为了展示数据的：

import java.util.List;

import javax.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.goldcity.business.service.GcWisdomService;
import com.goldcity.persistence.entity.SysUserInfo;
import com.repast.core.constant.SysConstant;
import com.repast.core.spring.auth.Author;
import com.repast.core.spring.auth.CheckType;
import com.repast.core.spring.mvc.util.JSONMap;

@Controller
@RequestMapping("/GcWisdomController")
public class GcWisdomController {
@Resource
GcWisdomService gcWisdomService;

/**
 * 查找 sys_user_info http://192.168.1.141:8080/goldcity/GcWisdomController/
 * querySysUserInfoList.json
 * 
 * @return model
 */
@RequestMapping("/querySysUserInfoList.json")
public @ResponseBody JSONMap<String, Object> querySysUserInfoList() {
    JSONMap<String, Object> model = new JSONMap<String, Object>();
    try {
        List<SysUserInfo> userInfo = gcWisdomService.querySysUserInfoList();
        model.put(SysConstant.OP_FLAG, true);
        model.put("userinfo", userInfo, "管理员");
    } catch (Exception e) {
        e.printStackTrace();
        model.put(SysConstant.OP_FLAG, false);
        model.put(SysConstant.OP_MESSAGE, SysConstant.Exception);
    }
    return model;
}

/**
 * 增添数据数据到 sys_user_info
 * http://192.168.1.141:8080/goldcity/GcWisdomController
 * /insertSysUserInfo.json
 * 
 * @return model
 */
@RequestMapping("/insertSysUserInfo.json")
public @ResponseBody JSONMap<String, Object> insertSysUserInfo() {
    JSONMap<String, Object> model = new JSONMap<String, Object>();
    try {
        int _insFlag = gcWisdomService.insertSysUserInfo();
        if (_insFlag == 1) {
            model.put(SysConstant.OP_FLAG, true);
            model.put(SysConstant.OP_MESSAGE, SysConstant.SUCCESS);
        } else {
            model.put(SysConstant.OP_FLAG, false);
            model.put(SysConstant.OP_MESSAGE, SysConstant.Exception);
        }

    } catch (Exception e) {
        e.printStackTrace();
        model.put(SysConstant.OP_FLAG, false);
        model.put(SysConstant.OP_MESSAGE, SysConstant.Exception);
    }
    return model;
}

/**
 * 修改数据到 sys_user_info
 * http://192.168.1.141:8080/goldcity/GcWisdomController/
 * updateSysUserInfo.json
 * 
 * @return model
 */
@Author(type = CheckType.NO_CHECK)
@RequestMapping("/updateSysUserInfo.json")
public @ResponseBody JSONMap<String, Object> updateSysUserInfo() {
    JSONMap<String, Object> model = new JSONMap<String, Object>();
    try {
        int _saveFlag = gcWisdomService.updateSysUserInfo();
        if (_saveFlag == 1) {
            model.put(SysConstant.OP_FLAG, true);
            model.put(SysConstant.OP_MESSAGE, SysConstant.SUCCESS);
        } else {
            model.put(SysConstant.OP_FLAG, false);
            model.put(SysConstant.OP_MESSAGE, SysConstant.Exception);
        }
    } catch (Exception e) {
        e.printStackTrace();
        model.put(SysConstant.OP_FLAG, false);
        model.put(SysConstant.OP_MESSAGE, SysConstant.Exception);
    }
    return model;
}

/**
 * 删除数据到 sys_user_info
 * http://192.168.1.141:8080/goldcity/GcWisdomController/
 * deleteSysUserInfo.json
 * 
 * @return model
 */
@Author(type = CheckType.NO_CHECK)
@RequestMapping("/deleteSysUserInfo.json")
public @ResponseBody JSONMap<String, Object> deleteSysUserInfo() {
    JSONMap<String, Object> model = new JSONMap<String, Object>();
    try {
        int _delFlag = gcWisdomService.deleteSysUserInfo();
        if (_delFlag == 1) {
            model.put(SysConstant.OP_FLAG, true);
            model.put(SysConstant.OP_MESSAGE, SysConstant.SUCCESS);
        } else {
            model.put(SysConstant.OP_FLAG, false);
            model.put(SysConstant.OP_MESSAGE, SysConstant.Exception);
        }
    } catch (Exception e) {
        e.printStackTrace();
        model.put(SysConstant.OP_FLAG, false);
        model.put(SysConstant.OP_MESSAGE, SysConstant.Exception);
    }
    return model;
}
}

Service主要是写主要的逻辑，但是本次数最基本的：

import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.goldcity.persistence.dao.GcWisdomDAO;
import com.goldcity.persistence.entity.SysUserInfo;

@Service("GcWisdomService")
public class GcWisdomService {
@Resource
GcWisdomDAO gcWisdomDAO;

public List<SysUserInfo>  querySysUserInfoList() {
    return gcWisdomDAO.querySysUserInfoList();
}

public int insertSysUserInfo(){
    // by zhaozh
    SysUserInfo sysUserInfo = new SysUserInfo();
    sysUserInfo.setUserid(gcWisdomDAO.getUUId());
    sysUserInfo.setUsername("Wisdom");
    sysUserInfo.setAccount("wisdom");
    sysUserInfo.setPassword("123456");
    int _insFlag = gcWisdomDAO.insertSysUserInfo(sysUserInfo);
    return _insFlag;
}

public int updateSysUserInfo(){
    SysUserInfo sysUserInfo = new SysUserInfo();
    sysUserInfo.setUserid("ca22784de6bc4dbcb618466b80596ccb");
    sysUserInfo.setUsername("Wisdomz");
    sysUserInfo.setAccount("wisdomz");
    sysUserInfo.setPassword("1111111");
    sysUserInfo.setContacttelnumber("1388388388");
    int _updFlag = gcWisdomDAO.updateSysUserInfo(sysUserInfo);
    return _updFlag;
}

public int deleteSysUserInfo(){
    SysUserInfo sysUserInfo = new SysUserInfo();
    sysUserInfo.setUserid("ca22784de6bc4dbcb618466b80596ccb");
    int _delFlag = gcWisdomDAO.deleteSysUserInfo(sysUserInfo);
    return _delFlag;
}
}

DAO主要是直接针对数据库的操作，最直接的是 增、删、改、查：

import java.util.List;
import org.springframework.stereotype.Component;
import com.goldcity.persistence.entity.SysUserInfo;
import com.repast.core.system.BaseDao;
@Component("GcSWisdomDAO")
public class GcWisdomDAO extends BaseDao {

public final static String QueryTableSql = "SELECT * FROM sys_user_info  ";
public List<SysUserInfo>  querySysUserInfoList(){
    // by zhaozh
    return this.queryForList(QueryTableSql, SysUserInfo.class);
}

public int insertSysUserInfo(SysUserInfo sysUserInfo){
    // by zhaozh
    int _insFlag  = this.saveNew(sysUserInfo);
    return _insFlag;
}

public int updateSysUserInfo(SysUserInfo sysUserInfo){
    int _updFlag = this.saveUpdate(sysUserInfo);
    return _updFlag;
}

public int deleteSysUserInfo(SysUserInfo sysUserInfo) {
    int _delFlag = this.saveRemove(sysUserInfo);
    return _delFlag;
}
}

最初的数据库：

新增完数据：

修改完数据：

删除完数据：