Java中SSM框架实现增删改查功能代码详解

2023-07-20 10:21:13 171

记录一下自己第一次整合smm框架的步骤。

参考博客和网站有：我没有三颗心脏How2J学习网站

1.数据库使用的是mySql，首先创建数据库ssm1，并创建表student

createdatabasessm1;

usessm1;

CREATETABLEstudent(
idint(11)NOTNULLAUTO_INCREMENT,
student_idint(11)NOTNULLUNIQUE,
namevarchar(255)NOTNULL,
ageint(11)NOTNULL,
sexvarchar(255)NOTNULL,
birthdaydateDEFAULTNULL,
PRIMARYKEY(id)
)ENGINE=InnoDBDEFAULTCHARSET=utf8;

2.新建javaweb项目，命名为ssm1,并且导入相关的jar包。

3.建立pojo类，在这里命名为student，包名为com.ssm1.pojo

packagecom.ssm1.pojo;

publicclassStudent{
privateintid;
privateintstudent_id;
privateStringname;
privateintage;
privateStringsex;
privateStringbirthday;
publicintgetId(){
returnid;
}
publicvoidsetId(intid){
this.id=id;
}
publicintgetStudent_id(){
returnstudent_id;
}
publicvoidsetStudent_id(intstudent_id){
this.student_id=student_id;
}
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicintgetAge(){
returnage;
}
publicvoidsetAge(intage){
this.age=age;
}
publicStringgetSex(){
returnsex;
}
publicvoidsetSex(Stringsex){
this.sex=sex;
}
publicStringgetBirthday(){
returnbirthday;
}
publicvoidsetBirthday(Stringbirthday){
this.birthday=birthday;
}


}

4.建立映射器接口studentMapper，包名为com.ssm1.mapper

packagecom.ssm1.mapper;

importjava.util.List;
importcom.ssm1.pojo.Student;

publicinterfaceStudentMapper{
publicintadd(Studentstudent);

publicvoiddelete(intid);

publicStudentget(intid);

publicintupdate(Studentstudent);

publicListlist();

}

5.建立与studentMapper对应的xml文件，同样属于包com.ssm1.mapper







INSERTINTOstudentVALUES(#{student_id},#{name},#{age},#{sex},#{birthday})





deletefromstudentwhereid=#{id}



select*fromstudentwhereid=#{id}



UPDATEstudentSETstudent_id=#{student_id},name=#{name},
age=#{age},sex=#{sex},birthday=#{birthday}WHEREid=#{id}


select*fromstudent

6.建立studentService接口，包名为com.ssm1.service

packagecom.ssm1.service;

importjava.util.List;
importcom.ssm1.pojo.Student;

publicinterfaceStudentService{
Listlist();
voidadd(Students);
voiddelete(Students);
voidupdate(Students);
Studentget(intid);
}

7.建立studentServiceImpl类，实现接口，包名为com.ssm1.service

packagecom.ssm1.service;

importjava.util.List;

importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.stereotype.Service;

importcom.ssm1.mapper.StudentMapper;
importcom.ssm1.pojo.Student;

@Service
publicclassStudentServiceImplimplementsStudentService{
@Autowired
StudentMapperstudentMapper;

@Override
publicListlist(){
//TODOAuto-generatedmethodstub
returnstudentMapper.list();
}

@Override
publicvoidadd(Students){
//TODOAuto-generatedmethodstub
studentMapper.add(s);
}

@Override
publicvoiddelete(Students){
//TODOAuto-generatedmethodstub
studentMapper.delete(s.getId());
}

@Override
publicvoidupdate(Students){
//TODOAuto-generatedmethodstub
studentMapper.update(s);
}

@Override
publicStudentget(intid){
//TODOAuto-generatedmethodstub
returnstudentMapper.get(id);
}

}

8.建立studentController控制器，包名为com.ssm1.controller

packagecom.ssm1.controller;

importjava.util.List;

importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.stereotype.Controller;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.servlet.ModelAndView;

importcom.github.pagehelper.PageHelper;
importcom.github.pagehelper.PageInfo;
importcom.ssm1.pojo.Student;
importcom.ssm1.service.StudentService;
importcom.ssm1.util.Page;

@Controller
@RequestMapping("")
publicclassStudentController{
@Autowired
StudentServicestudentService;

@RequestMapping("/index")
publicModelAndViewindex(Pagepage){
ModelAndViewmav=newModelAndView();
Listcs=studentService.list();
mav.addObject("cs",cs);
mav.setViewName("index");
returnmav;
}

@RequestMapping(value="addStudent",produces="text/html;charset=utf-8")
//@RequestMapping("addStudent")
publicModelAndViewaddStudent(Studentstudent){
studentService.add(student);
ModelAndViewmav=newModelAndView("redirect:/index");
returnmav;
}

@RequestMapping("deleteStudent")
publicModelAndViewdeleteStudent(Studentstudent){
studentService.delete(student);
ModelAndViewmav=newModelAndView("redirect:/index");
returnmav;
}

@RequestMapping("editStudent")
publicModelAndVieweditStudent(Studentstudent){
Students=studentService.get(student.getId());
ModelAndViewmav=newModelAndView("editStudent");
mav.addObject("s",s);
returnmav;
}

@RequestMapping("updateStudent")
publicModelAndViewupdateStudent(Studentstudent){
studentService.update(student);
ModelAndViewmav=newModelAndView("redirect:/index");
returnmav;

}
}

9.在WEB-INF目录下建立web.xml






contextConfigLocation
classpath:applicationContext.xml


org.springframework.web.context.ContextLoaderListener





mvc-dispatcher
org.springframework.web.servlet.DispatcherServlet


contextConfigLocation
classpath:springMVC.xml

1


mvc-dispatcher
/


CharacterEncodingFilter
org.springframework.web.filter.CharacterEncodingFilter

encoding
utf-8



CharacterEncodingFilter
/*

10.在src目录下新建applicationContext.xml文件，这是Spring的配置文件










com.mysql.jdbc.Driver


jdbc:mysql://localhost:3306/ssm1?characterEncoding=UTF-8



root


admin

11.在src目录下新增springMVC.xml文件

12.在WEB-INF下创建jsp目录，并创建文件index.jsp和editStudent.jsp

<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"import="java.util.*"%>

<%@tagliburi="http://java.sun.com/jsp/jstl/core"prefix="c"%>




Inserttitlehere




id
student_id
name
age
sex
birthday
编辑
删除



${c.id}
${c.student_id}
${c.name}
${c.age}
${c.sex}
${c.birthday}
编辑
删除






学生学号：


学生姓名：


学生年纪：


学生性别：


学生生日：

<%@pagelanguage="java"contentType="text/html;charset=UTF-8"
pageEncoding="UTF-8"import="java.util.*"%>

<%@tagliburi="http://java.sun.com/jsp/jstl/core"prefix="s"%>







分类名称：


分类名称：


分类名称：


分类名称：


分类名称：

Java中SSM框架实现增删改查功能代码详解

热门推荐

随机推荐