java hibernate用法

java hibernate用法

调用rest api的方法
zuul网关调用方法

http://192.168.10.29:9000/api-datashare/catalog/listall
http://192.168.10.29:9000/api-datashare/catalog/tree

javascript调用方法

//http://192.168.10.22:8002/api-sys/oauth/token
//登录 OK
function API_login(strName, strPwd) {
    let loginParams = new FormData();   //必须用FormData()OK
    loginParams.append('client_id', 'app');
    loginParams.append('client_secret', '123456');
    loginParams.append('grant_type', 'password');
    loginParams.append('username', strName);
    loginParams.append('password', strPwd);
    return API_POST('/api-sys/oauth/token', loginParams)
};

本地调用方法

http://192.168.10.22:8006/catalog/listAll
http://192.168.10.22:8006/catalog/tree

引入pom.xml的库

<dependency>
    <groupId>org.postgresql</groupId>
     <artifactId>postgresql</artifactId>
     <version>42.2.5</version>
 </dependency>
 <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-data-jpa</artifactId>
 </dependency>
 <dependency>
     <groupId>org.projectlombok</groupId>
     <artifactId>lombok</artifactId>
     <version>${lombok.version}</version>
 </dependency>

定义hibernate 表类 定义

package com.bootdo.clouddodatashare.domain;

import lombok.Data;

import javax.persistence.Entity;
import javax.persistence.Id;

@Data
@Entity
public class ldap_catalog {
    @Id
    private String id;
    private int sid;
    private String cate_name;
    private String parent_id;
    private String remark;
    private String cate_std;
}

定义表类对象的操作类

package com.bootdo.clouddodatashare.dao;

import com.bootdo.clouddocommon.dto.Tree;
import com.bootdo.clouddodatashare.domain.ldap_catalog;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface CatalogDao extends JpaRepository<ldap_catalog,String> {
}

定义restController类 rest api定 义

package com.bootdo.clouddodatashare.controller;

import com.bootdo.clouddocommon.dto.Tree;
import com.bootdo.clouddocommon.utils.BuildTree;
import com.bootdo.clouddocommon.utils.uuidUtil;
import com.bootdo.clouddodatashare.dao.CatalogDao;
import com.bootdo.clouddodatashare.domain.ldap_catalog;
import com.bootdo.clouddodatashare.service.CatalogService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.ArrayList;
import java.util.List;

@RequestMapping("/catalog")
@RestController
public class catalogController {
    @Autowired
    private CatalogDao catalogDao;

    @ResponseBody
    @GetMapping("/listall")
    public List<ldap_catalog> listAll(){
        List<ldap_catalog> tlist= catalogDao.findAll();
        return tlist;
    }
    public ldap_catalog get(String id)
    {
        return catalogDao.getOne(id);
    }
    @ResponseBody
    @GetMapping("/tree")
    public Tree<ldap_catalog> getTree()
    {
        List<Tree<ldap_catalog>> trees = new ArrayList<Tree<ldap_catalog>>();
        List<ldap_catalog> tList = catalogDao.findAll();
        for (ldap_catalog c : tList) {
            Tree<ldap_catalog> tree = new Tree<ldap_catalog>();
            tree.setId(c.getId().toString());
            tree.setParentId(c.getParent_id().toString());
            tree.setText(c.getCate_name());
            tree.setObject(c);
            trees.add(tree);
        }
        // 默认顶级菜单为０，根据数据库实际情况调整
        Tree<ldap_catalog> t = BuildTree.build(trees);
        return t;
    }
    @ResponseBody
    @PostMapping("/add")
    public ldap_catalog add(ldap_catalog c)
    {
        c.setId(uuidUtil.getUUID());
        return catalogDao.save(c);
    }
    @ResponseBody
    @PostMapping("/update")
    public ldap_catalog update(ldap_catalog c)
    {
        return catalogDao.save(c);
    }
    @ResponseBody
    @DeleteMapping("/remove")
    public void remove(String Id)
    {
        catalogDao.deleteById(Id);
    }
    @ResponseBody
    @PostMapping("/batchremove")
    public void batchRemove(String[] cIds)
    {
        for (String cId : cIds)
        {
            catalogDao.deleteById(cId);
        }
        //List<String> delIds=new ArrayList<>();
        //Iterator<String> items=delIds.iterator();
        //catalogDao.deleteInBatch(catalogDao.findAllById(items).iterator());
    }


}