package cn.hncu.domain;
public class User {
private String id;
private String name;
private String pwd;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";
}
}
User的映射文件User.xml(最简单的配置文件)
package cn.hncu.domain;
import java.util.List;
public interface UserMapper {
public List all();
public List user2(String string);
public List user3(User user);
}
UserMapper.java(接口,官方建议使用接口方式----更安全)
package cn.hncu.domain;
import java.util.List;
public interface UserMapper {
public List all();
public List user2(String string);
public List user3(User user);
}
Demo1.java
package cn.hncu.demo;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import cn.hncu.domain.User;
import cn.hncu.domain.UserMapper;
import cn.hncu.utils.SqlSessionUtils;
public class Demo1 {
@Test
public void test1(){
//先获取SqlSession
SqlSession s=SqlSessionUtils.getSqlSession();
List list=s.selectList("users.all");//返回结果用list封装,参数用id来指定使用映射文件中的哪一段,
User2.xml
<?xml version="1.0" encoding="UTF-8" ?>
select * from users
select * from users where id=#{xx}
select * from users where id=#{id}
and name=#{name}
select * from users
select * from users where id=#{id}
and name=#{name}