基于ssm框架的图书推荐系统（上）--配置文件

最新推荐文章于 2024-06-24 09:11:37 发布

sand_13

最新推荐文章于 2024-06-24 09:11:37 发布

阅读量4.8k

点赞数 4

分类专栏：练习

本文链接：https://blog.csdn.net/sandman_13/article/details/80568276

版权

练习专栏收录该内容

7 篇文章 0 订阅

订阅专栏

本科毕设题目和推荐系统有关，所以搭了一个基于用户的协同过滤算法实现的图书推荐系统，该系统包括四个模块：用户管理，图书管理，借阅管理，个性化图书推荐。下面讲述整个系统的搭建流程。
一、需求分析
首先在数据库创建4张表：user,book,borrow,recommend，表中存入需要的字段。
一、配置文件（Intelli IDEA ,maven项目）
需要配置的文件如下：pom.xml,resources/spring下的applicationContext.xml和spring-mvc.xml。
这里写图片描述
首先新建一个maven项目，修改其pom.xml文件，导入需要使用的依赖：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>fengsigaoju</groupId>
    <artifactId>fengsigaoju-springMvc-book</artifactId>
    <packaging>war</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>fengsigaoju-springMvc-book Maven Webapp</name>
    <url>http://maven.apache.org</url>
    <properties>
        <spring.version>4.0.5.RELEASE</spring.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.0.1</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.45</version>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>com.google.guava</groupId>
            <artifactId>guava</artifactId>
            <version>19.0</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.7.sec01</version>
        </dependency>
        <!--数据库连接池使用dbcp的jar-->
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.4</version>
        </dependency>
        <!--spring与mybatis整合-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.6</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-core</artifactId>
            <version>2.1.0</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.1.0</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-annotations</artifactId>
            <version>2.1.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${spring.version}</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <dependency>
            <groupId>com.aliyun.oss</groupId>
            <artifactId>aliyun-sdk-oss</artifactId>
            <version>2.8.2</version>
        </dependency>
        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.4</version>
        </dependency>
        <!--pageHelper-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.0.2</version>
        </dependency>
    </dependencies>
    <build>
        <finalName>fengsigaoju-springMvc-book</finalName>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

其次，配置spring-mvc.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:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:task="http://www.springframework.org/schema/task"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/task
       http://www.springframework.org/schema/task/spring-task.xsd">
    <!--查找使用构造型注解所标注的类,如@Component(组件)以及子类@Service（服务）,@Controller（控制器）,@Repository（数据仓库）-->
    <context:component-scan base-package="book.controller"/>
    <context:component-scan base-package="book.service"/>
    <context:component-scan base-package="book.dao"/>
    <context:component-scan base-package="book.task"/>
    <!-- 开启SpringMVC注解模式 -->
    <mvc:annotation-driven/>

    <!--DefaultServletHttpRequestHandler 对于进入DispatcherServlet的URL进行筛查,如果是静态资源的请求,就将该请求转由WEB应用默认的servlet处理-->
    <mvc:default-servlet-handler/>

    <!-- 配置视图路径的前缀和后缀-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
        <property name="prefix" value="/WEB-INF/jsp/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

最后，配置applicationContext.xml文件

这里写代码片<?xml version="1.0" encoding="UTF-8"?>
<!--这边是关联的schema文件,当需要使用相应的标签就需要引入对应的schema文件约束,在xmlns中配置,在schemaLocation配置两个地址,注意第二个地址可以省略版本号,版本号和pom里面的定义一致-->
<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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd"
       default-autowire="byName">

    <!--读取数据库的配置文件,之后可以使用占位符的方式-->
    <context:property-placeholder location="classpath:db.properties"/>
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <!--初始化连接大小-->
        <property name="initialSize" value="${jdbc.initialSize}"/>
        <!--设置最大活跃连接数-->
        <property name="maxActive" value="${jdbc.maxActive}"/>
        <!--设置最大空闲连接数,一般接近最大活跃连接数,因为超过最大空闲连接数剩余的连接会自动销毁,无法起到数据库连接池的作用-->
        <property name="maxIdle" value="${jdbc.maxIdle}"/>
        <!--设置最小空闲连接数-->
        <property name="minIdle" value="${jdbc.minIdle}"/>
        <!--设置最大超时时间-->
        <property name="maxWait" value="${jdbc.maxWait}"/>
        <!--解决mysql8小时问题-->
        <property name="testOnBorrow" value="${jdbc.testOnBorrow}"/>
        <property name="validationQuery" value="${jdbc.validationQuery}"/>
    </bean>
    <!-- spring和MyBatis整合，可以省略mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--设置数据源,这里使用dbcp的数据库连接池-->
        <property name="dataSource" ref="dataSource"/>
        <!--这里设置mybatis数据源配置(不是必须的,先留着吧)-->
        <property name="configLocation" value="classpath:mybatis/configuration.xml"/>
        <!-- 自动扫描mapping.xml映射文件-->
         <property name="mapperLocations" value="classpath:mybatis/sqlMap/*.xml"/>
    </bean>
    <!--配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--配置事务模板,之后可以使用编程式事务方式-->
    <bean id="transactionTemplate"
          class="org.springframework.transaction.support.TransactionTemplate">
        <property name="transactionManager" ref="transactionManager"/>
    </bean>
    <!--默认线程池-->
    <bean id="defaultEventHandlerExecutor" class="org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor">
        <property name="corePoolSize" value="5"/>
        <property name="maxPoolSize" value="20"/>
        <property name="queueCapacity" value="50"/>
    </bean>
</beans>

和数据库交互需要配置db.properties和Mybatis Sqlmap。
db.properties配置如下：

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=***
jdbc.initialSize=10
jdbc.maxActive=100
jdbc.maxIdle=100
jdbc.minIdle=0
jdbc.maxWait=1000
jdbc.testOnBorrow=true
jdbc.validationQuery=select 1

以user表为例，配置user.xml文件。

<?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="hahaha">

    <!--设置返回结果集,将数据库字段和java对象字段建立联系,type是java对象路径,id是结果集的唯一标识-->
    <resultMap type="UserDO" id="USER">
        <!--数据库是主键用id标签,非主键用result标签,column是数据库的字段名,property是java对象的字段名-->
        <id column="user_id" jdbcType="BIGINT" property="userId"/>
        <result column="username" jdbcType="VARCHAR" property="username"/>
        <result column="password" jdbcType="VARCHAR" property="password"/>
        <result column="user_status" jdbcType="VARCHAR" property="userStatus"/>
        <result column="gmt_modified" jdbcType="TIMESTAMP" property="gmtModified"/>
        <result column="gmt_create" jdbcType="TIMESTAMP" property="gmtCreate"/>
        <result column="modifier" jdbcType="VARCHAR" property="modifier"/>
        <result column="email" jdbcType="VARCHAR" property="email"/>
        <result column="phone_number" jdbcType="VARCHAR" property="phoneNumber"/>
        <result column="sex" jdbcType="INTEGER" property="sex"/>
        <result column="age" jdbcType="INTEGER" property="age"/>
        <result column="profession" jdbcType="VARCHAR" property="profession"/>
    </resultMap>

    <select id="queryByUserNameAndPassword" resultMap="USER">
        SELECT * FROM user where username=#{username} and password=#{password} and user_status!='DELETED'
    </select>

    <select id="queryByUserId" resultMap="USER">
        SELECT * FROM user where user_status!='DELETED' and user_id=#{userId}
    </select>

    <select id="listAllUsers" resultMap="USER">
        SELECT  * FROM user where user_status!='DELETED'
    </select>

    <insert id="insertUser"  parameterType="book.domain.dataobject.UserDO" useGeneratedKeys="true" keyProperty="userId">
        INSERT INTO user(username,password,user_status,gmt_modified,gmt_create,modifier,email,phone_number,sex,age,profession) VALUES (#{username},#{password},#{userStatus},CURRENT_TIMESTAMP ,CURRENT_TIMESTAMP ,#{modifier},#{email},#{phoneNumber},#{sex},#{age},#{profession})
    </insert>

    <update id="updateUser" parameterType="book.domain.dataobject.UserDO" useGeneratedKeys="true" keyProperty="userId">
        UPDATE user set username=#{username},password=#{password},user_status=#{userStatus},gmt_modified=#{gmtModified},gmt_create=#{gmtCreate},modifier=#{modifier},email=#{email},phone_number=#{phoneNumber},sex=#{sex},age=#{age},profession=#{profession} WHERE user_id=#{userId}
    </update>

    <delete id="deleteUser" parameterType="long">
        UPDATE user SET user_status='DELETED' WHERE user_id=#{userId}
    </delete>

    <select id="queryByName" resultMap="USER">
        SELECT * FROM user WHERE user_status!='DELETED'AND username=#{username}
    </select>
</mapper>

sand_13

关注

4
点赞
踩
33

收藏

觉得还不错? 一键收藏
6
评论
基于ssm框架的图书推荐系统（上）--配置文件

本科毕设题目和推荐系统有关，所以搭了一个基于用户的协同过滤算法实现的图书推荐系统，该系统包括四个模块：用户管理，图书管理，借阅管理，个性化图书推荐。下面讲述整个系统的搭建流程。一、需求分析首先在数据库创建4张表：user,book,borrow,recommend，表中存入需要的字段。一、配置文件（Intelli IDEA ,maven项目）需要配置的文件如下：pom.xml,re...
复制链接

扫一扫