SSH机试顺丰搬家预约信息查询参考

java代码结构图，controller层，dao层，service层，pojo层

配置文件图

web图

创建数据库


SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for move_booking
-- ----------------------------
DROp TABLE IF EXISTS `move_booking`;
CREATE TABLE `move_booking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `area` varchar(50) DEFAULT NULL,
  `cartype` varchar(20) DEFAULT NULL,
  `movedate` datetime DEFAULT NULL,
  `contact` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `status` varchar(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of move_booking
-- ----------------------------
INSERT INTO `move_booking` VALUES ('1', '朝阳区', '1042火车', '2011-03-27 00:00:00', '李四', '12312312315', '1');
INSERT INTO `move_booking` VALUES ('2', '朝阳区', '1043货车', '2011-03-28 00:00:00', '王麻子', '13131231231', '0');
INSERT INTO `move_booking` VALUES ('3', '海淀区', '皮卡', '2021-01-01 00:00:00', '张三', '12312312317', '0');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', '1234', '123456');
INSERT INTO `users` VALUES ('2', '1235', '123456');
INSERT INTO `users` VALUES ('3', '1236', '123456');

首先web-inf下创建lib文件导入全部的jar包

云盘链接：https://pan.baidu.com/s/1_MSPk7Y-B-yKy0Q_hawLgw

提取码：xiik

先启动tomcat测试一下能否正常启动

配置web-inf=>web.xml



    
    
        org.springframework.web.context.ContextLoaderListener
    

    
    
        contextConfigLocation
        classpath:applicationContext.xml
    

    
        struts2
        org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
    

    
        struts2
        
        vertical-align:middle
      }
    

  
  
  顺丰搬家预约信息查询
  ————顺风搬家
  添加
  
    

        
      
        起始地区
        所用车型
        搬家日期
        联系人
        联系电话
        状态
        操作
      
      
          ${u.getArea()}
          ${u.getCartype()}
          ${u.getMovedate()}
          ${u.getContact()}
          ${u.getPhone()}
          
            
              未处理
            
            
              已派车
            
            
              已结束
            
          
          修改  详情

起始地区	所用车型	搬家日期	联系人	联系电话	状态	操作
${u.getArea()}	${u.getCartype()}	${u.getMovedate()}	${u.getContact()}	${u.getPhone()}	未处理已派车已结束	修改详情

web-inf=> login.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    
    登陆页面
    
    
    



    
        用户名：
        
    
    
        密码：

这里需要设置一下tomcat，启动时进入login.jsp页面

wen-inf=>add.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


  
  
  



  
    
      
        顺丰搬家预约登记
      
    
    
      
      
        ————顺丰搬家，一路顺风
      
    
    
      
        起始地区： 
        
      
    
    
      
        所用车型： 金杯
        皮卡
        厢式货车
        1041货车
      
    
    搬家日期： 日期格式如：2010-06-10
    
     联系人： 
    
    联系电话：

wen-inf=>update.jsp

<%--
  Created by IntelliJ IDEA.
  User: 小米2020
  Date: 2021/10/19
  Time: 23:43
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title
    


    
        顺丰搬家预约信息查询
        ————顺风搬家
        
        起始地区:${sessionScope.moveBooking.getArea()}
        所用车型:${sessionScope.moveBooking.getCartype()}
        搬家日期:${sessionScope.moveBooking.getMovedate()}
        联系人:${sessionScope.moveBooking.getContact()}
        联系电话:${sessionScope.moveBooking.getPhone()}
        状态:

wen-inf=>xianqing.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title
    


    顺丰搬家预约信息查询
    ————顺风搬家
    起始地区:${sessionScope.moveBooking.getArea()}
    所用车型:${sessionScope.moveBooking.getCartype()}
    搬家日期:${sessionScope.moveBooking.getMovedate()}
    联系人:${sessionScope.moveBooking.getContact()}
    联系电话:${sessionScope.moveBooking.getPhone()}
    状态:
        
            未处理
        
        
            已派车
        
        
            已结束
        
    
    返回

配置图，看着不迷路

applicationContext.xml

struts.xml




    
    

    

        
            /index.jsp
            /login.jsp
        

        
            /xianqing.jsp
        

        
            list
        

        
            /index.jsp
        

        
            /update.jsp
        

        
            list

hibernate.cfg.xml






    
        
        com.mysql.jdbc.Driver
        jdbc:mysql://localhost:3306/s?serverTimezone=UTC&characterEncoding=utf-8
        root
        
        
        org.hibernate.dialect.SQLServer2008Dialect

        
        5

        
        true

        
        true

        
        update

move_booking.hbm.xml

users.hbm.xml

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

建议写一步测一步，这样写的能能最大程度提高敲代码效率，减少bug的出错率，把出的bug控制在可以解决的范围内

java代码

com.tang.pojo.Users.java

package com.tang.pojo;

public class Users {

    private Integer id;

    private String name;

    private String password;

   //省略get，set，toString()方法
}

com.tang.pojo.MoveBooking.java

package com.tang.pojo;

import java.util.Date;

public class MoveBooking {

    private Integer id;

    private String area;

    private String cartype;

    private String movedate;

    private String contact;

    private String phone;

    private String status;

   //省略get，set，toString()方法
}

com.tang.dao.UsersDao.java

package com.tang.dao;

import com.tang.pojo.Users;

public interface UsersDao {

    Users users(String name, String password);

}

com.tang.dao.UsersDaoImpl.java

package com.tang.dao.impl;

import com.tang.dao.UsersDao;
import com.tang.pojo.Users;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.classic.Session;

import java.util.List;

public class UsersDaoImpl implements UsersDao {

    private SessionFactory sessionFactory;

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }

    @Override
    public Users users(String name, String password) {
        System.out.println("UsersDaoImpl=>users()");
        Session session = sessionFactory.openSession();
        String hql="FROM Users WHERe name = :name AND password = :password";
        List list = session.createQuery(hql).setString("name", name).setString("password", password).list();
        if(list.size()!=0){
            Users users= (Users) list.get(0);
            System.out.println(users);
            return users;
        }
        return null;
    }
}

com.tang.dao.MoveBookingDao .java

package com.tang.dao;

import com.tang.pojo.MoveBooking;

import java.util.List;

public interface MoveBookingDao {

    List lists();

    MoveBooking moveBooking(Integer id);

    void addMoveBooking(MoveBooking moveBooking);

    void update(MoveBooking moveBooking);
}

com.tang.dao.MoveBookingDaoImpl .java

package com.tang.dao.impl;

import com.tang.dao.MoveBookingDao;
import com.tang.pojo.MoveBooking;
import com.tang.pojo.Users;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.classic.Session;

import java.util.List;

public class MoveBookingDaoImpl implements MoveBookingDao {

    private SessionFactory sessionFactory;

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }

    @Override
    public List lists() {
        List lists=null;
        System.out.println("MoveBookingDaoImpl=>lists()");
        Session session = sessionFactory.openSession();
        try {
            Transaction tx = session.beginTransaction();
            Query query = session.createQuery("from MoveBooking");
            lists = query.list();
            tx.commit();
            return lists;
        } catch (Exception e) {
            System.out.println(e);
        }
        return null;
    }

    @Override
    public MoveBooking moveBooking(Integer id) {
        System.out.println("MoveBookingDaoImpl=>moveBooking()");
        Session session = sessionFactory.openSession();
        MoveBooking m = (MoveBooking) session.get(MoveBooking.class, id);
        return m;
    }

    @Override
    public void addMoveBooking(MoveBooking moveBooking) {
        System.out.println("MoveBookingDaoImpl=>addMoveBooking()");
        Session session = sessionFactory.openSession();
        Transaction ts = session.beginTransaction();
        try {
            session.save(moveBooking);
            ts.commit();
        } catch (Exception e) {
            e.printStackTrace();
            ts.rollback();
            System.out.println(e);
        }
    }

    @Override
    public void update(MoveBooking moveBooking) {
        System.out.println("MoveBookingDaoImpl=>updateMoveBooking()");
        Session session = sessionFactory.openSession();
        Transaction ts = session.beginTransaction();
        try {
            session.update(moveBooking);
            ts.commit();
        } catch (Exception e) {
            e.printStackTrace();
            ts.rollback();
            System.out.println(e);
        }
    }
}

com.tang.service.UsersService.java

package com.tang.service;

import com.tang.pojo.Users;

public interface UsersService {

    Users users(Users users);

}

com.tang.service.UsersServiceImpl .java

package com.tang.service.impl;

import com.tang.dao.UsersDao;
import com.tang.dao.impl.UsersDaoImpl;
import com.tang.pojo.Users;
import com.tang.service.UsersService;

public class UsersServiceImpl implements UsersService {

    private UsersDao usersDao;


    public void setUsersDao(UsersDao usersDao) {
        this.usersDao = usersDao;
    }

    @Override
    public Users users(Users users) {
        return usersDao.users(users.getName(),users.getPassword());
    }
}

com.tang.service.MoveBookingService .java

package com.tang.service;

import com.tang.dao.MoveBookingDao;
import com.tang.pojo.MoveBooking;

import java.util.List;

public interface MoveBookingService {

    List lists();

    MoveBooking moveBooking(Integer id);

    void addMoveBooking(MoveBooking moveBooking);

    void update(MoveBooking moveBooking);

}

com.tang.service.MoveBookingServiceImpl .java

package com.tang.service.impl;

import com.tang.dao.MoveBookingDao;
import com.tang.pojo.MoveBooking;
import com.tang.service.MoveBookingService;

import java.util.List;

public class MoveBookingServiceImpl implements MoveBookingService {

    private MoveBookingDao moveBookingDao;

    public void setMoveBookingDao(MoveBookingDao moveBookingDao) {
        this.moveBookingDao = moveBookingDao;
    }

    @Override
    public List lists() {
        return moveBookingDao.lists();
    }

    @Override
    public MoveBooking moveBooking(Integer id) {
        return moveBookingDao.moveBooking(id);
    }

    @Override
    public void addMoveBooking(MoveBooking moveBooking) {
        moveBookingDao.addMoveBooking(moveBooking);
    }

    @Override
    public void update(MoveBooking moveBooking) {
        moveBookingDao.update(moveBooking);
    }
}

com.tang.controller.UsersController .java

package com.tang.controller;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import com.tang.dao.MoveBookingDao;
import com.tang.pojo.Users;
import com.tang.service.MoveBookingService;
import com.tang.service.UsersService;

import java.util.List;
import java.util.Map;

public class UsersController extends ActionSupport implements ModelDriven {

    private UsersService usersService;

    private MoveBookingService moveBookingService;

    public void setMoveBookingService(MoveBookingService moveBookingService) {
        this.moveBookingService = moveBookingService;
    }

    public void setUsersService(UsersService usersService) {
        this.usersService = usersService;
    }

    private Users users=new Users();

    @Override
    public Users getModel() {
        return users;
    }

    
    public String login(){
        Users users = usersService.users(this.users);
        ActionContext context=ActionContext.getContext();
        Map session = context.getSession();
        if(users!=null){
            List lists = moveBookingService.lists();
            session.put("lists",lists);
            return "none";
        }
        return ERROR;
    }
}

com.tang.controller.MbControoler.java

package com.tang.controller;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import com.opensymphony.xwork2.interceptor.AbstractInterceptor;
import com.tang.dao.MoveBookingDao;
import com.tang.pojo.MoveBooking;
import com.tang.pojo.Users;
import com.tang.service.MoveBookingService;

import java.util.List;
import java.util.Map;


public class MbControoler extends ActionSupport implements ModelDriven {


    private MoveBooking moveBooking=new MoveBooking();

    @Override
    public MoveBooking getModel() {
        return moveBooking;
    }

    private static final long serialVersionUID = 1L;

    private MoveBookingService moveBookingService;

    public void setMoveBookingService(MoveBookingService moveBookingService) {
        this.moveBookingService = moveBookingService;
    }


    
    public String moveBooking(){
        ActionContext context=ActionContext.getContext();
        Map session = context.getSession();
        MoveBooking moveBooking = moveBookingService.moveBooking(this.moveBooking.getId());
        session.put("moveBooking",moveBooking);
        return NONE;
    }

    
    public String add(){
        moveBookingService.addMoveBooking(moveBooking);
        return NONE;
    }

    
    public  String list(){
        List lists = moveBookingService.lists();
        ActionContext context=ActionContext.getContext();
        Map session = context.getSession();
        session.put("lists",lists);
        return NONE;
    }

    
    public String toUpdate(){
        ActionContext context=ActionContext.getContext();
        Map session = context.getSession();
        MoveBooking moveBooking1 = moveBookingService.moveBooking(moveBooking.getId());
        session.put("moveBooking",moveBooking1);
        return NONE;
    }

    
    public String update(){
        moveBookingService.update(moveBooking);
        return NONE;
    }

    
    public String xianqing(){
        ActionContext context=ActionContext.getContext();
        Map session = context.getSession();
        MoveBooking moveBooking1 = moveBookingService.moveBooking(moveBooking.getId());
        session.put("moveBooking",moveBooking1);
        return NONE;
    }
}

再次建议，写一步测一步，只供参考！！！

顺丰搬家预约登记
	————顺丰搬家，一路顺风
起始地区：
所用车型：	金杯皮卡厢式货车 1041货车
搬家日期：	日期格式如：2010-06-10
联系人：
联系电话：

SSH机试顺丰搬家预约信息查询参考

————顺风搬家 添加 起始地区 所用车型 搬家日期 联系人 联系电话 状态 操作 ${u.getArea()} ${u.getCartype()} ${u.getMovedate()} ${u.getContact()} ${u.getPhone()} 未处理 已派车 已结束 修改 详情

Java相关栏目本月热门文章

————顺风搬家添加

起始地区所用车型搬家日期联系人联系电话状态操作

${u.getArea()} ${u.getCartype()} ${u.getMovedate()} ${u.getContact()} ${u.getPhone()} 未处理已派车已结束修改详情