Bootstrap4+MySQL前后端综合实训-Day10-AM【实训汇报-下午返校、项目代码（7个包+7个Html页面）】

电玩女神 2022-12-24 05:58 153阅读 0赞

【Bootstrap4前端框架+MySQL数据库】前后端综合实训【10天课程 博客汇总表 详细笔记】【附：实训所有代码】

目录

实训汇报

数据库——所有SQL语句

工程文件展示

代码

①package com.newcapec.dao;

BaseDao.java

ItemUserDao.java

LogsInfoDao.java

NewItemDao.java

NewsInfoDao.java

UserInfoDao.java

②package com.newcapec.entity;

ItemUserEntity.java

LogsInfoEntity.java

NewItemEntity.java

NewsInfoEntity.java

ResultData.java

UserInfoEntity.java

③package com.newcapec.servlet;

AddUserServlet.java

DeleteUserServlet.java

LoginServlet.java

SelectUserByIdServlet.java

SelectUserByPageServlet.java

UpdateUserServlet.java

④package com.newcapec.servlet.newitem;

AddItemServlet.java

DeleteItemServlet.java

SelectItemByIdServlet.java

SelectItembyUserServlet.java

UpdateItemServlet.java

⑤package com.newcapec.servlet.news;

AddNewsServlet.java

⑥package com.newcapec.test;

TestItemUserDao.java

TestLogsInfoDao.java

TestNewItemDao.java

NewsInfoDao.java

TestUserInfoDao.java

⑦package com.newcapec.utils;

DBUtils.java

MD5Utils.java

pages

item_manager.html

news_manager.html

user_manager.html

index.html

login.html

loginFailure.html

phone.html

实训汇报

从昨天下午就开始实训答辩了。

今天上午，继续答辩。

上午10:00左右，所有的小组答辩完毕。

革命尚未成功，同学仍需努力~

数据库——所有SQL语句

  1. /*
  2. SQLyog Ultimate v12.08 (64 bit)
  3. MySQL - 8.0.20 : Database - zykkk
  4. *********************************************************************
  5. */
  8. /*!40101 SET NAMES utf8 */;
  10. /*!40101 SET SQL_MODE=''*/;
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. CREATE DATABASE /*!32312 IF NOT EXISTS*/`zykkk` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
  18. USE `zykkk`;
  20. /*Table structure for table `item_user` */
  22. DROP TABLE IF EXISTS `item_user`;
  24. CREATE TABLE `item_user` (
  25.   `item_user_id` int NOT NULL AUTO_INCREMENT,
  26.   `user_id` int DEFAULT NULL,
  27.   `item_id` int DEFAULT NULL,
  28.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  29.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  30.   `status` int DEFAULT '1' COMMENT '1：启用 0：禁用',
  31.   PRIMARY KEY (`item_user_id`),
  32.   KEY `FK_Reference_2` (`user_id`),
  33.   KEY `FK_Reference_3` (`item_id`),
  34.   CONSTRAINT `FK_Reference_2` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`user_id`),
  35.   CONSTRAINT `FK_Reference_3` FOREIGN KEY (`item_id`) REFERENCES `new_item` (`item_id`)
  36. ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;
  38. /*Data for the table `item_user` */
  40. insert  into `item_user`(`item_user_id`,`user_id`,`item_id`,`create_time`,`update_time`,`status`) values (1,1,2,'2020-11-23 11:24:16','2020-11-25 10:27:54',1),(2,2,4,NULL,'2020-11-25 09:38:17',1),(3,1,1,'2020-11-24 09:19:58','2020-11-25 09:38:21',1),(5,1,18,NULL,'2020-11-25 09:44:16',1),(6,1,27,'2020-11-25 11:11:35','2020-11-25 11:11:35',1),(7,1,28,'2020-11-25 11:17:59','2020-11-25 11:17:59',1),(8,1,29,'2020-11-25 11:29:14','2020-11-25 11:29:14',1),(9,1,30,'2020-11-25 11:30:54','2020-11-25 11:30:54',1),(10,1,31,'2020-11-25 11:36:51','2020-11-25 11:36:51',1),(11,1,32,'2020-11-25 16:26:23','2020-11-25 16:26:23',1),(12,1,33,'2020-11-25 16:26:37','2020-11-25 16:26:37',1),(13,1,34,'2020-11-26 10:01:29','2020-11-26 10:01:29',1),(14,1,35,'2020-11-26 10:28:53','2020-11-26 10:28:53',1);
  42. /*Table structure for table `logs_info` */
  44. DROP TABLE IF EXISTS `logs_info`;
  46. CREATE TABLE `logs_info` (
  47.   `logs_id` int NOT NULL AUTO_INCREMENT,
  48.   `user_id` int DEFAULT NULL,
  49.   `logs_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci,
  50.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  51.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  52.   PRIMARY KEY (`logs_id`),
  53.   KEY `FK_Reference_1` (`user_id`),
  54.   CONSTRAINT `FK_Reference_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`user_id`)
  55. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;
  57. /*Data for the table `logs_info` */
  59. insert  into `logs_info`(`logs_id`,`user_id`,`logs_content`,`create_time`,`update_time`) values (1,1,NULL,NULL,'2020-11-24 09:27:05'),(2,2,NULL,NULL,'2020-11-24 09:27:12'),(3,4,NULL,NULL,'2020-11-23 11:29:06'),(14,1,'woshishenren','2020-11-24 09:24:52','2020-11-24 09:24:52'),(15,1,'woshishenren','2020-11-24 09:25:58','2020-11-24 09:25:58');
  61. /*Table structure for table `new_item` */
  63. DROP TABLE IF EXISTS `new_item`;
  65. CREATE TABLE `new_item` (
  66.   `item_id` int NOT NULL AUTO_INCREMENT,
  67.   `item_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci NOT NULL,
  68.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  69.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  70.   `status` int DEFAULT '1' COMMENT '1：启用 0：禁用',
  71.   PRIMARY KEY (`item_id`)
  72. ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;
  74. /*Data for the table `new_item` */
  76. insert  into `new_item`(`item_id`,`item_name`,`create_time`,`update_time`,`status`) values (1,'呵呵哒','2020-11-24 15:47:00','2020-11-26 10:28:39',1),(2,'党支部','2020-11-24 15:47:03','2020-11-25 14:44:31',0),(3,'分团委','2020-11-24 15:47:05','2020-11-25 14:43:54',1),(4,'院团委','2020-11-24 15:47:08','2020-11-25 14:44:38',1),(5,'111','2020-11-23 15:22:54','2020-11-25 14:45:55',1),(6,'学生会','2020-11-24 09:27:36','2020-11-25 14:46:01',1),(8,'党支部','2020-11-24 13:51:13','2020-11-25 14:46:07',1),(18,'党支部','2020-11-25 09:11:51','2020-11-25 15:49:06',1),(19,'院团委','2020-11-25 10:42:54','2020-11-25 14:46:16',1),(20,'111','2020-11-25 10:54:12','2020-11-25 14:46:19',1),(21,'学生会','2020-11-25 10:56:21','2020-11-25 14:46:35',1),(22,'党支部','2020-11-25 10:57:35','2020-11-25 14:46:43',1),(23,'分团委','2020-11-25 11:00:20','2020-11-25 14:46:48',1),(24,'院团委','2020-11-25 11:00:47','2020-11-25 14:46:55',1),(25,'qweqwe','2020-11-25 11:01:37','2020-11-25 11:01:37',1),(26,'eqweqweqwe','2020-11-25 11:01:53','2020-11-25 11:01:53',1),(27,'分团委','2020-11-25 11:11:35','2020-11-25 15:49:18',1),(28,'sadsads','2020-11-25 11:17:59','2020-11-25 11:18:40',0),(29,'院团委','2020-11-25 11:29:13','2020-11-25 15:49:25',1),(30,'789','2020-11-25 11:30:54','2020-11-25 11:37:19',0),(31,'zyk','2020-11-25 11:36:51','2020-11-25 11:37:19',0),(32,'委员会','2020-11-25 16:26:23','2020-11-26 08:37:48',0),(33,'委员会~~~','2020-11-25 16:26:37','2020-11-26 10:01:40',1),(34,'演示~','2020-11-26 10:01:29','2020-11-26 10:01:33',0),(35,'筑基修士！！！','2020-11-26 10:28:53','2020-11-26 10:29:14',1);
  78. /*Table structure for table `news_info` */
  80. DROP TABLE IF EXISTS `news_info`;
  82. CREATE TABLE `news_info` (
  83.   `new_id` int NOT NULL AUTO_INCREMENT,
  84.   `item_id` int DEFAULT NULL,
  85.   `news_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci NOT NULL,
  86.   `news_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci DEFAULT NULL,
  87.   `news_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci,
  88.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  89.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  90.   PRIMARY KEY (`new_id`),
  91.   KEY `FK_Reference_4` (`item_id`),
  92.   CONSTRAINT `FK_Reference_4` FOREIGN KEY (`item_id`) REFERENCES `new_item` (`item_id`)
  93. ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;
  95. /*Data for the table `news_info` */
  97. insert  into `news_info`(`new_id`,`item_id`,`news_title`,`news_image`,`news_content`,`create_time`,`update_time`) values (1,2,'蓝桥杯比赛',NULL,NULL,NULL,'2020-11-23 09:27:39'),(2,3,'新学期学费',NULL,NULL,NULL,'2020-11-23 09:28:10'),(3,1,'拔河比赛',NULL,'拔河比赛要使劲！！！','2020-11-25 14:57:28','2020-11-25 14:57:32'),(4,18,'街舞比赛',NULL,'一起摇摆~','2020-11-25 15:54:09','2020-11-25 15:54:11'),(10,27,'数学建模',NULL,'一起加油！','2020-11-25 16:10:02','2020-11-25 22:17:19'),(11,29,'班班唱',NULL,'《走向复兴》','2020-11-25 16:12:23','2020-11-25 16:12:23'),(12,1,'篮球比赛',NULL,'冲冲冲~','2020-11-25 16:13:04','2020-11-25 16:13:04'),(13,1,'NECCS',NULL,'冲呀~','2020-11-25 16:27:22','2020-11-26 08:38:03'),(14,18,'卓见杯',NULL,'啦啦啦~','2020-11-25 17:41:32','2020-11-25 22:17:56'),(15,33,'动则升阳',NULL,'年轻不养生，年老养医生！','2020-11-26 00:12:42','2020-11-26 00:12:42'),(16,33,'11月26日',NULL,'筑基修士','2020-11-26 10:02:20','2020-11-26 10:02:20'),(17,35,'大家好',NULL,'333','2020-11-26 10:29:35','2020-11-26 10:29:35'),(18,35,'大家好！！！',NULL,'333','2020-11-26 10:29:45','2020-11-26 10:29:45');
  99. /*Table structure for table `user_info` */
  101. DROP TABLE IF EXISTS `user_info`;
  103. CREATE TABLE `user_info` (
  104.   `user_id` int NOT NULL AUTO_INCREMENT,
  105.   `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci NOT NULL,
  106.   `user_pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci NOT NULL,
  107.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  108.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  109.   `status` int DEFAULT '1' COMMENT '1:启用 0：禁用',
  110.   PRIMARY KEY (`user_id`)
  111. ) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;
  113. /*Data for the table `user_info` */
  115. insert  into `user_info`(`user_id`,`user_name`,`user_pwd`,`create_time`,`update_time`,`status`) values (1,'宋书航','1','2020-11-23 09:30:16','2020-11-25 22:16:25',1),(2,'雨柔子','1','2020-11-23 11:25:41','2020-11-25 22:16:25',1),(4,'王五','1','2020-11-23 11:25:58','2020-11-25 22:16:26',0),(5,'赵柳','1','2020-11-23 11:26:12','2020-11-25 22:16:26',0),(8,'田七','1','2020-11-23 11:26:29','2020-11-25 22:16:27',0),(9,'田七','1','2020-11-23 15:03:23','2020-11-25 22:16:28',0),(10,'田七','1','2020-11-23 15:03:43','2020-11-25 22:16:28',0),(11,'戴沐白','1','2020-11-24 10:45:06','2020-11-25 22:16:29',1),(12,'张小凡','1','2020-11-24 10:45:29','2020-11-25 22:16:29',1),(13,'userName2','1','2020-11-24 10:45:29','2020-11-25 22:16:30',0),(15,'碧瑶','1','2020-11-24 10:45:29','2020-11-25 22:16:31',1),(16,'赵恋凡','1','2020-11-24 10:45:29','2020-11-25 22:16:31',1),(17,'李长寿','1','2020-11-24 10:45:29','2020-11-25 22:16:32',1),(18,'蓝梦娥','1','2020-11-24 10:45:29','2020-11-25 22:16:33',1),(22,'路明非','123456','2020-11-24 10:45:29','2020-11-25 17:44:31',1),(23,'楚子航','123456','2020-11-24 10:45:29','2020-11-25 22:14:26',1),(33,'乔微尼','123456','2020-11-24 10:45:29','2020-11-25 23:05:48',1),(97,'userName86','123456','2020-11-24 10:45:32','2020-11-24 10:45:32',1),(98,'userName87','123456','2020-11-24 10:45:32','2020-11-24 10:45:32',1),(99,'userName88','123456','2020-11-24 10:45:32','2020-11-24 10:45:32',1),(100,'userName89','123456','2020-11-24 10:45:32','2020-11-24 10:45:32',1),(101,'2020年好运来~','123456','2020-11-24 10:45:32','2020-11-26 10:01:06',1),(102,'333','123456','2020-11-24 10:45:32','2020-11-26 10:28:14',1),(103,'666','888','2020-11-24 10:45:32','2020-11-26 10:28:26',1),(104,'userName93','123456','2020-11-24 10:45:32','2020-11-26 10:00:54',0),(105,'userName94','123456','2020-11-24 10:45:32','2020-11-26 10:00:47',0),(106,'userName95','123456','2020-11-24 10:45:32','2020-11-26 10:00:47',0),(107,'userName96','123456','2020-11-24 10:45:32','2020-11-26 10:00:47',0),(108,'userName97','123456','2020-11-24 10:45:32','2020-11-26 10:00:47',0),(109,'userName98','123456','2020-11-24 10:45:32','2020-11-25 10:12:58',0),(110,'userName99','123456','2020-11-24 10:45:32','2020-11-25 10:12:58',0),(111,'userName100','123456','2020-11-24 10:45:33','2020-11-25 10:12:58',0),(115,'萧潜','1','2020-11-25 23:00:16','2020-11-25 23:00:16',1),(116,'演示视频','haha','2020-11-26 10:00:33','2020-11-26 10:27:37',0),(117,'啦啦啦','1','2020-11-26 10:27:14','2020-11-26 10:27:37',0),(118,'演示视频','222','2020-11-26 10:27:23','2020-11-26 10:27:37',0),(119,'实训小组hyy','111','2020-11-26 14:37:14','2020-11-26 14:37:14',1);
  117. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  118. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  119. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  120. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

工程文件展示

20210130161831257.png 20210130162001637.png 20210130162016540.png watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70

代码

①package com.newcapec.dao;

BaseDao.java

  1. package com.newcapec.dao;
  3. import java.sql.SQLException;
  4. import java.util.List;
  6. /**
  7.  * JDBC在后期需要使用hibernate/mybatis优化
  8.  * 
  9.  * @author user
  10.  *
  11.  * @param <T>
  12.  */
  13. public interface BaseDao<T> {
  14.     // public int insert(T t) throws ClassNotFoundException, SQLException;
  16.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException;
  18.     public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException;
  20.     public boolean update(T t) throws ClassNotFoundException, SQLException;
  22.     public T selectById(int id) throws ClassNotFoundException, SQLException;
  24.     public List<T> selectAll() throws ClassNotFoundException, SQLException;
  25. }

ItemUserDao.java

  1. package com.newcapec.dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.Date;
  9. import java.util.List;
  11. import com.newcapec.entity.ItemUserEntity;
  12. import com.newcapec.utils.DBUtils;
  14. public class ItemUserDao implements BaseDao<ItemUserEntity> {
  16.     public boolean insert(ItemUserEntity t) throws ClassNotFoundException, SQLException {
  17.         boolean flag = false;
  18.         // 获取与数据库的连接
  19.         Connection connection = DBUtils.openConn();
  20.         // ?表示占位符 可以解决sql注入的问题
  21.         String sql = "insert into item_user (user_id,item_id,create_time) values (?,?,now())";
  22.         PreparedStatement statement = connection.prepareStatement(sql);
  23.         statement.setInt(1, t.getUserId());
  24.         statement.setInt(2, t.getItemId());
  25.         // 执行sql语句
  26.         int count = statement.executeUpdate();
  27.         if (count > 0) {
  28.             flag = true;
  29.         }
  30.         statement.close();
  31.         connection.close();
  32.         return flag;
  33.     }
  35.     @Override
  36.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
  37.         boolean flag = false;
  38.         Connection connection = DBUtils.openConn();
  39.         String sql = "delete from item_user where item_user_id = ?";
  40.         PreparedStatement statement = connection.prepareStatement(sql);
  41.         statement.setInt(1, id);
  42.         int count = statement.executeUpdate();
  43.         if (count > 0) {
  44.             flag = true;
  45.         }
  46.         statement.close();
  47.         connection.close();
  48.         return flag;
  49.     }
  51.     @Override
  52.     public boolean update(ItemUserEntity t) throws ClassNotFoundException, SQLException {
  53.         boolean flag = false;
  54.         // 获取连接
  55.         Connection connection = DBUtils.openConn();
  56.         // sql语句
  57.         String sql = "update item_user set user_id = ?,item_id = ? where item_user_id = ?";
  58.         // 预处理对象
  59.         PreparedStatement statement = connection.prepareStatement(sql);
  60.         // 添加参数
  61.         statement.setInt(1, t.getUserId());
  62.         statement.setInt(2, t.getItemId());
  63.         statement.setInt(3, t.getItemUserId());
  64.         // 执行预处理对象
  65.         int count = statement.executeUpdate();
  66.         if (count > 0) {
  67.             flag = true;
  68.         }
  69.         statement.close();
  70.         connection.close();
  71.         return flag;
  72.     }
  74.     @Override
  75.     public ItemUserEntity selectById(int id) throws ClassNotFoundException, SQLException {
  76.         ItemUserEntity ItemUserEntity = null;
  77.         Connection connection = DBUtils.openConn();
  78.         String sql = "select * from item_user where item_user_id = ?";
  79.         PreparedStatement statement = connection.prepareStatement(sql);
  80.         statement.setInt(1, id);
  81.         ResultSet resultSet = statement.executeQuery();
  82.         while (resultSet.next()) {
  83.             int itemUserId = resultSet.getInt("item_user_id");
  84.             int userId = resultSet.getInt("user_id");
  85.             int itemId = resultSet.getInt("item_id");
  86.             Date createTime = resultSet.getTimestamp("create_time");
  87.             Date updateTime = resultSet.getTimestamp("update_time");
  88.             ItemUserEntity = new ItemUserEntity(itemUserId, userId, itemId, createTime, updateTime);
  89.         }
  90.         resultSet.close();
  91.         statement.close();
  92.         connection.close();
  93.         return ItemUserEntity;
  94.     }
  96.     @Override
  97.     public List<ItemUserEntity> selectAll() throws ClassNotFoundException, SQLException {
  98.         List<ItemUserEntity> list = new ArrayList<>();
  99.         Connection connection = DBUtils.openConn();
  100.         String sql = "select * from item_user  and status = 1";
  101.         PreparedStatement statement = connection.prepareStatement(sql);
  102.         ResultSet resultSet = statement.executeQuery();
  103.         while (resultSet.next()) {
  104.             int itemUserId = resultSet.getInt("item_user_id");
  105.             int userId = resultSet.getInt("user_id");
  106.             int itemId = resultSet.getInt("item_id");
  107.             Date createTime = resultSet.getTimestamp("create_time");
  108.             Date updateTime = resultSet.getTimestamp("update_time");
  109.             ItemUserEntity itemUserEntity = new ItemUserEntity(itemUserId, userId, itemId, createTime, updateTime);
  110.             list.add(itemUserEntity);
  111.         }
  112.         resultSet.close();
  113.         statement.close();
  114.         connection.close();
  115.         return list;
  116.     }
  118.     @Override
  119.     public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException {
  120.         // TODO 自动生成的方法存根
  121.         return false;
  122.     }
  124. }

LogsInfoDao.java

  1. package com.newcapec.dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.Date;
  9. import java.util.List;
  11. import com.newcapec.entity.LogsInfoEntity;
  12. import com.newcapec.utils.DBUtils;
  14. public class LogsInfoDao implements BaseDao<LogsInfoEntity> {
  16.     public boolean insert(LogsInfoEntity t) throws ClassNotFoundException, SQLException {
  17.         boolean flag = false;
  18.         Connection connection = DBUtils.openConn();
  19.         String sql = "insert into logs_info (user_id,logs_content,create_time) values (?,?,now())";
  20.         PreparedStatement statement = connection.prepareStatement(sql);
  21.         statement.setInt(1, t.getUserId());
  22.         statement.setString(2, t.getLogsContent());
  23.         int count = statement.executeUpdate();
  24.         if (count > 0) {
  25.             flag = true;
  26.         }
  27.         statement.close();
  28.         connection.close();
  29.         return flag;
  30.     }
  32.     @Override
  33.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
  34.         boolean flag = false;
  35.         Connection connection = DBUtils.openConn();
  36.         String sql = "delete from logs_info where logs_id = ?";
  37.         PreparedStatement statement = connection.prepareStatement(sql);
  38.         statement.setInt(1, id);
  39.         int count = statement.executeUpdate();
  40.         if (count > 0) {
  41.             flag = true;
  42.         }
  43.         statement.close();
  44.         connection.close();
  45.         return flag;
  46.     }
  48.     @Override
  49.     public boolean update(LogsInfoEntity t) throws ClassNotFoundException, SQLException {
  50.         boolean flag = false;
  51.         Connection connection = DBUtils.openConn();
  52.         String sql = "update logs_info set user_id = ?, logs_content = ? where logs_id = ?";
  53.         PreparedStatement statement = connection.prepareStatement(sql);
  54.         statement.setInt(1, t.getUserId());
  55.         statement.setString(2, t.getLogsContent());
  56.         statement.setInt(3, t.getLogsId());
  57.         int count = statement.executeUpdate();
  58.         if (count > 0) {
  59.             flag = true;
  60.         }
  61.         statement.close();
  62.         connection.close();
  63.         return flag;
  64.     }
  66.     @Override
  67.     public LogsInfoEntity selectById(int id) throws ClassNotFoundException, SQLException {
  68.         LogsInfoEntity logsInfoEntity = null;
  69.         Connection connection = DBUtils.openConn();
  70.         String sql = "select * from logs_info where logs_id = ?";
  71.         PreparedStatement statement = connection.prepareStatement(sql);
  72.         statement.setInt(1, id);
  73.         ResultSet resultSet = statement.executeQuery();
  74.         while (resultSet.next()) {
  75.             int newsId = resultSet.getInt("logs_id");
  76.             int itemId = resultSet.getInt("user_id");
  77.             String logsContent = resultSet.getString("logs_content");
  78.             Date createTime = resultSet.getDate("create_time");
  79.             Date updateTime = resultSet.getDate("update_time");
  80.             logsInfoEntity = new LogsInfoEntity(newsId, itemId, logsContent, createTime, updateTime);
  81.         }
  82.         resultSet.close();
  83.         statement.close();
  84.         connection.close();
  85.         return logsInfoEntity;
  86.     }
  88.     @Override
  89.     public List<LogsInfoEntity> selectAll() throws ClassNotFoundException, SQLException {
  90.         List<LogsInfoEntity> list = new ArrayList<LogsInfoEntity>();
  91.         Connection connection = DBUtils.openConn();
  92.         String sql = "select * from logs_info";
  93.         PreparedStatement statement = connection.prepareStatement(sql);
  94.         ResultSet resultSet = statement.executeQuery();
  95.         while (resultSet.next()) {
  96.             int newsId = resultSet.getInt("logs_id");
  97.             int itemId = resultSet.getInt("user_id");
  98.             String logsContent = resultSet.getString("logs_content");
  99.             Date createTime = resultSet.getDate("create_time");
  100.             Date updateTime = resultSet.getDate("update_time");
  101.             LogsInfoEntity logsInfoEntity = new LogsInfoEntity(newsId, itemId, logsContent, createTime, updateTime);
  102.             list.add(logsInfoEntity);
  103.         }
  104.         resultSet.close();
  105.         statement.close();
  106.         connection.close();
  107.         return list;
  108.     }
  110.     @Override
  111.     public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException {
  112.         // TODO 自动生成的方法存根
  113.         return false;
  114.     }
  116. }

NewItemDao.java

  1. package com.newcapec.dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8. import java.util.ArrayList;
  9. import java.util.Date;
  10. import java.util.List;
  12. import com.newcapec.entity.NewItemEntity;
  13. import com.newcapec.utils.DBUtils;
  15. public class NewItemDao implements BaseDao<NewItemEntity> {
  17.     public int insert(NewItemEntity t) throws ClassNotFoundException, SQLException {
  18.         Connection connection = DBUtils.openConn();
  19.         String sql = "insert into new_item (item_name,create_time) values (?,now())";
  20.         PreparedStatement statement = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
  21.         statement.setString(1, t.getItemName());
  22.         statement.executeUpdate();
  23.         ResultSet resultSet = statement.getGeneratedKeys();
  24.         resultSet.next();
  25.         int id = resultSet.getInt(1);
  26.         statement.close();
  27.         connection.close();
  28.         return id;
  29.     }
  31.     @Override
  32.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
  33.         boolean flag = false;
  34.         // 获取连接
  35.         Connection connection = DBUtils.openConn();
  36.         // sql语句
  37.         String sql = "delete from new_item where item_id = ?";
  38.         // 预处理对象
  39.         PreparedStatement statement = connection.prepareStatement(sql);
  40.         // 添加参数
  41.         statement.setInt(1, id);
  42.         // 执行预处理对象
  43.         int count = statement.executeUpdate();
  44.         if (count > 0) {
  45.             flag = true;
  46.         }
  47.         statement.close();
  48.         connection.close();
  49.         return flag;
  50.     }
  52.     @Override
  53.     public boolean update(NewItemEntity t) throws ClassNotFoundException, SQLException {
  54.         boolean flag = false;
  55.         // 获取连接
  56.         Connection connection = DBUtils.openConn();
  57.         // sql语句
  58.         String sql = "update new_item set item_name = ? where item_id = ?";
  59.         // 预处理对象
  60.         PreparedStatement statement = connection.prepareStatement(sql);
  61.         // 添加参数
  62.         statement.setString(1, t.getItemName());
  63.         statement.setInt(2, t.getItemId());
  64.         // 执行预处理对象
  65.         int count = statement.executeUpdate();
  66.         if (count > 0) {
  67.             flag = true;
  68.         }
  69.         statement.close();
  70.         connection.close();
  71.         return flag;
  72.     }
  74.     @Override
  75.     public NewItemEntity selectById(int id) throws ClassNotFoundException, SQLException {
  76.         NewItemEntity newItemEntity = null;
  77.         Connection connection = DBUtils.openConn();
  78.         String sql = "select * from new_item where item_id = ?";
  79.         PreparedStatement statement = connection.prepareStatement(sql);
  80.         statement.setInt(1, id);
  81.         ResultSet resultSet = statement.executeQuery();
  82.         while (resultSet.next()) {
  83.             int itemId = resultSet.getInt("item_id");
  84.             String itemName = resultSet.getString("item_name");
  85.             Date createTime = resultSet.getTimestamp("create_time");
  86.             Date updateTime = resultSet.getTimestamp("update_time");
  87.             newItemEntity = new NewItemEntity(itemId, itemName, createTime, updateTime);
  88.         }
  89.         resultSet.close();
  90.         statement.close();
  91.         connection.close();
  92.         return newItemEntity;
  93.     }
  95.     @Override
  96.     public List<NewItemEntity> selectAll() throws ClassNotFoundException, SQLException {
  97.         List<NewItemEntity> list = new ArrayList<>();
  98.         Connection connection = DBUtils.openConn();
  99.         String sql = "select * from new_item ";
  100.         PreparedStatement statement = connection.prepareStatement(sql);
  101.         ResultSet resultSet = statement.executeQuery();
  102.         while (resultSet.next()) {
  103.             int itemId = resultSet.getInt("item_id");
  104.             String itemName = resultSet.getString("item_name");
  105.             Date createTime = resultSet.getTimestamp("create_time");
  106.             Date updateTime = resultSet.getTimestamp("update_time");
  107.             NewItemEntity newItemEntity = new NewItemEntity(itemId, itemName, createTime, updateTime);
  108.             list.add(newItemEntity);
  109.         }
  110.         resultSet.close();
  111.         statement.close();
  112.         connection.close();
  113.         return list;
  114.     }
  116.     public List<NewItemEntity> selectAllByUserId(int userId) throws ClassNotFoundException, SQLException {
  117.         List<NewItemEntity> list = new ArrayList<>();
  118.         Connection connection = DBUtils.openConn();
  119.         String sql = "SELECT new_item.`item_id`,new_item.`item_name`,new_item.`create_time`,new_item.`update_time` FROM new_item \r\n"
  120.                 + "    INNER JOIN item_user ON new_item.`item_id` = item_user.`item_id`\r\n"
  121.                 + "    INNER JOIN user_info ON user_info.`user_id` = item_user.`user_id`\r\n"
  122.                 + "    WHERE user_info.user_id = ? and new_item.status = 1";
  123.         PreparedStatement statement = connection.prepareStatement(sql);
  124.         statement.setInt(1, userId);
  125.         ResultSet resultSet = statement.executeQuery();
  126.         while (resultSet.next()) {
  127.             int itemId = resultSet.getInt("item_id");
  128.             String itemName = resultSet.getString("item_name");
  129.             Date createTime = resultSet.getTimestamp("create_time");
  130.             Date updateTime = resultSet.getTimestamp("update_time");
  131.             NewItemEntity newItemEntity = new NewItemEntity(itemId, itemName, createTime, updateTime);
  132.             list.add(newItemEntity);
  133.         }
  134.         resultSet.close();
  135.         statement.close();
  136.         connection.close();
  137.         return list;
  138.     }
  140.     public int selectAllByUserIdCount(int userId) throws ClassNotFoundException, SQLException {
  141.         int count = 0;
  142.         Connection connection = DBUtils.openConn();
  143.         String sql = "SELECT count(*) as allCount FROM new_item \r\n"
  144.                 + "    INNER JOIN item_user ON new_item.`item_id` = item_user.`item_id`\r\n"
  145.                 + "    INNER JOIN user_info ON user_info.`user_id` = item_user.`user_id`\r\n where new_item.status = 1 AND user_info.`user_id` = ?";
  146.         PreparedStatement statement = connection.prepareStatement(sql);
  147.         statement.setInt(1, userId);
  148.         ResultSet resultSet = statement.executeQuery();
  149.         while (resultSet.next()) {
  150.             count = resultSet.getInt("allCount");
  151.         }
  152.         resultSet.close();
  153.         statement.close();
  154.         connection.close();
  155.         return count;
  156.     }
  158.     @Override
  159.     public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException {
  160.         boolean flag = false;
  161.         // 获取连接
  162.         Connection connection = DBUtils.openConn();
  163.         // sql语句
  164.         // String sql = "delete from new_item where item_id = ?";
  165.         String sql = "update new_item set status = 0 where item_id = ?";
  166.         // 预处理对象
  167.         PreparedStatement statement = connection.prepareStatement(sql);
  168.         // 添加参数
  169.         for (int id : ids) {
  170.             statement.setInt(1, id);
  171.             statement.addBatch();
  172.         }
  173.         int[] result = statement.executeBatch();
  174.         // 执行预处理对象
  175.         // int count = statement.executeUpdate();
  176.         if (result.length > 0) {
  177.             flag = true;
  178.         }
  179.         statement.close();
  180.         connection.close();
  181.         return flag;
  182.     }
  184. }

NewsInfoDao.java

  1. package com.newcapec.dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.Date;
  9. import java.util.List;
  11. import com.newcapec.entity.NewsInfoEntity;
  12. import com.newcapec.utils.DBUtils;
  14. public class NewsInfoDao implements BaseDao<NewsInfoEntity> {
  16.     public boolean insert(NewsInfoEntity t) throws ClassNotFoundException, SQLException {
  17.         boolean flag = false;
  18.         Connection connection = DBUtils.openConn();
  19.         String sql = "insert into news_info (item_id,news_title,news_content,create_time) values (?,?,?,now())";
  20.         PreparedStatement statement = connection.prepareStatement(sql);
  21.         statement.setInt(1, t.getItemId());
  22.         statement.setString(2, t.getNewsTitle());
  23.         statement.setString(3, t.getNewsContent());
  24.         int count = statement.executeUpdate();
  25.         if (count > 0) {
  26.             flag = true;
  27.         }
  28.         statement.close();
  29.         connection.close();
  30.         return flag;
  31.     }
  33.     @Override
  34.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
  35.         boolean flag = false;
  36.         Connection connection = DBUtils.openConn();
  37.         String sql = "delete from news_info where news_id = ?";
  38.         PreparedStatement statement = connection.prepareStatement(sql);
  39.         statement.setInt(1, id);
  40.         int count = statement.executeUpdate();
  41.         if (count > 0) {
  42.             flag = true;
  43.         }
  44.         statement.close();
  45.         connection.close();
  46.         return flag;
  47.     }
  49.     @Override
  50.     public boolean update(NewsInfoEntity t) throws ClassNotFoundException, SQLException {
  51.         boolean flag = false;
  52.         Connection connection = DBUtils.openConn();
  53.         String sql = "update news_info set item_id = ?, news_title = ?, news_image = ?, news_content=? where news_id = ?";
  54.         PreparedStatement statement = connection.prepareStatement(sql);
  55.         statement.setInt(1, t.getItemId());
  56.         statement.setString(2, t.getNewsTitle());
  57.         statement.setString(3, t.getNewsImage());
  58.         statement.setString(4, t.getNewsContent());
  59.         statement.setInt(5, t.getNewsId());
  60.         int count = statement.executeUpdate();
  61.         if (count > 0) {
  62.             flag = true;
  63.         }
  64.         statement.close();
  65.         connection.close();
  66.         return flag;
  67.     }
  69.     @Override
  70.     public NewsInfoEntity selectById(int id) throws ClassNotFoundException, SQLException {
  71.         NewsInfoEntity newsInfoEntity = null;
  72.         Connection connection = DBUtils.openConn();
  73.         String sql = "select * from news_info where news_id = ?";
  74.         PreparedStatement statement = connection.prepareStatement(sql);
  75.         statement.setInt(1, id);
  76.         ResultSet resultSet = statement.executeQuery();
  77.         while (resultSet.next()) {
  78.             int newsId = resultSet.getInt("news_id");
  79.             int itemId = resultSet.getInt("item_id");
  80.             String newsTitle = resultSet.getString("news_title");
  81.             String newsContent = resultSet.getString("news_content");
  82.             String newsImage = resultSet.getString("news_image");
  83.             Date createTime = resultSet.getDate("create_time");
  84.             Date updateTime = resultSet.getDate("update_time");
  85.             newsInfoEntity = new NewsInfoEntity(newsId, itemId, newsTitle, newsImage, newsContent, createTime,
  86.                     updateTime);
  87.         }
  88.         resultSet.close();
  89.         statement.close();
  90.         connection.close();
  91.         return newsInfoEntity;
  92.     }
  94.     @Override
  95.     public List<NewsInfoEntity> selectAll() throws ClassNotFoundException, SQLException {
  96.         List<NewsInfoEntity> list = new ArrayList<NewsInfoEntity>();
  97.         Connection connection = DBUtils.openConn();
  98.         String sql = "select * from news_info";
  99.         PreparedStatement statement = connection.prepareStatement(sql);
  100.         ResultSet resultSet = statement.executeQuery();
  101.         while (resultSet.next()) {
  102.             int newsId = resultSet.getInt("news_id");
  103.             int itemId = resultSet.getInt("item_id");
  104.             String newsTitle = resultSet.getString("news_title");
  105.             String newsContent = resultSet.getString("news_content");
  106.             String newsImage = resultSet.getString("news_image");
  107.             Date createTime = resultSet.getDate("create_time");
  108.             Date updateTime = resultSet.getDate("update_time");
  109.             NewsInfoEntity newsInfoEntity = new NewsInfoEntity(newsId, itemId, newsTitle, newsImage, newsContent,
  110.                     createTime, updateTime);
  111.             list.add(newsInfoEntity);
  112.         }
  113.         resultSet.close();
  114.         statement.close();
  115.         connection.close();
  116.         return list;
  117.     }
  119.     @Override
  120.     public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException {
  121.         // TODO 自动生成的方法存根
  122.         return false;
  123.     }
  125. }

UserInfoDao.java

  1. package com.newcapec.dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.Date;
  9. import java.util.List;
  11. import com.newcapec.entity.UserInfoEntity;
  12. import com.newcapec.utils.DBUtils;
  14. public class UserInfoDao implements BaseDao<UserInfoEntity> {
  16.     public UserInfoEntity login(String userName, String userPwd) throws ClassNotFoundException, SQLException {
  17.         UserInfoEntity userInfoEntity = null;
  18.         Connection connection = DBUtils.openConn();
  19.         String sql = "select * from user_info where user_name = ? and user_pwd = ?";
  20.         PreparedStatement statement = connection.prepareStatement(sql);
  21.         statement.setString(1, userName);
  22.         statement.setString(2, userPwd);
  23.         ResultSet resultSet = statement.executeQuery();
  24.         while (resultSet.next()) {
  25.             int userId = resultSet.getInt("user_id");
  26.             Date createTime = resultSet.getTimestamp("create_time");
  27.             Date updateTime = resultSet.getTimestamp("update_time");
  28.             userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  29.         }
  30.         resultSet.close();
  31.         statement.close();
  32.         connection.close();
  33.         return userInfoEntity;
  34.     }
  36.     public boolean insert(UserInfoEntity t) throws ClassNotFoundException, SQLException {
  37.         boolean flag = false;
  38.         // 获取与数据库的连接
  39.         Connection connection = DBUtils.openConn();
  40.         // ?表示占位符 可以解决sql注入的问题
  41.         String sql = "insert into user_info (user_name,user_pwd,create_time) values (?,?,now())";
  42.         PreparedStatement statement = connection.prepareStatement(sql);
  43.         statement.setString(1, t.getUserName());
  44.         statement.setString(2, t.getUserPwd());
  45.         // 执行sql语句
  46.         int count = statement.executeUpdate();
  47.         if (count > 0) {
  48.             flag = true;
  49.         }
  50.         statement.close();
  51.         connection.close();
  52.         return flag;
  53.     }
  55.     @Override
  56.     public boolean deleteById(int id) throws ClassNotFoundException, SQLException {
  57.         boolean flag = false;
  58.         // 获取连接
  59.         Connection connection = DBUtils.openConn();
  60.         // sql语句
  61.         // String sql = "delete from user_info where user_id = ?";
  62.         String sql = "update user_info set status = 0 where user_id = ?";
  63.         // 预处理对象
  64.         PreparedStatement statement = connection.prepareStatement(sql);
  65.         // 添加参数
  66.         statement.setInt(1, id);
  67.         // 执行预处理对象
  68.         int count = statement.executeUpdate();
  69.         if (count > 0) {
  70.             flag = true;
  71.         }
  72.         statement.close();
  73.         connection.close();
  74.         return flag;
  75.     }
  77.     @Override
  78.     public boolean update(UserInfoEntity t) throws ClassNotFoundException, SQLException {
  79.         boolean flag = false;
  80.         // 获取连接
  81.         Connection connection = DBUtils.openConn();
  82.         // sql语句
  83.         String sql = "update user_info set user_name = ?,user_pwd = ? where user_id = ?";
  84.         // 预处理对象
  85.         PreparedStatement statement = connection.prepareStatement(sql);
  86.         // 添加参数
  87.         statement.setString(1, t.getUserName());
  88.         statement.setString(2, t.getUserPwd());
  89.         statement.setInt(3, t.getUserId());
  90.         // 执行预处理对象
  91.         int count = statement.executeUpdate();
  92.         if (count > 0) {
  93.             flag = true;
  94.         }
  95.         statement.close();
  96.         connection.close();
  97.         return flag;
  98.     }
  100.     @Override
  101.     public UserInfoEntity selectById(int id) throws ClassNotFoundException, SQLException {
  102.         UserInfoEntity userInfoEntity = null;
  103.         Connection connection = DBUtils.openConn();
  104.         String sql = "select * from user_info where user_id = ? and status = 1";
  105.         PreparedStatement statement = connection.prepareStatement(sql);
  106.         statement.setInt(1, id);
  107.         ResultSet resultSet = statement.executeQuery();
  108.         while (resultSet.next()) {
  109.             int userId = resultSet.getInt("user_id");
  110.             String userName = resultSet.getString("user_name");
  111.             String userPwd = resultSet.getString("user_pwd");
  112.             Date createTime = resultSet.getTimestamp("create_time");
  113.             Date updateTime = resultSet.getTimestamp("update_time");
  114.             userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  115.         }
  116.         resultSet.close();
  117.         statement.close();
  118.         connection.close();
  119.         return userInfoEntity;
  120.     }
  122.     @Override
  123.     public List<UserInfoEntity> selectAll() throws ClassNotFoundException, SQLException {
  124.         List<UserInfoEntity> list = new ArrayList<>();
  125.         Connection connection = DBUtils.openConn();
  126.         String sql = "select * from user_info";
  127.         PreparedStatement statement = connection.prepareStatement(sql);
  128.         ResultSet resultSet = statement.executeQuery();
  129.         while (resultSet.next()) {
  130.             int userId = resultSet.getInt("user_id");
  131.             String userName = resultSet.getString("user_name");
  132.             String userPwd = resultSet.getString("user_pwd");
  133.             Date createTime = resultSet.getTimestamp("create_time");
  134.             Date updateTime = resultSet.getTimestamp("update_time");
  135.             UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  136.             list.add(userInfoEntity);
  137.         }
  138.         resultSet.close();
  139.         statement.close();
  140.         connection.close();
  141.         return list;
  142.     }
  144.     public List<UserInfoEntity> selectByPage(int offset, int limit) throws ClassNotFoundException, SQLException {
  145.         List<UserInfoEntity> list = new ArrayList<>();
  146.         Connection connection = DBUtils.openConn();
  147.         String sql = "select * from user_info where status = 1 limit ?,?";
  148.         PreparedStatement statement = connection.prepareStatement(sql);
  149.         statement.setInt(1, offset);
  150.         statement.setInt(2, limit);
  151.         ResultSet resultSet = statement.executeQuery();
  152.         while (resultSet.next()) {
  153.             int userId = resultSet.getInt("user_id");
  154.             String userName = resultSet.getString("user_name");
  155.             String userPwd = resultSet.getString("user_pwd");
  156.             Date createTime = resultSet.getTimestamp("create_time");
  157.             Date updateTime = resultSet.getTimestamp("update_time");
  158.             UserInfoEntity userInfoEntity = new UserInfoEntity(userId, userName, userPwd, createTime, updateTime);
  159.             list.add(userInfoEntity);
  160.         }
  161.         resultSet.close();
  162.         statement.close();
  163.         connection.close();
  164.         return list;
  165.     }
  167.     public int selectCount() throws ClassNotFoundException, SQLException {
  168.         int count = 0;
  169.         Connection connection = DBUtils.openConn();
  170.         String sql = "SELECT COUNT(*) AS userCount FROM user_info where status = 1";
  171.         PreparedStatement statement = connection.prepareStatement(sql);
  172.         ResultSet resultSet = statement.executeQuery();
  173.         while (resultSet.next()) {
  174.             count = resultSet.getInt("userCount");
  175.         }
  176.         resultSet.close();
  177.         statement.close();
  178.         connection.close();
  179.         return count;
  180.     }
  182.     @Override
  183.     public boolean batchDeleteById(int[] ids) throws ClassNotFoundException, SQLException {
  184.         boolean flag = false;
  185.         // 获取连接
  186.         Connection connection = DBUtils.openConn();
  187.         // sql语句
  188.         // String sql = "delete from user_info where user_id = ?";
  189.         String sql = "update user_info set status = 0 where user_id = ?";
  190.         // 预处理对象
  191.         PreparedStatement statement = connection.prepareStatement(sql);
  192.         // 添加参数
  193.         for (int id : ids) {
  194.             statement.setInt(1, id);
  195.             statement.addBatch();
  196.         }
  197.         int[] result = statement.executeBatch();
  198.         // 执行预处理对象
  199.         // int count = statement.executeUpdate();
  200.         if (result.length > 0) {
  201.             flag = true;
  202.         }
  203.         statement.close();
  204.         connection.close();
  205.         return flag;
  206.     }
  208. }

②package com.newcapec.entity;

ItemUserEntity.java

  1. package com.newcapec.entity;
  3. import java.util.Date;
  5. public class ItemUserEntity extends Object {
  7.     private int itemUserId;
  8.     private int userId;
  9.     private int itemId;
  10.     private Date createTime;
  11.     private Date updateTime;
  13.     public ItemUserEntity() {
  14.     }
  16.     public ItemUserEntity(int itemUserId, int userId, int itemId, Date createTime, Date updateTime) {
  17.         super();
  18.         this.itemUserId = itemUserId;
  19.         this.userId = userId;
  20.         this.itemId = itemId;
  21.         this.createTime = createTime;
  22.         this.updateTime = updateTime;
  23.     }
  25.     public int getItemUserId() {
  26.         return itemUserId;
  27.     }
  29.     public void setItemUserId(int itemUserId) {
  30.         this.itemUserId = itemUserId;
  31.     }
  33.     public int getUserId() {
  34.         return userId;
  35.     }
  37.     public void setUserId(int userId) {
  38.         this.userId = userId;
  39.     }
  41.     public int getItemId() {
  42.         return itemId;
  43.     }
  45.     public void setItemId(int itemId) {
  46.         this.itemId = itemId;
  47.     }
  49.     public Date getCreateTime() {
  50.         return createTime;
  51.     }
  53.     public void setCreateTime(Date createTime) {
  54.         this.createTime = createTime;
  55.     }
  57.     public Date getUpdateTime() {
  58.         return updateTime;
  59.     }
  61.     public void setUpdateTime(Date updateTime) {
  62.         this.updateTime = updateTime;
  63.     }
  65.     @Override
  66.     public String toString() {
  67.         return "ItemUserEntity [itemUserId=" + itemUserId + ", userId=" + userId + ", itemId=" + itemId
  68.                 + ", createTime=" + createTime + ", updateTime=" + updateTime + "]";
  69.     }
  71. }

LogsInfoEntity.java

  1. package com.newcapec.entity;
  3. import java.util.Date;
  5. public class LogsInfoEntity extends Object {
  7.     private int logsId;
  8.     private int userId;
  9.     private String logsContent;
  10.     private Date createTime;
  11.     private Date updateTime;
  13.     public LogsInfoEntity() {
  14.     }
  16.     public LogsInfoEntity(int logsId, int userId, String logsContent, Date createTime, Date updateTime) {
  17.         super();
  18.         this.logsId = logsId;
  19.         this.userId = userId;
  20.         this.logsContent = logsContent;
  21.         this.createTime = createTime;
  22.         this.updateTime = updateTime;
  23.     }
  25.     public int getLogsId() {
  26.         return logsId;
  27.     }
  29.     public void setLogsId(int logsId) {
  30.         this.logsId = logsId;
  31.     }
  33.     public int getUserId() {
  34.         return userId;
  35.     }
  37.     public void setUserId(int userId) {
  38.         this.userId = userId;
  39.     }
  41.     public String getLogsContent() {
  42.         return logsContent;
  43.     }
  45.     public void setLogsContent(String logsContent) {
  46.         this.logsContent = logsContent;
  47.     }
  49.     public Date getCreateTime() {
  50.         return createTime;
  51.     }
  53.     public void setCreateTime(Date createTime) {
  54.         this.createTime = createTime;
  55.     }
  57.     public Date getUpdateTime() {
  58.         return updateTime;
  59.     }
  61.     public void setUpdateTime(Date updateTime) {
  62.         this.updateTime = updateTime;
  63.     }
  65.     @Override
  66.     public String toString() {
  67.         return "LogsInfoEntity [logsId=" + logsId + ", userId=" + userId + ", logsContent=" + logsContent
  68.                 + ", createTime=" + createTime + ", updateTime=" + updateTime + "]";
  69.     }
  71. }

NewItemEntity.java

  1. package com.newcapec.entity;
  3. import java.util.Date;
  5. import com.alibaba.fastjson.annotation.JSONField;
  7. public class NewItemEntity extends Object {
  9.     private int itemId;
  10.     private String itemName;
  11.     @JSONField(format = "yyyy-MM-dd HH:mm:ss")
  12.     private Date createTime;
  13.     @JSONField(format = "yyyy-MM-dd HH:mm:ss")
  14.     private Date updateTime;
  16.     public NewItemEntity() {
  17.     }
  19.     public NewItemEntity(int itemId, String itemName) {
  20.         super();
  21.         this.itemId = itemId;
  22.         this.itemName = itemName;
  23.     }
  25.     public NewItemEntity(int itemId, String itemName, Date createTime, Date updateTime) {
  26.         super();
  27.         this.itemId = itemId;
  28.         this.itemName = itemName;
  29.         this.createTime = createTime;
  30.         this.updateTime = updateTime;
  31.     }
  33.     public int getItemId() {
  34.         return itemId;
  35.     }
  37.     public void setItemId(int itemId) {
  38.         this.itemId = itemId;
  39.     }
  41.     public String getItemName() {
  42.         return itemName;
  43.     }
  45.     public void setItemName(String itemName) {
  46.         this.itemName = itemName;
  47.     }
  49.     public Date getCreateTime() {
  50.         return createTime;
  51.     }
  53.     public void setCreateTime(Date createTime) {
  54.         this.createTime = createTime;
  55.     }
  57.     public Date getUpdateTime() {
  58.         return updateTime;
  59.     }
  61.     public void setUpdateTime(Date updateTime) {
  62.         this.updateTime = updateTime;
  63.     }
  65.     @Override
  66.     public String toString() {
  67.         return "NewItemEntity [itemId=" + itemId + ", itemName=" + itemName + ", createTime=" + createTime
  68.                 + ", updateTime=" + updateTime + "]";
  69.     }
  71. }

NewsInfoEntity.java

  1. package com.newcapec.entity;
  3. import java.util.Date;
  5. public class NewsInfoEntity extends Object {
  7.     private int newsId;
  8.     private int itemId;
  9.     private String newsTitle;
  10.     private String newsImage;
  11.     private String newsContent;
  12.     private Date createTime;
  13.     private Date updateTime;
  15.     public NewsInfoEntity() {
  16.     }
  18.     public NewsInfoEntity(int newsId, int itemId, String newsTitle, String newsImage, String newsContent,
  19.             Date createTime, Date updateTime) {
  20.         super();
  21.         this.newsId = newsId;
  22.         this.itemId = itemId;
  23.         this.newsTitle = newsTitle;
  24.         this.newsImage = newsImage;
  25.         this.newsContent = newsContent;
  26.         this.createTime = createTime;
  27.         this.updateTime = updateTime;
  28.     }
  30.     public int getNewsId() {
  31.         return newsId;
  32.     }
  34.     public void setNewsId(int newsId) {
  35.         this.newsId = newsId;
  36.     }
  38.     public int getItemId() {
  39.         return itemId;
  40.     }
  42.     public void setItemId(int itemId) {
  43.         this.itemId = itemId;
  44.     }
  46.     public String getNewsTitle() {
  47.         return newsTitle;
  48.     }
  50.     public void setNewsTitle(String newsTitle) {
  51.         this.newsTitle = newsTitle;
  52.     }
  54.     public String getNewsImage() {
  55.         return newsImage;
  56.     }
  58.     public void setNewsImage(String newsImage) {
  59.         this.newsImage = newsImage;
  60.     }
  62.     public String getNewsContent() {
  63.         return newsContent;
  64.     }
  66.     public void setNewsContent(String newsContent) {
  67.         this.newsContent = newsContent;
  68.     }
  70.     public Date getCreateTime() {
  71.         return createTime;
  72.     }
  74.     public void setCreateTime(Date createTime) {
  75.         this.createTime = createTime;
  76.     }
  78.     public Date getUpdateTime() {
  79.         return updateTime;
  80.     }
  82.     public void setUpdateTime(Date updateTime) {
  83.         this.updateTime = updateTime;
  84.     }
  86.     @Override
  87.     public String toString() {
  88.         return "NewsInfoEntity [newsId=" + newsId + ", itemId=" + itemId + ", newsTitle=" + newsTitle + ", newsImage="
  89.                 + newsImage + ", newsContent=" + newsContent + ", createTime=" + createTime + ", updateTime="
  90.                 + updateTime + "]";
  91.     }
  93. }

ResultData.java

  1. package com.newcapec.entity;
  3. public class ResultData<T> {
  5.     private int total;
  6.     private T rows;
  7.     private String code;
  9.     public ResultData() {
  10.         super();
  11.     }
  13.     public ResultData(int total, T rows, String code) {
  14.         super();
  15.         this.total = total;
  16.         this.rows = rows;
  17.         this.code = code;
  18.     }
  20.     public int getTotal() {
  21.         return total;
  22.     }
  24.     public void setTotal(int total) {
  25.         this.total = total;
  26.     }
  28.     public T getRows() {
  29.         return rows;
  30.     }
  32.     public void setRows(T rows) {
  33.         this.rows = rows;
  34.     }
  36.     public String getCode() {
  37.         return code;
  38.     }
  40.     public void setCode(String code) {
  41.         this.code = code;
  42.     }
  44.     @Override
  45.     public String toString() {
  46.         return "ResultData [total=" + total + ", rows=" + rows + ", code=" + code + "]";
  47.     }
  49. }

UserInfoEntity.java

  1. package com.newcapec.entity;
  3. import java.util.Date;
  5. import com.alibaba.fastjson.annotation.JSONField;
  7. public class UserInfoEntity {
  9.     private int userId;
  10.     private String userName;
  11.     private String userPwd;
  12.     @JSONField(format = "yyyy-MM-dd HH:mm:ss")
  13.     private Date createTime;
  14.     @JSONField(format = "yyyy-MM-dd HH:mm:ss")
  15.     private Date updateTime;
  17.     public UserInfoEntity() {
  18.     }
  20.     public UserInfoEntity(int userId, String userName, String userPwd) {
  21.         super();
  22.         this.userId = userId;
  23.         this.userName = userName;
  24.         this.userPwd = userPwd;
  25.     }
  27.     public UserInfoEntity(int userId, String userName, String userPwd, Date createTime, Date updateTime) {
  28.         super();
  29.         this.userId = userId;
  30.         this.userName = userName;
  31.         this.userPwd = userPwd;
  32.         this.createTime = createTime;
  33.         this.updateTime = updateTime;
  34.     }
  36.     public int getUserId() {
  37.         return userId;
  38.     }
  40.     public void setUserId(int userId) {
  41.         this.userId = userId;
  42.     }
  44.     public String getUserName() {
  45.         return userName;
  46.     }
  48.     public void setUserName(String userName) {
  49.         this.userName = userName;
  50.     }
  52.     public String getUserPwd() {
  53.         return userPwd;
  54.     }
  56.     public void setUserPwd(String userPwd) {
  57.         this.userPwd = userPwd;
  58.     }
  60.     public Date getCreateTime() {
  61.         return createTime;
  62.     }
  64.     public void setCreateTime(Date createTime) {
  65.         this.createTime = createTime;
  66.     }
  68.     public Date getUpdateTime() {
  69.         return updateTime;
  70.     }
  72.     public void setUpdateTime(Date updateTime) {
  73.         this.updateTime = updateTime;
  74.     }
  76.     @Override
  77.     public String toString() {
  78.         return "UserInfoEntity [userId=" + userId + ", userName=" + userName + ", userPwd=" + userPwd + ", createTime="
  79.                 + createTime + ", updateTime=" + updateTime + "]";
  80.     }
  82. }

③package com.newcapec.servlet;

AddUserServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import com.alibaba.fastjson.JSON;
  14. import com.newcapec.dao.UserInfoDao;
  15. import com.newcapec.entity.UserInfoEntity;
  17. /**
  18.  * Servlet implementation class AddUserServlet
  19.  */
  20. @WebServlet(name = "/AddUserServlet", urlPatterns = "/AddUserServlet")
  21. public class AddUserServlet extends HttpServlet {
  23.     private static final long serialVersionUID = 1L;
  24.     private UserInfoDao userInfoDao = new UserInfoDao();
  26.     /**
  27.      * @see HttpServlet#HttpServlet()
  28.      */
  29.     public AddUserServlet() {
  30.         super();
  31.         // TODO Auto-generated constructor stub
  32.     }
  34.     /**
  35.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  36.      *      response)
  37.      */
  38.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  39.             throws ServletException, IOException {
  40.         // TODO Auto-generated method stub
  41.         response.getWriter().append("Served at: ").append(request.getContextPath());
  42.     }
  44.     /**
  45.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  46.      *      response)
  47.      */
  48.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  49.             throws ServletException, IOException {
  50.         request.setCharacterEncoding("utf-8");
  51.         response.setContentType("text/json;charset=utf-8");
  52.         String userName = request.getParameter("userName");
  53.         String userPwd = request.getParameter("userPwd");
  54.         UserInfoEntity userInfoEntity = new UserInfoEntity();
  55.         userInfoEntity.setUserName(userName);
  56.         userInfoEntity.setUserPwd(userPwd);
  57.         try {
  58.             boolean flag = userInfoDao.insert(userInfoEntity);
  59.             HashMap<String, Boolean> result = new HashMap<>();
  60.             result.put("flag", flag);
  61.             response.getWriter().write(JSON.toJSONString(result));
  62.         } catch (ClassNotFoundException | SQLException e) {
  63.             // TODO 自动生成的 catch 块
  64.             e.printStackTrace();
  65.         }
  66.     }
  68. }

DeleteUserServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.Arrays;
  6. import java.util.HashMap;
  8. import javax.servlet.ServletException;
  9. import javax.servlet.annotation.WebServlet;
  10. import javax.servlet.http.HttpServlet;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  14. import com.alibaba.fastjson.JSON;
  15. import com.newcapec.dao.UserInfoDao;
  17. /**
  18.  * Servlet implementation class DeleteUserServlet
  19.  */
  20. @WebServlet(name = "/DeleteUserServlet", urlPatterns = "/DeleteUserServlet")
  21. public class DeleteUserServlet extends HttpServlet {
  23.     private static final long serialVersionUID = 1L;
  24.     private UserInfoDao userInfoDao = new UserInfoDao();
  26.     /**
  27.      * @see HttpServlet#HttpServlet()
  28.      */
  29.     public DeleteUserServlet() {
  30.         super();
  31.         // TODO Auto-generated constructor stub
  32.     }
  34.     /**
  35.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  36.      *      response)
  37.      */
  38.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  39.             throws ServletException, IOException {
  40.         // TODO Auto-generated method stub
  41.         response.getWriter().append("Served at: ").append(request.getContextPath());
  42.     }
  44.     /**
  45.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  46.      *      response)
  47.      */
  48.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  49.             throws ServletException, IOException {
  50.         // 此处可以使用过滤器批量处理
  51.         request.setCharacterEncoding("utf-8");
  52.         response.setContentType("text/json;charset=utf-8");
  53.         String[] userIds = request.getParameterValues("userIds[]");
  54.         // 使用userInfoDao执行批量删除
  55.         int[] ids = new int[userIds.length];
  56.         for (int i = 0; i < userIds.length; i++) {
  57.             ids[i] = Integer.valueOf(userIds[i]);
  58.         }
  59.         try {
  60.             boolean flag = userInfoDao.batchDeleteById(ids);
  61.             HashMap<String, Boolean> result = new HashMap<>();
  62.             result.put("flag", flag);
  63.             response.getWriter().write(JSON.toJSONString(result));
  64.         } catch (ClassNotFoundException | SQLException e) {
  65.             // TODO 自动生成的 catch 块
  66.             e.printStackTrace();
  67.         }
  68.     }
  70. }

LoginServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  12. import com.newcapec.dao.UserInfoDao;
  13. import com.newcapec.entity.UserInfoEntity;
  15. /**
  16.  * Servlet implementation class LoginServlet
  17.  */
  18. @WebServlet(name = "/LoginServlet", urlPatterns = "/LoginServlet")
  19. public class LoginServlet extends HttpServlet {
  21.     private UserInfoDao userInfoDao = new UserInfoDao();
  22.     private static final long serialVersionUID = 1L;
  24.     /**
  25.      * @see HttpServlet#HttpServlet()
  26.      */
  27.     public LoginServlet() {
  28.         super();
  29.         // TODO Auto-generated constructor stub
  30.     }
  32.     /**
  33.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  34.      *      response)
  35.      */
  36.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  37.             throws ServletException, IOException {
  38.         // TODO Auto-generated method stub
  39.         response.getWriter().append("Served at: ").append(request.getContextPath());
  40.     }
  42.     /**
  43.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  44.      *      response)
  45.      */
  46.     // 注意：在正规开发中 登录密码需要加密
  47.     // 需要有验证码
  48.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  49.             throws ServletException, IOException {
  50.         request.setCharacterEncoding("UTF-8");
  51.         String userName = request.getParameter("userName");
  52.         String userPwd = request.getParameter("userPwd");
  53.         try {
  54.             UserInfoEntity userInfoEntity = userInfoDao.login(userName, userPwd);
  55.             if (userInfoEntity != null) {
  56.                 // 登录成功
  57.                 request.getSession().setAttribute("userInfo", userInfoEntity);
  58.                 response.sendRedirect("index.html");
  59.             } else {
  60.                 // 登录失败 重定向
  61.                 response.sendRedirect("loginFailure.html");
  62.             }
  63.         } catch (ClassNotFoundException | SQLException e) {
  64.             // TODO 自动生成的 catch 块
  65.             e.printStackTrace();
  66.         }
  67.     }
  69. }

SelectUserByIdServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  12. import com.alibaba.fastjson.JSON;
  13. import com.newcapec.dao.UserInfoDao;
  14. import com.newcapec.entity.UserInfoEntity;
  16. /**
  17.  * Servlet implementation class SelectUserByIdServlet
  18.  */
  19. @WebServlet(name = "/SelectUserByIdServlet", urlPatterns = "/SelectUserByIdServlet")
  20. public class SelectUserByIdServlet extends HttpServlet {
  22.     private static final long serialVersionUID = 1L;
  23.     private UserInfoDao userInfoDao = new UserInfoDao();
  25.     /**
  26.      * @see HttpServlet#HttpServlet()
  27.      */
  28.     public SelectUserByIdServlet() {
  29.         super();
  30.         // TODO Auto-generated constructor stub
  31.     }
  33.     /**
  34.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  35.      *      response)
  36.      */
  37.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  38.             throws ServletException, IOException {
  39.         // 此处可以使用过滤器批量处理
  40.         request.setCharacterEncoding("utf-8");
  41.         response.setContentType("text/json;charset=utf-8");
  42.         int userId = Integer.parseInt(request.getParameter("userId"));
  43.         try {
  44.             UserInfoEntity userInfoEntity = userInfoDao.selectById(userId);
  45.             response.getWriter().write(JSON.toJSONString(userInfoEntity));
  46.         } catch (ClassNotFoundException | SQLException e) {
  47.             // TODO 自动生成的 catch 块
  48.             e.printStackTrace();
  49.         }
  50.     }
  52.     /**
  53.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  54.      *      response)
  55.      */
  56.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  57.             throws ServletException, IOException {
  58.         // TODO Auto-generated method stub
  59.         doGet(request, response);
  60.     }
  62. }

SelectUserByPageServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  6. import java.util.List;
  8. import javax.servlet.ServletException;
  9. import javax.servlet.annotation.WebServlet;
  10. import javax.servlet.http.HttpServlet;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  14. import com.alibaba.fastjson.JSON;
  15. import com.newcapec.dao.UserInfoDao;
  16. import com.newcapec.entity.ResultData;
  17. import com.newcapec.entity.UserInfoEntity;
  19. /**
  20.  * Servlet implementation class SelectAllServlet
  21.  */
  22. @WebServlet(name = "/SelectAllServlet", urlPatterns = "/SelectAllServlet")
  23. public class SelectUserByPageServlet extends HttpServlet {
  25.     private static final long serialVersionUID = 1L;
  26.     private UserInfoDao userInfoDao = new UserInfoDao();
  28.     /**
  29.      * @see HttpServlet#HttpServlet()
  30.      */
  31.     public SelectUserByPageServlet() {
  32.         super();
  33.         // TODO Auto-generated constructor stub
  34.     }
  36.     /**
  37.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  38.      *      response)
  39.      */
  40.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  41.             throws ServletException, IOException {
  42.         response.setCharacterEncoding("utf-8");
  43.         response.setContentType("text/json;charset=utf-8");
  44.         // 当前页码
  45.         // 页大小
  46.         int offset = Integer.parseInt(request.getParameter("offset"));
  47.         int limit = Integer.parseInt(request.getParameter("limit"));
  49.         // bootstrap-table插件需要后台传回total/rows
  50.         ResultData<List<UserInfoEntity>> data = new ResultData<>();
  51.         try {
  52.             data.setRows(userInfoDao.selectByPage(offset, limit));
  53.             data.setTotal(userInfoDao.selectCount());
  54.             response.getWriter().write(JSON.toJSONString(data));
  55.         } catch (ClassNotFoundException | SQLException e1) {
  56.             // TODO 自动生成的 catch 块
  57.             e1.printStackTrace();
  58.         }
  59.     }
  61.     /**
  62.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  63.      *      response)
  64.      */
  65.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  66.             throws ServletException, IOException {
  67.         // TODO Auto-generated method stub
  68.         doGet(request, response);
  69.     }
  71. }

UpdateUserServlet.java

  1. package com.newcapec.servlet;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import com.alibaba.fastjson.JSON;
  14. import com.newcapec.dao.UserInfoDao;
  15. import com.newcapec.entity.UserInfoEntity;
  17. /**
  18.  * Servlet implementation class UpdateUserServlet
  19.  */
  20. @WebServlet(name = "/UpdateUserServlet", urlPatterns = "/UpdateUserServlet")
  21. public class UpdateUserServlet extends HttpServlet {
  23.     private static final long serialVersionUID = 1L;
  24.     private UserInfoDao userInfoDao = new UserInfoDao();
  26.     /**
  27.      * @see HttpServlet#HttpServlet()
  28.      */
  29.     public UpdateUserServlet() {
  30.         super();
  31.         // TODO Auto-generated constructor stub
  32.     }
  34.     /**
  35.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  36.      *      response)
  37.      */
  38.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  39.             throws ServletException, IOException {
  40.         // TODO Auto-generated method stub
  41.         response.getWriter().append("Served at: ").append(request.getContextPath());
  42.     }
  44.     /**
  45.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  46.      *      response)
  47.      */
  48.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  49.             throws ServletException, IOException {
  50.         // 此处可以使用过滤器批量处理
  51.         request.setCharacterEncoding("utf-8");
  52.         response.setContentType("text/json;charset=utf-8");
  53.         int userId = Integer.parseInt(request.getParameter("userId"));
  54.         String userName = request.getParameter("userName");
  55.         String userPwd = request.getParameter("userPwd");
  56.         UserInfoEntity entity = new UserInfoEntity(userId, userName, userPwd);
  57.         try {
  58.             boolean flag = userInfoDao.update(entity);
  59.             HashMap<String, Boolean> result = new HashMap<>();
  60.             result.put("flag", flag);
  61.             response.getWriter().write(JSON.toJSONString(result));
  62.         } catch (ClassNotFoundException | SQLException e) {
  63.             // TODO 自动生成的 catch 块
  64.             e.printStackTrace();
  65.         }
  66.     }
  68. }

④​​​​​​​package com.newcapec.servlet.newitem;

AddItemServlet.java

  1. package com.newcapec.servlet.newitem;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import com.alibaba.fastjson.JSON;
  14. import com.newcapec.dao.ItemUserDao;
  15. import com.newcapec.dao.NewItemDao;
  16. import com.newcapec.entity.ItemUserEntity;
  17. import com.newcapec.entity.NewItemEntity;
  18. import com.newcapec.entity.UserInfoEntity;
  20. /**
  21.  * Servlet implementation class AddUserServlet
  22.  */
  23. @WebServlet(name = "/AddItemServlet", urlPatterns = "/AddItemServlet")
  24. public class AddItemServlet extends HttpServlet {
  26.     private static final long serialVersionUID = 1L;
  27.     private NewItemDao newItemDao = new NewItemDao();
  28.     private ItemUserDao itemUserDao = new ItemUserDao();
  30.     /**
  31.      * @see HttpServlet#HttpServlet()
  32.      */
  33.     public AddItemServlet() {
  34.         super();
  35.         // TODO Auto-generated constructor stub
  36.     }
  38.     /**
  39.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  40.      *      response)
  41.      */
  42.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  43.             throws ServletException, IOException {
  44.         // TODO Auto-generated method stub
  45.         response.getWriter().append("Served at: ").append(request.getContextPath());
  46.     }
  48.     /**
  49.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  50.      *      response)
  51.      */
  52.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  53.             throws ServletException, IOException {
  54.         request.setCharacterEncoding("utf-8");
  55.         response.setContentType("text/json;charset=utf-8");
  56.         String ItemName = request.getParameter("itemName");
  57.         NewItemEntity newItemEntity = new NewItemEntity();
  58.         newItemEntity.setItemName(ItemName);
  59.         ItemUserEntity itemUserEntity = new ItemUserEntity();
  60.         // itemUserEntity.setItemId(itemId);
  61.         try {
  62.             int itemId = newItemDao.insert(newItemEntity);
  63.             itemUserEntity.setItemId(itemId);
  64.             UserInfoEntity userInfoEntity = (UserInfoEntity) request.getSession().getAttribute("userInfo");
  65.             itemUserEntity.setUserId(userInfoEntity.getUserId());
  66.             boolean flag = itemUserDao.insert(itemUserEntity);
  67.             HashMap<String, Boolean> result = new HashMap<>();
  68.             result.put("flag", flag);
  69.             response.getWriter().write(JSON.toJSONString(result));
  70.         } catch (ClassNotFoundException | SQLException e) {
  71.             // TODO 自动生成的 catch 块
  72.             e.printStackTrace();
  73.         }
  74.     }
  76. }

DeleteItemServlet.java

  1. package com.newcapec.servlet.newitem;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import com.alibaba.fastjson.JSON;
  14. import com.newcapec.dao.NewItemDao;
  16. /**
  17.  * Servlet implementation class DeleteItemServlet
  18.  */
  19. @WebServlet(name = "/DeleteItemServlet", urlPatterns = "/DeleteItemServlet")
  20. public class DeleteItemServlet extends HttpServlet {
  22.     private static final long serialVersionUID = 1L;
  23.     private NewItemDao newItemDao = new NewItemDao();
  25.     /**
  26.      * @see HttpServlet#HttpServlet()
  27.      */
  28.     public DeleteItemServlet() {
  29.         super();
  30.         // TODO Auto-generated constructor stub
  31.     }
  33.     /**
  34.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  35.      *      response)
  36.      */
  37.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  38.             throws ServletException, IOException {
  39.         // TODO Auto-generated method stub
  40.         response.getWriter().append("Served at: ").append(request.getContextPath());
  41.     }
  43.     /**
  44.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  45.      *      response)
  46.      */
  47.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  48.             throws ServletException, IOException {
  49.         // 此处可以使用过滤器批量处理
  50.         request.setCharacterEncoding("utf-8");
  51.         response.setContentType("text/json;charset=utf-8");
  52.         String[] itemIds = request.getParameterValues("itemIds[]");
  53.         // 使用newItemDao执行批量删除
  54.         int[] ids = new int[itemIds.length];
  55.         for (int i = 0; i < itemIds.length; i++) {
  56.             ids[i] = Integer.valueOf(itemIds[i]);
  57.         }
  58.         try {
  59.             boolean flag = newItemDao.batchDeleteById(ids);
  60.             HashMap<String, Boolean> result = new HashMap<>();
  61.             result.put("flag", flag);
  62.             response.getWriter().write(JSON.toJSONString(result));
  63.         } catch (ClassNotFoundException | SQLException e) {
  64.             // TODO 自动生成的 catch 块
  65.             e.printStackTrace();
  66.         }
  67.     }
  69. }

SelectItemByIdServlet.java

  1. package com.newcapec.servlet.newitem;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  12. import com.alibaba.fastjson.JSON;
  13. import com.newcapec.dao.NewItemDao;
  14. import com.newcapec.entity.NewItemEntity;
  16. /**
  17.  * Servlet implementation class SelectUserByIdServlet
  18.  */
  19. @WebServlet(name = "/SelectItemByIdServlet", urlPatterns = "/SelectItemByIdServlet")
  20. public class SelectItemByIdServlet extends HttpServlet {
  22.     private static final long serialVersionUID = 1L;
  23.     private NewItemDao newItemDao = new NewItemDao();
  25.     /**
  26.      * @see HttpServlet#HttpServlet()
  27.      */
  28.     public SelectItemByIdServlet() {
  29.         super();
  30.         // TODO Auto-generated constructor stub
  31.     }
  33.     /**
  34.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  35.      *      response)
  36.      */
  37.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  38.             throws ServletException, IOException {
  39.         // 此处可以使用过滤器批量处理
  40.         request.setCharacterEncoding("utf-8");
  41.         response.setContentType("text/json;charset=utf-8");
  42.         int itemId = Integer.parseInt(request.getParameter("itemId"));
  43.         try {
  44.             NewItemEntity newItemEntity = newItemDao.selectById(itemId);
  45.             response.getWriter().write(JSON.toJSONString(newItemEntity));
  46.         } catch (ClassNotFoundException | SQLException e) {
  47.             // TODO 自动生成的 catch 块
  48.             e.printStackTrace();
  49.         }
  50.     }
  52.     /**
  53.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  54.      *      response)
  55.      */
  56.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  57.             throws ServletException, IOException {
  58.         // TODO Auto-generated method stub
  59.         doGet(request, response);
  60.     }
  62. }

SelectItembyUserServlet.java

  1. package com.newcapec.servlet.newitem;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  6. import java.util.List;
  8. import javax.servlet.ServletException;
  9. import javax.servlet.annotation.WebServlet;
  10. import javax.servlet.http.HttpServlet;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  14. import com.alibaba.fastjson.JSON;
  15. import com.newcapec.dao.NewItemDao;
  16. import com.newcapec.entity.NewItemEntity;
  17. import com.newcapec.entity.UserInfoEntity;
  19. /**
  20.  * Servlet implementation class SelectItembyUserServlet
  21.  */
  22. @WebServlet(name = "/SelectItembyUserServlet", urlPatterns = "/SelectItembyUserServlet")
  23. public class SelectItembyUserServlet extends HttpServlet { // 获取item数据表中的数据
  25.     private static final long serialVersionUID = 1L;
  26.     private NewItemDao newItemDao = new NewItemDao();
  28.     /**
  29.      * @see HttpServlet#HttpServlet()
  30.      */
  31.     public SelectItembyUserServlet() {
  32.         super();
  33.         // TODO Auto-generated constructor stub
  34.     }
  36.     /**
  37.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  38.      *      response)
  39.      */
  40.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  41.             throws ServletException, IOException {
  42.         request.setCharacterEncoding("utf-8");
  43.         response.setContentType("text/json;charset=utf-8");
  44.         // 通过userId获取
  45.         UserInfoEntity userInfoEntity = (UserInfoEntity) request.getSession().getAttribute("userInfo");
  46.         try {
  47.             List<NewItemEntity> rows = newItemDao.selectAllByUserId(userInfoEntity.getUserId());
  48.             int total = newItemDao.selectAllByUserIdCount(userInfoEntity.getUserId());
  49.             HashMap<String, Object> result = new HashMap<>();
  50.             result.put("rows", rows);
  51.             result.put("total", total);
  52.             response.getWriter().write(JSON.toJSONString(result));
  53.         } catch (ClassNotFoundException | SQLException e) {
  54.             // TODO 自动生成的 catch 块
  55.             e.printStackTrace();
  56.         }
  57.     }
  59.     /**
  60.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  61.      *      response)
  62.      */
  63.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  64.             throws ServletException, IOException {
  65.         // TODO Auto-generated method stub
  66.         doGet(request, response);
  67.     }
  69. }

UpdateItemServlet.java

  1. package com.newcapec.servlet.newitem;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import com.alibaba.fastjson.JSON;
  14. import com.newcapec.dao.NewItemDao;
  15. import com.newcapec.entity.NewItemEntity;
  17. /**
  18.  * Servlet implementation class UpdateUserServlet
  19.  */
  20. @WebServlet(name = "/UpdateItemServlet", urlPatterns = "/UpdateItemServlet")
  22. public class UpdateItemServlet extends HttpServlet {
  24.     private static final long serialVersionUID = 1L;
  25.     private NewItemDao newItemDao = new NewItemDao();
  27.     /**
  28.      * @see HttpServlet#HttpServlet()
  29.      */
  30.     public UpdateItemServlet() {
  31.         super();
  32.         // TODO Auto-generated constructor stub
  33.     }
  35.     /**
  36.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  37.      *      response)
  38.      */
  39.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  40.             throws ServletException, IOException {
  41.         // TODO Auto-generated method stub
  42.         response.getWriter().append("Served at: ").append(request.getContextPath());
  43.     }
  45.     /**
  46.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  47.      *      response)
  48.      */
  50.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  51.             throws ServletException, IOException {
  52.         // 此处可以使用过滤器批量处理
  53.         request.setCharacterEncoding("utf-8");
  54.         response.setContentType("text/json;charset=utf-8");
  55.         int itemId = Integer.parseInt(request.getParameter("itemId"));
  56.         String itemName = request.getParameter("itemName");
  57.         NewItemEntity entity = new NewItemEntity(itemId, itemName);
  58.         try {
  59.             boolean flag = newItemDao.update(entity);
  60.             HashMap<String, Boolean> result = new HashMap<>();
  61.             result.put("flag", flag);
  62.             response.getWriter().write(JSON.toJSONString(result));
  63.         } catch (ClassNotFoundException | SQLException e) {
  64.             // TODO 自动生成的 catch 块
  65.             e.printStackTrace();
  66.         }
  67.     }
  69. }

⑤package com.newcapec.servlet.news;

AddNewsServlet.java

  1. package com.newcapec.servlet.news;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.HashMap;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import com.alibaba.fastjson.JSON;
  14. import com.newcapec.dao.NewsInfoDao;
  15. import com.newcapec.entity.NewsInfoEntity;
  17. /**
  18.  * Servlet implementation class AddNewsServlet
  19.  */
  20. @WebServlet(name = "/AddNewsServlet", urlPatterns = "/AddNewsServlet")
  21. public class AddNewsServlet extends HttpServlet {
  23.     private static final long serialVersionUID = 1L;
  24.     private NewsInfoDao newsInfoDao = new NewsInfoDao();
  26.     /**
  27.      * @see HttpServlet#HttpServlet()
  28.      */
  29.     public AddNewsServlet() {
  30.         super();
  31.         // TODO Auto-generated constructor stub
  32.     }
  34.     /**
  35.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
  36.      *      response)
  37.      */
  38.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  39.             throws ServletException, IOException {
  40.         // TODO Auto-generated method stub
  41.         response.getWriter().append("Served at: ").append(request.getContextPath());
  42.     }
  44.     /**
  45.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
  46.      *      response)
  47.      */
  48.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  49.             throws ServletException, IOException {
  50.         // TODO Auto-generated method stub
  51.         // doGet(request, response);
  52.         request.setCharacterEncoding("utf-8");
  53.         response.setContentType("text/json;charset=utf-8");
  54.         String addNewsTitle = request.getParameter("addNewsTitle");
  55.         String addNewsItem = request.getParameter("addNewsItem"); // 栏目id
  56.         String addNewsContent = request.getParameter("addNewsContent");
  57.         NewsInfoEntity newsInfoEntity = new NewsInfoEntity();
  58.         newsInfoEntity.setNewsTitle(addNewsTitle);
  59.         newsInfoEntity.setItemId(Integer.parseInt(addNewsItem));
  60.         newsInfoEntity.setNewsContent(addNewsContent);
  61.         try {
  62.             boolean flag = newsInfoDao.insert(newsInfoEntity);
  63.             HashMap<String, Boolean> result = new HashMap<>();
  64.             result.put("flag", flag);
  65.             response.getWriter().write(JSON.toJSONString(result));
  66.         } catch (ClassNotFoundException | SQLException e) {
  67.             // TODO 自动生成的 catch 块
  68.             e.printStackTrace();
  69.         }
  70.     }
  72. }

⑥package com.newcapec.test;

TestItemUserDao.java

  1. package com.newcapec.test;
  3. import java.sql.SQLException;
  4. import java.util.List;
  6. import org.junit.Assert;
  7. import org.junit.Test;
  9. import com.newcapec.dao.ItemUserDao;
  10. import com.newcapec.entity.ItemUserEntity;
  12. public class TestItemUserDao {
  14.     private ItemUserDao ItemUserDao = new ItemUserDao();
  16.     @Test
  17.     public void testInsert() throws ClassNotFoundException, SQLException {
  18.         ItemUserEntity itemUserEntity = new ItemUserEntity();
  19.         itemUserEntity.setUserId(1);
  20.         itemUserEntity.setItemId(1);
  21.         Assert.assertTrue(ItemUserDao.insert(itemUserEntity));
  22.     }
  24.     @Test
  25.     public void testDeleteById() throws ClassNotFoundException, SQLException {
  26.         Assert.assertTrue(ItemUserDao.deleteById(1));
  27.     }
  29.     @Test
  30.     public void testUpdate() throws ClassNotFoundException, SQLException {
  31.         ItemUserEntity entity = ItemUserDao.selectById(2);
  32.         entity.setItemId(2);
  33.         Assert.assertTrue(ItemUserDao.update(entity));
  34.     }
  36.     @Test
  37.     public void testSelectAll() throws ClassNotFoundException, SQLException {
  38.         System.out.println(ItemUserDao.selectAll());
  39.     }
  41. }

TestLogsInfoDao.java

  1. package com.newcapec.test;
  3. import java.sql.SQLException;
  4. import java.util.List;
  6. import org.junit.Assert;
  7. import org.junit.Test;
  9. import com.newcapec.dao.LogsInfoDao;
  10. import com.newcapec.entity.LogsInfoEntity;
  12. public class TestLogsInfoDao {
  14.     private LogsInfoDao logsInfoDao = new LogsInfoDao();
  16.     @Test
  17.     public void testInsert() throws ClassNotFoundException, SQLException {
  18.         LogsInfoEntity logsInfoEntity = new LogsInfoEntity();
  19.         logsInfoEntity.setUserId(1);
  20.         logsInfoEntity.setLogsContent("woshishenren");
  21.         // userInfoDao.insert(userInfoEntity);
  22.         Assert.assertTrue(logsInfoDao.insert(logsInfoEntity));
  23.     }
  25.     @Test
  26.     public void testSelect() throws ClassNotFoundException, SQLException {
  27.         List<LogsInfoEntity> list = logsInfoDao.selectAll();
  28.         System.out.println(list);
  29.     }
  31.     @Test
  32.     public void testDeleteById() throws ClassNotFoundException, SQLException {
  33.         Assert.assertTrue(logsInfoDao.deleteById(2));
  34.     }
  36.     @Test
  37.     public void testUpdate() throws ClassNotFoundException, SQLException {
  38.         LogsInfoEntity logsInfoEntity = logsInfoDao.selectById(2);
  39.         logsInfoEntity.setUserId(1);
  40.         logsInfoDao.update(logsInfoEntity);
  41.     }
  43.     @Test
  44.     public void testselectById() throws ClassNotFoundException, SQLException {
  45.         System.out.println(logsInfoDao.selectById(1));
  46.     }
  48. }

TestNewItemDao.java

  1. package com.newcapec.test;
  3. import java.sql.SQLException;
  4. import java.util.List;
  6. import org.junit.Assert;
  7. import org.junit.Test;
  9. import com.newcapec.dao.NewItemDao;
  10. import com.newcapec.entity.NewItemEntity;
  12. public class TestNewItemDao {
  14.     private NewItemDao newItemDao = new NewItemDao();
  16.     @Test
  17.     public void testInsert() throws ClassNotFoundException, SQLException {
  18.         NewItemEntity newItemEntity = new NewItemEntity();
  19.         newItemEntity.setItemId(1);
  20.         newItemEntity.setItemName("插入测试");
  21.         // Assert.assertTrue(newItemDao.insert(newItemEntity));
  22.     }
  24.     @Test
  25.     public void testDeleteById() throws ClassNotFoundException, SQLException {
  26.         Assert.assertTrue(newItemDao.deleteById(14));
  27.     }
  29.     @Test
  30.     public void testUpdate() throws ClassNotFoundException, SQLException {
  31.         NewItemEntity entity = newItemDao.selectById(1);
  32.         entity.setItemName("更新item测试");
  33.         Assert.assertTrue(newItemDao.update(entity));
  34.     }
  36.     @Test
  37.     public void testSelectAll() throws ClassNotFoundException, SQLException {
  38.         System.out.println(newItemDao.selectAll());
  39.     }
  41. }

NewsInfoDao.java

  1. package com.newcapec.test;
  3. import java.sql.SQLException;
  5. import org.junit.Assert;
  6. import org.junit.Test;
  8. import com.newcapec.dao.NewsInfoDao;
  9. import com.newcapec.entity.NewsInfoEntity;
  11. public class TestNewsInfoDao {
  13.     private NewsInfoDao newsInfoDao = new NewsInfoDao();
  15.     @Test
  16.     public void testInsert() throws ClassNotFoundException, SQLException {
  17.         NewsInfoEntity newsInfoEntity = new NewsInfoEntity();
  18.         newsInfoEntity.setItemId(1);
  19.         newsInfoEntity.setNewsTitle("新能源召回大户特斯拉的“美式”傲慢｜观潮");
  20.         newsInfoEntity.setNewsImage(
  21.                 "http://pics1.baidu.com/feed/71cf3bc79f3df8dcecfa18268a75ee8c46102829.jpeg?token=32875797d2ded1ed2a9334df610bccf7");
  22.         newsInfoEntity.setNewsContent("新浪科技 花子健\r\n" + "从“硬件升级”到“召回”，理想汽车只用了5天。\r\n"
  23.                 + "而不久前的威马汽车召回事件，前后耗时23天，威马汽车将之定义为“史上最快召回”。如果仅仅是简单对比，理想汽车无疑刷新了历史记录。\r\n"
  24.                 + "对于新造车势力来说，受限于工艺和新技术，召回是大概率事件。目前除了小鹏未有实际的召回经历之外，蔚来汽车、威马汽车以及理想汽车，包括外来者特斯拉，都遇到过召回。只不过，中国新造车势力和特斯拉表现出来的态度截然不同。\r\n"
  25.                 + "“惶恐”的造车新势力\r\n" + "11月1日，理想汽车在媒体沟通会上宣布了针对前悬架下摆臂球销和底盘的“免费升级”，其中前悬架下摆臂球销受力太低与理想ONE多次出现断轴事件有关系。\r\n"
  26.                 + "但理想汽车的措辞遭到质疑。一方面是理想汽车CEO李想公开承认“升级肯定是因为产品有缺陷，我们是在行驶当中发生碰撞断掉的几率高于平均值。”而另外一方面，则是在一开始否认“召回”，以“免费升级”代替。\r\n"
  27.                 + "理想汽车销售服务副总裁刘杰强调，升级和那种由于车辆本身在行驶过程中出现故障和质量问题的召回，是不一样的。11月6日，理想汽车最终宣布召回10469辆理想ONE，占已交付车辆的将近50%。\r\n"
  28.                 + "官方披露的信息显示，截至2020年10月31日，理想ONE累计发生了97起前悬架碰撞事故，其中前悬架下摆臂球头从球销脱出的情况超过10起，造成了理想汽车在碰撞之后断轴的严重事故。");
  29.         Assert.assertTrue(newsInfoDao.insert(newsInfoEntity));
  30.     }
  32.     @Test
  33.     public void testDeleteById() throws ClassNotFoundException, SQLException {
  34.         Assert.assertTrue(newsInfoDao.deleteById(1));
  35.     }
  37.     @Test
  38.     public void testUpdate() throws ClassNotFoundException, SQLException {
  39.         NewsInfoEntity entity = newsInfoDao.selectById(2);
  40.         entity.setNewsTitle("图书馆维修，暂停开放一天");
  41.         Assert.assertTrue(newsInfoDao.update(entity));
  42.     }
  44.     @Test
  45.     public void testSelectAll() throws ClassNotFoundException, SQLException {
  46.         System.out.println(newsInfoDao.selectAll());
  47.     }
  49. }

TestUserInfoDao.java

  1. package com.newcapec.test;
  3. import java.sql.SQLException;
  4. import java.util.List;
  6. import org.junit.Assert;
  7. import org.junit.Test;
  9. import com.newcapec.dao.UserInfoDao;
  10. import com.newcapec.entity.UserInfoEntity;
  12. public class TestUserInfoDao {
  14.     private UserInfoDao userInfoDao = new UserInfoDao();
  16.     @Test
  17.     public void testInsert() throws ClassNotFoundException, SQLException {
  18.         /*
  19.          * UserInfoEntity userInfoEntity = new UserInfoEntity();
  20.          * userInfoEntity.setUserName("田七"); userInfoEntity.setUserPwd("123456");
  21.          * //userInfoDao.insert(userInfoEntity);
  22.          * Assert.assertTrue(userInfoDao.insert(userInfoEntity));
  23.          */
  24.         for (int i = 1; i <= 100; i++) {
  25.             UserInfoEntity userInfoEntity = new UserInfoEntity();
  26.             userInfoEntity.setUserName("userName" + i);
  27.             userInfoEntity.setUserPwd("123456");
  28.             // userInfoDao.insert(userInfoEntity);
  29.             Assert.assertTrue(userInfoDao.insert(userInfoEntity));
  30.         }
  31.     }
  33.     @Test
  34.     public void testSelect() throws ClassNotFoundException, SQLException {
  35.         List<UserInfoEntity> list = userInfoDao.selectAll();
  36.         System.out.println(list);
  37.     }
  39.     @Test
  40.     public void testDeleteById() throws ClassNotFoundException, SQLException {
  41.         Assert.assertTrue(userInfoDao.deleteById(7));
  42.     }
  44.     @Test
  45.     public void testUpdate() throws ClassNotFoundException, SQLException {
  46.         UserInfoEntity userInfoEntity = userInfoDao.selectById(1);
  47.         userInfoEntity.setUserName("zhangsan");
  48.         userInfoDao.update(userInfoEntity);
  49.     }
  51.     @Test
  52.     public void testselectById() throws ClassNotFoundException, SQLException {
  53.         System.out.println(userInfoDao.selectById(1));
  54.     }
  56. }

⑦package com.newcapec.utils;

DBUtils.java

  1. package com.newcapec.utils;
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.SQLException;
  7. import com.mysql.jdbc.Driver;
  9. /**
  10.  * 获取与数据库的连接 此处后期需要使用阿里巴巴的druid数据库连接池优化
  11.  * 
  12.  * @author user
  13.  *
  14.  */
  15. public class DBUtils {
  17.     public static Connection openConn() throws ClassNotFoundException, SQLException {
  18.         // 连接数据库四要素
  19.         // url username password driver
  20.         String user = "root";
  21.         String password = "root";
  22.         // String driver = "com.mysql.jdbc.Driver";
  23.         // String url = "jdbc:mysql://127.0.0.1:3306/zykkk?characterEncoding=UTF-8";
  24.         String driver = "com.mysql.cj.jdbc.Driver";
  25.         String url = "jdbc:mysql://localhost:3306/zykkk?characterEncoding=utf-8&serverTimezone=UTC";// (UTC表示标准时区)
  26.         // 注册数据库驱动
  27.         Class.forName(driver);
  29.         return DriverManager.getConnection(url, user, password);
  30.     }
  32. }

MD5Utils.java

  1. package com.newcapec.utils;
  3. import java.security.MessageDigest;
  5. public class MD5Utils {
  7.     /***
  8.      * MD5加码 生成32位md5码
  9.      */
  10.     public static String stringMD5(String inStr) {
  11.         MessageDigest md5 = null;
  12.         try {
  13.             md5 = MessageDigest.getInstance("MD5");
  14.         } catch (Exception e) {
  15.             System.out.println(e.toString());
  16.             e.printStackTrace();
  17.             return "";
  18.         }
  19.         char[] charArray = inStr.toCharArray();
  20.         byte[] byteArray = new byte[charArray.length];
  21.         for (int i = 0; i < charArray.length; i++)
  22.             byteArray[i] = (byte) charArray[i];
  23.         byte[] md5Bytes = md5.digest(byteArray);
  24.         StringBuffer hexValue = new StringBuffer();
  25.         for (int i = 0; i < md5Bytes.length; i++) {
  26.             int val = ((int) md5Bytes[i]) & 0xff;
  27.             if (val < 16)
  28.                 hexValue.append("0");
  29.             hexValue.append(Integer.toHexString(val));
  30.         }
  31.         return hexValue.toString();
  32.     }
  34.     /**
  35.      * 加密解密算法 执行一次加密，两次解密
  36.      */
  37.     public static String convertMD5(String inStr) {
  38.         char[] a = inStr.toCharArray();
  39.         for (int i = 0; i < a.length; i++) {
  40.             a[i] = (char) (a[i] ^ 't');
  41.         }
  42.         String s = new String(a);
  43.         return s;
  44.     }
  46.     // 测试主函数
  47.     public static void main(String args[]) {
  48.         String s = new String("1233");
  49.         System.out.println("原始：" + s);
  50.         System.out.println("MD5后：" + stringMD5(s));
  51.         System.out.println("加密的：" + convertMD5(s));
  52.         System.out.println("解密的：" + convertMD5(convertMD5(s)));
  53.     }
  55. }

pages

item_manager.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="utf-8">
  6.     <!-- 新 Bootstrap4 核心 CSS 文件 -->
  7.     <link rel="stylesheet" href="../bootstrap4/css/bootstrap.min.css">
  8.     <link rel="stylesheet" type="text/css" href="../font-awesome-4.7.0/css/font-awesome.min.css" />
  9.     <link href="../bootstrap-table/bootstrap-table.min.css" rel="stylesheet" />
  10.     <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  11.     <script src="../jquery/jquery.min.js"></script>
  12.     <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  13.     <script src="../js/popper.min.js"></script>
  14.     <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  15.     <script src="../bootstrap4/js/bootstrap.min.js"></script>
  16.     <script src="../bootstrap-table/bootstrap-table.js"></script>
  17.     <script src="../bootstrap-table/locale/bootstrap-table-zh-CN.js"></script>
  18.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  19.     <title>栏目管理</title>
  20.     <script type="text/javascript">
  21.         function batchDelete() {
  22.             var rows = $('#newItemTab').bootstrapTable('getSelections');
  23.             console.log(rows);
  24.             var itemIds = new Array();
  25.             for (var i = 0; i < rows.length; i++) {
  26.                 itemIds.push(rows[i].itemId);
  27.             }
  28.             console.log(itemIds);
  29.             $.ajax({
  30.                 type: "POST",
  31.                 url: "../DeleteItemServlet",
  32.                 data: { "itemIds": itemIds },
  33.                 success: function (msg) {
  34.                     if (msg.flag) {
  35.                         alert("batchDelete()成功");
  36.                         //刷新数据
  37.                         $('#newItemTab').bootstrapTable("refresh");
  38.                     } else {
  39.                         alert("失败");
  40.                     }
  41.                 }
  42.             });
  43.         }
  45.         function addNewItem() {
  46.             var itemName = $("#addItemName").val();
  47.             var itemdata = {
  48.                 "itemName": itemName
  49.             };
  50.             $.ajax({
  51.                 type: "POST",
  52.                 url: "../AddItemServlet",
  53.                 data: itemdata,
  54.                 success: function (msg) {
  55.                     if (msg.flag) {
  56.                         alert("addNewItem()成功");
  57.                         //刷新数据
  58.                         $('#newItemTab').bootstrapTable("refresh");
  59.                     } else {
  60.                         alert("失败");
  61.                     }
  62.                     $("#addItemName").val("");
  63.                 }
  64.             });
  65.         }
  67.         function edit(itemId) { // 编辑用户信息
  68.             console.log(itemId);
  69.             //通过该ID获取数据
  70.             //通过ajax发起请求获取用户信息
  71.             $.ajax({
  72.                 type: "get",
  73.                 url: "../SelectItemByIdServlet",
  74.                 data: { "itemId": itemId },
  75.                 success: function (msg) {
  76.                     console.log(msg);
  77.                     //获取成功后填入参数展示模态框
  78.                     $("input[name='itemId']").val(msg.itemId);
  79.                     $("input[name='itemName']").val(msg.itemName);
  80.                     $("#updateNewItem").modal('show');
  81.                 }
  82.             });
  83.             //执行更新
  84.         }
  86.         function updateNewItem() { // 刷新页面信息
  87.             var newItem = {
  88.                 "itemId": $("input[name='itemId']").val(),
  89.                 "itemName": $("input[name='itemName']").val()
  90.             };
  91.             $.ajax({
  92.                 type: "post",
  93.                 url: "../UpdateItemServlet",
  94.                 data: newItem,
  95.                 success: function (msg) {
  96.                     if (msg.flag) {
  97.                         alert("updateNewItem()成功");
  98.                         //刷新数据
  99.                         $('#newItemTab').bootstrapTable("refresh");
  100.                     } else {
  101.                         alert("失败");
  102.                     }
  103.                     $("input[name='itemId']").val("");
  104.                     $("input[name='itemName']").val("");
  105.                 }
  106.             });
  107.         }
  108.     </script>
  109. </head>
  111. <body>
  112.     <div style="padding: 10px">
  113.         <div id="toolbar" style="display: flex;">
  114.             <button type="button" class="btn btn-info" data-toggle="modal" data-target="#addNewItem"><i
  115.                     class="fa fa-plus"></i> 添加</button>
  116.             <button type="button" class="btn btn-danger" onclick="batchDelete()"><i class="fa fa-minus"></i>
  117.                 批量删除</button>
  118.             <!--     <input type="text" placeholder="请输入栏目名" id="itemName" value="新闻处"/><button class="btn btn-info" onclick='search()'><i class="fa fa-search"></i></button> -->
  120.         </div>
  121.         <table id="newItemTab" class="table table-hover table-bordered table-striped">
  123.         </table>
  125.         <div class="modal fade" id="updateNewItem">
  126.             <div class="modal-dialog">
  127.                 <div class="modal-content">
  129.                     <!-- 模态框头部 -->
  130.                     <div class="modal-header bg-info">
  131.                         <h4 class="modal-title">更新栏目信息</h4>
  132.                         <button type="button" class="close" data-dismiss="modal">×</button>
  133.                     </div>
  135.                     <!-- 模态框主体 -->
  136.                     <div class="modal-body">
  137.                         <form>
  138.                             <input type="hidden" name="itemId" />
  139.                             <div class="input-group mb-3">
  140.                                 <div class="input-group-prepend">
  141.                                     <span class="input-group-text"><i class="fa fa-user"></i></span>
  142.                                 </div>
  143.                                 <input type="text" name="itemName" class="form-control" placeholder="Itemname">
  144.                             </div>
  146.                         </form>
  147.                     </div>
  149.                     <!-- 模态框底部 -->
  150.                     <div class="modal-footer">
  151.                         <button type="button" class="btn btn-success" data-dismiss="modal"
  152.                             onclick=updateNewItem()>更新</button>
  153.                         <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
  154.                     </div>
  156.                 </div>
  157.             </div>
  158.         </div>
  159.         <!-- 模态框 -->
  160.         <div class="modal fade" id="addNewItem">
  161.             <div class="modal-dialog">
  162.                 <div class="modal-content">
  164.                     <!-- 模态框头部 -->
  165.                     <div class="modal-header bg-info">
  166.                         <h4 class="modal-title">添加栏目信息</h4>
  167.                         <button type="button" class="close" data-dismiss="modal">×</button>
  168.                     </div>
  170.                     <!-- 模态框主体 -->
  171.                     <div class="modal-body">
  172.                         <form>
  173.                             <div class="input-group mb-3">
  174.                                 <div class="input-group-prepend">
  175.                                     <span class="input-group-text"><i class="fa fa-user"></i></span>
  176.                                 </div>
  177.                                 <input type="text" id="addItemName" class="form-control" placeholder="Itemname">
  178.                             </div>
  180.                         </form>
  181.                     </div>
  183.                     <!-- 模态框底部 -->
  184.                     <div class="modal-footer">
  185.                         <button type="button" class="btn btn-success" data-dismiss="modal"
  186.                             onclick=addNewItem()>添加！</button>
  187.                         <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
  188.                     </div>
  190.                 </div>
  191.             </div>
  192.         </div>
  193.     </div>
  195.     <script>
  196.         var icons = {
  197.             paginationSwitchDown: 'fa-caret-square-down',
  198.             paginationSwitchUp: 'fa-caret-square-up',
  199.             refresh: 'fa-refresh',
  200.             toggleOff: 'fa-toggle-off',
  201.             toggleOn: 'fa-toggle-on',
  202.             columns: 'fa-th-list',
  203.             fullscreen: 'fa-arrows-alt',
  204.             detailOpen: 'fa-plus',
  205.             detailClose: 'fa-minus'
  206.         };
  207.         //异步加载表格数据
  208.         $('#newItemTab').bootstrapTable({
  209.             url: '../SelectItembyUserServlet',         //请求后台的URL（*）
  210.             method: 'get',                      //请求方式（*）
  211.             toolbar: '#toolbar',                //工具按钮用哪个容器
  212.             striped: true,                      //是否显示行间隔色
  213.             cache: false,                       //是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）
  214.             pagination: true,                   //是否显示分页（*）
  215.             icons: icons,                       //重新定义图标 修复图标加载失败问题
  216.             queryParams: function (params) {
  217.                 var temp = {   //这里的键的名字和控制器的变量名必须一直，这边改动，控制器也需要改成一样的
  218.                     limit: params.limit,   //页面大小
  219.                     offset: params.offset  //页码
  220.                     //itemName: $("#itemName").val()
  221.                     //statu: $("#txt_search_statu").val()
  222.                 };
  223.                 return temp;
  224.             },
  225.             sidePagination: "server",           //分页方式：client客户端分页，server服务端分页（*）
  226.             pageNumber: 1,                       //初始化加载第一页，默认第一页
  227.             pageSize: 10,                       //每页的记录行数（*）
  228.             pageList: [10, 15, 20, 25],        //可供选择的每页的行数（*）
  229.             //search: true,                       //是否显示表格搜索，此搜索是客户端搜索，不会进服务端，所以，个人感觉意义不大
  230.             strictSearch: true,
  231.             showRefresh: true,                  //是否显示刷新按钮
  232.             clickToSelect: true,                //是否启用点击选中行
  233.             uniqueId: "itemId",                     //每一行的唯一标识，一般为主键列
  234.             //showToggle:true,                    //是否显示详细视图和列表视图的切换按钮
  235.             //cardView: false,                    //是否显示详细视图
  236.             columns: [{
  237.                 checkbox: true
  238.             }, {
  239.                 field: 'itemId',
  240.                 title: '栏目Id'
  241.             }, {
  242.                 field: 'itemName',
  243.                 title: '栏目名称'
  244.             }, {
  245.                 field: 'createTime',
  246.                 title: '创建时间'
  247.             }, {
  248.                 field: 'updateTime',
  249.                 title: '更新时间'
  250.             }, {
  251.                 field: 'itemId',
  252.                 title: '编辑',
  253.                 formatter: function (value, row, index) {
  254.                     var e = '<a class="btn btn-waring" href="#" mce_href="#" title="编辑" onclick="edit(\''
  255.                         + row.itemId
  256.                         + '\')"><i class="fa fa-edit"></i>编辑</a> ';
  257.                     return e;
  258.                 }
  259.             }]
  260.         });
  261.     </script>
  262. </body>
  264. </html>

news_manager.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="utf-8">
  6.     <title>新闻管理</title>
  7.     <!-- 新 Bootstrap4 核心 CSS 文件 -->
  8.     <link rel="stylesheet" href="../bootstrap4/css/bootstrap.min.css">
  9.     <link rel="stylesheet" type="text/css" href="../font-awesome-4.7.0/css/font-awesome.min.css" />
  10.     <link href="../bootstrap-table/bootstrap-table.min.css" rel="stylesheet" />
  11.     <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  12.     <script src="../jquery/jquery.min.js"></script>
  13.     <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  14.     <script src="../js/popper.min.js"></script>
  15.     <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  16.     <script src="../bootstrap4/js/bootstrap.min.js"></script>
  17.     <script src="../bootstrap-table/bootstrap-table.js"></script>
  18.     <script src="../bootstrap-table/locale/bootstrap-table-zh-CN.js"></script>
  19.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  20.     <style type="text/css">
  21.         body {
  22.             display: flex;
  23.             flex-direction: column;
  24.             min-height: 100vh;
  25.         }
  27.         #header {
  28.             display: flex;
  29.             align-items: center;
  30.             justify-content: space-between;
  31.             font-size: 20px;
  32.             margin: 15px;
  33.         }
  35.         #header>a {
  36.             color: #007FB0;
  37.         }
  39.         #bodychild1>a {
  40.             color: #007FB0;
  41.         }
  43.         #header>#header1 {
  44.             display: flex;
  45.             flex-direction: row;
  46.         }
  48.         #header1>#header2 {
  49.             display: flex;
  50.             flex-direction: row;
  51.         }
  53.         #body {
  54.             display: flex;
  55.             flex-direction: column;
  56.             border: 1px solid darkgrey;
  57.             margin: 15px;
  58.         }
  60.         #body1 {
  61.             height: 50px;
  62.             display: flex;
  63.             flex-grow: 1;
  64.             align-items: center;
  65.             padding: 20px;
  66.             background-color: #cecece;
  67.             border-bottom: 1px solid darkgrey;
  68.         }
  70.         #body2 {
  71.             height: 500px;
  72.             display: flex;
  73.             flex-direction: column;
  74.             margin: 20px;
  75.         }
  77.         #body3 {
  78.             height: 50px;
  79.             display: flex;
  80.             flex-direction: row;
  81.             margin: 10px;
  82.         }
  84.         #body4 {
  85.             height: 40px;
  86.             width: 80px;
  87.             display: flex;
  88.             justify-content: center;
  89.             align-items: center;
  90.             border: 1px solid darkgrey;
  91.         }
  92.     </style>
  93.     <script type="text/javascript">
  94.         $(function () {
  95.             $.ajax({
  96.                 url: "../SelectItembyUserServlet",
  97.                 method: "get",
  98.                 success: function (data) {
  99.                     for (var i = 0; i < data.rows.length; i++) {
  100.                         //var $option = $("<option value="+data.rows[i].itetmId+">"+data.rows[i].itemName+"</option");
  101.                         $("#addNewsItem").append("<option value=" + data.rows[i].itemId + ">" + data.rows[i].itemName + "</option");
  103.                     }
  104.                 }
  105.             });
  106.         });
  107.         function addNewItem() {
  108.             var addNewsTitle = $("#addNewsTitle").val();
  109.             var addNewsItem = $("#addNewsItem").val();
  110.             var addNewsContent = $("#addNewsContent").val();
  111.             console.log(addNewsTitle);
  112.             console.log(addNewsItem);
  113.             console.log(addNewsContent);
  114.             var newsdata = {
  115.                 "addNewsTitle": addNewsTitle,
  116.                 "addNewsItem": addNewsItem,
  117.                 "addNewsContent": addNewsContent
  118.             };
  119.             console.log(newsdata);
  120.             //return;
  121.             $.ajax({
  122.                 type: "POST",
  123.                 url: "../AddNewsServlet",
  124.                 data: newsdata,
  125.                 success: function (msg) {
  126.                     if (msg.flag) {
  127.                         alert("成功插入新闻，芜湖~");
  128.                         //刷新数据 $('#newItemTab').bootstrapTable("refresh");
  129.                     } else {
  130.                         alert("插入新闻失败~");
  131.                     }
  132.                     //$("#addItemName").val("");
  133.                 }
  134.             });
  135.         }
  136.     </script>
  137. </head>
  139. <body>
  140.     <div id="header">
  141.         <a>新闻管理</a>
  142.         <div id="header1">
  143.             <div class="dropdown">
  144.                 <button type="button" class="btn btn-secondary dropdown-toggle" data-toggle="dropdown"
  145.                     style="background-color: white; color: #cbcbcb;">
  146.                     教务处
  147.                 </button>
  148.                 <div class="dropdown-menu">
  149.                     <a class="dropdown-item" href="#">学生会</a>
  150.                     <a class="dropdown-item" href="#">党支部</a>
  151.                     <a class="dropdown-item" href="#">分团委</a>
  152.                 </div>
  153.                 <!--    <select>
  154.                   <option value="volvo">Volvo</option>
  155.                   <option value="saab">Saab</option>
  156.                   <option value="opel">Opel</option>
  157.                   <option value="audi">Audi</option>
  158.                 </select>   -->
  159.             </div>
  160.             <div id="header2"><input type="text" class="form-control" placeholder="用户名">
  161.                 <span class="input-group-text"><a href="#"><i class="fa-circle-thin"></i></a></span>
  162.             </div>
  163.         </div>
  164.     </div>
  165.     <!-- header yes -->
  166.     <div id="body">
  167.         <div id="body1">
  168.             <a>发布新闻</a>
  169.         </div>
  170.         <div id="body2">
  171.             <div id="body3">
  172.                 <div id="body4"><a>标题</a> </div>
  173.                 <div><input id="addNewsTitle" type="text" placeholder="新闻标题" style="height: 40px;width: 300px;"></div>
  174.             </div>
  175.             <div id="body3">
  176.                 <div id="body4"><a>栏目</a> </div>
  177.                 <!-- <div class="dropdown" style="width: 300px">
  178.                         <button type="button"  class="btn btn-secondary dropdown-toggle" data-toggle="dropdown" style="background-color: white; color: #b8b8b8;width: 150px;height: 40px">
  179.                           教务处
  180.                         </button>
  181.                         <div class="dropdown-menu">
  182.                           <a class="dropdown-item" href="#">学生会</a>
  183.                           <a class="dropdown-item" href="#">党支部</a>
  184.                           <a class="dropdown-item" href="#">分团委</a>
  185.                           <a class="dropdown-item" href="#">院团委</a>
  186.                         </div>
  187.                       </div> -->
  188.                 <select id="addNewsItem" class="form-control" style="height: 40px;width: 300px;">
  190.                 </select>
  191.             </div>
  192.             <div style="margin: 10px;">
  193.                 <textarea id="addNewsContent" rows="10" cols="100" placeholder="新闻内容"></textarea>
  194.             </div>
  195.             <div style="margin: 10px;"><button type="button" class="btn btn-primary" style="width: 80px;"
  196.                     onClick="addNewItem()">发布</button></div>
  197.         </div>
  198. </body>
  200. </html>

user_manager.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="utf-8">
  6.     <!-- 新 Bootstrap4 核心 CSS 文件 -->
  7.     <link rel="stylesheet" href="../bootstrap4/css/bootstrap.min.css">
  8.     <link rel="stylesheet" type="text/css" href="../font-awesome-4.7.0/css/font-awesome.min.css" />
  9.     <link href="../bootstrap-table/bootstrap-table.min.css" rel="stylesheet" />
  10.     <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  11.     <script src="../jquery/jquery.min.js"></script>
  12.     <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  13.     <script src="../js/popper.min.js"></script>
  14.     <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  15.     <script src="../bootstrap4/js/bootstrap.min.js"></script>
  16.     <script src="../bootstrap-table/bootstrap-table.js"></script>
  17.     <script src="../bootstrap-table/locale/bootstrap-table-zh-CN.js"></script>
  18.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  19.     <title>用户管理</title>
  20.     <script type="text/javascript">
  21.         function batchDelete() {
  22.             var rows = $('#userInfoTab').bootstrapTable('getSelections');
  23.             console.log(rows);
  24.             var userIds = new Array();
  25.             for (var i = 0; i < rows.length; i++) {
  26.                 userIds.push(rows[i].userId);
  27.             }
  28.             console.log(userIds);
  29.             $.ajax({
  30.                 type: "POST",
  31.                 url: "../DeleteUserServlet",
  32.                 data: { "userIds": userIds },
  33.                 success: function (msg) {
  34.                     if (msg.flag) {
  35.                         alert("成功");
  36.                         //刷新数据
  37.                         $('#userInfoTab').bootstrapTable("refresh");
  38.                     } else {
  39.                         alert("失败");
  40.                     }
  41.                 }
  42.             });
  43.         }
  45.         function addUserInfo() {
  46.             var userName = $("#addUserName").val();
  47.             var userPwd = $("#addUserPwd").val();
  48.             var userdata = {
  49.                 "userName": userName,
  50.                 "userPwd": userPwd
  51.             };
  52.             $.ajax({
  53.                 type: "POST",
  54.                 url: "../AddUserServlet",
  55.                 data: userdata,
  56.                 success: function (msg) {
  57.                     if (msg.flag) {
  58.                         alert("成功");
  59.                         //刷新数据
  60.                         $('#userInfoTab').bootstrapTable("refresh");
  61.                     } else {
  62.                         alert("失败");
  63.                     }
  64.                     $("#addUserName").val("");
  65.                     $("#addUserPwd").val("");
  66.                 }
  67.             });
  68.         }
  70.         function edit(userId) {
  71.             console.log(userId);
  72.             //通过该ID获取数据
  73.             //通过ajax发起请求获取用户信息
  74.             $.ajax({
  75.                 type: "get",
  76.                 url: "../SelectUserByIdServlet",
  77.                 data: { "userId": userId },
  78.                 success: function (msg) {
  79.                     console.log(msg);
  80.                     //获取成功后填入参数展示模态框
  81.                     $("input[name='userId']").val(msg.userId);
  82.                     $("input[name='userName']").val(msg.userName);
  83.                     $("input[name='userPwd']").val(msg.userPwd);
  84.                     $("#updateUserInfo").modal('show');
  85.                 }
  86.             });
  87.             //执行更新
  88.         }
  90.         function updateUserInfo() {
  91.             var userInfo = {
  92.                 "userId": $("input[name='userId']").val(),
  93.                 "userName": $("input[name='userName']").val(),
  94.                 "userPwd": $("input[name='userPwd']").val()
  95.             };
  96.             $.ajax({
  97.                 type: "post",
  98.                 url: "../UpdateUserServlet",
  99.                 data: userInfo,
  100.                 success: function (msg) {
  101.                     if (msg.flag) {
  102.                         alert("成功");
  103.                         //刷新数据
  104.                         $('#userInfoTab').bootstrapTable("refresh");
  105.                     } else {
  106.                         alert("失败");
  107.                     }
  108.                     $("input[name='userId']").val("");
  109.                     $("input[name='userName']").val("");
  110.                     $("input[name='userPwd']").val("");
  111.                 }
  112.             });
  113.         }
  114.     </script>
  115. </head>
  117. <body>
  118.     <div style="padding: 10px">
  119.         <div id="toolbar" style="display: flex;">
  120.             <button type="button" class="btn btn-info" data-toggle="modal" data-target="#addUserInfo"><i
  121.                     class="fa fa-plus"></i> 添加</button>
  122.             <button type="button" class="btn btn-danger" onclick="batchDelete()"><i class="fa fa-minus"></i>
  123.                 批量删除</button>
  124.             <!--     <input type="text" placeholder="请输入用户名" id="userName" value="zhangsan"/><button class="btn btn-info" onclick='search()'><i class="fa fa-search"></i></button> -->
  126.         </div>
  127.         <table id="userInfoTab" class="table table-hover table-bordered table-striped">
  129.         </table>
  131.         <div class="modal fade" id="updateUserInfo">
  132.             <div class="modal-dialog">
  133.                 <div class="modal-content">
  135.                     <!-- 模态框头部 -->
  136.                     <div class="modal-header bg-info">
  137.                         <h4 class="modal-title">更新用户信息</h4>
  138.                         <button type="button" class="close" data-dismiss="modal">×</button>
  139.                     </div>
  141.                     <!-- 模态框主体 -->
  142.                     <div class="modal-body">
  143.                         <form>
  144.                             <input type="hidden" name="userId" />
  145.                             <div class="input-group mb-3">
  146.                                 <div class="input-group-prepend">
  147.                                     <span class="input-group-text"><i class="fa fa-user"></i></span>
  148.                                 </div>
  149.                                 <input type="text" name="userName" class="form-control" placeholder="Username">
  150.                             </div>
  151.                             <div class="input-group mb-3">
  152.                                 <div class="input-group-prepend">
  153.                                     <span class="input-group-text"><i class="fa fa-lock"></i></span>
  154.                                 </div>
  155.                                 <input type="password" name="userPwd" class="form-control" placeholder="userpwd">
  156.                             </div>
  158.                         </form>
  159.                     </div>
  161.                     <!-- 模态框底部 -->
  162.                     <div class="modal-footer">
  163.                         <button type="button" class="btn btn-success" data-dismiss="modal"
  164.                             onclick=updateUserInfo()>更新</button>
  165.                         <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
  166.                     </div>
  168.                 </div>
  169.             </div>
  170.         </div>
  171.         <!-- 模态框 -->
  172.         <div class="modal fade" id="addUserInfo">
  173.             <div class="modal-dialog">
  174.                 <div class="modal-content">
  176.                     <!-- 模态框头部 -->
  177.                     <div class="modal-header bg-info">
  178.                         <h4 class="modal-title">添加用户信息</h4>
  179.                         <button type="button" class="close" data-dismiss="modal">×</button>
  180.                     </div>
  182.                     <!-- 模态框主体 -->
  183.                     <div class="modal-body">
  184.                         <form>
  185.                             <div class="input-group mb-3">
  186.                                 <div class="input-group-prepend">
  187.                                     <span class="input-group-text"><i class="fa fa-user"></i></span>
  188.                                 </div>
  189.                                 <input type="text" id="addUserName" class="form-control" placeholder="Username">
  190.                             </div>
  191.                             <div class="input-group mb-3">
  192.                                 <div class="input-group-prepend">
  193.                                     <span class="input-group-text"><i class="fa fa-lock"></i></span>
  194.                                 </div>
  195.                                 <input type="password" id="addUserPwd" class="form-control" placeholder="userpwd">
  196.                             </div>
  198.                         </form>
  199.                     </div>
  201.                     <!-- 模态框底部 -->
  202.                     <div class="modal-footer">
  203.                         <button type="button" class="btn btn-success" data-dismiss="modal"
  204.                             onclick=addUserInfo()>添加</button>
  205.                         <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
  206.                     </div>
  208.                 </div>
  209.             </div>
  210.         </div>
  211.     </div>
  213.     <script>
  214.         var icons = {
  215.             paginationSwitchDown: 'fa-caret-square-down',
  216.             paginationSwitchUp: 'fa-caret-square-up',
  217.             refresh: 'fa-refresh',
  218.             toggleOff: 'fa-toggle-off',
  219.             toggleOn: 'fa-toggle-on',
  220.             columns: 'fa-th-list',
  221.             fullscreen: 'fa-arrows-alt',
  222.             detailOpen: 'fa-plus',
  223.             detailClose: 'fa-minus'
  224.         };
  226.         //异步加载表格数据
  227.         $('#userInfoTab').bootstrapTable({
  228.             url: '../SelectAllServlet',         //请求后台的URL（*）
  229.             method: 'get',                      //请求方式（*）
  230.             toolbar: '#toolbar',                //工具按钮用哪个容器
  231.             striped: true,                      //是否显示行间隔色
  232.             cache: false,                       //是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）
  233.             pagination: true,                   //是否显示分页（*）
  234.             icons: icons,                       //重新定义图标 修复图标加载失败问题
  235.             queryParams: function (params) {
  236.                 var temp = {   //这里的键的名字和控制器的变量名必须一直，这边改动，控制器也需要改成一样的
  237.                     limit: params.limit,   //页面大小
  238.                     offset: params.offset  //页码
  239.                     //userName: $("#userName").val()
  240.                     //statu: $("#txt_search_statu").val()
  241.                 };
  242.                 return temp;
  243.             },
  244.             sidePagination: "server",           //分页方式：client客户端分页，server服务端分页（*）
  245.             pageNumber: 1,                       //初始化加载第一页，默认第一页
  246.             pageSize: 10,                       //每页的记录行数（*）
  247.             pageList: [10, 15, 20, 25],        //可供选择的每页的行数（*）
  248.             //search: true,                       //是否显示表格搜索，此搜索是客户端搜索，不会进服务端，所以，个人感觉意义不大
  249.             strictSearch: true,
  250.             showRefresh: true,                  //是否显示刷新按钮
  251.             clickToSelect: true,                //是否启用点击选中行
  252.             uniqueId: "userId",                     //每一行的唯一标识，一般为主键列
  253.             //showToggle:true,                    //是否显示详细视图和列表视图的切换按钮
  254.             //cardView: false,                    //是否显示详细视图
  255.             columns: [{
  256.                 checkbox: true
  257.             }, {
  258.                 field: 'userId',
  259.                 title: '用户Id'
  260.             }, {
  261.                 field: 'userName',
  262.                 title: '用户名'
  263.             }, {
  264.                 field: 'createTime',
  265.                 title: '创建时间'
  266.             }, {
  267.                 field: 'updateTime',
  268.                 title: '更新时间'
  269.             }, {
  270.                 field: 'userId',
  271.                 title: '编辑',
  272.                 formatter: function (value, row, index) {
  273.                     var e = '<a class="btn btn-waring" href="#" mce_href="#" title="编辑" onclick="edit(\''
  274.                         + row.userId
  275.                         + '\')"><i class="fa fa-edit"></i>编辑</a> ';
  276.                     return e;
  277.                 }
  278.             }]
  279.         });
  280.     </script>
  281. </body>
  283. </html>

index.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="utf-8">
  6.     <title></title>
  7.     <!-- 新 Bootstrap4 核心 CSS 文件 -->
  8.     <link rel="stylesheet" href="bootstrap4/css/bootstrap.min.css">
  9.     <link rel="stylesheet" type="text/css" href="font-awesome-4.7.0/css/font-awesome.min.css" />
  10.     <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  11.     <script src="jquery/jquery.min.js"></script>
  12.     <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  13.     <script src="js/popper.min.js"></script>
  14.     <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  15.     <script src="bootstrap4/js/bootstrap.min.js"></script>
  16.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  17.     <title>主页</title>
  18.     <style type="text/css">
  19.         body {
  20.             display: flex;
  21.             flex-direction: column;
  22.             min-height: 100vh;
  23.         }
  25.         header {
  26.             height: 80px;
  27.             background-color: #007FB0;
  28.             display: flex;
  29.             align-items: center;
  30.             padding-left: 40px;
  31.         }
  33.         #main {
  34.             flex-grow: 1;
  35.             display: flex;
  36.         }
  39.         #left {
  40.             background-color: #EEEEEE;
  41.             /*     border: 1px #004085 solid; */
  42.         }
  44.         #left {
  45.             width: 200px;
  46.             flex-shrink: 0;
  47.             display: flex;
  48.             flex-direction: column;
  49.         }
  51.         #left>p {
  52.             height: 40px;
  53.             padding: 0px;
  54.             margin: 0px;
  55.             display: flex;
  56.             justify-content: center;
  57.             align-items: center;
  58.             background-color: #F5F5F5;
  59.             border-bottom: 1px solid darkgrey;
  60.         }
  62.         #left>a {
  63.             height: 50px;
  64.             background-color: #EEEEEE;
  65.             border-bottom: 1px darkgrey solid;
  66.             border-right: 1px darkgrey solid;
  67.             display: flex;
  68.             justify-content: center;
  69.             align-items: center;
  70.             text-decoration: none;
  71.             color: #007FB0;
  72.         }
  74.         #left>a:hover {
  75.             background-color: white;
  76.         }
  78.         #left>a:nth-child(2) {
  79.             background-image: url(img/icon_01.png);
  80.             background-repeat: no-repeat;
  81.             background-position: 40px 18px;
  82.         }
  84.         #left>a:nth-child(3) {
  85.             background-image: url(img/icon_02.png);
  86.             background-repeat: no-repeat;
  87.             background-position: 40px 18px;
  88.         }
  90.         #left>a:nth-child(4) {
  91.             background-image: url(img/icon_03.png);
  92.             background-repeat: no-repeat;
  93.             background-position: 40px 18px;
  94.         }
  96.         #content {
  97.             flex-grow: 1;
  98.         }
  99.     </style>
  100. </head>
  102. <body>
  103.     <header>
  104.         <img src="img/tit.png" />
  105.     </header>
  106.     <div id="main">
  107.         <div id="left">
  108.             <p>当前用户：管理员“lwx”</p>
  109.             <a href="pages/user_manager.html" target="myFrame">账户管理</a>
  110.             <a href="pages/item_manager.html" target="myFrame">栏目管理</a>
  111.             <a href="pages/news_manager.html" target="myFrame">新闻管理</a>
  112.         </div>
  113.         <iframe id="content" frameborder="0" name="myFrame" src="pages/user_manager.html"></iframe>
  114.     </div>
  115. </body>
  117. </html>

login.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="utf-8">
  6.     <title></title>
  7.     <!-- 新 Bootstrap4 核心 CSS 文件 -->
  8.     <link rel="stylesheet" href="bootstrap4/css/bootstrap.min.css">
  9.     <link rel="stylesheet" type="text/css" href="font-awesome-4.7.0/css/font-awesome.min.css" />
  10.     <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  11.     <script src="jquery/jquery.min.js"></script>
  12.     <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  13.     <script src="js/popper.min.js"></script>
  14.     <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  15.     <script src="bootstrap4/js/bootstrap.min.js"></script>
  16.     <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  17.     <style type="text/css">
  18.         header,
  19.         footer {
  20.             height: 100px;
  21.             /* background-color: #005CBF; */
  22.         }
  24.         body {
  25.             display: flex;
  26.             flex-direction: column;
  27.             min-height: 100vh;
  28.         }
  30.         #main {
  31.             flex-grow: 1;
  32.             background-image: url(img/banner.jpg);
  33.             background-repeat: no-repeat;
  34.             background-size: cover;
  35.             display: flex;
  36.             align-items: center;
  37.             justify-content: flex-end;
  38.         }
  40.         #login {
  41.             height: 400px;
  42.             width: 400px;
  43.             background-color: white;
  44.             margin-right: 100px;
  45.             border-radius: 10px;
  46.         }
  47.     </style>
  48.     <title>login</title>
  49. </head>
  51. <body>
  52.     <header></header>
  53.     <div id="main">
  54.         <div id="login">
  55.             <form style="padding: 20px;" action="LoginServlet" method="post">
  56.                 <div class="input-group mb-3">
  57.                     <div class="input-group-prepend">
  58.                         <span class="input-group-text"><i class="fa fa-user"></i></span>
  59.                     </div>
  60.                     <input type="text" name="userName" class="form-control" placeholder="请输入用户名">
  61.                 </div>
  62.                 <div class="input-group mb-3">
  63.                     <div class="input-group-prepend">
  64.                         <span class="input-group-text"><i class="fa fa-lock"></i></span>
  65.                     </div>
  66.                     <input type="text" name="userPwd" class="form-control" placeholder="Username">
  67.                 </div>
  68.                 <button type="submit" class="btn btn-info form-control">登录</button>
  69.             </form>
  70.         </div>
  71.     </div>
  72.     <footer></footer>
  73. </body>
  75. </html>

loginFailure.html

  1. <!DOCTYPE html>
  2. <html>
  4. <head>
  5.     <meta charset="UTF-8">
  6.     <title>Insert title here</title>
  7. </head>
  9. <body>
  10.     登录失败，请重新<a href="login.html">登录</a>
  11. </body>
  13. </html>

phone.html

  1. <!DOCTYPE html>
  2. <html>
  3.     <head>
  4.         <meta charset="utf-8">
  5.         <title></title>
  6.         <!-- 新 Bootstrap4 核心 CSS 文件 -->
  7.         <link rel="stylesheet" href="bootstrap4/css/bootstrap.min.css">
  8.         <link rel="stylesheet" type="text/css" href="font-awesome-4.7.0/css/font-awesome.min.css" />
  9.         <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  10.         <script src="jquery/jquery.min.js"></script>
  11.         <!-- bootstrap.bundle.min.js 用于弹窗、提示、下拉菜单，包含了 popper.min.js -->
  12.         <script src="js/popper.min.js"></script>
  13.         <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  14.         <script src="bootstrap4/js/bootstrap.min.js"></script>
  15.         <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  16.         <title>主页</title>
  17.         <style type="text/css">
  18.             body {
  19.                 margin: 0px;
  20.             }
  21.             header {
  22.                 height: 54px;
  23.                 background-color: #F8F8F8;
  24.                 display: flex;
  25.                 justify-content: space-between;
  26.                 padding: 0px 10px;
  27.                 align-items: center; /*垂直居中*/
  28.             }
  29.             #back, #close-page {
  30.                 color: #FFC74F;
  31.             }
  32.             nav {
  33.                 height: 45px;
  34.                 border-bottom: 1px solid #FFC74F;
  35.                 display: flex;
  36.             }
  37.             nav>a {
  38.                 text-decoration: none;
  39.                 flex-grow: 1; /*flex-grow属性定义项目的放大比例，默认为0，即如果存在剩余空间，也不放大。*/
  40.                 border-right: 1px #FFC74F solid;
  41.                 background-color: antiquewhite;
  42.                 display: flex;
  43.                 justify-content: center;
  44.                 align-items: center;
  45.                 color: brown;
  46.             }
  47.             .col-7 {
  48.                 display: flex;
  49.                 flex-direction: column;
  50.                 justify-content: space-between;
  51.             }
  52.             .row {
  53.                 margin-bottom: 5px;
  54.                 background-color: rgb(250, 235, 215, 0.5);
  55.             }
  56.         </style>
  57.     </head>
  58.     <body>
  59.         <header>
  60.             <span id="back"><i class="fa fa-chevron-left"></i> 返回</span>
  61.             <span>校内新闻</span>
  62.             <span id="close-page"><a href="login.html">登录</a></span>
  63.         </header>
  64.         <nav>
  65.             <a href="#">教务处</a>
  66.             <a href="#">委员会</a>
  67.             <a href="#">管理会</a>
  68.         </nav>
  69.         <div class="container-fluid">
  70.             <div class="row">
  71.                 <div class="col-5">
  72.                     <img src="img/1.jpg" class="img-fluid" />
  73.                 </div>
  74.                 <div class="col-7">
  75.                     <h5>我是一条莫得感情的信息。</h5>
  76.                     <span>2020-11-19 09:15</span>
  77.                 </div>
  78.             </div>
  79.             <div class="row">
  80.                 <div class="col-5">
  81.                     <img src="img/2.jpg" class="img-fluid" />
  82.                 </div>
  83.                 <div class="col-7">
  84.                     <h5>新闻手机登录端展示。</h5>
  85.                     <span>2020-11-19 09:15</span>
  86.                 </div>
  87.             </div>
  88.             <div class="row">
  89.                 <div class="col-5">
  90.                     <img src="img/3.jpg" class="img-fluid" />
  91.                 </div>
  92.                 <div class="col-7">
  93.                     <h5>冲呀~</h5>
  94.                     <span>2020-11-19 09:15</span>
  95.                 </div>
  96.             </div>
  97.             <div class="row">
  98.                 <div class="col-5">
  99.                     <img src="img/dragon.gif" class="img-fluid" />
  100.                 </div>
  101.                 <div class="col-7">
  102.                     <h5>奥里给~</h5>
  103.                     <span>2020-11-19 09:15</span>
  104.                 </div>
  105.             </div>
  106.             <div class="row">
  107.                 <div class="col-5">
  108.                     <img src="img/1.jpg" class="img-fluid" />
  109.                 </div>
  110.                 <div class="col-7">
  111.                     <h5>我是一条莫得感情的信息。</h5>
  112.                     <span>2020-11-19 09:15</span>
  113.                 </div>
  114.             </div>
  115.             <div class="row">
  116.                 <div class="col-5">
  117.                     <img src="img/2.jpg" class="img-fluid" />
  118.                 </div>
  119.                 <div class="col-7">
  120.                     <h5>新闻手机登录端展示。</h5>
  121.                     <span>2020-11-19 09:15</span>
  122.                 </div>
  123.             </div>
  124.             <div class="row">
  125.                 <div class="col-5">
  126.                     <img src="img/3.jpg" class="img-fluid" />
  127.                 </div>
  128.                 <div class="col-7">
  129.                     <h5>冲呀~</h5>
  130.                     <span>2020-11-19 09:15</span>
  131.                 </div>
  132.             </div>
  133.             <div class="row">
  134.                 <div class="col-5">
  135.                     <img src="img/dragon.gif" class="img-fluid" />
  136.                 </div>
  137.                 <div class="col-7">
  138.                     <h5>奥里给~</h5>
  139.                     <span>2020-11-19 09:15</span>
  140.                 </div>
  141.             </div>
  142.             <div class="row">
  143.                 <div class="col-5">
  144.                     <img src="img/dog.jpg" class="img-fluid" />
  145.                 </div>
  146.                 <div class="col-7">
  147.                     <h5>加油~</h5>
  148.                     <span>2020-11-19 09:15</span>
  149.                 </div>
  150.             </div>
  151.         </div>
  152.     </body>
  153. </html>

2021年1月30日 下午 附上代码。

发表评论

表情：
评论列表 （有 0 条评论，153人围观）

还没有评论，来说两句吧...

相关阅读