Skip to content

coderbigxinbrother/Mybatis_Cache1

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

关联映射:
1v1 双向

老师  班级

双向:1、通过老师查班,也能通过班查询老师

关系模型(数据库表的设计):如何保证两个表的数据是一对一
方案一:将外键unique
方案二:将主键、外键相同
classes
    cid
    cname
    
teacher
    cid  primary key  foreign key
    tname
    (cid  unique)
    
对象模型(显示结果的方便):
Teacher
    tid
    tname
    Classes对象
Classes
    cid
    cname
    Teacher对象
    
    
sql语句有区别:
1、一条语句查询
    select tid, tname, cid, cname
    from teacher
    inner join classes
    on teacher.cid = classes.cid
    where tid = 1;
    
    select tid, tname, cid, cname
    from teacher,classes
    on teacher.cid = classes.cid
    where tid = 1;
2、两条语句查询   
    
实现双向  发多条语句

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages