少年阿宾

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> student=new ArrayList<Student>();
 
 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<Student> getStudent() {
  return student;
 }

 public void setStudent(List<Student> student) {
  this.student = student;
 }

 
}

StudentMapper.xml（org.abin.lee.bean）
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.abin.lee.dao.StudentDao">
  <parameterMap type="Student" id="parameterStudentMap">
    <parameter property="sid"/>
    <parameter property="sname"/>
    <parameter property="teacherId"/>
  </parameterMap>
   
  <insert id="insertStudent"    parameterMap="parameterStudentMap">
    <selectKey    keyProperty="sid" resultType="int" order="AFTER">
      SELECT LAST_INSERT_ID() AS ID
    </selectKey>
    INSERT INTO student(sname,teacherId)
    VALUES(#{sname},#{teacherId})
  </insert>   
   
  <resultMap type="Student" id="StudentMap">
    <result property="sid" column="sid"/>
    <result property="sname" column="sname"/>
    <result property="teacherId" column="teacherId"/>
    <association property="teacher" javaType="Teacher" column="teacherId" select="org.abin.lee.dao.TeacherDao.getTeacher"/>
  </resultMap>   
  <select id="getStudent" resultMap="StudentMap" parameterType="int">
    SELECT * FROM student
    WHERE sid=#{sid}
  </select>
   
  <select id="getStudentById" resultMap="StudentMap" parameterType="int">
    SELECT * FROM student
    WHERE teacherId=#{teacherId}
  </select>
 
 
</mapper>  



TeacherMapper.xml（org.abin.lee.bean）

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.abin.lee.dao.TeacherDao">
  <parameterMap type="Teacher" id="parameterTeacherMap">
    <parameter property="tid"/>
    <parameter property="tname"/>
  </parameterMap>

  <insert id="insertTeacher" parameterMap="parameterTeacherMap">
    <selectKey    keyProperty="tid" resultType="int" order="AFTER">
      SELECT @@IDENTITY AS ID
    </selectKey>
    INSERT INTO teacher(tname)
    VALUES(#{tname})
  </insert>       
   
  <resultMap type="Teacher" id="resultTeacherMap">
    <result property="tid" column="tid"/>
    <result property="tname" column="tname"/>
    <collection property="student" column="sid" select="org.abin.lee.dao.StudentDao.getStudentById"/>
  </resultMap>
   
  <select id="getTeacher" resultMap="resultTeacherMap" parameterType="int">
    SELECT *
    FROM teacher
    WHERE tid=#{id}
  </select>         
  
</mapper>

package org.abin.lee.dao;

import java.util.List;

import org.abin.lee.bean.Student;

public interface StudentDao {
 void insertStudent(Student student);
 List<Student> getStudent(int id);
 List<Student> 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<Student> getStudent(int id) {
  List<Student> list=null;
  String hql="select o from Student o where o.id="+id;
  try {
   list=(List<Student>)this.getHibernateTemplate().find(hql);
  } catch (Exception e) {
   e.printStackTrace();
  }
  return list;
 }

 public List<Student> getStudentById(int teacherId) {
  List<Student> list=null;
  String hql="select o from Student o where o.id="+teacherId;
  try {
   list=(List<Student>)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<Student> getStudent(int id);
 List<Student> 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<Student> getStudent(int id) {
  return this.studentDao.getStudent(id);
 }

 public List<Student> 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）

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">

   <!--创建数据映射器，数据映射器必须为接口-->
 <bean id="studentDao"
  class="org.mybatis.spring.mapper.MapperFactoryBean">
  <property name="sqlSessionFactory" ref="sqlSessionFactory" />
  <property name="mapperInterface"
   value="org.abin.lee.dao.StudentDao" />
 </bean>
 
 <bean id="teacherDao"
  class="org.mybatis.spring.mapper.MapperFactoryBean">
  <property name="sqlSessionFactory" ref="sqlSessionFactory" />
  <property name="mapperInterface"
   value="org.abin.lee.dao.TeacherDao" />
 </bean>

</beans>

applicationContext-resource.xml（org.abin.lee.spring）

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">

 <!--配置数据源 -->
 <bean id="dataSource"
  class="org.apache.commons.dbcp.BasicDataSource"
  destroy-method="close">
  <property name="driverClassName"
   value="com.mysql.jdbc.Driver">
  </property>
  <property name="url" value="jdbc:mysql://localhost:3306/abin"></property>
  <property name="username" value="root"></property>
  <property name="password" value=""></property>
  <property name="maxActive" value="100"></property>
  <property name="maxIdle" value="30"></property>
  <property name="maxWait" value="500"></property>
  <property name="defaultAutoCommit" value="true"></property>
 </bean>

    <!-- 创建SqlSessionFactory，同时指定数据源-->
 <bean id="sqlSessionFactory"
  class="org.mybatis.spring.SqlSessionFactoryBean">
  <property name="dataSource" ref="dataSource" />
  <property name="configLocation"
   value="classpath:mybatis-config.xml" />
 </bean>

 <bean id="transactionManager"
  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource" />
 </bean>

</beans>

applicationContext-service.xml（org.abin.lee.spring）

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">

 <bean id="studentService"
  class="org.abin.lee.service.impl.StudentServiceImpl">
  <property name="studentDao">
   <ref bean="studentDao" />
  </property>
 </bean>

 <bean id="teacherService"
  class="org.abin.lee.service.impl.TeacherServiceImpl">
  <property name="teacherDao">
   <ref bean="teacherDao" />
  </property>
 </bean>

</beans>

mybatis-config.xml（直接放在src目录下面）

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD  Config 3.0//EN"              
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

 <settings>
  <!-- changes from the defaults for testing -->
  <setting name="cacheEnabled" value="false" />
  <setting name="useGeneratedKeys" value="true" />
  <setting name="defaultExecutorType" value="REUSE" />
 </settings>

 <typeAliases>
  <typeAlias type="org.abin.lee.bean.Student" alias="Student" />
  <typeAlias type="org.abin.lee.bean.Teacher" alias="Teacher" />
 </typeAliases>

 

 <mappers>
  <mapper resource="org/abin/lee/bean/StudentMapper.xml" />
  <mapper resource="org/abin/lee/bean/TeacherMapper.xml" />
 </mappers>

</configuration>





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<Student> list=this.studentService.getStudentById(4);
  Student stu=new Student();
  Teacher tea=new Teacher();
  for(int i=0;i<list.size();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;
 }
 
}