本次整个基于jar进行，各个版本：

Spring4.3.8

SpringMVC4.3.8

MyBatis3.4.2

Tomcat8.0

1、jar包引用

 

2、配置文件

主要用到数据库配置：

jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/db_ssm?characterEncoding=utf-8jdbc.username=lxjdbc.password=lxjdbc.maxsize=100jdbc.minsize=5jdbc.idletime=60

 

log4j日志配置

#Set root logger level to WARN and append to stdoutlog4j.rootLogger=DEBUG,stdoutlog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayout#Pattern to output the caller’s file name and line number.log4j.appender.stdout.layout.ConversionPattern=%d %5p (%c:%L) - %m%n#Print only messages of level ERROR or above in the package noModule.log4j.logger.noMoudle=FATAL

 

spring的配置

 

springMVC的配置文件

 

还有网站的配置信息

      
          
       
        ZH_SSM
           
           
               
        
         org.springframework.web.context.ContextLoaderListener
            
           
               
        
         contextConfigLocation
                
        
         classpath:applicationContext.xml
            
           
           
           
        
         springmvc
            
        
         org.springframework.web.servlet.DispatcherServlet
            
            
            
         
          contextConfigLocation
             
             
         
          classpath:springMVC.xml
             
            
            
        
         1
            
           
           
           
        
         springmvc
            
            
        
         /
            
       
      

 

3、表的映射类

public class phone{    private int id;    private String xh;    private String pp;    private double jg;    private double size;    public int getId(){    return id;}public void setId(int id){    this.id=id;}public String getXh(){    return xh;}public void setXh(String xh){    this.xh=xh;}public String getPp(){    return pp;}public void setPp(String pp){    this.pp=pp;}public double getJg(){    return jg;}public void setJg(double jg){    this.jg=jg;}public double getSize(){    return size;}public void setSize(double size){    this.size=size;}}

4、dao层的接口

基于注解实现的

public interface PhoneMapper{    //新增    @Insert(“insert into tb_phone(xh,pp,jg,size) values(#{xh},#{pp},#{jg},#{size})”)    @Options(useGeneratedKeys=true,keyProperty=”id”)    int save(Phone p);        //查询    @Select(“select * from tb_phone”)    @ResultType(Phone.class)    List
      
        queryAll();}
      

5、service层对应的类

@Service@Transactionalpublic class PhoneService{    @Autowired    private PhoneMapper dao;    public boolean save(Phone p){    return dao.save(p)>0?true:false;}public List
      
        queryAll(){    return dao.queryAll();}}
      

6、控制器

这里写代码

@Controllerpublic class PhoneController{    @Autowired    private PhoneService service;    //请求页面    @RequestMapping(“/{jn}”)    public String test1(@PathVariable String jn){    return jn;}//新增@RequestMapping(“/add”)public String test2(Phone phone,Model model){    if(!service.save(phone)){    moder.addAttribute(“msg”,”网络繁忙，稍后再来”);}return “phoneadd”;}//查询@RequestMapping(“/query”)public String test3(Model model){    model.addAttribute(“list”,service.queryAll());return “phoneadd”;}}

 

7、页面

<%@page language=”java” contentType=”text/html;charset=UTF-8”    pageEncoding=”UTF-8”%>    <%@taglib url=”http://java.sun.com/jsp/jstl/core” prefix=”c”%>
      
      
添加手机信息
${msg }
      
       
        品牌：
        
        
型号：
        
        
价格：
        
        
尺寸：
        
        
        
       
      
      
查询手机信息
刷新数据
      
       
       
       
        
         
          
序号
          
品牌
          
型号
          
价格
          
尺寸
         
         
          
暂无数据
         
         
          
${p.id }
          
${p.pp }
          
${p.xh }
          
${p.jg }
          
${p/size }
         
        
       
      

 

8、运行结果页面

 

https://blog.csdn.net/xingfei_work/article/details/77067513