栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

基于SSM实现简单企业/公司门户网站制作

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

基于SSM实现简单企业/公司门户网站制作

截图:

目录

1.项目结构

2.配置文件

 2.1 spring配置文件(applicationContent.xml)

 2.2 sqlConfig.xml(mybatis配置文件)

 2.3 log4j.properties

 2.4 springmvc.xml (springmvc的配置文件)

 2.5 jdbc.properties

 2.6 web.xml

3.后端代码

 3.1 实体类

 3.2:创建DAO接口【在mybatis中 mapper就相当于dao]

 3.3 实现dao接口【mybatis中就是UserMapper.xml文件】

 3.4  建立service以及service实现【UserService.java】

 3.5  service实现类 【UserServiceImpl.java】

 3.6 建立controller

 3.6.1 UserController.java

 3.6.2  LoginController.java


简单制作的demo,初衷是搭建一个:可以通过后台数据配置,形成页面内容可定制的企业门户网站,现在还在开发中,下面是详细步骤,会加入一些提示和自己在敲码时学习到的知识和一些遇到的问题。

使用到的"工具":IDEA旗舰版,MySQL8.0,JDK11,apache-maven-3.8.6,apache-tomcat-8.5.81,Dbeaver

ps:建议用IDEA旗舰版(可免费试用30天或者破解),社区版配置tomcat很麻烦会导致配置失败~

1.项目结构

 一张图显示不下放了两张,用的是idea,eclipse基本上差不多

 ps:两个工具最大的区别就是,idea的project=eclipse的workspace,其他对应关系如下:

pom.xml



    4.0.0

    org.example
    untitled1
    1.0-SNAPSHOT
    war

    
        11
        11
    

    
        
        
            org.springframework
            spring-webmvc
            4.3.7.RELEASE
        

        
        
            org.springframework
            spring-jdbc
            4.3.7.RELEASE
        

        
        
            org.springframework
            spring-aspects
            4.3.7.RELEASE
        

        
        
            org.mybatis
            mybatis
            3.4.2
        

        
        
            org.mybatis
            mybatis-spring
            1.3.1
        
        
        
            c3p0
            c3p0
            0.9.1.2
        

        
            mysql
            mysql-connector-java
            8.0.29
        

        
        
            javax.servlet
            jstl
            1.2
        
        
            javax.servlet
            javax.servlet-api
            3.1.0
            provided
        
        
            junit
            junit
            4.12
            test
        

        
        
            org.springframework
            spring-test
            4.3.7.RELEASE
            test
        

        
        
        
            com.github.pagehelper
            pagehelper
            4.1.5
        
    

    
        
            
                src/main/java
                
                    ***.xml
                
                false
            
            
                src/main/resources
                
                    ***.xml
                
                false
            
        
    


 根据pom.xml中的dependency导入后的jar包:

2.配置文件

 2.1 spring配置文件(applicationContent.xml)



    
    
    

    
    
    
        
        
        
        
    

    
    
    
        
        
        
    

    
    
        
        
        
    

    
    
        
    

    
    
        
        
    

    
    
        
            
            
            
            
        
    

 2.2 sqlConfig.xml(mybatis配置文件)

        


    
    
        
    

    
    
        
    

 2.3 log4j.properties
### set log levels ###
log4j.rootLogger = INFO , console , debug , error  

### console ###
log4j.appender.console = org.apache.log4j.ConsoleAppender  
log4j.appender.console.Target = System.out  
log4j.appender.console.layout = org.apache.log4j.PatternLayout  
log4j.appender.console.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [%p]-[%c] %m%n  

### log file ###
log4j.appender.debug = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.debug.File = ../logs/springmvc-demo.log  
log4j.appender.debug.Append = true  
log4j.appender.debug.Threshold = INFO  
log4j.appender.debug.layout = org.apache.log4j.PatternLayout  
log4j.appender.debug.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [%p]-[%c] %m%n  

### exception ###
log4j.appender.error = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.error.File = ../logs/springmvc-demo_error.log  
log4j.appender.error.Append = true  
log4j.appender.error.Threshold = ERROR  
log4j.appender.error.layout = org.apache.log4j.PatternLayout  
log4j.appender.error.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [%p]-[%c] %m%n  


###u9700u8981u58F0u660EuFF0Cu7136u540Eu4E0Bu65B9u624Du53EFu4EE5u4F7Fdruid sqlu8F93u51FAuFF0Cu5426u5219u4F1Au629Bu51FAlog4j.error.key not found
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{ISO8601} %l %c%n%p: %m%n  

### druid sql ###
log4j.logger.druid.sql=warn,stdout  
log4j.logger.druid.sql.DataSource=warn,stdout  
log4j.logger.druid.sql.Connection=warn,stdout  
log4j.logger.druid.sql.Statement=warn,stdout  
log4j.logger.druid.sql.ResultSet=warn,stdout  

 2.4 springmvc.xml (springmvc的配置文件)


    
    

    
    
        
        
    

    
    
    
    

 2.5 jdbc.properties
jdbc.url = jdbc:mysql://localhost:3306/mtcs?useSSL=false
jdbc.driver = com.mysql.cj.jdbc.Driver
jdbc.username= root
jdbc.password= root

 ps:

1.一开始jdbc.driver写的是com.mysql.jdbc.Driver(没有添加cj),项目能运行,但是到了数据库操作层的时候报错了,原因是我用的是mysql8.0,需要加上cj;如果是mysql5版本,可不用添加cj。

2.mysql5.7之后的版本必须要加上useSSL=false,因为MySQL在高版本需要指明是否进行SSL连接,mysql5.7以及之前的版本则不用进行添加useSSL=false,会默认为false,一般情况下都是使用useSSL=false,尤其是在将项目部署到linux上时,一定要使用useSSL=false!!!,useSSL=true是进行安全验证,一般通过证书或者令牌什么的,useSSL=false就是通过账号密码进行连接

2.6 web.xml



    

    untitled1
    
        index.jsp
    

    
    
        contextConfigLocation
        classpath:applicationContext.xml
    
    
        org.springframework.web.context.ContextLoaderListener
    

    
    
        dispatcherServlet
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:springmvc.xml
        
        1
    
    
    
        dispatcherServlet
        /
    
    
        default
        *.jpg
    
    
        default
        *.png
    
    
        default
        *.ico
    
    
        default
        *.gif
    
    
        default
        *.js
    
    
        default
        *.css
    


    
    
        CharacterEncodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            utf-8
        
    
    
        CharacterEncodingFilter
        
public class User {

    //主键
    private int id;
    //用户名
    private String username;
    //年龄
    private String age;
    //登录账号
    private  String account;
    //登录密码
    private String pass;

    public User() {
        super();
    }

    public User(int id, String username, String age, String account, String pass) {
        super();
        this.id = id;
        this.username = username;
        this.age = age;
        this.account = account;
        this.pass = pass;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    public String getAccount() {
        return account;
    }

    public void setAccount(String account) {
        this.account = account;
    }

    public String getPass() {
        return pass;
    }

    public void setPass(String pass) {
        this.pass = pass;
    }

}

 3.2:创建DAO接口【在mybatis中 mapper就相当于dao]
package com.ssm.mapper;

import java.util.List;

import com.ssm.model.User;
import org.apache.ibatis.annotations.Param;


public interface UserMapper {

    void saveUser(User user);

    boolean updateUser(User user);

    boolean deleteUser(int id);

    User findUserById(int id);

    User findUserByAccountAndPass(@Param("account")String account, @Param("pass")String pass);

    List findAll();
}

 3.3 实现dao接口【mybatis中就是UserMapper.xml文件】

        
        


    
    
        insert into t_user(user_name,user_age) values (#{username},#{age})
    

    
    
        update t_user set user_name=#{username},user_age=#{age} where user_id=#{id}
    

    
    
        delete from t_user where user_id=#{id}
    

    
    
        select user_id id,user_name username,user_age age from t_user where user_account=#{account} and user_pass=#{pass}
    

    
    

 3.4 建立service以及service实现【UserService.java】
package com.ssm.service;

import java.util.List;

import com.ssm.model.User;

public interface UserService {

    void saveUser(User user);

    boolean updateUser(User user);

    boolean deleteUser(int id);

    User findUserById(int id);

    User findUserByAccountAndPass(String account,String pass);

    List findAll();
}

 3.5 service实现类 【UserServiceImpl.java】
package com.ssm.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.ssm.mapper.UserMapper;
import com.ssm.model.User;
import com.ssm.service.UserService;
@Service

public class UserServiceImpl implements UserService {

    
    @Autowired
    private UserMapper userMapper;

    
    @Override
    public void saveUser(User user) {
        userMapper.saveUser(user);
    }

    
    @Override
    public boolean updateUser(User user) {
        return userMapper.updateUser(user);
    }

    
    @Override
    public boolean deleteUser(int id) {
        return userMapper.deleteUser(id);
    }

    
    @Override
    public User findUserById(int id) {
        User user = userMapper.findUserById(id);
        return user;
    }

    
    @Override
    public User findUserByAccountAndPass(String account,String pass) {
        User user = userMapper.findUserByAccountAndPass(account,pass);
        return user;
    }

    
    @Override
    public List findAll() {
        List allUser = userMapper.findAll();
        return allUser;
    }

}

 3.6 建立controller

 3.6.1 UserController.java
package com.ssm.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.ssm.model.User;
import com.ssm.service.UserService;

@Controller
@RequestMapping("/user")

public class UserController {

    @Autowired
    private UserService userService;

    
    @RequestMapping("toAddUser")
    public String toAddUser(){
        return "addUser";
    }

    
    @RequestMapping("addUser")
    public String addUser(Model model,User user){
        if(user != null){
            userService.saveUser(user);
        }
        return "redirect:/user/userInfo";
    }

    
    @RequestMapping("updateUser")
    public String UpdateUser(Model model,User user){
        if(userService.updateUser(user)){
            user = userService.findUserById(user.getId());
            model.addAttribute("user", user);
            return "redirect:/user/userInfo";
        }
        return "/error";
    }

    
    @RequestMapping("getAllUser")
    public String getAllUser(Model model){
        List user = userService.findAll();
        model.addAttribute("userList",user);
        return "allUser";
    }

    
    @RequestMapping("/getUser")
    public String getUser(int id,Model model){
        model.addAttribute("user", userService.findUserById(id));
        return "editUser";
    }
    
    @RequestMapping("/delUser")
    public String deleteUser(int id,Model model){
        model.addAttribute("user", userService.deleteUser(id));
        return "redirect:/user/userInfo";
    }

    
    @RequestMapping("userInfo")
    public String getUsers(@RequestParam(value="pn",defaultValue="1")Integer pn,Model model){
        //从第一条开始 每页查询五条数据
        PageHelper.startPage(pn, 5);
        List users = userService.findAll();
        //将用户信息放入PageInfo对象里
        PageInfo page = new PageInfo(users,5);
        model.addAttribute("pageInfo", page);
        return "allUser";
    }
}

 3.6.2  LoginController.java

  登录接口目前写的比较简单,之后再完善,大家可自己发挥一下

package com.ssm.controller;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.ssm.model.User;
import com.ssm.service.LoginService;
import com.ssm.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

@Controller
@RequestMapping("/login")

public class LoginController {

    @Autowired
    private UserService userService;
    private LoginService loginService;

    
    @RequestMapping("toLogin")
    public String toLogin(){
        return "login";
    }


    @RequestMapping("login")
    public String UpdateUser(Model model,User user){
        user = userService.findUserByAccountAndPass(user.getAccount(),user.getPass());
        if (user!=null){
            return "manage";
        }else{
            return "ERROR";
        }
    }



}

到这里后端代码已经差不多好了,自行参照修改吧~

前端代码过一会更新,休息一下~

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/1024217.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号