mybatis注解
@Select("select * from t_student where id = #{id}")
@Results({
@Result(id=true,property="id",column="id",javaType=Integer.class),
@Result(property="studentName",column="student_name",javaType=String.class),
@Result(property="courses",column="id",javaType=List.class,many=@Many(select="findCourseByStudentId"))
})
public StudentBean queryStudentWithCourse(int id);
@Select("select id as id, course_name as courseName from t_course where id in"+
"(select fk_course_id from t_stuorcou where fk_student_id = #{id})")
@ResultType(CourseBean.class)
public List<CourseBean> findCourseByStudentId(int id);
@Insert("insert into t_lock (lock_name) values (#{lock.lockName})")
public int saveLock(@Param("lock")LockBean lock) throws Exception;
spring框架
set注入
<bean id="userService" class="com.lovo.sevice.impl.UserServiceImpl">
<property name="dao" ref="userDao"></property>
</bean>
public void setDao(IUserDao dao) {
this.dao = dao;
}
构造器注入
<bean id="userService" class="com.lovo.sevice.impl.UserServiceImpl">
<constructor-arg index="0" ref="userDao"></constructor-arg>
</bean>
public UserServiceImpl( IUserDao dao) {
this.dao = dao;
}