12 2014 档案

存储过程插入100 条数据
摘要:create proc ppas declare @n intset @n=1while @n<=100begininsert into student values('11341101320'+LTRIM(@n),'Jack'+ltrim(@n),'男',22,'上海','18272986984... 阅读全文

posted @ 2014-12-29 16:31 @冰糖 阅读(555) 评论(0) 推荐(0)

SQL 查询 之 union ,case ,group
摘要:union alluse myDBSELECT '大于20' as scope,count(*) as 人数FROM student where age>=60union all SELECT '小于20' as scope ,count(*) as 人数FROM student where ag... 阅读全文

posted @ 2014-12-17 16:47 @冰糖 阅读(301) 评论(0) 推荐(0)

Delphi 打印杨辉三角
摘要:program yanghui1;{$APPTYPE CONSOLE}uses SysUtils; var i,j,t,n:Integer; a:array[0..14,0..14] of Integer; begin write('请输入行数:'); readln(n); for i... 阅读全文

posted @ 2014-12-16 10:32 @冰糖 阅读(532) 评论(0) 推荐(0)

SQL 基础1
摘要:1 use myDB; 2 insert into student values('1134110116','Tom','男',22,'上海','18272986984','上海'); 3 insert into student values('1134110117','Tom1','男',... 阅读全文

posted @ 2014-12-11 20:09 @冰糖 阅读(241) 评论(0) 推荐(0)

Delphi 控制台程序
摘要:新建控制台程序: File--> New -->Other --> console Application 1 program Project1; 2 3 {$APPTYPE CONSOLE} 4 5 uses 6 SysUtils; 7 var 8 a,b,sum:Integer; 9 ... 阅读全文

posted @ 2014-12-10 13:43 @冰糖 阅读(486) 评论(0) 推荐(0)

ADO方式连接数据库--添删查修
摘要:程序界面:程序源码: 1 unit mydb; 2 3 interface 4 5 uses 6 Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, 7 Dialogs, DB... 阅读全文

posted @ 2014-12-09 20:31 @冰糖 阅读(284) 评论(0) 推荐(0)

备忘录(记事本)
摘要:1 unit DateTimePicker; 2 3 interface 4 5 uses 6 Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, 7 Dialogs, Co... 阅读全文

posted @ 2014-12-05 11:16 @冰糖 阅读(404) 评论(0) 推荐(0)

红绿灯模拟
摘要:1 unit TrafficLight3; 2 3 interface 4 5 uses 6 Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, 7 Dialogs, Std... 阅读全文

posted @ 2014-12-05 10:22 @冰糖 阅读(319) 评论(0) 推荐(0)

简易计算器
摘要:1 unit Unit1_test; 2 3 interface 4 5 uses 6 Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, 7 Dialogs, StdCtrls; 8 ... 阅读全文

posted @ 2014-12-02 08:48 @冰糖 阅读(236) 评论(0) 推荐(0)

导航