/**
   * @Title: main @Description: TODO
   *
   * @param @param args
   * @return void
   * @throws
   */
  public static void main(String[] args) {
    // TODO Auto-generated method stub
    UserInfoDao userInfoDao = new UserInfoDao();
    // Update Test
    UserInfoEntity userInfo = new UserInfoEntity();
    userInfo.setUID("UID20130828001");
    // userInfo.setPassword("Password");

    userInfoDao.UpdateTest(userInfo);
    System.out.println("*************After Update Data***************\r\n");
    ArrayList<UserInfoEntity> userInfoSels = (ArrayList<UserInfoEntity>) userInfoDao.SelectTest();
    // printUserInfos(userInfoSels);

    // SelectTest();

    userInfoSels = (ArrayList<UserInfoEntity>) userInfoDao.SelectTest();
    System.out.println("*************Before Delete Data***************\r\n");
    // printUserInfos(userInfoSels);

    userInfoDao.DeleteTest();
    userInfoSels = (ArrayList<UserInfoEntity>) userInfoDao.SelectTest();
    System.out.println("*************After Delete Data****************\r\n");
    // printUserInfos(userInfoSels);

    ArrayList<UserInfoEntity> userInfoInserts = createUserInfos(10);
    System.out.println("*****************Insert Data******************\r\n");
    // printUserInfos(userInfoInserts);

    long l1 = System.currentTimeMillis();
    for (UserInfoEntity userInfoIns : userInfoInserts) {
      userInfoDao.InsertTest(userInfoIns);
    }
    long l2 = System.currentTimeMillis();
    userInfoInserts = (ArrayList<UserInfoEntity>) userInfoDao.SelectTest();
    System.out.println(
        "****************After Insert Data***************\r\n " + userInfoInserts.size());
    // printUserInfos(userInfoInserts);

    System.out.println((l2 - l1) / 1000.000 + "s");
  }