把student项目改造成ssm  struts2 +mybatis+spring

1，先添加spring支持：类库三个，applicationContext.xml写在webinf下四个命名空间，监听器

2，添加struts2支持  struts2与spring整合的jar包

3，添加mybatis2支持，把jar包导入，mybatis与spring整合的jar包，把原来在mybatis.cfg.xml中的大部分配置都写在applicationContext.xml，跟hibernate一样，只不过像日志输出方式与分页插件还是需要写在mybatis.cfg.xml中

<?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:aop="http://www.springframework.org/schema/aop"

	xmlns:context="http://www.springframework.org/schema/context"

	xmlns:p="http://www.springframework.org/schema/p"

	xmlns:tx="http://www.springframework.org/schema/tx"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd

		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd

		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd">

	<context:component-scan base-package="cn.bdqn.student"/>

	<!-- 配置数据源 -->

	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"

	p:driverClassName="oracle.jdbc.OracleDriver"

		p:url="jdbc:oracle:thin:@localhost:1521:ORCL"

		p:username="stuinfo"

		p:password="ok"

	/>

	<!-- 配置SQLSessionFactory "dataSource"注入数据源 typeAliasesPackage把这个实体类下的所有都自动设置别名-->

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"

		p:dataSource-ref="dataSource"

		p:mapperLocations="classpath:cn/bdqn/student/mapper/*.xml"

		p:typeAliasesPackage="cn.bdqn.student.entity"

		p:configLocation="classpath:mybatis.cfg.xml"

	/>

	<!-- 配置事务管理器 -->

	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"

		p:dataSource-ref="dataSource"

	/>

	<!-- 事务增强 -->

	<tx:advice id="txAdvice">

		<tx:attributes>

			<tx:method name="*"/>

		</tx:attributes>

	</tx:advice>

	<!-- 事务切面 -->

	<aop:config>

		<aop:pointcut expression="execution(* cn.bdqn.student.service..*.*(..))" id="txMethods"/>

		<aop:advisor advice-ref="txAdvice" pointcut-ref="txMethods"/>

	</aop:config>

	<!-- 配置动态创建Mapper实现类对象 -->

	<!--

	<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"

		p:mapperInterface="cn.bdqn.student.mapper.UserMapper"

		p:sqlSessionFactory-ref="sqlSessionFactory"

	/>  

   	<bean id="courseMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"

		p:mapperInterface="cn.bdqn.student.mapper.CourseMapper"

		p:sqlSessionFactory-ref="sqlSessionFactory"

	/>  

	<bean id="educationMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"

		p:mapperInterface="cn.bdqn.student.mapper.EducationMapper"

		p:sqlSessionFactory-ref="sqlSessionFactory"

	/>

	<bean id="studentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"

		p:mapperInterface="cn.bdqn.student.mapper.StudentMapper"

		p:sqlSessionFactory-ref="sqlSessionFactory"

	/>

	-->

	<!-- 扫描指定的包，根据映射自动生成Mapper实现类对象 -->

	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"

		p:basePackage="cn.bdqn.student.mapper"

	/>  

</beans>

<?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="cn.bdqn.student.mapper.StudentMapper">

	<insert id="saveStudent" parameterType="Student">

		INSERT INTO Student(id,name,sex,birthday,cid,eid,contact,time,state,addTime,pic) VALUES(

		SEQ_STUDENT.nextval,

		#{name},

		#{sex},

		#{birthday},

		#{course.id},

		#{education.id},

		#{contact},

		#{time},

		#{state},

		#{addtime},

		#{pic}

		)

	</insert>

	<select id="getStudent" resultMap="studentMap">

		SELECT

      	  s.id,

		  s.name,

		  s.sex,

		  s.birthday,

		  s.cid,

		  s.eid,

		  s.contact,

		  s.time,

		  s.state,

		  s.addTime,

		  c.name AS cname,

		  e.name AS ename,

      	  s.pic

		FROM Student s INNER JOIN Course c ON s.cid=c.id

		               INNER JOIN Education e ON s.eid=e.id

		WHERE s.id=#{id}

	</select>

	<select id="findStudent" resultMap="studentMap">

		SELECT

      	  s.id,

		  s.name,

		  s.sex,

		  s.birthday,

		  s.cid,

		  s.eid,

		  s.contact,

		  s.time,

		  s.state,

		  s.addTime,

		  c.name AS cname,

		  e.name AS ename,

      	  s.pic

		FROM Student s INNER JOIN Course c ON s.cid=c.id

		               INNER JOIN Education e ON s.eid=e.id

		<where>

			<if test="name!=null">s.name LIKE #{name}</if>

			<if test="courseId">AND s.cid=#{courseId}</if>

			<if test="time!=null">AND time=#{time}</if>

			<if test="educationId!=null">AND s.eid=#{educationId}</if>

			<if test="state!=null">AND state=#{state}</if>

		</where>

		ORDER  BY s.id DESC

	</select>

	<resultMap id="studentMap" type="Student">

		<id column="id" property="id"/>

		<result column="name" property="name"/>

		<result column="sex" property="sex"/>

		<result column="birthday" property="birthday"/>

		<result column="contact" property="contact"/>

		<result column="time" property="time"/>

		<result column="state" property="state"/>

		<result column="addTime" property="addtime"/>

		<result column="birthday" property="birthday"/>

		<association property="course" javaType="Course">

			<id column="cid" property="id"/>

			<result column="cname" property="name"/>

		</association>

		<association property="education" javaType="Education">

			<id column="eid" property="id"/>

			<result column="ename" property="name"/>

		</association>

	</resultMap>

	<update id="updateStudent" parameterType="Studnet">

		UPDATE Student SET

			name=#{name},

			sex=#{sex},

			birthday=#{birthday},

			cid=#{course.id},

			eid=#{education.id},

			contact=#{contact},

			time=#{time},

			state=#{state},

			pic=#{pic}

		WHERE

			id=#{id}

	</update>

	<delete id="deleteStudent">

		DELETE FROM Student WHERE id=#{id} 

	</delete>

</mapper>

package cn.bdqn.student.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import cn.bdqn.mybatis.plugin.PageParam;

import cn.bdqn.student.entity.Course;

import cn.bdqn.student.entity.Student;

public interface StudentMapper {

	public List<Student> findStudent(

			@Param("pageParam") PageParam param,

			@Param("name") String name,

			@Param("courseId") Integer courseId,

			@Param("time") Integer time,

			@Param("educationId") Integer educationId,

			@Param("state") Integer state

			);

	public void saveStudent(Student student); 

	public Student getStudent(Integer id);

	//更新学生

	public void updateStudent(Student student);

	//删除学生

	public void deleteStudent(Integer id);

}

package cn.bdqn.student.dao.student;

import java.util.List;

import org.apache.commons.lang.StringUtils;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Repository;

import cn.bdqn.mybatis.plugin.PageParam;

import cn.bdqn.student.entity.Student;

import cn.bdqn.student.mapper.StudentMapper;

import cn.bdqn.student.util.PageBean;

@Repository("studentDAO")

public class StudentDAOImpl implements IStudentDAO{

	private StudentMapper studentMapper;

	@Autowired

	public void setStudentMapper(StudentMapper studentMapper) {

		this.studentMapper = studentMapper;

	}

	@Override

	public void saveStudent(Student student) {

		studentMapper.saveStudent(student);

	}

	@Override

	public PageBean findStudent(int pageIndex, int pageSize, String name,

			Integer courseId, Integer time, Integer educationId, Integer state) {

		PageBean p=new PageBean();

		PageParam param=new PageParam();

		if(StringUtils.isEmpty(name) ){

			name=null;

		}//由于name是“”空字符串，但我在判断的时候却是以空来进行判断的，所以需要进行处理

		List<Student> results=studentMapper.findStudent(param, name, courseId, time, educationId, state);

		p.setPageIndex(pageIndex);

		p.setPageSize(pageSize);

		p.setPageCount(param.getPageCount());

		p.setResults(results);

		p.setRowCount(param.getRowCount());

		return p;

	}

	@Override

	public Student getStudent(Integer id) {

		// TODO Auto-generated method stub

		return studentMapper.getStudent(id);

	}

	@Override

	public void updateStudent(Student student) {

		// TODO Auto-generated method stub

	}

	@Override

	public void deleteStudent(Integer id) {

		// TODO Auto-generated method stub

	}

}

最新文章

  1. Sql Server函数全解(三)数据类型转换函数和文本图像函数
  2. oracle数据库从入门到精通
  3. Centos ftp服务器安装配置
  4. Git.Framework 框架随手记--SQL配置文件的使用
  5. sgu548 Dragons and Princesses　　　贪心＋优先队列
  6. ExtjsMVC开发过程中遇到的具体问题总结
  7. 详解C/C++函数指针声明 ( *( void(*)())0)();
  8. Android应用程序的生命周期
  9. iOS使用ffmpeg播放rstp实时监控视频数据流
  10. Python入门（转）
  11. 【Android开发经验】使用反射，得到的类的字段、方法、并实现了简单的调用
  12. Gulp和webpack的区别，是一种工具吗？
  13. Java集合之Properties
  14. NET 泛型，详细介绍
  15. Android单元测试之三：使用模拟框架模拟依赖
  16. LinkedList阅读
  17. 谈谈逆向android里面的so
  18. Saltstack报错小记
  19. ERC: Claim Holder #735 status:Discussion
  20. 使用vue模拟购物车小球动画

热门文章

  1. Loadrunner教程读后感-VuGen
  2. android 项目学习随笔二（引导页 ）
  3. ssh-keygen+ssh-copy-id 在linux下实现ssh无密码登录访问(转)
  4. Jquery 插件库
  5. JAVA学习方法
  6. git 使用详解（5）-- get log 查看提交历史【转】
  7. error LNK1123: 转换到 COFF 期间失败: 文件无效或损坏 E:\OCX
  8. PHP的数据类型、常量、时间
  9. js实现通用的微信分享组件示例
  10. sdp内容解析