简单的ssm练手项目

这是一个简单的ssm整合项目实现了汽车的品牌，价格，车型的添加，修改，删除，所有数据从数据库中拿取

使用到了jsp+mysql+Mybatis+spring+springmvc 等后端技术，使用springboot快速搭建项目，前端使用到了layui

1.准备数据库相关

1.1 新建car表

CREATETABLE`car` (

`id`int(11)NOTNULLAUTO_INCREMENT,

`brand`varchar(20)NOTNULL,

`type`varchar(20)NOTNULL,

`price`double(20,0)NOTNULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=25DEFAULT CHARSET=utf8;

1.2 添加数据

INSERTINTO`car`VALUES('1','丰田','卡罗拉','128888');

INSERTINTO`car`VALUES('2','本田','思域','138888');

INSERTINTO`car`VALUES('3','宝马','3系','328888');

INSERTINTO`car`VALUES('4','荣威','RX8','168888');

INSERTINTO`car`VALUES('5','丰田','汉兰达','328888');

INSERTINTO`car`VALUES('6','大众','帕沙特','218888');

INSERTINTO`car`VALUES('7','奥迪','A6','456666');

INSERTINTO`car`VALUES('8','宝马','7系','1200000');

2开始项目

新建一个springboot项目

添加相关依赖

</dependency>

<groupId>com.alibaba</groupId>

<artifactId>druid</artifactId>

</dependency>

<groupId>com.baomidou</groupId>

<artifactId>mybatis-plus</artifactId>

</dependency>

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

</dependency>

<groupId>javax.servlet</groupId>

</dependency>

<groupId>org.apache.tomcat.embed</groupId>

<artifactId>tomcat-embed-jasper</artifactId>

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

<groupId>taglibs</groupId>

<artifactId>standard</artifactId>

</dependency>

<groupId>com.github.pagehelper</groupId>

<artifactId>pagehelper</artifactId>

</dependency>

</dependencies>

创建com.car.pojo.Car数据库表对应类，打上@TableName注解关联上数据库表，提供get/set方法，如果不想手写get/set方法可以在创建springboot项目时勾选上Lombok依赖，可以自动创建get/set方法

@TableName("car")//和数据库的表相对应

//@Data//自动添加get/set方法

publicclassCar{

@TableId(type=IdType.AUTO)

privateIntegerid;

privateStringtype;

privateStringbrand;

privateDoubleprice;

publicIntegergetId() {

returnid;

}

publicvoidsetId(Integerid) {

this.id=id;

}

publicStringgetType() {

returntype;

}

publicvoidsetType(Stringtype) {

this.type=type;

}

publicStringgetBrand() {

returnbrand;

}

publicvoidsetBrand(Stringbrand) {

this.brand=brand;

}

publicDoublegetPrice() {

returnprice;

}

publicvoidsetPrice(Doubleprice) {

this.price=price;

}

@Override

publicStringtoString() {

return"Car{"+

"id="+id+

", type='"+type+'\''+

", brand='"+brand+'\''+

", price="+price+

'}';

}

在car包下新建conteoller.AutoConteoller类并打上@Controller注解

@Controller

public class AutoController {

@Autowired

private AutoServiceImpl autoService;

@RequestMapping("/findAll")

public String findAll(Integer page,Model model){

//开始分页

PageHelper.startPage(page,3);

List<Car> carList = autoService.findAll(page);

PageInfo<Car> pageInfo = new PageInfo<>(carList);

model.addAttribute("list",carList);

model.addAttribute("page",page);

return "list";

}

//添加数据

@RequestMapping("/add")

public String addCar(Car car){

autoService.addCar(car);

return "redirect:findAll";

}

//搜索

@RequestMapping("/findCarByType")

public String findCarByType(String brand,Model model){

List<Car> carList = autoService.findCarByType(brand);

model.addAttribute("list",carList);

return "list";

}

//根据id删除

@RequestMapping("/delete")

public String deleteById(Integer id){

autoService.deleteById(id);

return "redirect:findAll";

}

//跳转修改页

@RequestMapping("/alter")

public String skip(Integer id,Model model){

List<Car> carBrand = autoService.findCarById(id);

model.addAttribute("list",carBrand);

return "update";

}

//修改

@RequestMapping("/update")

public String updateCarByBrand(Car car){

autoService.updateCarByBrand(car);

return "redirect:findAll";

}

//根据id查询

public String findCarById(Integer id,Model model){

List<Car> cars = autoService.findCarById(id);

model.addAttribute("list",cars);

return "list";

}

在car包下新建srvice.AutoService接口

publicinterfaceAutoService{

//查询所有

List<Car>findAll(Integerpage);

//新增

voidaddCar(Carcar);

//根据品牌搜索

List<Car>findCarByType(Stringbrand);

//根据id删除

voiddeleteById(Integerid);

//修改

voidupdateCarByBrand(Carcar);

//根据id查询

List<Car>findCarById(Integerid);

}

在Service包下新建AutoService接口的实现类impl.AutoServiceImpl实现AutoService接口中的方法，并打上@Service注解‘

@Service

publicclassAutoServiceImplimplementsAutoService{

@Autowired(required=false)

privateAutoMapperautoMapper;

//查询所有

@Override

publicList<Car>findAll(Integerpage) {

List<Car>carList=autoMapper.findAll(page);

returncarList;

}

@Override

publicvoidaddCar(Carcar) {

autoMapper.addCar(car);

}

@Override

publicList<Car>findCarByType(Stringbrand) {

List<Car>carList=autoMapper.findCarByType(brand);

returncarList;

}

@Override

publicvoiddeleteById(Integerid) {

autoMapper.deleteById(id);

}

@Override

publicvoidupdateCarByBrand(Carcar) {

autoMapper.updateCarByBrand(car);

}

@Override

publicList<Car>findCarById(Integerid) {

List<Car>cars=autoMapper.findCarById(id);

returncars;

}

在car包下新建mapper.AutoMapper接口，并打上@Mapper注解

@Mapper

publicinterfaceAutoMapper{

@Select("select * from car")

List<Car>findAll(Integerpage);

//添加

@Insert("insert into car(brand,type,price)values(#{brand},#{type},#{price})")

voidaddCar(Carcar);

//根据品牌查询

@Select("select * from car where brand like '%${brand}%'")

List<Car>findCarByType(Stringbrand);

//根据id删除

@Delete("delete from car where id=#{id}")

voiddeleteById(Integerid);

//修改

@Update("update car set brand=#{brand},type=#{type},price=#{price} where brand=#{brand}")

voidupdateCarByBrand(Carcar);

//根据id查询

@Select("select * from car where id = #{id}")

List<Car>findCarById(Integerid);

}

新建list.jsp页面（主页面展示）

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="utf-8" %>

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

<html>

<head>

.layui-form{

display: flex;

}

.layui-btn{

margin-left: 10px;

}

.hint{

color: red;

line-height: 40px

}

.break-point{

height: 2px;

}

.layui-table th{

text-align: center;

}

.layui-table td{

text-align: center;

}

.layui-card{

background-color:#393D49;

}

.layui-card-header{

color: #01AAED;

text-align: center;

}

.page-button{

width: 30%;

display: flex;

align-items:center;

justify-content: center;

}

.main{

display: flex;

align-items:center;

justify-content: center;

}

</style>

</head>

<tbody>

</div>

</div>

</div>

</div>

</form>

</div>

<div>

<div class="hint">提示：搜索功能支持模糊查找</div>

</div>

</form>

<thead>

<tr>

</tr>

<tbody>

<c:forEach items="${list}" var="carlist">

<tr>

<td>${carlist.id}</td>

<td>${carlist.brand}</td>

<td>${carlist.type}</td>

<td>￥${carlist.price}</td>

<td>

</td>

</tr>

</c:forEach>

</tbody>

</table>

</body>

</html>

新建update.jsp页面（车辆信息修改）

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8" %>

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

<html>

<head>

.layui-form{

display: flex;

}

.layui-btn{

margin-left: 10px;

}

.layui-card{

background-color:#393D49;

}

.layui-card-header{

color: #01AAED;

text-align: center;

}

</style>

</head>

<body>

</div>

<c:forEach items="${list}" var="car">

</div>

</div>

</div>

</form>

</c:forEach>

</body>

</html>

注意：前端使用到了Layui需要的可以去Layui官网下载根据文档使用