sql 多表关联查询
create database example
use example
create table major
(
spno varchar(10) primary key not null,
spname varchar(20) not null
)
create table student
(
sno varchar(10) primary key not null,
sname varchar(10) not null,
ssex varchar(2) not null,
spno varchar(10) foreign key references major(spno)
)
create table course
( cno varchar(10) primary key not null,
cname varchar(10) not null
)
create table scourse
(
sno varchar(10) foreign key references student(sno),
cno varchar(10) foreign key references course(cno),
gmark int
)
insert into major values('001','英语')
insert into major values('002','语文')
insert into major values('003','数学')
insert into major values('004','生物')
insert into major values('005','物理')
insert into major values('006','化学')
insert into student values('2007151301','bobo','男','001')
insert into student values('2007151302','roy','男','002')
insert into student values('2007151303','max','男','004')
insert into student values('2007151304','tony','男','004')
insert into student values('2007151305','jaims','男','005')
insert into student values('2007151306','wing','男','006')
insert into student values('2007151307','allen','男','001')
insert into student values('2007151308','heng','男','002')
insert into student values('2007151309','chart','男','003')
insert into course values('001','乒乓球')
insert into course values('002','篮球')
insert into course values('003','足球')
insert into course values('004','网球球')
insert into course values('005','舞蹈')
insert into course values('006','瑜伽')
insert into course values('007','游泳')
insert into scourse values('2007151301','001','88')
insert into scourse values('2007151302','002','88')
insert into scourse values('2007151303','003','88')
insert into scourse values('2007151304','004','88')
insert into scourse values('2007151305','005','88')
insert into scourse val
相关文档：
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--每页显示记录条数
@currentpage int output,--第几页
@orderid nvarchar(50),--主键排序
@sort int,--排序方式，1表示升序，0表示降序排列
......
对http request过来的数据，凡是含有单引号，双引号，反斜线等都进行加斜线处理。防止进行注入操作。
/*
堵SQL漏洞
*/
function quotes($content){
//如果magic_quotes_gpc=Off，那么就开始处理
if (!get_magic_quotes_gpc()) {
//判断$content是否为数组
if (is_array($content)) {
//如果$content是 ......
环境搭建：
windows Mobile的开发环境的搭建这里就不说了，不明白的朋友在网上搜下即可。
步骤概述:
1：PC上的SQL SERVER 需要开启远程连接。
2：Moblie模拟器需要通过ActiveSync连接，使其能够通过PC连网。(如果是手机的话，需要能够通过无线网络连入互联网)
详细说明：
1:SQL Server 2005开启远程连 ......
--省级 Provincial
--城市 City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'北京市')
insert into Provincial values(2,'天津市')
insert into Provincial values(3,'上海市')
insert into Provincial values(4,'� ......
--省级 Provincial
--城市 City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'北京市')
insert into Provincial values(2,'天津市')
insert into Provincial values(3,'上海市')
insert into Provincial values(4,'� ......
