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

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！

数据库的密码

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

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

<beans xmlns=“http://www.springframework.org/schema/beans”

xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

xmlns:context=“http://www.springframework.org/schema/context”

xmlns:mvc=“http://www.springframework.org/schema/mvc”

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">

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

mvc:annotation-driven/

mvc:default-servlet-handler/

6.web.xml

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

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

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

<project xmlns=“http://maven.apache.org/POM/4.0.0” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

xsi:schemaLocation=“http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd”>

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=“http://java.sun.com/jsp/jstl/core”%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;

%>

编号 姓名 密码

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

${bean.id} ${bean.username} ${bean.password}

</c:forEach>

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();

面试题总结

其它面试题（springboot、mybatis、并发、java中高级面试总结等）

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
/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();

面试题总结

其它面试题（springboot、mybatis、并发、java中高级面试总结等）

[外链图片转存中…(img-WXlXH8FX-1714665536473)]

[外链图片转存中…(img-emhY9Vxt-1714665536474)]

[外链图片转存中…(img-bdVorrDK-1714665536474)]

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！