-w-

NKUCodingCat · NKUCodingCat · commit 7b6f8b0dd1d4 · 2015-02-14T20:00:23.000+08:00
diff --git a/NKUCodingCat/0024/0024.sql b/NKUCodingCat/0024/0024.sql
@@ -0,0 +1,63 @@
+﻿# SQL-Front 5.1  (Build 4.16)
+
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
+/*!40101 SET SQL_MODE='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
+/*!40103 SET SQL_NOTES='ON' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
+/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
+
+
+# Host: localhost    Database: 0024
+# ------------------------------------------------------
+# Server version 5.5.38
+
+DROP DATABASE IF EXISTS `0024`;
+CREATE DATABASE `0024` /*!40100 DEFAULT CHARACTER SET utf8 */;
+USE `0024`;
+
+#
+# Source for table code
+#
+
+DROP TABLE IF EXISTS `code`;
+CREATE TABLE `code` (
+  `id` int(20) NOT NULL DEFAULT '0',
+  `to` text NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+#
+# Dumping data for table code
+#
+
+LOCK TABLES `code` WRITE;
+/*!40000 ALTER TABLE `code` DISABLE KEYS */;
+/*!40000 ALTER TABLE `code` ENABLE KEYS */;
+UNLOCK TABLES;
+
+#
+# Source for table max
+#
+
+DROP TABLE IF EXISTS `max`;
+CREATE TABLE `max` (
+  `pro` varchar(255) DEFAULT NULL,
+  `max` int(11) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+#
+# Dumping data for table max
+#
+
+LOCK TABLES `max` WRITE;
+/*!40000 ALTER TABLE `max` DISABLE KEYS */;
+INSERT INTO `max` VALUES ('max',0);
+/*!40000 ALTER TABLE `max` ENABLE KEYS */;
+UNLOCK TABLES;
+
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
diff --git a/NKUCodingCat/0024/SQLIO.py b/NKUCodingCat/0024/SQLIO.py
@@ -0,0 +1,22 @@
+import time, os, json, MySQLdb, HTMLParser, cgi
+def SQL_init():
+	db = MySQLdb.connect("127.0.0.1","root","root","0024" )
+	return db.cursor()
+def SQL_max(new=None):
+	cursor = SQL_init()
+	if new != None
+		sql="""UPDATE `max` SET `max`=%d WHERE `pro`='max'"""%new
+		cursor.execute(sql)
+		return True
+	else:
+		sql="""SELECT * FROM `max` WHERE `pro`='max'"""
+		cursor.execute(sql)
+		return cursor.fetchall()[0][1]
+def SQL_in(task):
+	max = SQL_max()
+	
+def SQL_out():
+	cursor = SQL_init()
+	sql = """SELECT * FROM `code`"""
+	cursor.execute(sql)
+	return cursor.fetchall()
diff --git a/NKUCodingCat/0024/main.py b/NKUCodingCat/0024/main.py
@@ -89,10 +89,10 @@
 """
 
 
-from bottle import static_file,route, run, post, request, redirect
+from bottle import static_file,route, run, post, request, redirect, error
 import os,  urllib,re,json,time
 Root = os.path.split(os.path.realpath(__file__))[0]+"/static/"
-
+import SQLIO
 
 @route('/todo')
 def index():
@@ -105,5 +105,19 @@ def Accept():
 	for i in L:
 		A = re.split("=",i)
 		M[A[0]] = urllib.unquote(A[1])
-	return json.dumps(M)
+	for j in M.keys():
+		if re.findall("id-",j):
+			return "Delete",j[3:]
+	try:
+		type = M["new"]
+		newtask = M["newtask"]
+		if newtask != "":
+			return newtask
+		else:
+			return "=.=所以你想添加什么任务呀"
+	except:
+		return "虽然不知道你在干什么但是触发了服务器错误呢"
+@route('/error')
+def err():
+	return "虽然不知道你在干什么但是触发了服务器错误呢"
 run(host='localhost',port=8080)
