swift « 爱好玩

FMDB

全称FMDatabase,是一个用Objective-C写的sqlite封装

下载

可以通过github下载源码包,复制src/fmdb/下所有文件到项目目录下
也可以通过CocoaPods,添加pod 'FMDB'到配置文件中

代码

在Swift项目中添加Objective-C代码,会提示添加Bridgging-Header
在Bridgging-Header.h中添加#include "FMDB.h"就像写C的头文件那样
然后Swift里就可以用FMDB的所有类了

获取DB

class func getDb() -> FMDatabase {
    let filemgr = NSFileManager.defaultManager()
    let dirPaths = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)
    let docsDir = dirPaths[0] as! String
    //数据库路径
    var databasePath = docsDir.stringByAppendingPathComponent("travel.db")
    //如果文件不存在则创建
    if !filemgr.fileExistsAtPath(databasePath) {
        let db = FMDatabase(path: databasePath)
        if db == nil {
            println("Error: \(db.lastErrorMessage())")
        }
        if db.open() {
            let sql_stmt = "CREATE TABLE IF NOT EXISTS FAVORITE (TITLE TEXT PRIMARY KEY, BOOKURL TEXT, HEADIMAGE TEXT, TEXT TEXT)"
            if !db.executeStatements(sql_stmt) {
                println("Error: \(db.lastErrorMessage())")
            }
            db.close()
        } else {
            println("Error: \(db.lastErrorMessage())")
        }
    }
    let resDb = FMDatabase(path: databasePath)
    return resDb
}

class func getDb() -> FMDatabase {

let filemgr = NSFileManager.defaultManager()

let dirPaths = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)

let docsDir = dirPaths[0] as! String

//数据库路径

var databasePath = docsDir.stringByAppendingPathComponent("travel.db")

//如果文件不存在则创建

if !filemgr.fileExistsAtPath(databasePath) {

let db = FMDatabase(path: databasePath)

if db == nil {

println("Error: \(db.lastErrorMessage())")

}

if db.open() {

let sql_stmt = "CREATE TABLE IF NOT EXISTS FAVORITE (TITLE TEXT PRIMARY KEY, BOOKURL TEXT, HEADIMAGE TEXT, TEXT TEXT)"

if !db.executeStatements(sql_stmt) {

println("Error: \(db.lastErrorMessage())")

}

db.close()

} else {

println("Error: \(db.lastErrorMessage())")

}

let resDb = FMDatabase(path: databasePath)

return resDb

}

添加数据

var db:FMDatabase = self.getDb()
db.open()
db.executeUpdate("INSERT INTO FAVORITE(TITLE,BOOKURL,HEADIMAGE,TEXT)VALUES(?,?,?,?)", withArgumentsInArray: [title,bookUrl,headImage,text])
db.close()

var db:FMDatabase = self.getDb()

db.open()

db.executeUpdate("INSERT INTO FAVORITE(TITLE,BOOKURL,HEADIMAGE,TEXT)VALUES(?,?,?,?)", withArgumentsInArray: [title,bookUrl,headImage,text])

db.close()

删除数据

var db:FMDatabase = self.getDb()
db.open()
db.executeUpdate("DELETE FROM FAVORITE WHERE TITLE = ?", withArgumentsInArray: [title])
db.close()

var db:FMDatabase = self.getDb()

db.open()

db.executeUpdate("DELETE FROM FAVORITE WHERE TITLE = ?", withArgumentsInArray: [title])

db.close()

查找数据

var db = DB.getDb()
db.open()
let rs:FMResultSet = db.executeQuery("SELECT * FROM FAVORITE", withArgumentsInArray: [])
while(rs.next()) {
    var fd = FavoriteData()
    fd.title = rs.stringForColumn("TITLE")!
    fd.headImage = rs.stringForColumn("HEADIMAGE")!
    fd.bookUrl = rs.stringForColumn("BOOKURL")!
    fd.text = rs.stringForColumn("TEXT")!
    list.append(fd)
}
db.close()

var db = DB.getDb()

db.open()

let rs:FMResultSet = db.executeQuery("SELECT * FROM FAVORITE", withArgumentsInArray: [])

while(rs.next()) {

var fd = FavoriteData()

fd.title = rs.stringForColumn("TITLE")!

fd.headImage = rs.stringForColumn("HEADIMAGE")!

fd.bookUrl = rs.stringForColumn("BOOKURL")!

fd.text = rs.stringForColumn("TEXT")!

list.append(fd)

}

db.close()

Enjoy it!

找回了一点写后端的感觉,呕吼吼吼

这个问题一开始困扰了我一段时间

原因是Swift继承@protocol的时候颜色会和Swift里NSObjectProtocol的颜色不一样

我以为不能继承了

首先在Bridge-Header.h里(没有的话,创建一个Objective-C的类,会提示创建,再删除OC的类就可以了)

#import "WeiboSDK.h"

1	#import "WeiboSDK.h"

然后在Swift里就能正确出现代码提示了

继承protocol这么写

class AppDelegate: UIResponder, UIApplicationDelegate,WeiboSDKDelegate

1	class AppDelegate: UIResponder, UIApplicationDelegate,WeiboSDKDelegate

注意一点,要把实现也写上,否则Swift编译是不通过的

根据OC版本的SDK,翻译成Swift

    func application(application: UIApplication!, didFinishLaunchingWithOptions launchOptions: NSDictionary!) -> Bool {
        // Override point for customization after application launch.
        WeiboSDK.enableDebugMode(true);
        WeiboSDK.registerApp(APPID);
        return true
    }
    
    func application(application: UIApplication, openURL url: NSURL, sourceApplication: String, annotation: AnyObject?) -> Bool {
        return WeiboSDK.handleOpenURL(url, delegate: self)
    }
    
    func didReceiveWeiboRequest(request: WBBaseRequest!) {
        if (request.isKindOfClass(WBProvideMessageForWeiboRequest)) {
            //TODO: sth
        }
    }

    func didReceiveWeiboResponse(response: WBBaseResponse!) {
        if (response.isKindOfClass(WBSendMessageToWeiboResponse)) {
            var message = "响应状态:(response.statusCode.toRaw())n响应UserInfo数据:(response.userInfo)n原请求UserInfo数据:(response.requestUserInfo)"
            var alert = UIAlertView(title: "发送结果", message: message, delegate: nil, cancelButtonTitle: "确定")
            alert.show()
        } else if (response.isKindOfClass(WBAuthorizeResponse)) {
            var message = "响应状态: (response.statusCode.toRaw())nresponse.userId: ((response as WBAuthorizeResponse).userID)nresponse.accessToken: ((response as WBAuthorizeResponse).accessToken)n响应UserInfo数据: (response.userInfo)n原请求UserInfo数据: (response.requestUserInfo)"
            var alert = UIAlertView(title: "认证结果", message: message, delegate: nil, cancelButtonTitle: "确定")
            alert.show()
        }
    }

func application(application: UIApplication!, didFinishLaunchingWithOptions launchOptions: NSDictionary!) -> Bool {

// Override point for customization after application launch.

WeiboSDK.enableDebugMode(true);

WeiboSDK.registerApp(APPID);

return true

}

func application(application: UIApplication, openURL url: NSURL, sourceApplication: String, annotation: AnyObject?) -> Bool {

return WeiboSDK.handleOpenURL(url, delegate: self)

}

func didReceiveWeiboRequest(request: WBBaseRequest!) {

if (request.isKindOfClass(WBProvideMessageForWeiboRequest)) {

//TODO: sth

}

func didReceiveWeiboResponse(response: WBBaseResponse!) {

if (response.isKindOfClass(WBSendMessageToWeiboResponse)) {

var message = "响应状态:(response.statusCode.toRaw())n响应UserInfo数据:(response.userInfo)n原请求UserInfo数据:(response.requestUserInfo)"

var alert = UIAlertView(title: "发送结果", message: message, delegate: nil, cancelButtonTitle: "确定")

alert.show()

} else if (response.isKindOfClass(WBAuthorizeResponse)) {

var message = "响应状态: (response.statusCode.toRaw())nresponse.userId: ((response as WBAuthorizeResponse).userID)nresponse.accessToken: ((response as WBAuthorizeResponse).accessToken)n响应UserInfo数据: (response.userInfo)n原请求UserInfo数据: (response.requestUserInfo)"

var alert = UIAlertView(title: "认证结果", message: message, delegate: nil, cancelButtonTitle: "确定")

alert.show()

}

最后在合适的地方调用

    // MARK: - 微博登录按钮
    @IBAction func onWeiboLoginClick(sender: AnyObject) {
        var request: WBAuthorizeRequest! = WBAuthorizeRequest.request() as WBAuthorizeRequest
        request.redirectURI = "https://api.weibo.com/oauth2/default.html"
        request.scope = "all"
        
        WeiboSDK.sendRequest(request)
    }

// MARK: - 微博登录按钮

@IBAction func onWeiboLoginClick(sender: AnyObject) {

var request: WBAuthorizeRequest! = WBAuthorizeRequest.request() as WBAuthorizeRequest

request.redirectURI = "https://api.weibo.com/oauth2/default.html"

request.scope = "all"

WeiboSDK.sendRequest(request)

}

微博SDK集成登录功能就做好了

直接上代码

let task = NSTask()
task.launchPath = "/bin/echo"
task.arguments = ["first-argument", "second-argument"]

let pipe = NSPipe()
task.standardOutput = pipe
task.launch()

let data = pipe.fileHandleForReading.readDataToEndOfFile()
let output: String = NSString(data: data, encoding: NSUTF8StringEncoding)

print(output)

let task = NSTask()

task.launchPath = "/bin/echo"

task.arguments = ["first-argument", "second-argument"]

let pipe = NSPipe()

task.standardOutput = pipe

task.launch()

let data = pipe.fileHandleForReading.readDataToEndOfFile()

let output: String = NSString(data: data, encoding: NSUTF8StringEncoding)

print(output)

在swift里可以轻松调用objective-c的类

已经在目录下新建了一个setting.plist

let settingPath = NSBundle.mainBundle().pathForResource("setting", ofType: "plist")
let settingDict = NSDictionary(contentsOfFile: settingPath)
let namesStr = settingDict.objectForKey("lang_names")

let settingPath = NSBundle.mainBundle().pathForResource("setting", ofType: "plist")

let settingDict = NSDictionary(contentsOfFile: settingPath)

let namesStr = settingDict.objectForKey("lang_names")

首先创建一个iOS Application 选择Single View Application

ViewController.swift代码如下

import UIKit

class ViewController: UIViewController {
    
    @IBOutlet var wv:UIWebView
    
    override func viewDidLoad() {
        super.viewDidLoad()
        wv.loadRequest(NSURLRequest(URL:NSURL(string:"http://www.superyyl.com")))
    }

    override func didReceiveMemoryWarning() {
        super.didReceiveMemoryWarning()
    }
}

import UIKit

class ViewController: UIViewController {

@IBOutlet var wv:UIWebView

override func viewDidLoad() {

super.viewDidLoad()

wv.loadRequest(NSURLRequest(URL:NSURL(string:"http://www.superyyl.com")))

}

override func didReceiveMemoryWarning() {

super.didReceiveMemoryWarning()

}

在Main.storyboard里,拖入一个Web View

然后将WebView和ViewController里的wv,通过Referencing Outlets连接起来

使@IBOutlet var wv:UIWebView旁边的圆点变成实心的

接着运行,就可以看到模拟器里的WebView成功载入网页了

定义class

class Hi {
    func sayHi(){
        println("Hi superyyl")
    }
}

class Hi {

func sayHi(){

println("Hi superyyl")

}

实例化

var hi = Hi()

1	var hi = Hi()

调用类方法

hi.sayHi()//Hi superyyl

1	hi.sayHi()//Hi superyyl

继承

class Hello:Hi {   
}

1 2	class Hello:Hi { }

调用继承方法

var h = Hello()
h.sayHi()//Hi superyyl

1 2	var h = Hello() h.sayHi()//Hi superyyl

重写方法

class Hello:Hi {
    override func sayHi() {
        println("Hello superyyl")
    }
}

var h = Hello()
h.sayHi()//Hello superyyl

class Hello:Hi {

override func sayHi() {

println("Hello superyyl")

}

var h = Hello()

h.sayHi()//Hello superyyl

构造方法和成员变量

class Hello:Hi {
    var _name:String
    
    init(name:String) {
        println("Init Hello")
        self._name = name
    }
    
    override func sayHi(){
        println("Hello (self._name)")
    }
}

var h = Hello(name:"ZhangSan")
h.sayHi()//Hello ZhangSan

class Hello:Hi {

var _name:String

init(name:String) {

println("Init Hello")

self._name = name

}

override func sayHi(){

println("Hello (self._name)")

}

var h = Hello(name:"ZhangSan")

h.sayHi()//Hello ZhangSan

需要注意的是,传参数和OC一样,需要有个标签

没有返回值的调用

func sayHello(name:String) {
    println("Hello (name)")
}
sayHello("superyyl")//Hello superyyl

func sayHello(name:String) {

println("Hello (name)")

}

sayHello("superyyl")//Hello superyyl

多个返回值的调用

func getNums()->(Int,Int) {
    return (2,3)
}
let (a,b) = getNums()
println("a=(a),b=(b)")//a=2,b=3

func getNums()->(Int,Int) {

return (2,3)

}

let (a,b) = getNums()

println("a=(a),b=(b)")//a=2,b=3

函数也是类型,可以赋值

var fun = sayHello
fun("World")//Hello World

1 2	var fun = sayHello fun("World")//Hello World

输出所有偶数

for index in 0..100 {
    if index % 2 == 0 {
        println(index) //输出所有偶数
    }
}

for index in 0..100 {

if index % 2 == 0 {

println(index) //输出所有偶数

}

判断myName是否为空

var myName:String? = "superyyl"
myName = nil

if let name = myName {
    println("Hello (name)")
}

var myName:String? = "superyyl"

myName = nil

if let name = myName {

println("Hello (name)")

}

关于教程里的”?”我是没看懂,找啊找,于是发现了这篇文章<Swift之?和!>

一下子解决了好多疑问

简单的for循环

var arr = String[]()
for index in 0..100{
    arr.append("Item(index)")
}
println(arr)

var arr = String[]()

for index in 0..100{

arr.append("Item(index)")

}

println(arr)

遍历数组

for value in arr{
    println(value)
}

for value in arr{

println(value)

}

while循环遍历

var i = 0
while i<arr.count{
    println(arr[i])
    i++
}

var i = 0

while i<arr.count{

println(arr[i])

i++

}

遍历字典

var dict = ["name":"superyyl","age":"16"]
for (key,value) in dict{
    println("(key),(value)")
}
/*
name,superyyl
age,16
*/

var dict = ["name":"superyyl","age":"16"]

for (key,value) in dict{

println("(key),(value)")

}

name,superyyl

age,16

字典就相当于OC里的NSDictionary,根据视频里的例子

var dict = ["name":"superyyl","age":"16"]
dict["sex"] = "Female"
println(dict)//[sex: Female, name: superyyl, age: 16]
println(dict["name"])//superyyl

var dict = ["name":"superyyl","age":"16"]

dict["sex"] = "Female"

println(dict)//[sex: Female, name: superyyl, age: 16]

println(dict["name"])//superyyl

好吧,这里说一下我遇到的一个问题

var dict = ["name":"superyyl","age":16]
println(dict)
/*
{
    age = 16;
    name = superyyl;
}
*/
dict["sex"] = "Female" //error:Cannot assign to the result of the Expression

var dict = ["name":"superyyl","age":16]

println(dict)

{

age = 16;

name = superyyl;

}

dict["sex"] = "Female" //error:Cannot assign to the result of the Expression

我觉得我既然开始时候没指定dict的value类型,就应该让我随便添加,我认为这应该算是个bug吧,不知道苹果是怎么考量的,为什么混合的value类型就不允许添加

一	二	三	四	五	六	日
« 1月
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

爱好玩

Stay Hungry, Stay Foolish.

Tag Archives: swift

[Swift]FMDatabase的使用

FMDB

下载

代码

获取DB

添加数据

删除数据

查找数据

Enjoy it!

[Swift]集成WeiboSDK登录功能

[Swift]在Swift里执行Shell命令

[Swift]读取plist文件

[Swift]开发iOS项目

[Swift]面向对象

[Swift]函数

[Swift]流程控制

[Swift]循环

[Swift]字典