package com.njupt.test;



 import java.io.InputStream;

 import java.util.HashMap;

 import java.util.List;

 import java.util.Map;







 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.junit.Test;



 import com.njupt.pojo.User;



 public class Test1 {



//查询的结果一实体的形式返回

@Test

public void test1() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


User u = session.selectOne("com.njupt.pojo.User.selectUserById","0001");


System.out.println(u.getUsername());

}


@Test

public void test6() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


session.delete("com.njupt.pojo.User.deleteUserById","0004");


session.commit();

}



@Test

public void test2() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);


SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


List<User> users = session.selectList("com.njupt.pojo.User.selectAllUsers");


for( User u : users ){

System.out.println(u.getUsername());

}

}


@Test

public void test3() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


User u = new User();

u.setId("003");

u.setUsername("liushishi2");

u.setAddress("beijing1");


int i = session.insert("com.njupt.pojo.User.insertUser",u);

   

//一定要有,否则事务还没有提交

session.commit();


//打印数据库中受影响的行数

System.out.println(i);

}



//查询结果以map的形式返回

@Test

public void test4() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);


SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


Map m  = session.selectOne("com.njupt.pojo.User.selectUserByIdForMap","003");


System.out.println(m);


}



@Test

public void test5() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);

SqlSession session = sf.openSession();


Map map = new HashMap();


map.put("id", "0004");

map.put("username1", "liuyifei1");

map.put("address", "shanghai1");


session.insert("com.njupt.pojo.User.insertUserForMap",map);


session.commit();


}


@Test

public void test7() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


User u = new User();


u.setId("003");

u.setUsername("hjd");

u.setAddress("maoming");


session.update("com.njupt.pojo.User.updateUserById",u);

session.commit();

}



@Test

public void test8() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


Map m = new HashMap();


m.put("id", "003");

m.put("username2", "hjd2");

m.put("address", "guangdong");


session.update("com.njupt.pojo.User.updateUserByIdForMap",m);

session.commit();



}


@Test

public void test9() throws Exception{

String resource = "sqlMapConfig.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);


SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


User u = new User();


u.setId("0001");

u.setAddress("guangdong");

List<User> users = session.selectList("com.njupt.pojo.User.selectUserByCondition",u);


for( User user : users){

System.out.println(user.getUsername());

}

}


@Test

public void test10() throws Exception{

String resource = "sqlMapConfig.xml";

 InputStream inputStream = Resources.getResourceAsStream(resource);


SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


User u = new User();


u.setId("0001");

 //
 u.setAddress("guangdong");

List<User> users = session.selectList("com.njupt.pojo.User.selectUserByCondition1",u);


for( User user : users){

System.out.println(user.getUsername());

}

}



@Test

public void test11() throws Exception{

String resource = "sqlMapConfig.xml";

 InputStream inputStream = Resources.getResourceAsStream(resource);


SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);


SqlSession session = sf.openSession();


User u = new User();


u.setUsername("hjd2");



List<User> users = session.selectList("com.njupt.pojo.User.selectUserByCondition1",u);


for( User user : users){

System.out.println(user.getUsername());

}

}

 }