做一个User表:
Id username password roleId
能够实现对User表的持久化操作 进行 增 删 改 查操作 CURD
使用 mybatis Jdbc statement preparedStatement写测试 测试这五个方法:
Public User query(String id);
Public List query(String username) 模糊查询
Public void update()
Public void insert()
Public void delete()
接口:
package com.self.mapper;
import com.self.pojo.User;
import java.util.List;
public interface UserMapper {
public User query(String id);
public User queryByName(String name);
public List<User> queryAll();
public void updateById(User use);
public void insert(User user);
public void deleteById(String id);
}
User:
package com.self.pojo;
import org.apache.ibatis.type.Alias;
@Alias("user")
public class User {
priv