mybaits

这节课我们学习了mybatis，先建几个文件，如下图：

在User里输入以下代码：
package com.zhongruan.bean;

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 "User{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            '}';
}

}

在IUserDao输入以下代码：
package com.zhongruan.dao;

import com.zhongruan.bean.User;

import java.util.List;

public interface IUserDao {
List findAll();
void deleteById (int id);
void updateById(User user);

}

在UserMapper1输入以下代码：

<?xml version="1.0" encoding="UTF-8"?> select * from tb_user delete from tb_user where id=#{id} update tb_user set username=#{username},password=#{password} where id=#{id};

在Test输入以下代码:
package com.zhongruan.test;

import com.zhongruan.bean.User;
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.apache.ibatis.session.defaults.DefaultSqlSessionFactory;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

public class Test {
public static void main(String[] args) throws IOException {
Reader reader= Resources.getResourceAsReader(“sqlMapConfig .xml”);
SqlSessionFactory build=new SqlSessionFactoryBuilder().build(reader);
SqlSession session=build.openSession();
// List users=session.selectList(“findAll”);
// System.out.println(users);

// session.delete(“deleteById”,1);
// session.commit();
// session.close();
User user=new User();
user.setId(21);
user.setUsername(“32”);
user.setPassword(“12”);
session.update(“updateById”,user);
session.commit();
session.close();

    };

}

在sqlMapConfig输入以下代码：

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

在index中输入以下代码：
<%–
Created by IntelliJ IDEA.
User: 虫仔0621
Date: 2019/10/11
Time: 8:50
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

$END$