combine UITabBarController & UINavigationController

1. add UITabBarController

2. for "Tab Bar Controller" , set first tab's controller as Navigation Controller

3. set view of first tab as "firstView.nib"

4. set first tab's view's controller as "firstViewController"

Game kit

2 functions:

(1) p2p connectivity:

create an ad-hoc Bluetooth network

(2) in-game voice

use GKSession class

not support first-generation iphone & ipod touch

each peer has a peerID

use displayNameForPeer to get peer's name

GKSessionDelegage: handle connection request

data handler: receive data from peer

3 session mode:

(1)server:

advertise sessionID

GKSessionModeServer

(2)client:

search for sessionID

(3)peer:

advertise sessionID & search for sessionID

GKSessionModePeer

sqlite

import data to table from csv file:

1. sqlite3 testDatabase

create database testDatabase

2. create table testTable(name String primary key, job String);

3. .mode csv

4. .import ./test.csv testTable

5. select * from testTable;

show content of testTable

6. drop table testTable;

delete testTable

support sqlite in project:

(1)add framework

framework location:

/Developer/Platforms/iPhoneOS.plateform/Developer/SDKs/iPhoneOS2.2.1.sdk/usr/lib/libsqlite3.0.dylib

(2) import "/usr/include/sqlite3.h"

dial phone number

[[UIApplication sharedApplication] openURL:[NSURL URLWithString:@"tel://+886223699148"]];

call 02-23699148