栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

联表查询

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

联表查询

1.数据库表格

pom.xml 



    4.0.0

    org.example
    mybatis02
    1.0-SNAPSHOT

    
        
            org.mybatis
            mybatis
            3.4.6
        
        
            mysql
            mysql-connector-java
            8.0.28
        
        
            org.projectlombok
            lombok
            1.18.24
        
        
            junit
            junit
            4.12
            test
        
        
            log4j
            log4j
            1.2.17
        
    

mybatis.xml




    
        
            
            
                
                
                
                
            
        
    
    
        
        
        
    

log4j.properties添加日志

log4j.rootLogger=DEBUG, Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

com.zsb.entity.student学生

Student   学生

package com.zsb.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
    private int id;
    private String name;
    private String age;
    private String sex;
    private Integer classId;

    private Clazz clazz;
}

Clazz   教室

package com.zsb.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Clazz {
    private Integer cid;
    private String cname;
}

com.zsb.don

StudentDao

package com.zsb.dao;

import com.zsb.entity.Student;

public interface StudentDao {
    
    public Student findStudentById(int id);
}

resources.mapper

StudentMapper.xml




    
    
        
        
        
        
        

        
            
            
        
    
    
        select * from t_student s join c_class c on s.class_id=c.cid where stu_id=#{id}
    

测试

com.zsb.test

Test

package com.zsb.test;

import com.zsb.dao.StudentDao;
import com.zsb.entity.Student;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.Reader;

public class Test03 {
    @Test
    public void testFindStudentById() throws Exception{
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        StudentDao studentDao = session.getMapper(StudentDao.class);

        Student student = studentDao.findStudentById(1);
        System.out.println(student);

        session.commit();
        session.close();
    }
}

 

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/950712.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号