package com.oracle.test;
import java.io.InputStream;
import java.sql.Date;
import java.util.ArrayList;
import java.util.List;
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 com.oracle.entity.AccountInfo;
import com.oracle.mapper.AccountInfoMapper;
public class MybatisTest {
public static void main(String[] args) throws Exception {
String resource = "config/mybatis-configuration.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder()
.build(inputStream);
SqlSession session = sessionFactory.openSession();
AccountInfoMapper mapper = session.getMapper(AccountInfoMapper.class);
List<AccountInfo> accountInfoList = mapper.queryAllAccountInfo();
if (accountInfoList == null) {
System.out.println("The result is null.");
} else {
for (AccountInfo personInfo : accountInfoList) {
System.out.println(personInfo);
}
}
mapper.batchInsertAccountInfo(generateData());
session.commit();
}
static List<AccountInfo> generateData(){
List<AccountInfo> result = new ArrayList<AccountInfo>();
AccountInfo account = new AccountInfo();
account.setId(3L);
account.setUserName("zhangsanfeng");
account.setPassword("123456");
account.setGender("1");
account.setEmail("zhangsanfeng@wudang.com");
account.setCreateDate(new Date(System.currentTimeMillis()));
result.add(account);
account = new AccountInfo();
account.setId(4L);
account.setUserName("zhouzhiruo");
account.setPassword("zhangwuji");
account.setGender("0");
account.setEmail("zhouzhiruo@emei.com");
account.setCreateDate(new Date(System.currentTimeMillis()));
result.add(account);
account = new AccountInfo();
account.setId(5L);
account.setUserName("zhaomin");
account.setPassword("zhangwuji");
account.setGender("0");
account.setEmail("zhaomin@yuan.com");
account.setCreateDate(new Date(System.currentTimeMillis()));
result.add(account);
return result;
}
}