创建数据库
create database ssm;
创建表
use ssm;
CREATE TABLE category_ (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(30) ,
PRIMARY KEY (id)
) DE
use ssm;
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_
pojo
package
com.ssm.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.ssm.mapper;
import
java.util.List;
import
com.ssm.pojo.Category;
public
interface
CategoryMapper {
public
void
add(Category category);
public
void
delete(
int
id);
public
Category get(
int
id);
public
void
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.ssm.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
>
CategoryService
package
com.ssm.service;
import
java.util.List;
import
com.ssm.pojo.Category;
public
interface
CategoryService {
List<Category> list();
}
package
com.ssm.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.ssm.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.ssm.pojo.Category;
import
com.ssm.service.CategoryService;
// 告诉spring mvc这是一个控制器类
@Controller
@RequestMapping
(
""
)
public
class
CategoryController {
@Resource
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
>
<?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.ssm.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/ssm?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.ssm.pojo"
/>
<property name=
"dataSource"
ref=
"dataSource"
/>
<property name=
"mapperLocations"
value=
"classpath:com/ssm/mapper/*.xml"
/>
</bean>
<bean
class
=
"org.mybatis.spring.mapper.MapperScannerConfigurer"
>
<property name=
"basePackage"
value=
"com.ssm.mapper"
/>
</bean>
</beans>
<?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.ssm.controller"
>
</context:component-scan>
<mvc:annotation-driven />
<!-- 视图定位 -->
<bean
class
=
"org.springframework.web.servlet.view.InternalResourceViewResolver"
>
<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