create database how2java; |
use how2java; CREATE TABLE category_ ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(30) , PRIMARY KEY (id) ) DEFAULT CHARSET=UTF8; |
use how2java; insert into category_ values(null,"category1"); insert into category_ values(null,"category2"); insert into category_ values(null,"category3"); insert into category_ values(null,"category4"); insert into category_ values(null,"category5"); select * from category_ |
http: //127.0.0.1:8080/ssm/listCategory |
package com.how2java.pojo; public class Category { private int id; private String name; public int getId() { return id; } public void setId( int id) { this .id = id; } public String getName() { return name; } public void setName(String name) { this .name = name; } @Override public String toString() { return "Category [id=" + id + ", name=" + name + "]" ; } } |
package com.how2java.mapper; import java.util.List; import com.how2java.pojo.Category; public interface CategoryMapper { public int add(Category category); public void delete( int id); public Category get( int id); public int update(Category category); public List<Category> list(); public int count(); } |
<? 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.how2java.mapper.CategoryMapper" > < insert id = "add" parameterType = "Category" > insert into category_ ( name ) values (#{name}) </ insert > < delete id = "delete" parameterType = "Category" > delete from category_ where id= #{id} </ delete > < select id = "get" parameterType = "_int" resultType = "Category" > select * from category_ where id= #{id} </ select > < update id = "update" parameterType = "Category" > update category_ set name=#{name} where id=#{id} </ update > < select id = "list" resultType = "Category" > select * from category_ </ select > </ mapper > |
package com.how2java.service; import java.util.List; import com.how2java.pojo.Category; public interface CategoryService { List<Category> list(); } |
package com.how2java.service.impl; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.how2java.mapper.CategoryMapper; import com.how2java.pojo.Category; import com.how2java.service.CategoryService; @Service public class CategoryServiceImpl implements CategoryService{ @Autowired CategoryMapper categoryMapper; public List<Category> list(){ return categoryMapper.list(); } } |
package com.how2java.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.how2java.pojo.Category; import com.how2java.service.CategoryService; // 告诉spring mvc这是一个控制器类 @Controller @RequestMapping ( "" ) public class CategoryController { @Autowired CategoryService categoryService; @RequestMapping ( "listCategory" ) public ModelAndView listCategory(){ ModelAndView mav = new ModelAndView(); List<Category> cs= categoryService.list(); // 放入转发参数 mav.addObject( "cs" , cs); // 放入jsp路径 mav.setViewName( "listCategory" ); return mav; } } |
<? 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核心:分发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 > </ web-app > |
<context:annotation-config /> <context:component-scan base- package = "com.how2java.service" /> |
<bean id= "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource" > |
<bean id= "sqlSession" class = "org.mybatis.spring.SqlSessionFactoryBean" > |
<bean class = "org.mybatis.spring.mapper.MapperScannerConfigurer" > |
<?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 http://www.springframework.org/schema/mvc/spring-mvc.xsd"> <context:annotation-config /> <context:component-scan base- package = "com.how2java.service" /> <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/how2java?characterEncoding=UTF-8</value> </property> <property name= "username" > <value>root</value> </property> <property name= "password" > <value>admin</value> </property> </bean> <bean id= "sqlSession" class = "org.mybatis.spring.SqlSessionFactoryBean" > <property name= "typeAliasesPackage" value= "com.how2java.pojo" /> <property name= "dataSource" ref= "dataSource" /> <property name= "mapperLocations" value= "classpath:com/how2java/mapper/*.xml" /> </bean> <bean class = "org.mybatis.spring.mapper.MapperScannerConfigurer" > <property name= "basePackage" value= "com.how2java.mapper" /> </bean> </beans> |
<context:annotation-config/> <context:component-scan base- package = "com.how2java.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> |
<?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 http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd"> <context:annotation-config/> <context:component-scan base- package = "com.how2java.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> |
<%@ 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" %> <table align= ‘center‘ border= ‘1‘ cellspacing= ‘0‘ > <tr> <td>id</td> <td>name</td> </tr> <c:forEach items= "${cs}" var= "c" varStatus= "st" > <tr> <td>${c.id}</td> <td>${c.name}</td> </tr> </c:forEach> </table> |
http: //127.0.0.1:8080/ssm/listCategory |
Java框架之SSM(Spring+SpringMVC+Mybatis)
原文:https://www.cnblogs.com/GGLoner/p/12693473.html