SSM(Spring+SpringMVC+Mybatis)简单新闻管理系统

编程入门行业动态更新时间:2024-10-05 01:20:13

SSM(Spring+SpringMVC+Mybatis)简单新闻<a href=https://www.elefans.com/category/jswz/34/1769858.html style= 管理系统"/>

SSM(Spring+SpringMVC+Mybatis)简单新闻管理系统

项目链接（码云）

项目链接（GitHub）

一、目录结构

二、数据库

/*
Navicat MySQL Data TransferSource Server         : hello
Source Server Version : 50562
Source Host           : localhost:3306
Source Database       : hibernate_labTarget Server Type    : MYSQL
Target Server Version : 50562
File Encoding         : 65001Date: 2021-01-07 16:35:00
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (`id` int(11) NOT NULL AUTO_INCREMENT,`categoryName` varchar(10) NOT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '军事');
INSERT INTO `category` VALUES ('2', '娱乐');
INSERT INTO `category` VALUES ('3', '体育');
INSERT INTO `category` VALUES ('4', '游戏');
INSERT INTO `category` VALUES ('5', '影视');-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(60) NOT NULL,`source` varchar(20) DEFAULT NULL,`content` longtext NOT NULL,`issueTime` datetime NOT NULL,`cid` int(11) DEFAULT NULL,PRIMARY KEY (`id`),KEY `FKasi698e9ovs6xpcedbcdrhk67` (`cid`),CONSTRAINT `news_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('3', 'iou88', 'adfad88', '00008888', '2020-11-19 17:27:17', '1');
INSERT INTO `news` VALUES ('4', '老母猪高产', '新华网', '张三家养的一只老母猪一夜高产12只小猪', '2020-12-26 14:49:49', '3');
INSERT INTO `news` VALUES ('5', '闰土刺猹', '今日头条', '这里的乡村非常美', '2020-12-24 14:50:38', '2');
INSERT INTO `news` VALUES ('7', '超级赛亚人来袭', '龙珠', '速趴贝吉塔', '2020-12-28 12:56:57', '2');
INSERT INTO `news` VALUES ('9', '四级报名时间出了', '中华网', '今年下半年四级时间将推迟两个月报名！！！', '2020-12-28 14:44:11', '2');-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(255) NOT NULL,`password` varchar(255) DEFAULT NULL,PRIMARY KEY (`id`,`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'xiaoxiao', '12138');
INSERT INTO `user` VALUES ('2', 'lbl', '123');

三、配置文件

1.pom.xml

<?xml version="1.0" encoding="UTF-8"?><project xmlns=".0.0" xmlns:xsi=""xsi:schemaLocation=".0.0 .0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.xiaoxiao</groupId><artifactId>news</artifactId><version>1.0-SNAPSHOT</version><packaging>war</packaging><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><mavenpiler.source>1.7</mavenpiler.source><mavenpiler.target>1.7</mavenpiler.target><!-- 设置项目编码编码 --><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><!-- spring版本号 --><spring.version>4.3.5.RELEASE</spring.version><!-- mybatis版本号 --><mybatis.version>3.4.1</mybatis.version></properties><dependencies><!-- java ee --><dependency><groupId>javax</groupId><artifactId>javaee-api</artifactId><version>7.0</version></dependency><!-- 单元测试 --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency><!-- 实现slf4j接口并整合 --><dependency><groupId>ch.qos.logback</groupId><artifactId>logback-classic</artifactId><version>1.2.2</version></dependency><!-- JSON --><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.8.7</version></dependency><!-- 数据库 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.41</version><scope>runtime</scope></dependency><!-- 数据库连接池 --><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.2</version></dependency><!-- MyBatis --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>${mybatis.version}</version></dependency><!-- mybatis/spring整合包 --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.1</version></dependency><!-- thymeleaf --><dependency><groupId>org.thymeleaf</groupId><artifactId>thymeleaf-spring5</artifactId><version>3.0.11.RELEASE</version></dependency><!-- Spring --><dependency><groupId>org.springframework</groupId><artifactId>spring-core</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</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>org.springframework</groupId><artifactId>spring-test</artifactId><version>${spring.version}</version></dependency></dependencies></project>

2.jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
#数据库地址
jdbc.url=jdbc:mysql://localhost:3306/hibernate_lab?useUnicode=true&characterEncoding=utf8
#用户名
jdbc.username=root
#密码
jdbc.password=lbl123...
#最大连接数
c3p0.maxPoolSize=30
#最小连接数
c3p0.minPoolSize=10
#关闭连接后不自动commit
c3p0.autoCommitOnClose=false
#获取连接超时时间
c3p0.checkoutTimeout=10000
#当获取连接失败重试次数
c3p0.acquireRetryAttempts=2

3.spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns=""xmlns:xsi=""xmlns:context=""xmlns:mvc=""xsi:schemaLocation="://www.springframework/schema/beans/spring-beans.xsd://www.springframework/schema/context/spring-context.xsd://www.springframework/schema/mvc/spring-mvc-3.2.xsd"><!-- 扫描web相关的bean --><context:component-scan base-package="cn.wmyskxz.controller"/><mvc:interceptors><!--  使用bean定义一个Interceptor，直接定义在mvc:interceptors根下面的Interceptor将拦截所有的请求   --><!-- <bean class="com.bybo.aca.web.interceptor.Login"/> --><!--注意在<mvc:interceptor>标签中不能有注释，否则报错--><mvc:interceptor><mvc:mapping path="/admin/**" /><mvc:exclude-mapping path="/admin/login"/><mvc:exclude-mapping path="/admin/loginVerify"/><bean class="cn.wmyskxz.config.LoginHandlerInterceptor"/></mvc:interceptor></mvc:interceptors><!-- 开启SpringMVC注解模式 --><mvc:annotation-driven/><!-- 静态资源默认servlet配置 --><mvc:default-servlet-handler/><mvc:resources mapping="/static/**" location="/WEB-INF/static/"/><!-- 配置thymeleaf框架的视图解析对象 --><bean id="templateResolver" class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver"><property name="prefix" value="/WEB-INF/views/"/><property name="suffix" value=".jsp"/><property name="characterEncoding" value="UTF-8"/><property name="order" value="1"/><property name="templateMode" value="HTML5"/><property name="cacheable" value="false"/></bean><bean id="templateEngine" class="org.thymeleaf.spring5.SpringTemplateEngine"><property name="templateResolver" ref="templateResolver"/></bean><bean id="viewResolver" class="org.thymeleaf.spring5.view.ThymeleafViewResolver"><property name="templateEngine" ref="templateEngine"/><property name="characterEncoding" value="UTF-8"/></bean></beans>

4.spring-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns=""xmlns:xsi=""xmlns:context="" xmlns:tx=""xsi:schemaLocation="://www.springframework/schema/beans/spring-beans.xsd://www.springframework/schema/context/spring-context.xsd  .xsd"><!-- 扫描service包下所有使用注解的类型 --><context:component-scan base-package="cn.wmyskxz.service"/><!-- 配置数据库相关参数properties的属性：${url} --><context:property-placeholder location="classpath:jdbc.properties"/><!-- 数据库连接池 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/><property name="maxPoolSize" value="${c3p0.maxPoolSize}"/><property name="minPoolSize" value="${c3p0.minPoolSize}"/><property name="autoCommitOnClose" value="${c3p0.autoCommitOnClose}"/><property name="checkoutTimeout" value="${c3p0.checkoutTimeout}"/><property name="acquireRetryAttempts" value="${c3p0.acquireRetryAttempts}"/></bean><!-- 配置SqlSessionFactory对象 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- 注入数据库连接池 --><property name="dataSource" ref="dataSource"/><!-- 扫描entity包 使用别名 --><property name="typeAliasesPackage" value="cn.wmyskxz.entity"/><!-- 扫描sql配置文件:mapper需要的xml文件 --><property name="mapperLocations" value="classpath:mapper/*.xml"/></bean><!-- 配置扫描Dao接口包，动态实现Dao接口，注入到spring容器中 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!-- 注入sqlSessionFactory --><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/><!-- 给出需要扫描Dao接口包 --><property name="basePackage" value="cn.wmyskxz.dao"/></bean><!-- 配置事务管理器 --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><!-- 注入数据库连接池 --><property name="dataSource" ref="dataSource"/></bean><!-- 配置基于注解的声明式事务 --><tx:annotation-driven transaction-manager="transactionManager"/></beans>