jsp+ssm+mysql实现图书馆预约占座管理系统项目
软件工具 Eclipse Mars (IDEA也可) JDK1.7 TOMCAT7 MySQL
下载链接：/gepanjiang/LibrarySeats
一款由jsp+ssm+mysql实现的图书馆预约占座管理系统，前端采用的是当下最流行的easyui框架，后台用的ssm（spring、springMVC、mybaits）框架，主要实现的功能有：用户管理、菜单管理、角色管理、权限管理、学生管理、教师管理、班级管理、图书馆阅览室管理、学生信用管理、预约占座管理、发帖评论管理、违规统计、占座预约统计等，添加学生和教师时会自动在用户表中注册，定时任务会定时生成座位信息，阅览室分类中可设置信用等级，学生被扣分后信用等级低于相应的值后不能预约相应的阅览室座位。
【配置文件 applicationContext.xml】
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:mvc="/schema/mvc"xmlns:xsi="/2001/XMLSchema-instance"xmlns:context="/schema/context"xmlns:aop="/schema/aop"xmlns:tx="/schema/tx"xmlns:jee="/schema/jee"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-3.0.xsd/schema/context/schema/context/spring-context-3.0.xsd/schema/mvc/schema/mvc/spring-mvc-3.0.xsd/schema/aop/schema/aop/spring-aop-3.0.xsd/schema/tx/schema/tx/spring-tx-3.0.xsd/schema/jee/schema/jee/spring-tx-3.0.xsd"default-autowire="byType"><!-- 自动扫描组件，这里要把controler下面的 controller去除，他们是在spring3-servlet.xml中配置的，如果不去除会影响事务管理的。 --> <context:component-scan base-package="dingzhen"> </context:component-scan> <!--<import resource="applicationContext-bean.xml"/>--><!-- ============================== 数据库配置 ==================================== --><bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><property name="locations"><list><value>classpath*:config.properties</value></list></property></bean><!-- 数据源配置 --><bean name="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName"><value>${DRIVER}</value></property><property name="url"><value>${URL}</value></property><property name="username"><value>${USERNAME}</value></property><property name="password"><value>${PWS}</value></property></bean><!-- ================================ MyBatis SqlSession配置 ========================================= --><!-- 使用SqlSessionFactoryBean工厂产生SqlSession对象，方便后期注入Dao --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="configLocation" value="classpath:mybatis_config/Configuration.xml"></property></bean><bean class="org.mybatis.spring.annotation.MapperScannerPostProcessor"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /><property name="basePackage" value="dingzhen.dao" /></bean><!-- 开启事务注解驱动 --><tx:annotation-driven /><!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><!-- ********************************定义AOP切面******************************** --><aop:aspectj-autoproxy /><!-- 自动装载aop --><bean id="logAspect" class="dingzhen.aop.LogAspect"/><!-- 切面定义（采用注解的方式定义及使用） --></beans>
【MyBatis: Student.xml】
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-////DTD Mapper 3.0//EN" "/dtd/mybatis-3-mapper.dtd"><mapper namespace="dingzhen.dao.StudentDao"><select id="findStudent" parameterType="student" resultType="student">select a.id as id,a.name as name,a.no as no,a.sex as sex,a.birth as birth,a.phone as phone,a.mail as mail,a.photo as photo,a.clazzid as clazzid,b.name as clazznamefrom student a left join clazz b on a.clazzid = b.id where 1 =1 <if test="clazzid != null and '' != clazzid"> <![CDATA[ and clazzid = #{clazzid} ]]> </if><if test="name != null and '' != name"> <![CDATA[ AND a.name like '%' #{name} '%' ]]> </if><if test="no!=null and ''!=no"> <![CDATA[ AND a.no like '%' #{no} '%' ]]> </if><if test="page != null and rows != null" > limit #{page}, #{rows} </if></select><select id="countStudent" parameterType="student" resultType="int">select count(*)from student a left join clazz b on a.clazzid = b.id where 1 =1 <if test="clazzid != null and '' != clazzid"> <![CDATA[ and clazzid = #{clazzid} ]]> </if><if test="name != null and '' != name"> <![CDATA[ AND a.name like '%' #{name} '%' ]]> </if><if test="no!=null and ''!=no"> <![CDATA[ AND a.no like '%' #{no} '%' ]]> </if></select><insert id="addStudent" parameterType="student" >insert student(no,name,sex,clazzid,birth,phone,mail,photo) values (#{no},#{name},#{sex},#{clazzid},#{birth},#{phone},#{mail},#{photo})</insert><update id="updateStudent" parameterType="student">update student set<trim suffixOverrides=","><if test="name!=null">name=#{name},</if><if test="no!=null">no=#{no},</if><if test="sex!=null">sex=#{sex},</if><if test="clazzid!=null">clazzid=#{clazzid},</if><if test="birth!=null">birth=#{birth},</if><if test="phone!=null">phone=#{phone},</if><if test="mail!=null">mail=#{mail},</if><if test="phone!=null">phone=#{phone},</if></trim><where>id=#{id}</where></update><delete id="deleteStudent" parameterType="Integer">delete from student <where>id=#{id}</where></delete><select id="findOneStudentByno" resultType="student">select a.id as id,a.name as name,a.no as no,a.sex as sex,a.birth as birth,a.phone as phone,a.mail as mail,a.photo as photo,a.clazzid as clazzid,b.name as clazznamefrom student a left join clazz b on a.clazzid = b.id where a.no = #{no} </select></mapper>
