mybatis-operate-fangneng（数据库增删改查）

导入包：

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

4.0.0

<groupId>org.example</groupId>
<artifactId>mybatis-operate-fangneng</artifactId>
<version>1.0-SNAPSHOT</version>

<dependencies>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.23</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.6</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/ch.qos.logback/logback-classic -->
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>1.3.0-alpha5</version>
        <scope>test</scope>
    </dependency>
</dependencies>

新建数据库：  UserDao文件：

public interface UserDao {
User selectUserById(Integer id);
/**
* 查询所有用户信息
*
* @return
/
List selectUserList();
/*
* 新增用户信息
*
* @param user
* @return
/
int insertUser(User user);
/*
* 修改用户信息
*
* @param user
* @return
/
int updateUserById(User user);
/*
* 删除用户信息
*
* @param id
* @return
*/
int deleteUserById(Integer id);

}
User文件：

public class User {
private Integer id;

public Integer getId() {
    return id;
}

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

public String getUsername() {
    return username;
}

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

public Integer getAge() {
    return age;
}

public void setAge(Integer age) {
    this.age = age;
}

public Integer getScore() {
    return score;
}

public void setScore(Integer score) {
    this.score = score;
}

private String username;
private Integer age;

@Override
public String toString() {
    return "entity.User{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", age=" + age +
            ", score=" + score +
            '}';
}

private Integer score;

}
UserDao.xml文件：

<?xml version="1.0" encoding="UTF-8" ?> SELECT * FROM user WHERE id = #{id}

<select id="selectUserList" resultType="entity.User">
SELECT * FROM user

<insert id="insertUser" parameterType="entity.User">
INSERT INTO user VALUES (#{id},#{username},#{age},#{score})

UPDATE user SET age = #{age}, username = #{username}, score = #{score} WHERE id = #{id}

<delete id="deleteUserById">
DELETE FROM user WHERE id = #{id}

mybatis-config.xml文件： <?xml version="1.0" encoding="UTF-8" ?> UserTest文件：

@SuppressWarnings({“Duplicates”})
public class UserTest {
public static void main(String[] args) throws IOException, SQLException {
// 读取配置文件
InputStream configuration = Resources.getResourceAsStream(“mybatis-config.xml”);
// 得到 SqlSessionFactory 核心类
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
// 开始一个 sql 会话
SqlSession session = sqlSessionFactory.openSession();
// 得到 mapper
UserDao mapper = session.getMapper(UserDao.class);
// 调用通过用户id查询用户信息的方法
User user = mapper.selectUserById(1);
System.out.println(user);
// 调用查询所有用户信息的方法
List userList = mapper.selectUserList();
for(int i=1;i<userList.size();i++){
System.out.println(userList.get(i));
}
// 调用查询所有用户信息的方法
/List userListBefore = mapper.selectUserList();
for(int i=1;i<userList.size();i++){
System.out.println(userList.get(i));
}/
// 创建一个要新增的对象并赋值
User insertUser = new User();
insertUser.setId(6);
insertUser.setUsername(“anne”);
insertUser.setAge(18);
insertUser.setScore(600);
// 调用新增用户信息的方法
/* int count = mapper.insertUser(insertUser);/
// 调用查询所有用户信息的方法
/List userListAfter = mapper.selectUserList();
for(int i=1;i<userList.size();i++){
System.out.println(userList.get(i));
}/
// 调用通过用户id查询用户信息的方法
User userBefore = mapper.selectUserById(6);
System.out.println(userBefore);
/ // 把成绩改为900
userBefore.setScore(900);
// 调用修改用户信息的方法
mapper.updateUserById(userBefore);*/
// 调用通过用户id查询用户信息的方法
User userAfter = mapper.selectUserById(6);
System.out.println(userAfter);
// 调用查询所有用户信息的方法
List userListBefore = mapper.selectUserList();
for(int i=1;i<userList.size();i++){
System.out.println(userList.get(i));
}
// 调用删除用户信息的方法
int count = mapper.deleteUserById(6);
// 调用查询所有用户信息的方法
List userListAfter = mapper.selectUserList();
for(int i=1;i<userList.size();i++){
System.out.println(userList.get(i));
}
// 提交session
session.commit();
// 关闭会话
session.close();
}
}
提示：数据库新增和删除修改只能运行一次，再次运行将报错
————————————————
版权声明：本文为CSDN博主「fangnengg_」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/weixin_49149125/article/details/115318765