@
目录
文件结构
C:.
│ pom.xml
│ ssm_0922.iml
│
├───.idea
│ .gitignore
│ compiler.xml
│ encodings.xml
│ jarRepositories.xml
│ misc.xml
│ ssm_0922.iml
│ uiDesigner.xml
│ workspace.xml
│
├───src
│ ├───java
│ │ └───com
│ │ └───aaa
│ │ ├───controller
│ │ │ StuController.java
│ │ │
│ │ ├───dao
│ │ │ StuMapper.java
│ │ │ StuMapper.xml
│ │ │
│ │ ├───entity
│ │ │ Student.java
│ │ │
│ │ └───servcie
│ │ StuService.java
│ │
│ ├───main
│ ├───resources
│ │ mybatis-conf.xml
│ │ spring.xml
│ │ springmvc.xml
│ │
│ └───webapp
│ │ index.jsp
│ │
│ └───WEB-INF
│ │ web.xml
│ │
│ └───jsp
│ hello.jsp
│
└───target
├───classes
│ │ mybatis-conf.xml
│ │ spring.xml
│ │ springmvc.xml
│ │
│ └───com
│ └───aaa
│ ├───controller
│ │ StuController.class
│ │
│ ├───dao
│ │ StuMapper.class
│ │ StuMapper.xml
│ │
│ ├───entity
│ │ Student.class
│ │
│ └───servcie
│ StuService.class
│
├───generated-sources
│ └───annotations
└───ssm_0922
│ index.jsp
│
├───META-INF
│ MANIFEST.MF
│
└───WEB-INF
│ web.xml
│
├───classes
│ │ mybatis-conf.xml
│ │ spring.xml
│ │ springmvc.xml
│ │
│ └───com
│ └───aaa
│ ├───controller
│ │ StuController.class
│ │
│ ├───dao
│ │ StuMapper.class
│ │ StuMapper.xml
│ │
│ ├───entity
│ │ Student.class
│ │
│ └───servcie
│ StuService.class
│
├───jsp
│ hello.jsp
│
└───lib
commons-dbcp2-2.1.1.jar
commons-logging-1.2.jar
commons-pool2-2.4.2.jar
mybatis-3.4.6.jar
mybatis-spring-1.3.2.jar
mysql-connector-java-8.0.16.jar
protobuf-java-3.6.1.jar
spring-aop-5.2.6.RELEASE.jar
spring-beans-5.2.6.RELEASE.jar
spring-context-5.2.6.RELEASE.jar
spring-core-5.2.6.RELEASE.jar
spring-expression-5.2.6.RELEASE.jar
spring-jcl-5.2.6.RELEASE.jar
spring-jdbc-5.1.5.RELEASE.jar
spring-tx-5.1.5.RELEASE.jar
spring-web-5.2.5.RELEASE.jar
spring-webmvc-5.2.5.RELEASE.jar
主要文件：
依赖包：
文件内容
StuController.java
package com.aaa.controller;
import com.aaa.entity.Student;
import com.aaa.servcie.StuService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
//控制层controller
@Controller
public class StuController {
@Autowired
private StuService stuService;
@RequestMapping("/query")
public ModelAndView query() throws Exception{
List<Student> result = stuService.queryAll();
System.out.println(result);
ModelAndView modelAndView = new ModelAndView();
modelAndView.addObject("resultID",result.get(0).getId());
modelAndView.addObject("resultNname",result.get(0).getName());
modelAndView.addObject("resultAddress",result.get(0).getAddress());
modelAndView.setViewName("hello");
return modelAndView;
}
}
StuMapper.java
package com.aaa.dao;
import com.aaa.entity.Student;
import org.springframework.stereotype.Repository;
import java.util.List;
//业务接口
@Repository
public interface StuMapper {
public List<Student> selectAll();
}
StuMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--接口绑定-->
<mapper namespace="com.aaa.dao.StuMapper">
<select id="selectAll" resultType="Student">
select * from student1;
</select>
</mapper>
Student.java
package com.aaa.entity;
//实体类
public class Student {
//定义属性
private int id ; //学生id
private String name; //学生名称
private String address; //地址
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
Stuservice.java
package com.aaa.servcie;
import com.aaa.dao.StuMapper;
import com.aaa.entity.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
//业务逻辑层
@Service
public class StuService {
@Autowired
private StuMapper stuMapper;
//业务逻辑
public List<Student> queryAll(){
return stuMapper.selectAll();
}
}
mybatis-conf.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--当加载实体类时只需要写类名就行了-->
<typeAliases >
<package name="com.aaa.entity"></package>
</typeAliases>
</configuration>
spring.xml
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
">
<!--数据库数据源-->
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://yuming.com:3306/database"></property>
<property name="username" value="name"></property>
<property name="password" value="password"></property>
</bean>
<!--sqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!--mybatis配置文件也要交给spring管理-->
<property name="configLocation" value="classpath:mybatis-conf.xml"></property>
</bean>
<!--mapper扫描器-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--扫描路径-->
<property name="basePackage" value="com.aaa.dao"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
</beans>
springmvc.xml
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
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-4.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
">
<!--注解扫描器-->
<context:component-scan base-package="com.aaa"/>
<!--mvc注解驱动-->
<mvc:annotation-driven/>
<!--视图解析器--><!--不能进行注解配置-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!--静态资源过滤器-->
<mvc:default-servlet-handler/>
</beans>
hello.jsp
<%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2020/9/21
Time: 16:13
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page isELIgnored="false" %>
<html>
<head>
<title>我的页面</title>
</head>
<body>
${resultID}
${resultNname}
${resultAddress}
</body>
</html>
web.xml
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!--加载spring配置文件-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</context-param>
<!-- 配置全局编码过滤器(POST) -->
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--监听器-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--前端控制器DisthcherServlet-->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!--url映射-->
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
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/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>ssm_0922</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>ssm_0922 Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
</properties>
<dependencies>
<!--mybatis的依赖包-->
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!--mybatis与spring整合-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
<!--spring的依赖包-->
<!--spring相关依赖-->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.2.6.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.5.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.1.5.RELEASE</version>
</dependency>
<!--dpcp2 数据源连接-->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-dbcp2</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<finalName>ssm_0922</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>