(1)entity
package com.guor.entity;
public class Student {
private int id;
private String name;
private int age;
...
}
(2)mapper
package com.guor.mapper;
import com.guor.entity.Student;
public interface StudentMapper {
public void addStudent(Student student);
public Student queryStudentByStuNo(int id);
}
<?xml version="1.0" encoding="UTF-8" ?>
<select id="queryStudentByStuNo" parameterType="int" resultType="com.guor.entity.Student">
select * from student where id = #{stuNo}
</select>
<insert id="addStudent" parameterType="com.guor.entity.Student">
insert into student(id,name,age) values (#{id},#{name},#{age})
</insert>
(3)service(面向接口编程)
package com.guor.service;
import com.guor.entity.Student;
public interface IStudentService {
public void addStudent(Student student);
public Student queryStudentByStuNo(int id);
}
package com.guor.service.impl;
import com.guor.entity.Student;
import com.guor.mapper.StudentMapper;
import com.guor.service.IStudentService;
public class StudentServiceImpl implements IStudentService {
private StudentMapper studentMapper;
public void setStudentMapper(StudentMapper studentMapper) {
this.studentMapper = studentMapper;
}
@Override
public void addStudent(Student student) {
studentMapper.addStudent(student);
}
@Override
public Student queryStudentByStuNo(int id) {
return studentMapper.queryStudentByStuNo(id);
}
}
```
(4)controller
```
package com.guor.controller;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import com.guor.entity.Student;
import com.guor.service.IStudentService;
@Controller
@RequestMapping("studentController")
public class StudentController {
@Autowired
@Qualifier("studentService")
private IStudentService studentService;
public void setStudentService(IStudentService studentService) {
this.studentService = studentService;
}
@RequestMapping("queryStudentByStuNo/{id}")//映射
public String queryStudentByStuNo(@PathVariable("id") Integer id,Map<String,Object> map) {
Student student = studentService.queryStudentByStuNo(id);
map.put("student", student);
return "result";
}
}
```
**四、Spring整合SpringMVC**
-----------------------
### 1、jar包
一个就行,spring-webmvc-4.3.9.RELEASE.jar
### 2、配置
```
<?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" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 扫描有注解的包 -->
<context:component-scan base-package="com.guor.controller"></context:component-scan>
<!-- 配置视图解析器(InternalResourceViewResolver) -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/views/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!-- springMVC基础配置、标配 -->
<mvc:annotation-driven></mvc:annotation-driven>
<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
<property name="messageConverters">
<list>
<ref bean="mappingJacksonHttpMessageConverter" />
</list>
</property>
</bean>
<bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
<bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
<!-- <property name="exceptionAttribute" value = "ex"></property> 异常变量的默认值是exception-->
# 知其然不知其所以然,大厂常问面试技术如何复习?
**1、热门面试题及答案大全**
面试前做足功夫,让你面试成功率提升一截,这里一份热门350道一线互联网常问面试题及答案助你拿offer
> [**面试宝典+书籍+核心知识获取:戳这里免费下载**](https://gitee.com/vip204888/java-p7)!诚意满满!!!
![](https://img-blog.csdnimg.cn/img_convert/87c93034107b704c2723923baad1f865.png)
**2、多线程、高并发、缓存入门到实战项目pdf书籍**
![](https://img-blog.csdnimg.cn/img_convert/a9a92582739e03e3e98bc8071db39283.png)
![](https://img-blog.csdnimg.cn/img_convert/4e23b4eeaaf92364adfd5b3554b08005.png)
![](https://img-blog.csdnimg.cn/img_convert/3b465378bdaa056c37a8859be2854f7c.png)
**3、文中提到面试题答案整理**
![](https://img-blog.csdnimg.cn/img_convert/971f3d8ef56f1468d990fdef929fb217.png)
**4、Java核心知识面试宝典**
覆盖了**JVM 、JAVA集合、JAVA多线程并发、JAVA基础、Spring原理、微服务、Netty与RPC、网络、日志、Zookeeper、Kafka、RabbitMQ、Hbase、MongoDB 、Cassandra、设计模式、负载均衡、数据库、一致性算法 、JAVA算法、数据结构、算法、分布式缓存、Hadoop、Spark、Storm的大量技术点且讲解的非常深入**
![](https://img-blog.csdnimg.cn/img_convert/87cece793d70e4e450220aeab9d5cde2.png)
![](https://img-blog.csdnimg.cn/img_convert/0a62388a82d1a8f2da4074069e42e60c.png)
![](https://img-blog.csdnimg.cn/img_convert/ce643fb2ebe0ddd392937e2923db23f8.png)
C3D-1628227032443)]
**4、Java核心知识面试宝典**
覆盖了**JVM 、JAVA集合、JAVA多线程并发、JAVA基础、Spring原理、微服务、Netty与RPC、网络、日志、Zookeeper、Kafka、RabbitMQ、Hbase、MongoDB 、Cassandra、设计模式、负载均衡、数据库、一致性算法 、JAVA算法、数据结构、算法、分布式缓存、Hadoop、Spark、Storm的大量技术点且讲解的非常深入**
[外链图片转存中...(img-PLmyhItQ-1628227032444)]
[外链图片转存中...(img-yanPXOg6-1628227032445)]
[外链图片转存中...(img-GmdQ2KZi-1628227032446)]