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(最简单的配置文件)
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
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}