20220628_MyBatis_数据库增删改查练习(一)

最新推荐文章于 2023-02-03 15:44:47 发布

VIP文章 PeterWarne

最新推荐文章于 2023-02-03 15:44:47 发布

阅读量156

点赞数

分类专栏： JavaWeb 数据库文章标签： mybatis 数据库 java

本文链接：https://blog.csdn.net/clarkgable/article/details/125509927

版权

先建一个表

show databases ;
use mybatis;

drop table if exists brand;
create table brand
(
    id           int primary key auto_increment,
    brand_name   varchar(20),
    company_name varchar(20),
    ordered      int, -- 用于将来手动排序
    description  varchar(100),
    status       int  -- 0 禁用 1 启用
);

insert into brand(brand_name, company_name, ordered, description, status)
values ('jia_duo_bao', 'herbal_tea_limited', 5, 'you do not burning inside', 0),
       ('huawei', 'huawei_honor', 10, 'connecting something', 1),
       ('xiaomi', 'lei_xiaomi', 20, 'are_you_ok', 1);

select *
from brand;

请添加图片描述

文章目录

一.查询所有
建一个brand类

package com.diy.pojo;

public class Brand {
   
    private Integer id;
    private String brandName;
    private String companyName;
    private Integer ordered;
    private String description;
    private Integer status;

    public Integer getId() {
   
        return id;
    }

    public void setId(Integer id) {
   
        this.id = id;
    }

    public String getBrandName() {
   
        return brandName;
    }

    public void setBrandName(String brandName) {
   
        this.brandName = brandName;
    }

    public String getCompanyName() {
   
        return companyName;
    }

    public void setCompanyName(String companyName) {
   
        this.companyName = companyName;
    }

    public Integer getOrdered() {
   
        return ordered;
    }

    public void setOrdered(Integer ordered) {
   
        this.ordered = ordered;
    }

    public String getDescription() {
   
        return description;