SSM框架电影管理系统:电影表、电影类型表和电影排片表映射文件示例
假设你使用的是Java编程语言,并且使用了MyBatis框架来进行数据库操作,以下是示例的映射文件的写法:
- 电影表(ssm_movie)的映射文件(MovieMapper.xml):
<!-- MovieMapper.xml -->
<mapper namespace="com.example.mapper.MovieMapper">
<!-- 根据电影ID查询电影信息 -->
<select id="getMovieById" parameterType="int" resultType="com.example.model.Movie">
SELECT * FROM ssm_movie WHERE id = #{id}
</select>
<!-- 插入电影信息 -->
<insert id="insertMovie" parameterType="com.example.model.Movie">
INSERT INTO ssm_movie (id, title, release_date, director, duration)
VALUES (#{id}, #{title}, #{releaseDate}, #{director}, #{duration})
</insert>
<!-- 更新电影信息 -->
<update id="updateMovie" parameterType="com.example.model.Movie">
UPDATE ssm_movie SET title = #{title}, release_date = #{releaseDate}, director = #{director},
duration = #{duration} WHERE id = #{id}
</update>
<!-- 删除电影信息 -->
<delete id="deleteMovie" parameterType="int">
DELETE FROM ssm_movie WHERE id = #{id}
</delete>
</mapper>
- 电影类型表(ssm_movie_type)的映射文件(MovieTypeMapper.xml):
<!-- MovieTypeMapper.xml -->
<mapper namespace="com.example.mapper.MovieTypeMapper">
<!-- 根据类型ID查询类型信息 -->
<select id="getMovieTypeById" parameterType="int" resultType="com.example.model.MovieType">
SELECT * FROM ssm_movie_type WHERE id = #{id}
</select>
<!-- 插入类型信息 -->
<insert id="insertMovieType" parameterType="com.example.model.MovieType">
INSERT INTO ssm_movie_type (id, name) VALUES (#{id}, #{name})
</insert>
<!-- 更新类型信息 -->
<update id="updateMovieType" parameterType="com.example.model.MovieType">
UPDATE ssm_movie_type SET name = #{name} WHERE id = #{id}
</update>
<!-- 删除类型信息 -->
<delete id="deleteMovieType" parameterType="int">
DELETE FROM ssm_movie_type WHERE id = #{id}
</delete>
</mapper>
- 电影排片表(ssm_movie_schedule)的映射文件(MovieScheduleMapper.xml):
<!-- MovieScheduleMapper.xml -->
<mapper namespace="com.example.mapper.MovieScheduleMapper">
<!-- 根据排片ID查询排片信息 -->
<select id="getMovieScheduleById" parameterType="int" resultType="com.example.model.MovieSchedule">
SELECT * FROM ssm_movie_schedule WHERE id = #{id}
</select>
<!-- 插入排片信息 -->
<insert id="insertMovieSchedule" parameterType="com.example.model.MovieSchedule">
INSERT INTO ssm_movie_schedule (id, movie_id, start_time, end_time, theater)
VALUES (#{id}, #{movieId}, #{startTime}, #{endTime}, #{theater})
</insert>
<!-- 更新排片信息 -->
<update id="updateMovieSchedule" parameterType="com.example.model.MovieSchedule">
UPDATE ssm_movie_schedule SET movie_id = #{movieId}, start_time = #{startTime},
end_time = #{endTime}, theater = #{theater} WHERE id = #{id}
</update>
<!-- 删除排片信息 -->
<delete id="deleteMovieSchedule" parameterType="int">
DELETE FROM ssm_movie_schedule WHERE id = #{id}
</delete>
</mapper>
这些示例映射文件中定义了基本的增删改查操作,根据你的具体需求可以进行修改和扩展。同时,你需要根据自己实际的数据库表结构和实体类定义,调整SQL语句和参数类型。
原文地址: https://www.cveoy.top/t/topic/qnJr 著作权归作者所有。请勿转载和采集!