<dependency>

           <groupId>org.springframework</groupId>

           <artifactId>spring-webmvc</artifactId>

           <version>4.3.18.RELEASE</version>

</dependency>

<listener>

              <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

<context-param>

              <param-name>contextConfigLocation</param-name>

              <param-value>classpath:applicationContext.xml</param-value>

</context-param>

<servlet>

    <servlet-name>springmvc</servlet-name>

    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

    <init-param>

      <param-name>contextConfigLocation</param-name>

      <param-value>classpath:springmvc-servlet.xml</param-value>

    </init-param>

    <load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

    <servlet-name>springmvc</servlet-name>

    <url-pattern>/</url-pattern>

</servlet-mapping>

    <!-- spring扫描的包 -->

    <context:component-scan base-package="com.wjj"/>

    <!-- DispatcherServlet不处理静态资源,交给服务器默认的servlet处理 -->

    <mvc:default-servlet-handler />

    <!-- 启用annotation -->

    <mvc:annotation-driven />

        <!-- mysql 的驱动包-->

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>8.0.12</version>

        </dependency>

        <!--logback 日志包-->

        <dependency>

            <groupId>ch.qos.logback</groupId>

            <artifactId>logback-classic</artifactId>

            <version>1.2.3</version>

        </dependency>

        <!-- mybatis jar 包-->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis</artifactId>

            <version>3.4.5</version>

        </dependency>

        <!-- 数据库连接池 alibaba 的 druid  -->

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid</artifactId>

            <version>1.1.7</version>

        </dependency>

        <!-- mybatis与spring整合的jar包-->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis-spring</artifactId>

            <version>1.3.1</version>

        </dependency>

        <!--spring管理的 jdbc ,以及事务相关的-->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-jdbc</artifactId>

            <version>4.3.17.RELEASE</version>

        </dependency>

db.driver=com.mysql.cj.jdbc.Driver

db.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC

db.username=root

db.password=123456

max=20

min=10

<?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="com.wjj.dao.UserDao">

       <insert id="addUser" parameterType="com.wjj.entity.User">

              insert into users(name,age) values(#{name}, #{age})

       </insert>

       <delete id="deleteUser" parameterType="int">

              delete from users where id=#{id}

       </delete>

       <update id="updateUser" parameterType="com.wjj.entity.User">

              update users set name=#{name},age=#{age} where id=#{id}

       </update>

       <select id="getUser" parameterType="int" resultType="com.wjj.entity.User">

              select * from users where id = #{id}

       </select>

       <select id="getAllUsers" resultType="com.wjj.entity.User">

              select * from users

       </select>

</mapper>

package com.wjj.dao;

import java.util.List;

import com.wjj.entity.User;

public interface UserDao {

    void addUser(User user);

    void deleteUser(int id);

    void updateUser(User user);

    User getUser(int id);

    List<User> getAllUsers();

}

<context:property-placeholder location="classpath:db.properties"/>

    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">

        <property name="driverClassName" value="${db.driver}"/>

        <property name="url" value="${db.url}"/>

        <property name="username" value="${db.username}"/>

        <property name="password" value="${db.password}"/>

        <property name="maxActive" value="${max}"/>

        <property name="minIdle" value="${min}"/>

    </bean>

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

        <property name="dataSource" ref="dataSource"/>

        <property name="mapperLocations" value="classpath*:*Mapper.xml"/>

    </bean>

    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">

        <constructor-arg index="0" ref="sqlSessionFactory" />

    </bean>

ClassPathXmlApplicationContext context = new

           ClassPathXmlApplicationContext("classpath:applicationContext.xml");

              /* 得到 SqlSession 对象*/

        SqlSession sqlSession = (SqlSession) context.getBean("sqlSession");

              String statement = null;

              //添加

              statement = "com.wjj.dao.UserDao.addUser";

              int insert = sqlSession.insert(statement, new User(-1, "yinfei", 28));

              System.out.println(insert);

              //删除

              statement = "com.wjj.dao.UserDao.deleteUser";

              int delete = sqlSession.delete(statement, 9);

              System.out.println(delete);

              //查询

              statement = "com.wjj.dao.UserDao.getUser";

              User user = sqlSession.selectOne(statement,1);

              System.out.println(user);

              //修改

              statement = "com.wjj.dao.UserDao.updateUser";

              int update = sqlSession.update(statement, new User(10, "yinfei", 30));

              System.out.println(update);

              //查询所有

              statement = "com.wjj.dao.UserDao.getAllUsers";

              List<User> list = sqlSession.selectList(statement);

              System.out.println(list);

<dependency>

                  <groupId>com.huaban</groupId>

                  <artifactId>jieba-analysis</artifactId>

                  <version>1.0.2</version>

</dependency>

import com.huaban.analysis.jieba.JiebaSegmenter;

JiebaSegmenter segmenter = new JiebaSegmenter();

String sentences = "他来到了网易杭研大厦, 网易杭研大厦";

List<String> wordList = segmenter.sentenceProcess(sentences);

System.out.println(wordList);

Map<String,Integer> amountWord=new HashMap<String,Integer>();

        for (String string : wordList) {

            if(!amountWord.containsKey(string)){

                amountWord.put(string,1);

            }else{

                amountWord.put(string, amountWord.get(string).intValue()+1);

            }

        }

System.out.println(amountWord);

//计算词频TF

Map<String, Double> tfWord=new HashMap<String,Double>();

for (Entry<String, Integer> string : amountWord.entrySet()) {

     tfWord.put(string.getKey(), Double.valueOf(string.getValue())/wordList.size());

}

System.out.println(tfWord);

CREATE DATABASE news_recommend;

字段

默认类型

备注

id

int

用户id，唯一，单调递增，主键

username

VARCHAR(30)

用户名，注册时候填写的，登录的时候使用，唯一索引

password

VARCHAR(30)

密码

phonenum

VARCHAR(30)

手机号

email

VARCHAR(30)

邮箱

level

int

用户等级。索引。

1：管理员

2：普通用户

history_news

TEXT

历史浏览记录, 新闻id列表，用","分割，例如"2,3,11,15"

search_words

TEXT

搜索记录，字符串列表，用","分割，例如"信息,天天,"

USE news_recommend;

CREATE TABLE users (id INT PRIMARY KEY AUTO_INCREMENT, username

 VARCHAR(30), password VARCHAR(30), phonenum VARCHAR(30), email

VARCHAR(30), level INT, history_news TEXT, search_words TEXT);

ALTER TABLE users ADD UNIQUE (username);    //创建唯一索引

ALTER TABLE users ADD INDEX level_index (level); //创建普通索引

DESC users;                                  //查看表的情况

字段

默认类型

备注

id

int

等同于上表中的用户id，主键

token

VARCHAR(30)

管理员token，调用API时需要带上该参数，15分钟后过期，唯一索引

create_time

DATETIME

创建时间，用于使该条记录过期，索引

level

int

用户等级。

1：管理员

2：普通用户

CREATE TABLE users_token (id INT PRIMARY KEY , token VARCHAR(30), create_time DATETIME, level INT);

ALTER TABLE users_token ADD UNIQUE (token);  //创建唯一索引

ALTER TABLE users_token ADD INDEX create_time_index (create_time); //创建普通索引

DESC users_token;                                  //查看表的情况

字段

默认类型

备注

id

int

新闻id，唯一，单调递增，主键

title

VARCHAR(30)

新闻标题

type

VARCHAR(30)

新闻类别，例如：政治新闻、经济新闻、法律新闻、军事新闻、科技新闻、文教新闻、体育版新闻、社会新闻等

label

VARCHAR(30)

新闻标签，新增新闻时用户手动输入

keyword

VARCHAR(30)

关键字，系统自动从新闻内容中提取

content

TEXT

新闻内容,长文本格式，0~65535长度

src

VARCHAR(100)

新闻来源，一个超链接，连接到源地址，例如：https://new.qq.com/omn/20200415/20200415A05J6M00.html

USE news_recommend;

CREATE TABLE news (id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(30), type VARCHAR(30), label VARCHAR(30), keyword VARCHAR(30), content TEXT, src  VARCHAR(100));

ALTER TABLE news ADD INDEX type_index (type); //创建普通索引

ALTER TABLE news ADD INDEX label_index (label); //创建普通索引

ALTER TABLE news ADD INDEX keyword_index (keyword); //创建普通索引

DESC news;                                  //查看表的情况

字段

默认类型

备注

id

int

新闻类别id，唯一，单调递增，主键

type

VARCHAR(30)

新闻类别，例如：政治新闻、经济新闻、法律新闻、军事新闻、科技新闻、文教新闻、体育版新闻、社会新闻等

USE news_recommend;

CREATE TABLE news_type(id INT PRIMARY KEY AUTO_INCREMENT,type VARCHAR(30));

DESC news_type;                                  //查看表的情况

错误码

说明

301

用户已存在（user is already existed）

302

管理员已存在（manager is already existed）

303

用户不存在（user is not existed）

304

用户权限错误(user permission error)

305

参数格式错误(invalid parm)

306

密码错误(password incorrect)

错误码

说明

307

无效的token(invalid token)

错误码

说明

401

新闻类别已存在(news type is already existed)

错误码

说明

错误码

说明

402

新闻类别不存在(news type not exist)

错误码

说明

403

新闻不存在(news not exist)

错误码

说明

错误码

说明

错误码

说明

404

无搜索记录(no search history)