解除父子关系java,休眠:父子关系数据结构 - java

源表

资料夹表:-

folder_id,folder_name,parent_id

---------------------------------

1,7-Zip,NULL

2,7z,1

3,Lang,1

文件表:

file_id,file_name,folder_id

---------------------------------

1,7-zip.chm,1

2,7-zip.dll,1

3,7z.dll,3

4,af.txt,3

当我插入数据时,数据结构如下所示(DS的大小为1)

[1,7-Zip,

childFolders[[2,7z],[3,Lang,childFolders[], childFiles[[3,7z.dll],[4,af.txt]]]],

childfiles[[1,7-zip.chm],[2,7-zip.dll]]]

当从数据库中检索数据时,我得到的是这样的。(DS的大小为3)

[1,7-Zip,

childFolders[[2,7z],[3,Lang,childFolders[], childFiles[[3,7z.dll],[4,af.txt]]]],

childfiles[[1,7-zip.chm],[2,7-zip.dll]]]

[2,7z,

childFolders[],

childfiles[]]

[3,Lang,

childFolders[],

childfiles[[3,7z.dll],[4,af.txt]]]

以下是我的文物

资料夹

@Entity

@Table(name="Searchedfolder")

public class SearchedFolder implements Serializable, Comparable{

/**

*

*/

private static final long serialVersionUID = -7373115811110399682L;

private long folderId;

private String folderName;

private String path;

private Date searchedTime;

private String description;

private Set childFiles = new HashSet();

private Set childFolders = new TreeSet();

private SearchedFolder parentFolder;

@Id

@Column(name="folder_id",insertable=true, updatable=true)

@GeneratedValue(strategy = GenerationType.AUTO)

public long getFolderId() {

return folderId;

}

public void setFolderId(long id) {

this.folderId = id;

}

@Column(name="path")

public String getPath() {

return path;

}

public void setPath(String path) {

this.path = path;

}

@Column(name="searched_time")

public Date getSearchedTime() {

return searchedTime;

}

public void setSearchedTime(Date searchedTime) {

this.searchedTime = searchedTime;

}

@Column(name="description")

public String getDescription() {

return description;

}

public void setDescription(String description) {

this.description = description;

}

@Column(name="folder_name")

public String getFolderName() {

return folderName;

}

public void setFolderName(String folderName) {

this.folderName = folderName;

}

@OneToMany(targetEntity= SearchedFile.class, mappedBy="parentFolder", cascade={CascadeType.ALL}, fetch = FetchType.EAGER)

public Set getChildFiles() {

return childFiles;

}

public void setChildFiles(Set childFiles) {

this.childFiles = childFiles;

}

@OneToMany(mappedBy="parentFolder", cascade={CascadeType.ALL}, fetch=FetchType.EAGER)

public Set getChildFolders() {

return childFolders;

}

public void setChildFolders(Set folders) {

this.childFolders = folders;

}

@ManyToOne(cascade={CascadeType.ALL})

@JoinColumn(name="parent_id")

public SearchedFolder getParentFolder() {

return parentFolder;

}

public void setParentFolder(SearchedFolder parentFolder) {

this.parentFolder = parentFolder;

}

public int compareTo(SearchedFolder searchedFolder) {

return this.getFolderName().compareTo(searchedFolder.getFolderName());

}

}

搜索文件

@Entity

@Table(name="searchedfile" )

public class SearchedFile implements Serializable, Comparable{

/**

*

*/

private static final long serialVersionUID = -7474936475144364605L;

private long fileId;

private String fileName;

private Date searchedTime;

private String extension;

private String description;

private SearchedFolder parentFolder;

@Id

@Column(name="file_id",insertable=true, updatable=true)

@GeneratedValue(strategy = GenerationType.AUTO)

public long getFileId() {

return fileId;

}

public void setFileId(long fileId) {

this.fileId = fileId;

}

@Column(name="file_name")

public String getFileName() {

return fileName;

}

public void setFileName(String fileName) {

this.fileName = fileName;

}

@Column(name="searched_time")

public Date getSearchedTime() {

return searchedTime;

}

public void setSearchedTime(Date searchedTime) {

this.searchedTime = searchedTime;

}

@Column(name="extension")

public String getExtension() {

return extension;

}

public void setExtension(String extension) {

this.extension = extension;

}

@Column(name="description")

public String getDescription() {

return description;

}

public void setDescription(String description) {

this.description = description;

}

@ManyToOne(targetEntity= SearchedFolder.class, cascade={CascadeType.ALL}, fetch = FetchType.EAGER)

@NotFound(action = NotFoundAction.IGNORE)

@JoinColumn(name="folder_id")

public SearchedFolder getParentFolder() {

return this.parentFolder;

}

public void setParentFolder(SearchedFolder parentFolder) {

this.parentFolder = parentFolder;

}

public int compareTo(SearchedFile searchedFile) {

return this.getFileName().compareTo(searchedFile.getFileName());

}

}

DAO文件:-

@Repository

public class SearchedFolderDAOImpl implements SearchedFolderDAO {

@Autowired

private SessionFactory schedulerSessionFactory;

@Override

public void addSearchedData(SearchedFolder searchedFolder) {

Session session = schedulerSessionFactory.openSession();

if(session == null){

schedulerSessionFactory.openSession();

}

try{

session.save(searchedFolder);

}catch (HibernateException e) {

e.printStackTrace();

}finally {

session.close();

}

}

@Override

public List getSearchedData() {

Criteria ctria = schedulerSessionFactory.getCurrentSession().createCriteria(SearchedFolder.class)

.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)

.setFetchMode("childFiles", FetchMode.SELECT);

List folders = (List) ctria.list();

return folders;

}

@Override

public void deleteSearchedData(Integer SearchedDataId) {

// TODO Auto-generated method stub

}

@Override

public List getSearchedData(String folderName) {

// TODO Auto-generated method stub

return null;

}

}

服务档案:-

@Service("defaultSearchDataService")

public class SearchDataServiceImpl implements SearchDataService{

{System.out.println("defaultSearchDataService...");}

@Autowired

private SearchedFileDAO searchedFileDAO;

@Autowired

private SearchedFolderDAO searchedFolderDAO;

@Override

@Transactional(readOnly=false, timeout=300, propagation=Propagation.REQUIRES_NEW)

public void saveFiles(List files) {

// TODO Auto-generated method stub

}

@Override

@Transactional(readOnly=true, timeout=300, propagation=Propagation.REQUIRED)

public List getFiles() {

// TODO Auto-generated method stub

return null;

}

@Override

@Transactional(readOnly=true, timeout=300, propagation=Propagation.REQUIRES_NEW)

public List getFolders() {

List folders = searchedFolderDAO.getSearchedData();

return folders;

}

@Override

@Transactional(readOnly=false,propagation=Propagation.REQUIRES_NEW, timeout=30)

public void addFolder(NewFolderForm newFolderForm) {

// TODO Auto-generated method stub

}

@Override

@Transactional(readOnly=false, timeout=300, propagation=Propagation.REQUIRED)

public void saveFolder(SearchedFolder searchedFolder) {

searchedFolderDAO.addSearchedData(searchedFolder);

}

@Override

public void saveFolder(Set directory) {

Iterator searchedFolderIterator = directory.iterator();

while(searchedFolderIterator.hasNext()){

SearchedFolder searchedFolder = searchedFolderIterator.next();

saveFolder(searchedFolder);

}

}

}

问题1:为什么插入和检索DataStructures不同?

问题2:如何解决此问题

参考方案

您要插入3个文件夹。当您插入此:

[1,7-Zip,

childFolders[[2,7z],[3,Lang,childFolders[], childFiles[[3,7z.dll],[4,af.txt]]]],

childfiles[[1,7-zip.chm],[2,7-zip.dll]]]

您要同时创建文件夹1、2和3。文件夹2没有文件或子文件夹。但是,文件夹3有3个文件。

当您尝试使用getFolders检索此信息时,将同时检索所有三个文件夹。这就是getSearchedData()的作用。

您可以通过在SearchedFolder类中创建新方法来解决此问题

@Override

public List getSearchedFolder(Long folderId) {

Criteria ctria = schedulerSessionFactory.getCurrentSession().createCriteria(SearchedFolder.class)

.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)

.setFetchMode("childFiles", FetchMode.SELECT);

List folders = (List) ctria.list();

ctria.add(Restrictions.eq("folderId", folderId));

return folders;

}

Java Double与BigDecimal - java

我正在查看一些使用双精度变量来存储(360-359.9998779296875)结果为0.0001220703125的代码。 double变量将其存储为-1.220703125E-4。当我使用BigDecimal时,其存储为0.0001220703125。为什么将它双重存储为-1.220703125E-4? 参考方案 我不会在这里提及精度问题,而只会提及数字…当回复有时是一个对象有时是一个数组时,如何在使用改造时解析JSON回复? - java

我正在使用Retrofit来获取JSON答复。这是我实施的一部分-@GET("/api/report/list") Observable listBill(@Query("employee_id") String employeeID); 而条例草案类是-public static class…无法使用具有简单的oneToMany-ManyToOne关系的JPA(休眠)持久化新对象图 - java

我正在尝试通过jpa持久化/合并一个全新的对象图,但是持久化的顺序似乎不正确,因为它试图保存对其父级存在约束的子对象。public class ObjectA implements Serializable { ... @OneToMany(cascade = CascadeType.ALL, mappedBy = "objectAId"…Java-父类正在从子类中调用方法? - java

抱歉,我还是编码的新手,可能还没有掌握所有术语。希望您仍然能理解我的问题。我想得到的输出是:"Cost for Parent is: 77.77" "Cost for Child is: 33.33" 但是,我得到这个:"Cost for Parent is: 33.33" "Cost f…Java Map,如何将UTF-8字符串正确放置到地图? - java

我有一个地图,LinkedHashMap更确切地说。我想在上面放一个字符串对象。然后,我读取此值以查看实际存储的内容。字符串本身具有非ASCII字符(西里尔文,韩文等)。将其放到地图上然后阅读后,这些字符将替换为??? s。一些代码:Map obj = new LinkedHashMap(); System.out.println("name: &…

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值