【代码片-1】 Project Perfect让Swift在服务器端跑起来－引言（一）

来源：互联网发布：mysql pid文件丢失编辑：程序博客网时间：2024/05/16 11:43
作者：u014388424----感谢原创，感谢作者！！
标签：swift 服务器端 project 模版 connector
<pre code_snippet_id="1576144" snippet_file_name="blog_20160208_1_4535071" name="code" class="plain">
import PerfectLib
import MySQL
 
 
let HOST = "你的数据库链接"
let USER = "你的帐号"
let PASSWORD = "你的密码"
let SCHEME = "你的数据库"
 
public func PerfectServerModuleInit() {
     
    Routing.Handler.registerGlobally()
    Routing.Routes["GET", ["/"]] = { (_:WebResponse) in return PerfectHandler() }
    print("\(Routing.Routes.description)")
}
 
//Create a handler for index Route
class PerfectHandler: RequestHandler {
     
    func handleRequest(request: WebRequest, response: WebResponse) {
         
        response.addHeader("Content-Type", value: "application/json")
        response.addHeader("Content-Type", value: "text/html; charset=utf-8")
         
        let mysql = MySQL()
        let connect = mysql.connect(HOST, user: USER, password: PASSWORD)
        if(connect)
        {
            let sres = mysql.selectDatabase(SCHEME)
            if(sres)
            {
                 
                let sres2 = mysql.query("SELECT name,memo FROM Info")
                 
                if(sres2)
                {
                    let results = mysql.storeResults()!
                     
                     
                     
                    if(results.numRows()==0)
                    {
                        do{
                             
                             
                            let encoder = JSONEncoder()
                            let data = try encoder.encode(["result": ""])
                            response.appendBodyString(data)
                        }
                        catch{
                            response.setStatus(500, message: "Could not create data")
                        }
                    }
                    else
                    {
                        var dataArray:Array<AnyObject> = []
                        var dict = Dictionary<String,String>()
                        while let row = results.next() {
                             
                            dict["name"]=row[0];
                            dataArray.append(dict)
                             
                        }
                         
                        print(NSJSONSerialization.isValidJSONObject(dataArray))
                         
                         
                        do {
                             
                             
                            let dataFinal = try NSJSONSerialization.dataWithJSONObject(dataArray, options:NSJSONWritingOptions(rawValue:0))
                             
                            let string = NSString(data: dataFinal, encoding: NSUTF8StringEncoding)
                             
                            let tee : String = string as! String
                            response.appendBodyString(tee)
                        }
                        catch{
                            response.setStatus(500, message: "Could not create data")
                        }
                         
                         
                         
                    }
                     
                     
                     
                     
                    results.close()
                }
            }
            mysql.close()
        }
        response.requestCompletedCallback()
    }
}
</pre>
阅读全文
0 0