- 博客(98)
- 收藏
- 关注
RSS订阅原创 Angular-JS初见
!DOCTYPE html> html> head> meta charset="utf-8"> script src="http://apps.bdimg.com/libs/angular.js/1.4.6/angular.min.js">/script> /head> body> div ng-app=""><!--div 是anjs的所有着--> p>名字 :
2016-02-05 14:13:41
430
转载 拿来老外的 layoutSubviews
init does not cause layoutSubviews to be called (duh) addSubview: causes layoutSubviews to be called on the view being added, the view it’s being added to (target view), and all the subviews of
2015-06-10 16:53:51
465
原创 sql 标量子查询
返回结果只有一行的查询叫标量子查询. SELECT shohin_mei shohin_bunrui FROM Shohin WHERE hanbai_tanka > (SELECT AVG(hanbai_tanka) FROM Shohin); 标量子查询可以和列一样 mysql> SELECT shohin_id ,shohin_mei,shohin_bunrui,\
2015-03-02 18:19:59
6591
原创 sql VIEW
mysql> CREATE VIEW ShohinSum (shohin_bunrui,cnt_shohin)\ -> AS\ -> SELECT shohin_bunrui,COUNT(*) \ -> FROM Shohin \ -> GROUP BY shohin_bunrui; mysql> SELECT shohin_b
2015-03-01 18:33:51
404
原创 sql 事务
UPDATE Shohin SET torokubi = '2009-09-01'; START TRANSACTION COMMIT; ROLLBACK; DELETE FROM Shohin;---清空表数据
2015-03-01 18:32:37
374
原创 sql 排序
SELECT hanbai_tanka,shiire_tanka FROM Shohin ORDER BY hanbai_tanka ASC,shiire_tanka ASC; DESC ASC 修饰不同的列. 含有NULL的会在开头或者结尾汇总，因为NULL是不能运算的。
2015-03-01 13:52:49
349
原创 HAVING 子句
mysql> SELECT shohin_bunrui,COUNT(*) FROM Shohin GROUP BY shohin_bunrui HAVING COUNT(*)=2; SELECT shohin_bunrui ,COUNT(*) FROM Shohin GROUP BY shohin_bunrui; SELECT shohin_bunrui,COUNT(*) FR
2015-03-01 13:33:03
440
原创 SQL聚合函数
SELECT COUNT(shohin_mei) FROM Shohin;--去掉NULL值 SELECT SUM(shiire_tanka) FROM Shohin ; SELECT MAX(shiire_tanka) FROM Shohin; SELECT MIN(shiire_tanka) FROM Shohin; SELECT AVG
2015-02-14 15:55:33
408
原创 sql 运算
mysql> SELECT shohin_mei,shohin_bunrui,hanbai_tanka,hanbai_tanka*2 AS "hanbai_tanka*2" FROM Shohin; sql 常用的运算符 +-*/ 包含NULL的运算结果是NULL SELECT (100+200)*3 AS keisan;--比较洋的写法 常用的比较运算符
2015-02-10 12:42:56
544
原创 sql查询
SELECT ID AS AID FROM TABLE SELECT DISTINCT shohin_bunrui FROM Shohin;//去重 SELECT shohin_mei ,shohin_bunrui FROM Shohin WHERE hanbai_tanka > 200; mysql> /* 注释 /*> 也是注释 /*>
2015-02-10 11:24:20
348
原创 table 操作
drop 删除表. ALTER TABLE ADD COLUMN varchar(100) ALTER TABLE DROP COLUMN
2015-02-09 13:14:39
409
原创 数据库语言划分
1 数据定义语言DDL CREATE 创建库表 DROP 删除库表 ALERT 更新库表 2 数据操作语言 DML SELECT 查询语言 INSERT 插入语言 UPDATE 更新 DELETE 删除 3 流程控制语言 COMMIT 提交 ROLLBACK 取消操作
2015-02-09 10:44:06
334
转载 git branch
分支开发原则： 如果本地dev分支有修改，则需要先切换到master分支，把本地分支的修改merge回master（git merge dev），然后在master上把合并后的内容push到master上；然后再切换回本地分支，再把master的内容merge回分支，然后就继续在分支开发。 开发流程： // 查看本地分支 git branch // 显
2014-12-09 17:57:19
542
转载 断点续传
fileHandle = [NSFileHandle fileHandleForWritingAtPath:temporaryPath]; offset = [fileHandle seekToEndOfFile]; NSString *range = [NSString stringWithFormat:@"bytes=%llu-",offset];
2014-05-22 18:03:22
462
原创 objc_message
http://www.cppblog.com/kesalin/archive/2011/08/15/objc_message.html
2014-05-22 17:06:29
467
转载 老外写的coreimage
http://www.raywenderlich.com/22167/beginning-core-image-in-ios-6
2014-05-20 11:06:30
507
转载 捕捉异常
void UncaughtExceptionHandler(NSException *exception) { NSArray *arr = [exception callStackSymbols]; NSLog(@"arr=:%@",arr); NSString *reason = [exception reason]; NSLog(@
2014-05-16 12:03:47
429
转载 cocoaGCD别人整理
http://www.cocoachina.com/applenews/devnews/2014/0428/8248.html
2014-05-16 07:52:36
412
转载 block使用
http://tanqisen.github.io/blog/2013/04/19/gcd-block-cycle-retain/
2014-05-15 12:15:56
366
转载 wangyouzhengli
http://blog.csdn.net/wzzvictory/article/details/8629036
2014-05-15 08:01:16
368
转载 gcd并行串行
http://www.cnblogs.com/touchme/archive/2012/05/14/2499630.html
2014-05-15 00:04:43
453
转载 runtime 机制
如您所见，NSObject的对象非常之简单，Class 类型的，我们再看Class 是什么: #include // for __DARWIN_NULL #include #include typedef struct objc_class *Class; typedef struct objc_object { Class isa; } *id;
2014-05-14 13:49:34
580
转载 setget方法
@property (retain) Object obj; ? 1 2 3 4 5 6 7 8 9 10 - (Object *)obj { return _obj; } - (void)setObj:(Object *)new
2014-05-09 15:00:46
522
转载 坐标转换
// controllerA 中有一个UITableView, UITableView里有多行UITableVieCell，cell上放有一个button // 在controllerA中实现: CGRect rc = [cell convertRect:cell.btn.frame toView:self.view]; // 或 CGRect rc = [self.view conver
2014-05-03 15:46:48
621
转载 getAttributedStringHeightWithString
- (int)getAttributedStringHeightWithString:(NSAttributedString *) string WidthValue:(int) width { int total_height = 0; CTFramesetterRef framesetter = CTFramesetterCreateWithAt
2014-04-18 09:45:22
946
原创 NSRegularExpression
NSString *parten = @"#([^\\#]+)#"; NSError* error = NULL; NSRegularExpression* regex = [[NSRegularExpression alloc] initWithPattern:parten
2014-04-17 15:19:32
479
原创 存取文件高手绕道
BOOL saved = [NSKeyedArchiver archiveRootObject:object toFile:filePath]; if (!saved) { DLOG(@"file at %@ save failed", filePath) }
2014-04-15 15:52:33
420
原创 雕虫
int [] myarray = {3,1,6,2,9,0,7,4,5,8}; int temp; for (int i = 0; i length; i++) { for (int j = 0; j length-1-i; j++) { if (myarray[j]>myarray[j+1]) { temp = myarray[j];
2014-04-12 16:47:36
468
原创 雕虫小技
typedef struct { unsigned short header; unsigned int contents; unsigned short tail; } msg; ... msg *pmsg; pmsg = (msg *)malloc(sizeof(msg)); memcpy(pmsg, &source ,sizeof(msg));
2014-04-01 12:37:19
462
原创 yaoxue shenyao
登陆http://mail.126.com/，用户名：shenyao2014@126.com，密码：shenyao
2014-03-16 15:01:44
1038
原创 静态地图
http://api.map.baidu.com/staticimage?center=116.403874,39.914889&width=400&height=300&zoom=15&markers=116.403874,39.914889&markerStyles=-1,http://api.map.baidu.com/images/marker_red.png,-1,23,25
2014-03-10 17:17:05
784
转载 __block typeof(self) bself = self;
block对于其变量都会形成strong reference，对于self也会形成strong reference ，而如果self本身对block也是 strong reference 的话，就会形成 strong reference 循环，造成内存泄露，为了防止这种情况发生，在block外部应该创建一个week（__block） reference。 所以在block内如果有self
2014-01-21 18:21:24
1852
转载 weak
The difference is that an object will be deallocated as soon as there are no strong pointers to it. Even if weak pointers point to it, once the last strong pointer is gone, the object will be dealloca
2014-01-16 10:16:48
520
转载 NSdate时间转换问题
使用NSDateFormatter转换时间字符串时，默认的时区是系统时区，如我们使用一般都是北京时间(＋8)， 如果直接使用 [cpp] view plaincopyprint? [dateFormatter dateFromString:@"2012-01-01 00:00:00"]; 你会发现实际转换为2011－12－31 16：00
2013-12-10 10:44:56
530
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人