記錄一下自己第一次整合smm框架的步驟。
參考博客和網(wǎng)站有：我沒有三顆心臟 How2J學習網(wǎng)站
1.數(shù)據(jù)庫使用的是mySql，首先創(chuàng)建數(shù)據(jù)庫ssm1，并創(chuàng)建表student
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
create database ssm1;use ssm1; CREATE TABLE student( id int(11) NOT NULL AUTO_INCREMENT, student_id int(11) NOT NULL UNIQUE, name varchar(255) NOT NULL, age int(11) NOT NULL, sex varchar(255) NOT NULL, birthday date DEFAULT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2.新建java web項目，命名為ssm1,并且導入相關的jar包。
3.建立pojo類，在這里命名為student，包名為com.ssm1.pojo
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
package com.ssm1.pojo;public class Student { private int id; private int student_id; private String name; private int age; private String sex; private String birthday; public int getId() { return id; } public void setId(int id) { this.id = id; } public int getStudent_id() { return student_id; } public void setStudent_id(int student_id) { this.student_id = student_id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getBirthday() { return birthday; } public void setBirthday(String birthday) { this.birthday = birthday; }} |
4.建立映射器接口studentMapper，包名為com.ssm1.mapper
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
package com.ssm1.mapper;import java.util.List;import com.ssm1.pojo.Student;public interface StudentMapper { public int add(Student student); public void delete(int id); public Student get(int id); public int update(Student student); public List<Student> list();} |
5.建立與studentMapper對應的xml文件，同樣屬于包com.ssm1.mapper
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
<?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.ssm1.mapper.StudentMapper"> <insert id="add" parameterType="Student"> INSERT INTO student VALUES(#{student_id},#{name}, #{age}, #{sex}, #{birthday}) </insert> <!-- <insert id="add" parameterType="com.ssm1.pojo.Student" useGeneratedKeys="true" keyProperty="id"> insert into student <trim prefix="(" suffix=")" suffixOverrides="," > <if test="student_id!=null"> student_id, </if> <if test="name!=null and name!=''"> name, </if> <if test="age!=null"> age, </if> <if test="sex!=null and sex!=''"> sex, </if> <if test="birthday!=null and birthday !=''"> birthday, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="student_id!=null"> #{student_id}, </if> <if test="name!=null and name!=''"> #{name}, </if> <if test="age!=null"> #{age}, </if> <if test="sex!=null and sex!=''"> #{sex}, </if> <if test="birthday!=null and birthday !=''"> #{birthday}, </if> </trim> </insert> --> <delete id="delete" parameterType="Student"> delete from student where id= #{id} </delete> <select id="get" parameterType="_int" resultType="Student"> select * from student where id= #{id} </select> <update id="update" parameterType="Student"> UPDATE student SET student_id = #{student_id}, name = #{name}, age = #{age}, sex = #{sex}, birthday = #{birthday} WHERE id = #{id} </update> <select id="list" resultType="Student"> select * from student </select></mapper> |
6.建立studentService接口，包名為com.ssm1.service
|
1
2
3
4
5
6
7
8
9
10
11
12
|
package com.ssm1.service;import java.util.List;import com.ssm1.pojo.Student;public interface StudentService { List<Student> list(); void add(Student s); void delete(Student s); void update(Student s); Student get(int id);} |
7.建立studentServiceImpl類，實現(xiàn)接口，包名為com.ssm1.service
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
package com.ssm1.service;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.ssm1.mapper.StudentMapper;import com.ssm1.pojo.Student;@Servicepublic class StudentServiceImpl implements StudentService { @Autowired StudentMapper studentMapper; @Override public List<Student> list() { // TODO Auto-generated method stub return studentMapper.list(); } @Override public void add(Student s) { // TODO Auto-generated method stub studentMapper.add(s); } @Override public void delete(Student s) { // TODO Auto-generated method stub studentMapper.delete(s.getId()); } @Override public void update(Student s) { // TODO Auto-generated method stub studentMapper.update(s); } @Override public Student get(int id) { // TODO Auto-generated method stub return studentMapper.get(id); }} |
8.建立studentController控制器，包名為com.ssm1.controller
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
package com.ssm1.controller;import java.util.List;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 com.github.pagehelper.PageHelper;import com.github.pagehelper.PageInfo;import com.ssm1.pojo.Student;import com.ssm1.service.StudentService;import com.ssm1.util.Page;@Controller@RequestMapping("")public class StudentController { @Autowired StudentService studentService; @RequestMapping("/index") public ModelAndView index(Page page) { ModelAndView mav = new ModelAndView(); List<Student> cs = studentService.list(); mav.addObject("cs", cs); mav.setViewName("index"); return mav; } @RequestMapping(value = "addStudent", produces = "text/html; charset=utf-8") // @RequestMapping("addStudent") public ModelAndView addStudent(Student student) { studentService.add(student); ModelAndView mav = new ModelAndView("redirect:/index"); return mav; } @RequestMapping("deleteStudent") public ModelAndView deleteStudent(Student student) { studentService.delete(student); ModelAndView mav = new ModelAndView("redirect:/index"); return mav; } @RequestMapping("editStudent") public ModelAndView editStudent(Student student) { Student s=studentService.get(student.getId()); ModelAndView mav=new ModelAndView("editStudent"); mav.addObject("s",s); return mav; } @RequestMapping("updateStudent") public ModelAndView updateStudent(Student student) { studentService.update(student); ModelAndView mav=new ModelAndView("redirect:/index"); return mav; }} |
9.在WEB-INF目錄下建立web.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5"> <!-- spring的配置文件--> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:applicationContext.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- spring mvc核心：分發(fā)servlet --> <servlet> <servlet-name>mvc-dispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- spring mvc的配置文件 --> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:springMVC.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>mvc-dispatcher</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <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></web-app> |
10.在src目錄下新建applicationContext.xml文件，這是Spring的配置文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
<?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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation=" http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/mvc <a href="http://www.springframework.org/schema/mvc/spring-mvc.xsd">">http://www.springframework.org/schema/mvc/spring-mvc.xsd"></a><!-- 配置@Service包的掃描 --> <context:annotation-config /> <context:component-scan base-package="com.ssm1.service" /> <!-- 配置數(shù)據(jù)庫的連接 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName"> <value>com.mysql.jdbc.Driver</value> </property> <property name="url"> <value>jdbc:mysql://localhost:3306/ssm1?characterEncoding=UTF-8</value> </property> <property name="username"> <value>root</value> </property> <property name="password"> <value>admin</value> </property> </bean> <!-- 配置SQLSessionFactory --> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="typeAliasesPackage" value="com.ssm1.pojo" /> <property name="dataSource" ref="dataSource"/> <property name="mapperLocations" value="classpath:com/ssm1/mapper/*.xml"/> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.ssm1.mapper"/> </bean></beans> |
11.在src目錄下新增springMVC.xml文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
<?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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/mvc <a href="http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd"><context:annotation-config/>">http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd"><context:annotation-config/></a> <context:component-scan base-package="com.ssm1.controller"> <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/> </context:component-scan> <mvc:annotation-driven /> <mvc:default-servlet-handler /> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/WEB-INF/jsp/" /> <property name="suffix" value=".jsp" /> </bean></beans> |
12.在WEB-INF下創(chuàng)建jsp目錄，并創(chuàng)建文件index.jsp和editStudent.jsp
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.util.*"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><!DOCTYPE html><html><head><meta charset="UTF-8"><title>Insert title here</title></head><body> <table align='center' border='1' cellspacing='0'> <tr> <td>id</td> <td>student_id</td> <td>name</td> <td>age</td> <td>sex</td> <td>birthday</td> <td>編輯</td> <td>刪除</td> </tr> <c:forEach items="${cs}" var="c" varStatus="st"> <tr> <td>${c.id}</td> <td>${c.student_id}</td> <td>${c.name}</td> <td>${c.age}</td> <td>${c.sex}</td> <td>${c.birthday}</td> <td><a href="editStudent?id=${c.id}" rel="external nofollow" >編輯</a></td> <td><a href="deleteStudent?id=${c.id}" rel="external nofollow" >刪除</a></td> </tr> </c:forEach></table> <div style="text-align:center;margin-top:40px"> <form method="post" action="addStudent" > 學生學號： <input name="student_id" value="" type="text"> <br><br> 學生姓名： <input name="name" value="" type="text"> <br><br> 學生年紀： <input name="age" value="" type="text"> <br><br> 學生性別： <input name="sex" value="" type="text"> <br><br> 學生生日： <input name="birthday" value="" type="text"> <br><br> <input type="submit" value="增加學生"> </form> </div> <div style="text-align:center; margin-top:20px"> <form action="${pageContext.request.contextPath }/index" method="post"> <input value="刷新" type="submit"> </form> </div></body></html> |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.util.*"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="s"%> <div style="width:500px;margin:0px auto;text-align:center"> <div style="text-align:center;margin-top:40px"> <form method="post" action="updateStudent"> 分類名稱： <input name="student_id" value="${s.student_id}" type="text"> <br><br> 分類名稱： <input name="name" value="${s.name}" type="text"> <br><br> 分類名稱： <input name="age" value="${s.age}" type="text"> <br><br> 分類名稱： <input name="sex" value="${s.sex}" type="text"> <br><br> 分類名稱： <input name="birthday" value="${s.birthday}" type="text"> <br><br> <input type="hidden" value="${s.id}" name="id"> <input type="submit" value="修改分類"> </form> </div> </div> |
13.最后在tomcat上部署項目，輸入路徑localhost:端口號/ssm1/index即可訪問
到此這篇關于Java中SSM框架實現(xiàn)增刪改查功能代碼詳解的文章就介紹到這了,更多相關SSM框架實現(xiàn)增刪改查功內(nèi)容請搜索服務器之家以前的文章或繼續(xù)瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://www.cnblogs.com/FrankYu-/p/11389413.html
