高版本
pom.xml
| |
| |
| <repositories> |
| <repository> |
| <id>repository.spring.milestone</id> |
| <name>Spring Milestone Repository</name> |
| <url>https://repo.spring.io/milestone</url> |
| </repository> |
| </repositories> |
| |
| |
| |
| <properties> |
| <junit.version>4.12</junit.version> |
| <spring.version>6.0.4</spring.version> |
| <mybatis.version>3.5.1</mybatis.version> |
| |
| <mybatis.spring.version>2.1.0</mybatis.spring.version> |
| <mybatis.paginator.version>1.2.15</mybatis.paginator.version> |
| |
| <mysql.version>8.0.30</mysql.version> |
| <slf4j.version>1.6.4</slf4j.version> |
| <druid.version>1.1.12</druid.version> |
| <pagehelper.version>5.1.2</pagehelper.version> |
| |
| <jakarta.jstl.version>2.0.0</jakarta.jstl.version> |
| <jakarta.servlet-api.version>5.0.0</jakarta.servlet-api.version> |
| <jakarta.jsp-api.version>3.0.0</jakarta.jsp-api.version> |
| |
| <jackson.version>2.9.6</jackson.version> |
| |
| </properties> |
| |
| |
| <dependencies> |
| |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-context</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-beans</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-webmvc</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-jdbc</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-aspects</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-jms</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-context-support</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.springframework</groupId> |
| <artifactId>spring-test</artifactId> |
| <version>${spring.version}</version> |
| </dependency> |
| |
| <dependency> |
| <groupId>org.mybatis</groupId> |
| <artifactId>mybatis</artifactId> |
| <version>${mybatis.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.mybatis</groupId> |
| <artifactId>mybatis-spring</artifactId> |
| <version>${mybatis.spring.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>com.github.miemiedev</groupId> |
| <artifactId>mybatis-paginator</artifactId> |
| <version>${mybatis.paginator.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>com.github.pagehelper</groupId> |
| <artifactId>pagehelper</artifactId> |
| <version>${pagehelper.version}</version> |
| </dependency> |
| |
| <dependency> |
| <groupId>mysql</groupId> |
| <artifactId>mysql-connector-java</artifactId> |
| <version>${mysql.version}</version> |
| </dependency> |
| |
| <dependency> |
| <groupId>com.alibaba</groupId> |
| <artifactId>druid</artifactId> |
| <version>${druid.version}</version> |
| </dependency> |
| |
| |
| <dependency> |
| <groupId>junit</groupId> |
| <artifactId>junit</artifactId> |
| <version>${junit.version}</version> |
| <scope>test</scope> |
| </dependency> |
| |
| |
| |
| <dependency> |
| <groupId>org.glassfish.web</groupId> |
| <artifactId>jakarta.servlet.jsp.jstl</artifactId> |
| <version>${jakarta.jstl.version}</version> |
| </dependency> |
| |
| <dependency> |
| <groupId>jakarta.servlet</groupId> |
| <artifactId>jakarta.servlet-api</artifactId> |
| <version>${jakarta.servlet-api.version}</version> |
| <scope>provided</scope> |
| </dependency> |
| |
| <dependency> |
| <groupId>jakarta.servlet.jsp</groupId> |
| <artifactId>jakarta.servlet.jsp-api</artifactId> |
| <version>${jakarta.jsp-api.version}</version> |
| <scope>provided</scope> |
| </dependency> |
| |
| |
| |
| <dependency> |
| <groupId>com.fasterxml.jackson.core</groupId> |
| <artifactId>jackson-databind</artifactId> |
| <version>${jackson.version}</version> |
| </dependency> |
| <dependency> |
| <groupId>org.json</groupId> |
| <artifactId>json</artifactId> |
| <version>20140107</version> |
| </dependency> |
| |
| |
| <dependency> |
| <groupId>commons-io</groupId> |
| <artifactId>commons-io</artifactId> |
| <version>2.4</version> |
| </dependency> |
| <dependency> |
| <groupId>commons-fileupload</groupId> |
| <artifactId>commons-fileupload</artifactId> |
| <version>1.3.1</version> |
| </dependency> |
| |
| <dependency> |
| <groupId>org.slf4j</groupId> |
| <artifactId>slf4j-simple</artifactId> |
| <version>${slf4j.version}</version> |
| </dependency> |
| |
| </dependencies> |
| |
| |
| <build> |
| <plugins> |
| <plugin> |
| <groupId>org.apache.maven.plugins</groupId> |
| <artifactId>maven-compiler-plugin</artifactId> |
| <configuration> |
| <source>1.8</source> |
| <target>1.8</target> |
| <encoding>UTF-8</encoding> |
| </configuration> |
| </plugin> |
| </plugins> |
| |
| <resources> |
| <resource> |
| <directory>src/main/java</directory> |
| <includes> |
| <include>**/*.properties</include> |
| <include>**/*.xml</include> |
| </includes> |
| <filtering>false</filtering> |
| </resource> |
| <resource> |
| <directory>src/main/resources</directory> |
| <includes> |
| <include>**/*.properties</include> |
| <include>**/*.xml</include> |
| </includes> |
| <filtering>false</filtering> |
| </resource> |
| </resources> |
| </build> |
| |
| |
jdbc.properties
| jdbc.driverClassName=com.mysql.填空.jdbc.Driver |
| jdbc.url=jdbc:mysql://localhost:3306/填空?useUnicode=true&characterEncoding=utf8 |
| jdbc.username=root |
| jdbc.password=root |
sqlMapConfig.xml(mybatis)
| <?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> |
| <settings> |
| |
| <setting name="logImpl" value="STDOUT_LOGGING"/> |
| |
| |
| |
| <setting name="mapUnderscoreToCamelCase" value="true"/> |
| </settings> |
| |
| </configuration> |
applicationContext.xml(spring)
| <?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:tx="http://www.springframework.org/schema/tx" |
| xmlns:aop="http://www.springframework.org/schema/aop" |
| xsi:schemaLocation=" |
| http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd |
| http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd |
| http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd |
| http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"> |
| |
| |
| <context:component-scan base-package="填空_1"/> |
| |
| |
| |
| <context:property-placeholder location="classpath:填空_2"/> |
| |
| |
| |
| <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"> |
| <property name="username" value="${jdbc.username}"/> |
| <property name="password" value="${jdbc.password}"/> |
| <property name="url" value="${jdbc.url}"/> |
| <property name="driverClassName" value="${jdbc.driverClassName}"/> |
| </bean> |
| |
| |
| <bean class="org.mybatis.spring.SqlSessionFactoryBean"> |
| |
| |
| <property name="configLocation" value="classpath:填空_3"/> |
| |
| <property name="dataSource" ref="dataSource"/> |
| |
| <property name="typeAliasesPackage" value="填空_4"/> |
| </bean> |
| |
| <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> |
| <property name="basePackage" value="填空_5"/> |
| </bean> |
| |
| <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> |
| <property name="dataSource" ref="dataSource"/> |
| </bean> |
| |
| <tx:annotation-driven transaction-manager="txManager"/> |
| |
| |
| <tx:advice id="myAdvice" transaction-manager="txManager"> |
| <tx:attributes> |
| <tx:method name="*select*" read-only="true"/> |
| <tx:method name="*find*" read-only="true"/> |
| <tx:method name="*get*" read-only="true"/> |
| <tx:method name="*search*" read-only="true"/> |
| <tx:method name="*insert*" propagation="REQUIRED"/> |
| <tx:method name="*save*" propagation="REQUIRED"/> |
| <tx:method name="*add*" propagation="REQUIRED"/> |
| <tx:method name="*delete*" propagation="REQUIRED"/> |
| <tx:method name="*remove*" propagation="REQUIRED"/> |
| <tx:method name="*clear*" propagation="REQUIRED"/> |
| <tx:method name="*update*" propagation="REQUIRED"/> |
| <tx:method name="*modify*" propagation="REQUIRED"/> |
| <tx:method name="*change*" propagation="REQUIRED"/> |
| <tx:method name="*set*" propagation="REQUIRED"/> |
| <tx:method name="*" propagation="SUPPORTS"/> |
| </tx:attributes> |
| </tx:advice> |
| |
| |
| <aop:config> |
| <aop:pointcut id="myPointcut" expression="execution(*填空_6.service.*.*(..))"/> |
| |
| |
| |
| <aop:advisor advice-ref="myAdvice" pointcut-ref="myPointcut"/> |
| </aop:config> |
| </beans> |
springmvc.xml
| <?xml version="1.0" encoding="UTF-8"?> |
| <beans xmlns="http://www.springframework.org/schema/beans" |
| xmlns:mvc="http://www.springframework.org/schema/mvc" |
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" |
| xmlns:context="http://www.springframework.org/schema/context" |
| xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd |
| http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd |
| http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd"> |
| |
| <context:component-scan base-package="包扫描"/> |
| |
| |
| |
| <mvc:annotation-driven/> |
| </beans> |
web.xml
| <?xml version="1.0" encoding="UTF-8"?> |
| <web-app xmlns="https://jakarta.ee/xml/ns/jakartaee" |
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" |
| xsi:schemaLocation="https://jakarta.ee/xml/ns/jakartaee |
| https://jakarta.ee/xml/ns/jakartaee/web-app_5_0.xsd" |
| version="5.0" |
| metadata-complete="true"> |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| <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:填空_1</param-value> |
| </init-param> |
| </servlet> |
| <servlet-mapping> |
| <servlet-name>springmvc</servlet-name> |
| <url-pattern>/</url-pattern> |
| </servlet-mapping> |
| |
| |
| <listener> |
| <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> |
| </listener> |
| |
| <context-param> |
| <param-name>contextConfigLocation</param-name> |
| <param-value>classpath:填空_2</param-value> |
| </context-param> |
| </web-app> |
sql
| CREATE DATABASE `ssm` ; |
| |
| USE `ssm`; |
| |
| |
| |
| DROP TABLE IF EXISTS `person`; |
| |
| CREATE TABLE `person` ( |
| `name` char(25) DEFAULT NULL, |
| `age` int(11) DEFAULT NULL |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| |
| |
| |
| insert into `person`(`name`,`age`) values ('张三',23),('李四',23),('王五',22); |
controller
| @Controller |
| public class PersonController { |
| |
| |
| PersonService personService; |
| @Autowired |
| public PersonController(PersonService personService) { |
| this.personService = personService; |
| } |
| |
| |
| @ResponseBody |
| @RequestMapping("/person/selectAll") |
| public List<Person> selectAll(){ |
| System.out.println(personService.selectAll()); |
| return personService.selectAll(); |
| } |
| |
| |
| |
| |
| |
| } |
service
service接口
| public interface PersonService { |
| List<Person> selectAll(); |
| } |
service.impl
| @Service |
| public class PersonServiceImpl implements PersonService { |
| |
| private PersonMapper personMapper; |
| @Autowired |
| public PersonServiceImpl(PersonMapper personMapper) { |
| this.personMapper = personMapper; |
| } |
| |
| |
| public List<Person> selectAll(){ |
| return personMapper.selectAll(); |
| } |
| } |
mapper
Mapper.java
| public interface PersonMapper { |
| |
| |
| |
| |
| List<Person> selectAll(); |
| } |
_Mapper.xml
| |
| <select id="selectAll" resultType="person"> |
| select name,age from person ; |
| </select> |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· NetPad:一个.NET开源、跨平台的C#编辑器
· 面试官:你是如何进行SQL调优的?