SSM项目-学生信息管理系统（3）

最新推荐文章于 2022-11-29 16:42:21 发布

IT-小公主

最新推荐文章于 2022-11-29 16:42:21 发布

阅读量397

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/XGZ2IT/article/details/105868655

版权

本文详细介绍了使用Spring、SpringMVC和MyBatis（SSM）框架构建学生信息管理系统的步骤。内容涵盖学生实体类定义、数据库操作接口及XML配置、服务接口与实现、后台控制器编写，以及多个JSP页面的设计，包括主框架、导航和信息展示等。

摘要由CSDN通过智能技术生成

1.学生信息实体类
包student.pojo中类Student.java

package student.pojo;



public class Student {
   
    
	private  int sid;
	private  String  sno;
	private  String   gender;
	private  String   sname;
	
	public String getGender() {
   
		return gender;
	}
	public void setGender(String gender) {
   
		this.gender = gender;
	}
	private  String major;
	public int getSid() {
   
		return sid;
	}
	public void setSid(int sid) {
   
		this.sid = sid;
	}
	public String getSno() {
   
		return sno;
	}
	public void setSno(String sno) {
   
		this.sno = sno;
	}
	public String getSname() {
   
		return sname;
	}
	public void setSname(String sname) {
   
		this.sname = sname;
	}
	public String getMajor() {
   
		return major;
	}
	public void setMajor(String major) {
   
		this.major = major;
	}
	
	
	
}

2.学生信息管理方法接口及实现
（1）包student.mapper中创建接口StudentMapper.java

package student.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import student.pojo.Student;




public interface StudentMapper {
   

	void save(Student student);

	List<Student> findAll();

	void delete(int sid);

	Student findById(int sid);

	void update(Student stu);

}

（2）文件mappings中创建StudentMapper.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="student.mapper.StudentMapper">

<resultMap type="student.pojo.Student" id="StudentMap">
		<result property="sid" column="sid" />
		<result property="sname" column="sname" />
		<result property="sno" column="sno" />
		<result property="gender" column="gender" />
		<result property="major" column="major" />
		
	</resultMap>

	<select id="findAll" resultMap="StudentMap">
		select *
		from tb_student
	</select>
	<!-- resultMap:映射实体类和字段之间的一一对应的关系 -->
<update id="update" parameterType="student.pojo.Student">
update  tb_student  set  
sno=#{
   sno},
sname=#{
   sname},
gender=#{
   gender},
major=#{
   major}
where  sid=#{
   sid}

</update>

	<!-- 通过ID查询一个用户 -->
	
	<select id="findById" parameterType="int"
		resultType="student.pojo.Student">
		select * from tb_student where sid = #{
   v}
	</select>
	
		
	<!-- 添加用户 -->
	<insert id="save" parameterType="student.pojo.Student">
	
		insert into tb_student
		(sno,sname,gender,major)values(#{
   sno},#{
   sname},#{
   gender},#{
   major})
		
	</insert>
	<!-- 删除 -->
	<delete id="delete" parameterType="Integer">
		delete from tb_student
		where sid =#{
   v}
	</delete>
</mapper>

3.学生信息服务器相关代码
（1）包student.service中创建接口StudentService.java

package student.service;

import java.util.List;

import student.pojo.Student;



public interface StudentService {
   

	void save(Student student);

	void update(Student student);

	List<Student> findAll();

	Student findById(int sid);

	void delete(int sid);

}

（2）包student.service.impl实现接口StudentService.java中的方法
创建类StudentServiceImpl.java

package student.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import student.mapper.StudentMapper;
import student.pojo.Student;
import student.service.StudentService;

@Service("studentService")
@Transactional
public class StudentServiceImpl  implements  StudentService {
   
	   @Autowired