IDEA创建SSM(Spring+SpringMVC+Mybatis)项目-Maven版

2.applicationContext.xml

<beans xmlns="www.springframework.org/schema/bean…"

xmlns:xsi="www.w3.org/2001/XMLSch…"

xmlns:tx="www.springframework.org/schema/tx"

xmlns:context="www.springframework.org/schema/cont…"

xsi:schemaLocation="www.springframework.org/schema/bean…

www.springframework.org/schema/bean…

www.springframework.org/schema/tx

www.springframework.org/schema/tx/s…

www.springframework.org/schema/cont…

www.springframework.org/schema/cont…

3.jdbc.properties

8.0之前的driver

#driver=com.mysql.jdbc.Driver

8.0之后的driver

driver=com.mysql.cj.jdbc.Driver

#mytest为我本地的数据库名

url=jdbc:mysql://localhost:3306/maven-ssm-demo?serverTimezone=UTC

数据库用户名

username=root

数据库的密码

password=admin

定义初始连接数

initialSize=1

定义最大连接数

maxActive=20

定义最大空闲

maxIdle=20

定义最小空闲

minIdle=1

定义最长等待时间

maxWait=60000

4.log4j.properties

#日志输出级别

log4j.rootLogger=debug,stdout,D,E

#设置stdout的日志输出控制台

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

#输出日志到控制台的方式，默认为System.out

log4j.appender.stdout.Target = System.out

#设置使用灵活布局

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

#灵活定义输出格式

log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss,SSS} -[%p] method:[%c (%rms)] - %m%n

5.spring-mvc.xml

<beans xmlns="www.springframework.org/schema/bean…"

xmlns:xsi="www.w3.org/2001/XMLSch…"

xmlns:context="www.springframework.org/schema/cont…"

xmlns:mvc="www.springframework.org/schema/mvc"

xsi:schemaLocation="www.springframework.org/schema/bean…

www.springframework.org/schema/bean…

www.springframework.org/schema/cont…

www.springframework.org/schema/cont…

www.springframework.org/schema/mvc

www.springframework.org/schema/mvc/…

<context:component-scan base-package="com.sjsq"/>

mvc:annotation-driven/

mvc:default-servlet-handler/

6.web.xml

contextConfigLocation

classpath:applicationContext.xml

org.springframework.web.context.ContextLoaderListener

springmvc

org.springframework.web.servlet.DispatcherServlet

contextConfigLocation

classpath:spring-mvc.xml

1

springmvc

*.do

index.jsp

7.pom.xml

<project xmlns="maven.apache.org/POM/4.0.0" xmlns:xsi="www.w3.org/2001/XMLSch…"

xsi:schemaLocation="maven.apache.org/POM/4.0.0 maven.apache.org/maven-v4_0_…

4.0.0

war

MavenSSMDemo

com.sjsq

MavenSSMDemo

1.0-SNAPSHOT

org.mortbay.jetty

maven-jetty-plugin

6.1.7

8888

30000

${project.build.directory}/${pom.artifactId}-${pom.version}

/

<srping.version>4.0.2.RELEASE</srping.version>

<mybatis.version>3.2.8</mybatis.version>

<slf4j.version>1.7.12</slf4j.version>

<log4j.version>1.2.17</log4j.version>

<druid.version>1.0.9</druid.version>

junit

junit

4.11

test

org.springframework

spring-test

${srping.version}

org.springframework

spring-core

${srping.version}

org.springframework

spring-oxm

${srping.version}

org.springframework

spring-tx

${srping.version}

org.springframework

spring-jdbc

${srping.version}

org.springframework

spring-aop

${srping.version}

org.springframework

spring-context

${srping.version}

org.springframework

spring-context-support

${srping.version}

org.springframework

spring-expression

${srping.version}

org.springframework

spring-orm

${srping.version}

org.springframework

spring-web

${srping.version}

org.springframework

spring-webmvc

${srping.version}

org.mybatis

mybatis

${mybatis.version}

org.mybatis

mybatis-spring

1.2.2

mysql

mysql-connector-java

8.0.20

commons-dbcp

commons-dbcp

1.4

jstl

jstl

1.2

log4j

log4j

${log4j.version}

org.slf4j

slf4j-api

${slf4j.version}

org.slf4j

slf4j-log4j12

${slf4j.version}

com.alibaba

druid

${druid.version}

2.前端

---

list.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ taglib prefix="c" uri="java.sun.com/jsp/jstl/co…

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

My JSP 'index.jsp' starting page

<c:forEach items="${list}" var="bean">

</c:forEach>

编号	姓名	密码
${bean.id}	${bean.username}	${bean.password}

3.后端

---

User

package com.sjsq.model;

/**

• 实体类

• @author shuijianshiqing

• @date 2020/6/21 10:21

*/

public class User {

private Integer id;

private String username;

private String password;

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

@Override

public String toString() {

return "User{" +

"id=" + id +

", username='" + username + ''' +

", password='" + password + ''' +

'}';

}

}

UserDao

package com.sjsq.dao;

import com.sjsq.model.User;

import java.util.List;

/**

• @author shuijianshiqing

• @date 2020/6/21 10:29

*/

public interface UserDao {

/**

• 获取所有用户信息

• @return

*/

public List list();

}

UserDaoImpl

package com.sjsq.dao.impl;

import com.sjsq.dao.UserDao;

import com.sjsq.model.User;

import org.apache.ibatis.session.SqlSessionFactory;

import org.mybatis.spring.support.SqlSessionDaoSupport;

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

import org.springframework.stereotype.Repository;

import java.util.List;

/**

• @author shuijianshiqing

• @date 2020/6/21 10:30

*/

@Repository("userDao")

public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {

@Autowired

@Override

public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {

super.setSqlSessionFactory(sqlSessionFactory);

}

/**

• 返回查询结果

• @return

*/

public List list() {

return this.getSqlSession().selectList("com.sjsq.model.user.mapper.list");

}

}

UserService

package com.sjsq.service;

import com.sjsq.model.User;

import java.util.List;

/**

• @author shuijianshiqing

• @date 2020/6/21 10:38

*/

public interface UserService {

public List list();

}

UserServiceImpl

package com.sjsq.service.impl;

import com.sjsq.dao.UserDao;

import com.sjsq.model.User;

import com.sjsq.service.UserService;

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

import org.springframework.stereotype.Service;

import java.util.List;

/**

• @author shuijianshiqing

• @date 2020/6/21 10:38

*/

@Service("userService")

public class UserServiceImpl implements UserService {

@Autowired

private UserDao userDao;

public void setUserDao(UserDao userDao){

this.userDao = userDao;

}

public List list() {

return userDao.list();

}

}

UserController

package com.sjsq.controller;

import com.sjsq.service.UserService;

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

import org.springframework.stereotype.Controller;

import org.springframework.ui.ModelMap;

import org.springframework.web.bind.annotation.RequestMapping;

/**

• @author shuijianshiqing

• @date 2020/6/21 10:42