Mybatis

最新推荐文章于 2023-12-09 12:00:00 发布

沐风IT

最新推荐文章于 2023-12-09 12:00:00 发布

阅读量71

点赞数

分类专栏： java mybatis 文章标签： Mybatis入门

本文链接：https://blog.csdn.net/qq_42956729/article/details/103262326

版权

java 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

mybatis

2 篇文章 0 订阅

订阅专栏

快速入门
配置文件映射：
<?xml version="1.0" encoding="UTF-8" ?>

select * from user and id=#{id} and username=#{username} and password=#{password} #{id}

SqlMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!--定义别名-->
<typeAliases>
    <typeAlias type="com.aiit.domain.User" alias="user"></typeAlias>
</typeAliases>

<!--配置数据源的环境-->
<environments default="development">
    <environment id="development">
        <transactionManager type="JDBC"></transactionManager>
        <dataSource type="POOLED">
            <property name="driver" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </dataSource>
    </environment>
</environments>

<!--加载映射文件-->
<mappers>
    <mapper resource="mapper/UserMapper.xml"></mapper>
</mappers

User类
package com.aiit.domain;

public class User {
private int id;
private String username;
private String password;

public int getId() {
    return id;
}

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

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;
}

@Override
public String toString() {
    return "com.aiit.User{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            '}';
}

}