mybatis完成单表的全查

最新推荐文章于 2024-01-06 16:46:40 发布

liu769

最新推荐文章于 2024-01-06 16:46:40 发布

阅读量100

点赞数

分类专栏： wed 文章标签： mybatis 数据库 mysql Powered by 金山文档

本文链接：https://blog.csdn.net/liu769/article/details/129374130

版权

wed 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

1.创建数据库

判断存在即删除数据库
drop database if exists mydb;
#创建数据库
create database mydb;
#使用数据库
use mydb;
#创建表
create table t_user
(
uid int primary key auto_increment,
username varchar(20),
password varchar(20),
phone varchar(11),
address varchar(50)
);
insert into t_user(username,password,phone,address) values('张
三','666','18965423548','南阳');
insert into t_user(username,password,phone,address) values('李
四','333','18754263548','许昌');
insert into t_user(username,password,phone,address) values('小
美','123','18565234759','信阳');
select * from t_user;

2.创建Java项目导入jar包

3.创建实体类，操作的接口类。

package com.l.bean;
public class User {
    private Integer uid;
    private String username;
    private String password;
    private String phone;
    private String address;

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "uid=" + uid +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", phone='" + phone + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

package com.l.dao;

import com.l.bean.User;

import java.util.List;

public interface UserDao {
    List<User> selectAll();
}

<?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.l.dao.UserDao">
    <select id="selectAll" resultType="com.l.bean.User">
        select * from t_user;
    </select>
</mapper>

4.创建mybatis框架的核心配置文件。