mysql many to one_Mybatis one-to-many(一对多)

最新推荐文章于 2023-04-07 11:41:55 发布
最新推荐文章于 2023-04-07 11:41:55 发布
阅读量182 收藏
点赞数
文章标签： mysql many to one
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39851872/article/details/113261422
版权

CREATE TABLE `teacher` (

`tid` int(11) NOT NULL AUTO_INCREMENT,

`tname` varchar(100) DEFAULT NULL,

PRIMARY KEY (`tid`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

CREATE TABLE `student` (

`sid` int(11) NOT NULL AUTO_INCREMENT,

`sname` varchar(100) DEFAULT NULL,

`teacherid` int(11) DEFAULT NULL,

PRIMARY KEY (`sid`),

KEY `ftid` (`teacherid`),

CONSTRAINT `ftid` FOREIGN KEY (`teacherid`) REFERENCES `teacher` (`tid`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

package org.abin.lee.bean;

public class Student implements java.io.Serializable{

private static final long serialVersionUID = 2664268794619785937L;

private int sid;

private String sname;

private int teacherId;

private Teacher teacher;

public Student() {

}

public int getSid() {

return sid;

}

public void setSid(int sid) {

this.sid = sid;

}

public String getSname() {

return sname;

}

public void setSname(String sname) {

this.sname = sname;

}

public Teacher getTeacher() {

return teacher;

}

public void setTeacher(Teacher teacher) {

this.teacher = teacher;

}

public int getTeacherId() {

return teacherId;

}

public void setTeacherId(int teacherId) {

this.teacherId = teacherId;

}

}

package org.abin.lee.bean;

import java.util.ArrayList;

import java.util.List;

public class Teacher implements java.io.Serializable{

private static final long serialVersionUID = -7053173500969534203L;

private int tid;

private String tname;

private List student=new ArrayList();

public Teacher() {

}

public int getTid() {

return tid;

}

public void setTid(int tid) {

this.tid = tid;

}

public String getTname() {

return tname;

}

public void setTname(String tname) {

this.tname = tname;

}

public List getStudent() {

return student;

}

public void setStudent(List student) {

this.student = student;

}

}

StudentMapper.xml(org.abin.lee.bean)

/p>

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

SELECT LAST_INSERT_ID() AS ID

INSERT INTO student(sname,teacherId)

VALUES(#{sname},#{teacherId})

SELECT * FROM student

WHERE sid=#{sid}

SELECT * FROM student

WHERE teacherId=#{teacherId}

TeacherMapper.xml(org.abin.lee.bean)

/p>

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

SELECT @@IDENTITY AS ID

INSERT INTO teacher(tname)

VALUES(#{tname})

SELECT *

FROM teacher

WHERE tid=#{id}

package org.abin.lee.dao;

import java.util.List;

import org.abin.lee.bean.Student;

public interface StudentDao {

void insertStudent(Student student);

List getStudent(int id);

List getStudentById(int teacherId);

}

package org.abin.lee.dao;

import org.abin.lee.bean.Teacher;

public interface TeacherDao {

void insertTeacher(Teacher teacher);

Teacher getTeacher(int id);

}

package org.abin.lee.dao.impl;

import java.util.List;

import org.abin.lee.bean.Student;

import org.abin.lee.dao.StudentDao;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class StudentDaoImpl extends HibernateDaoSupport implements StudentDao{

public List getStudent(int id) {

List list=null;

String hql="select o from Student o where o.id="+id;

try {

list=(List)this.getHibernateTemplate().find(hql);

} catch (Exception e) {

e.printStackTrace();

}

return list;

}

public List getStudentById(int teacherId) {

List list=null;

String hql="select o from Student o where o.id="+teacherId;

try {

list=(List)this.getHibernateTemplate().find(hql);

} catch (Exception e) {

e.printStackTrace();

}

return list;

}

public void insertStudent(Student student) {

try {

this.getHibernateTemplate().save(student);

} catch (Exception e) {

e.printStackTrace();

}

}

}

package org.abin.lee.dao.impl;

import org.abin.lee.bean.Teacher;

import org.abin.lee.dao.TeacherDao;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class TeacherDaoImpl extends HibernateDaoSupport implements TeacherDao{

public Teacher getTeacher(int id) {

Teacher teacher=null;

String hql="select o from Teacher o where o.id="+id;

try {

teacher=(Teacher)this.getHibernateTemplate().find(hql);

this.getHibernateTemplate().flush();

} catch (Exception e) {

e.printStackTrace();

}

return teacher;

}

public void insertTeacher(Teacher teacher) {

try {

this.getHibernateTemplate().save(teacher);

this.getHibernateTemplate().flush();

} catch (Exception e) {

e.printStackTrace();

}

}

}

package org.abin.lee.service;

import java.util.List;

import org.abin.lee.bean.Student;

public interface StudentService {

void insertStudent(Student student);

List getStudent(int id);

List getStudentById(int teacherId);

}

package org.abin.lee.service;

import org.abin.lee.bean.Teacher;

public interface TeacherService {

void insertTeacher(Teacher teacher);

Teacher getTeacher(int id);

}

package org.abin.lee.service.impl;

import java.util.List;

import org.abin.lee.bean.Student;

import org.abin.lee.dao.StudentDao;

import org.abin.lee.service.StudentService;

public class StudentServiceImpl implements StudentService{

private StudentDao studentDao;

public List getStudent(int id) {

return this.studentDao.getStudent(id);

}

public List getStudentById(int teacherId) {

return this.studentDao.getStudentById(teacherId);

}

public void insertStudent(Student student) {

this.studentDao.insertStudent(student);

}

public StudentDao getStudentDao() {

return studentDao;

}

public void setStudentDao(StudentDao studentDao) {

this.studentDao = studentDao;

}

}

package org.abin.lee.service.impl;

import org.abin.lee.bean.Teacher;

import org.abin.lee.dao.TeacherDao;

import org.abin.lee.service.TeacherService;

public class TeacherServiceImpl implements TeacherService{

private TeacherDao teacherDao;

public Teacher getTeacher(int id) {

return this.teacherDao.getTeacher(id);

}

public void insertTeacher(Teacher teacher) {

this.teacherDao.insertTeacher(teacher);

}

public TeacherDao getTeacherDao() {

return teacherDao;

}

public void setTeacherDao(TeacherDao teacherDao) {

this.teacherDao = teacherDao;

}

}

applicationContext-mapper.xml(org.abin.lee.spring)

class="org.mybatis.spring.mapper.MapperFactoryBean">

value="org.abin.lee.dao.StudentDao" />

class="org.mybatis.spring.mapper.MapperFactoryBean">

value="org.abin.lee.dao.TeacherDao" />

applicationContext-resource.xml(org.abin.lee.spring)

class="org.apache.commons.dbcp.BasicDataSource"

destroy-method="close">

value="com.mysql.jdbc.Driver">

class="org.mybatis.spring.SqlSessionFactoryBean">

value="classpath:mybatis-config.xml" />

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

applicationContext-service.xml(org.abin.lee.spring)

class="org.abin.lee.service.impl.StudentServiceImpl">

class="org.abin.lee.service.impl.TeacherServiceImpl">

mybatis-config.xml(直接放在src目录下面)

Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

log4j.properties(直接放在src目录下面)

log4j.rootLogger=INFO,stdout,logfile

//log4j.rootLogger=INFO,logfile

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss} [%c]-[%p] %m%n

log4j.appender.logfile=org.apache.log4j.RollingFileAppender

log4j.appender.logfile.File=../logs/contacts.log

log4j.appender.logfile.MaxFileSize=2048KB

log4j.appender.logfile.MaxBackupIndex=5

log4j.appender.logfile.layout=org.apache.log4j.PatternLayout

log4j.appender.logfile.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH:mm:ss} (%c) - %m%n

下面是测试代码：

package org.abin.lee.test;

import junit.framework.TestCase;

import org.abin.lee.bean.Student;

import org.abin.lee.bean.Teacher;

import org.abin.lee.service.StudentService;

import org.abin.lee.service.TeacherService;

import org.junit.Before;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestStudent extends TestCase{

private StudentService studentService;

private TeacherService teacherService;

private ApplicationContext context;

@Before

public void setUp(){

String[] xml=new String[3];

xml[0]="org/abin/lee/spring/applicationContext-resource.xml";

xml[1]="org/abin/lee/spring/applicationContext-mapper.xml";

xml[2]="org/abin/lee/spring/applicationContext-service.xml";

context=new ClassPathXmlApplicationContext(xml);

}

public void testStudent(){

Teacher tea=new Teacher();

tea.setTname("steven");

teacherService=(TeacherService)context.getBean("teacherService");

this.teacherService.insertTeacher(tea);

Student stu=new Student();

stu.setSname("john");

stu.setTeacherId(tea.getTid());

studentService=(StudentService)context.getBean("studentService");

this.studentService.insertStudent(stu);

}

public StudentService getStudentService() {

return studentService;

}

public void setStudentService(StudentService studentService) {

this.studentService = studentService;

}

public TeacherService getTeacherService() {

return teacherService;

}

public void setTeacherService(TeacherService teacherService) {

this.teacherService = teacherService;

}

}

package org.abin.lee.test;

import java.util.List;

import junit.framework.TestCase;

import org.abin.lee.bean.Student;

import org.abin.lee.bean.Teacher;

import org.abin.lee.service.StudentService;

import org.abin.lee.service.TeacherService;

import org.junit.Before;

import org.junit.Test;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestFind extends TestCase{

private StudentService studentService;

private TeacherService teacherService;

private ApplicationContext context;

@Before

public void setUp(){

String[] xml=new String[3];

xml[0]="org/abin/lee/spring/applicationContext-resource.xml";

xml[1]="org/abin/lee/spring/applicationContext-mapper.xml";

xml[2]="org/abin/lee/spring/applicationContext-service.xml";

context=new ClassPathXmlApplicationContext(xml);

}

@Test

public void testFind(){

teacherService=(TeacherService)context.getBean("teacherService");

studentService=(StudentService)context.getBean("studentService");

List list=this.studentService.getStudentById(4);

Student stu=new Student();

Teacher tea=new Teacher();

for(int i=0;i

System.out.println("666");

stu=list.get(i);

System.out.println("sid="+stu.getSid()+",sname="+stu.getSname()+",teacherid="+stu.getTeacherId());

tea=stu.getTeacher();

System.out.println("tid="+tea.getTid()+",tname="+tea.getTname());

}

}

public StudentService getStudentService() {

return studentService;

}

public void setStudentService(StudentService studentService) {

this.studentService = studentService;

}

public TeacherService getTeacherService() {

return teacherService;

}

public void setTeacherService(TeacherService teacherService) {

this.teacherService = teacherService;

}

}

weixin_39851872
关注
Mybatis 多表关联查询（2） one-to-many关系
mqweishijiunuli的博客
04-27 1620
Mybatis 多表关联查询（2） one-to-many关系本文中未说明的都在多表关联查询（1）中有说明。基础文件 在mybatis- config.xml文件加入两个映射文件 <mapper resource="com/adoken/mapper/ClassesMapper.xml"/> <mapper resource="com/adoken/mapper/StudentMapper.xml"
Mybatis One-to-many mapping
程序员备忘录
12-26 503
We can map one-to-many types of results to a collection of objects using the &lt;collection&gt; element.The JavaBeans for Course and Tutor are as follows: public class Course {  private Integer cour...
mysql many to one_Hibernate 多对一（Many-to-One）映射
weixin_42207707的博客
02-17 158
多对一(many-to-one)关联是最常见的关联关系，其中一个对象可以与多个对象相关联。例如，一个相同的地址对象可以与多个雇员的对象相关联。定义RDBMS表：考虑一个情况，我们需要员工记录存储在EMPLOYEE表，将有以下结构：create table EMPLOYEE(id INT NOT NULL auto_increment,first_name VARCHAR(20)defaultNUL...
Beginning MyBatis 3 Part 2 : How to Handle One-to-Many and One-to-One Selects
weixin_30849403的博客
04-15 90
One of the latest MyBatis feature is the ability to use Annotations or XML to do One-to-One or One-to-Many queries. Let’s start with an example, as usual im using PostgreSQL, Netbeans 6.9...
Mybatis中对象映射关联之collection使用
小小默：进无止境
12-02 6182
one to one - association ; one to many - collection ; Nested results - column is not necessary ，javaType is necessary ！ nested queries - column is necessary ，javaType is not necessary ！ 表结构：t_studen
mysql many to one_hibernate 多对一(Many-to-one)单向关联
weixin_35285276的博客
01-19 179
多对一实例(Employee-Department)1. E-R图：2. 实体类：Department类：package com.reiyen.hibernate.domainpublic class Department {private int id;private String name;//setter和getter方法....}Employee类:package com.reiyen.h...
mybatis mysql 树形结构_Mybatis查询树形结构数据
weixin_42590539的博客
02-07 1526
数据表的设计创建数据表对于树形结构的数据库设计通常是基于继承关系设计的，也就是通过父ID关联来实现的。一张树形结构的数据表基本的三个字段：id(自己)、name(名称)和parentid(父类编号)CREATE TABLE `tree` (`id` int(20) NOT NULL COMMENT 'id',`name` varchar(20) NOT NULL COMMENT '名称',`par...
mysql自增id 原理_Mybatis useGeneratedKeys 填充自增主键值(使用Mysql)的原理分析
weixin_39746652的博客
01-19 1365
一、Mybatis配置keyProperty="id" useGeneratedKeys="true">useGeneratedKeys=“true”时 ， mybatis会将自增ID值 填充到 TestDO对象中的 id (keyProperty指定)属性。二、JDBCjava.sql.Statement对象 执行 executeUpdateint executeUpdate(String...
springboot创建集成的demo，pagehelper分页插件，mybatis集成mysql的一对多，多对多，Swagge
03-21
在映射配置中，我们可以使用`<association>`标签表示一对一关系，`<collection>`标签表示一对多关系，以及`<many-to-many>`标签表示多对多关系。这种映射使得数据操作更加直观和便捷。 Swagger则是用于构建RESTful ...
springboot-redis-mybatis多对多例子
07-14
在Spring Boot应用中，可以使用MyBatis提供的`@Many`和`@ManyToMany`注解来处理多对多关系。例如，`User`类可能会有如下字段： ```java @ManyToMany(cascade = CascadeType.ALL) @JoinTable(name = "user_role", ...
many-to-one 配置详解
09-30
many-to-one 配置详解 讲的很清楚 适合新手 值得下载
myBatis一对一和一对多
08-11
在实际的项目开发中，我们经常遇到一对一（One-to-One）和一对多（One-to-Many）的关系映射，这两种关系在数据库设计中非常常见。本主题将详细探讨在MyBatis中如何实现一对一和一对多的映射。 ### 一对一映射（One-...
MyBatis 详解（一对一，一对多，多对多）
音符的博客
06-13 989
目录1，什么是MyBatis的？2，MyBatis入门实例基于xml配置3，MyBatis入门实例注解配置4，MyBatis入门实例一对一基于xml配置4，MyBatis入门实例一对多，多对一基于xml配置5，MyBatis入门实例多对多基于xml配置 回到顶部1，什么是MyBatis的？　　MyBatis本是apache的一个开源项目iBatis，2010年这个项目由apache软件基金会迁移到...
MyBatis many to one 注解
amazing_Code的博客
09-14 1054
DepartmentDao 接口 public interface DepartmentDao { @Select("select * from t_department") @Results({ @Result(column="d_id",property="id"), @Result(column="d_name",property="nam...
Mybatis many to many
weixin_34015336的博客
04-27 274
http://mybatis.co.uk/index.php/2010/10/mybatis-one-to-many-mapping.html 
a complete example of using One to Many and One to One associations using MyBatis annotations
Schen6 Online Life
10-31 9239
Dear Readers, Below is a complete example of using One to Many and One to One associations using MyBatis annotations. Example illustrates how we realized is-a and has-a relation (Candidate is a Pers
mybatis-plus注解方式实现一对多和多对多
最新发布
LuckyTHP
04-07 2820
上述示例是针对mybatis-plus框架进行数据库操作的注解实现一对多和多对多的关系的示例代码。通过使用以上的注解，我们可以轻松实现一对多和多对多的关系。进行数据库操作时，注解实现一对多和多对多的关系非常便捷。对于一对多的关系，我们可以使用。对于多对多的关系，我们可以使用。
MyBatis one many
专栏
02-21 215
one ->many @SelectProvider(type=Vote1SqlProvider.class, method="selectByExample") @ConstructorArgs({ @Arg(column="VID", javaType=Integer.class, jdbcType=JdbcType.INTEGER, i...
【Mybatis】mybatis详解（多对多）
Luck_And_Destiny的博客
09-14 5021
5、MyBatis 入门实例 多对多 基于xml配置 　　这里我们以 users 表和 groups 表为例，一个 users 可能加入多个 groups，而一个 groups 可能包含多个 users，故构成 多对多 的关联 　　①、在数据库中建立相应的表 　　users 表 　　groups 表 　　两者之间的关联表users_groups表 　　②、建立对应的实体类 　　Users.java package many.to.many; import java...
Mybatis框架详解：Mapper配置与对象关系映射
为了处理复杂的关联关系，如一对一、一对多、多对多，Mybatis提供了`@One`、`@Many`、`@ResultMap`等注解或XML标签来进行映射配置。这些映射关系的配置使得在Java对象和数据库表之间建立起了桥梁，方便数据的存取。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值