MyBatis 连接MySQL8，从客户表中取出数据

编写一个 MyBatis 的程序 ，从客户表中取出一条记录

数据库如图所示

INSERT INTO gds_goods VALUES (1, 2012011136, 'iPhone 13 Pro Max', 10099,'江苏省南京市','尽快发货');
INSERT INTO gds_goods VALUES (2, 2012011136, 'iPhone 12 Pro Max', 10099,'江苏省南京市','尽快发货');
INSERT INTO gds_goods VALUES (3, 2012011136, 'iPhone 11 Pro Max', 10099,'江苏省南京市','尽快发货');
INSERT INTO gds_goods VALUES (4, 2012011136, 'iPhone 12 Pro', 10099,'江苏省南京市','尽快发货');
INSERT INTO gds_goods VALUES (5, 2012011136, 'macbook', 15999,'江苏省南京市','尽快发货');
INSERT INTO gds_goods VALUES (6, 2012011136, 'MacBook Pro', 23999,'江苏省南京市','尽快发货');

mybatis根本配置

pojo

package com.yang.pojo;

public class Goods {
    private int gds_id;
    private String gds_no;
    private String gds_name;
    private Double gds_price;
    private String gds_path;
    private String gds_memo;

    public int getGds_id() {
        return gds_id;
    }

    public void setGds_id(int gds_id) {
        this.gds_id = gds_id;
    }

    public String getGds_no() {
        return gds_no;
    }

    public void setGds_no(String gds_no) {
        this.gds_no = gds_no;
    }

    public String getGds_name() {
        return gds_name;
    }

    public void setGds_name(String gds_name) {
        this.gds_name = gds_name;
    }

    public Double getGds_price() {
        return gds_price;
    }

    public void setGds_price(Double gds_price) {
        this.gds_price = gds_price;
    }

    public String getGds_path() {
        return gds_path;
    }

    public void setGds_path(String gds_path) {
        this.gds_path = gds_path;
    }

    public String getGds_memo() {
        return gds_memo;
    }

    public void setGds_memo(String gds_memo) {
        this.gds_memo = gds_memo;
    }

    @Override
    public String toString() {
        return "Goods [gds_id=" + gds_id + ", gds_no=" + gds_no + ", gds_name=" + gds_name + ", gds_price=" + gds_price + ", gds_path=" + gds_path + ", gds_memo=" + gds_memo + "]";
    }
}

查询语句mapper

 
 
    
    select * from gds_goods where gds_id = #{gds_id}
    

测试类

package com.yang.mybatis;

import com.yang.pojo.Goods;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;

import java.io.IOException;
import java.io.InputStream;

public class mybatisTest {
    @Test
    public void test() throws IOException {
        InputStream is = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(is);
        SqlSession ss = ssf.openSession();
        String statement = "com.yang.mapper.GoodsMapper.getGoods";
        Goods gds = ss.selectOne(statement, 6);
        System.out.println(gds);
        ss.close();
    }
}

如果如图所示，查询到id为6的信息