ssm项目-简单的健康信息管理系统01

今早8点进图书馆耗时3小时将我的实战练手项目：健康信息管理系统的后端搭建完毕，虽然还有空的API和功能没有补全，但是毕竟时间短，盲敲代码，我甚至发现我的记忆力惊人的好！

至于软件工程的项目文档那一套我们就不写了，因为这个小项目只是我自己检测自己对ssm框架理解与运用能力的一个测试而已啦。xdm，目前前端还没有写，计划后面两天补上，因为最近指定的计划是boot的yaml文件的学习与js的学习，有点赶时间的说。

项目实体与数据库表

出于对小型测试项目的考虑，我计划一个用户实体，一个用户的健康信息实体。模拟我们学校钉钉健康日报提交的方式。

User.java

public class User {
    private int id;
    private String name;
    private String sex;
    private String address;
    private String phone;
    private String emil;
//出于水文考虑，把set与get方法省略
}

Safe.java

public class Safe {
       private int id;
       private String wd;
       private String jkm;
       private String xck;
       private String address;
//这里也省略了set与get方法
}

数据库创建表格的语句代码

create schema ssmdemo;
use ssmdemo;
create table  ssmdemo_user(
    id int,
    name varchar(40),
    sex varchar(10),
    address varchar(50),
    phone varchar(100),
    emil varchar(100),
    primary key (id)
);
create table ssmdemo_safe(
    id int,
    wd varchar(20),温度
    jkm varchar(10),健康码状态
    xck varchar(10),行程卡状态
    address varchar(100),
    primary key(id)
);
create table ssmdemo_u_s(
    uid int,
    sid int
);
alter table ssmdemo_u_s add foreign key (uid) references  ssmdemo_user(id);
alter table ssmdemo_u_s add foreign key (sid) references ssmdemo_safe(id);

insert into ssmdemo_user values (1,'由比滨结衣','女','东京','123356','123356@qw');
insert into ssmdemo_safe values (1,'36.5','绿色','绿色','东京');
insert into ssmdemo_u_s values (1,1);

项目使用框架spring、springmvc、mybatis、web的核心配置文件

appliCationcontext.xml

springmvc.xml

?xml version="1.0" encoding="UTF-8"?>

config.xml

web.xml





  
    contextConfigLocation
    classpath:/spring/applicationContext.xml
  

  
    org.springframework.web.context.ContextLoaderListener
  

  
    DispatcherServlet
    org.springframework.web.servlet.DispatcherServlet
    
      contextConfigLocation
      classpath:/spring/springmvc.xml
    
    1
  
  
    DispatcherServlet
    /
  

  
    char encoding filter
    org.springframework.web.filter.CharacterEncodingFilter
    
      encoding
      UTF-8
    
  
  
    char encoding filter
    /*

项目业务逻辑代码部分

持久层接口与对应mapper映射文件

userDao

import java.util.List;

public interface UserDao {
    List userList();
    void delete(int id);
    void insert(User user);
    List queryByName(String name);
}

UserMapper.xml




    
        select * from ssmdemo.ssmdemo_user where name=#{name}
    
    
        insert into ssmdemo.ssmdemo_user values (#{id},#{name},#{sex},#{address},#{phone},#{emil})
    
    
        delete from ssmdemo.ssmdemo_user where id=#{id}

safeDao

import java.util.List;

public interface SafeDao {
    List safeList();
    List query(int id);
    void insert(Safe safe);
    void delete(int id);
}

SafeMapper.xml




    
        select * from ssmdemo.ssmdemo_safe where id=#{id}
    
    
        insert into ssmdemo.ssmdemo_safe values (#{id},#{wd},#{jkm},#{xck},#{address})
    
    
        delete from ssmdemo.ssmdemo_safe where id=#{id}

业务层接口与它的实现

userService

import java.util.List;

public interface UserService {
    List userList();
    void delete(int id);
    void insert(User user);
    List queryByName(String name);
}

userServieImpl

import java.util.List;
@Service("User")
public class UserServiceImpl implements UserService{

    @Autowired
    private UserDao userDao;

    @Override
    public List userList() {
        return userDao.userList();
    }

    @Override
    public void delete(int id) {
        userDao.delete(id);
    }

    @Override
    public void insert(User user) {
        userDao.insert(user);
    }

    @Override
    public List queryByName(String name) {
        return userDao.queryByName(name);
    }
}

safeService

import java.util.List;

public interface SafeService {
    List safeList();
    List query(int id);
    void insert(Safe safe);
    void delete(int id);
}

safeServiceImpl

import java.util.List;
@Service("Safe")
public class SafeServiceImpl implements SafeService{

    @Autowired
    private SafeDao safeDao;

    @Override
    public List safeList() {
        return safeDao.safeList();
    }

    @Override
    public List query(int id) {
        return safeDao.query(id);
    }

    @Override
    public void insert(Safe safe) {
        safeDao.insert(safe);
    }

    @Override
    public void delete(int id) {
        safeDao.delete(id);
    }
}

控制层代码（safeController代码与其相似，就是改方法名）

userController.java

@Controller
@RequestMapping("/User")
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("/List")
    public ModelAndView userList(){
        ModelAndView modelAndView = new ModelAndView();
        List userList = userService.userList();
        modelAndView.setViewName("UserList");
        modelAndView.addObject("userList",userList);
        return modelAndView;
    }

    @RequestMapping("/delete")
    public void delete(int id){
       userService.delete(id);
    }
    
//    注意这个视图逻辑：先由主页进入页面addUser.jsp页面中，再将里面的from表单提交的数据设置方法为我们这个/User/insert将数据流进
//    整理之后传进数据表，再将数据表中更新后的数据展示出来。
    @RequestMapping("/insert")
    public ModelAndView insert(User user){
        ModelAndView modelAndView = new ModelAndView();
        userService.insert(user);
        List userList = userService.userList();
        modelAndView.addObject("userList",userList);
        modelAndView.setViewName("UserList");
        return modelAndView;
    }

    @RequestMapping("/query")
    public ModelAndView query(String name){
        ModelAndView modelAndView = new ModelAndView();
        List userList = userService.queryByName(name);
        modelAndView.addObject("userList",userList);
        modelAndView.setViewName("queryUser");
        return modelAndView;
    }
}

项目资源文件、日志配置、pom文件坐标注入

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=root
jdbc.password=123456

log4j.properties

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=info, stdout

pom


    
      junit
      junit
      4.11
      test
    

    
      org.springframework
      spring-context
      5.3.16
    
    
      org.springframework
      spring-webmvc
      5.3.16
    
    
      org.springframework
      spring-jdbc
      5.2.5.RELEASE
    
    
      org.springframework
      spring-tx
      5.2.5.RELEASE
    
    
      org.springframework
      spring-test
      5.0.5.RELEASE
    
    
      org.springframework
      spring-web
      5.3.16
    
    
      org.aspectj
      aspectjweaver
      1.9.5
    
    
    
      javax.servlet
      javax.servlet-api
      4.0.1
    
    
      javax.servlet.jsp
      jsp-api
      2.2
    
    
    
      mysql
      mysql-connector-java
      8.0.28
    
    
      org.mybatis
      mybatis
      3.5.7
    
    
      org.mybatis
      mybatis-spring
      2.0.2
    
    
      com.mchange
      c3p0
      0.9.5.2
    
    
      jstl
      jstl
      1.2
    
    
      log4j
      log4j
      1.2.17

前端页面明天再写。

ssm项目-简单的健康信息管理系统01

Java相关栏目本月热门文章