2016年11月_倩倩之

原创 SQL第十三章QQ

--向QQUser表插入数据INSERT INTO QQUser(QQID,PassWord,lastLogTime,Online,Level) VALUES(54789625,'add512#&','2013-02-16 17:01:35',2,1)INSERT INTO QQUser(QQID,PassWord,lastLogTime,Online,Level) VAL

2016-11-27 17:17:33 7010

原创 SOL第十一章上机题1-5

--使用分组查询学生相关信息SELECT SUM(ClassHour)AS 总课时 FROM [Subject] GROUP BY GradeId ORDER BY SUM(ClassHour) SELECT StudentNo AS 学号,AVG(StudentResult) AS 学员平均分 FROM Result GROUP BY StudentNoSELECT SubjectId A

2016-11-25 14:17:51 790

原创 SQL第十章模糊查询和聚合函数上机题1-2

//使用模糊查询查询学生相关信息SELECT StudentName,Phone,Address FROM Student WHERE StudentName LIKE '%山东%'SELECT SubjectName,ClassHour,GradeId FROM Subject WHERE SubjectName LIKE'%数据库%' ORDER BY GradeIdSELECT Stu

2016-11-23 13:54:56 2536 1

原创 SQL第九章数据查询基础上机题1-4

//查询学生相关基本信息SELECT * FROM Student WHERE GradeId=1 SELECT StudentName,Phone FROM Student WHERE GradeId=2 SELECT StudentName+Phone FROM Student WHERE GradeId=2 SELECT * FROM Student WHERE GradeId=

2016-11-22 17:18:00 6040

原创 SQL第八章用SQL操作数据上机题1-7

//修改记录USE MySchool--修改学号为S1201302004学生的住址为“山东省济南市文化路1号院”。UPDATE Student SET Address='山东省济南市文化路1号院' WHERE StudentNo='S1201302004'--修改学号为S1201302005学生的所属年级为2。UPDATE Student SET GradeId=2 WHERE St

2016-11-20 18:01:31 4509

原创 c#第五章指导学习:库存管理

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace ConsoleApplication3{ class Goods { private string _goods

2016-11-15 17:34:29 8103 1

原创 c#第四章深入String类上机题2

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace ConsoleApplication2{ class User { public void showName()

2016-11-15 14:37:54 4094

原创 c#第三章上机题2-3

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace ConsoleApplication2{ class Data {

2016-11-11 17:22:50 4892

原创 c#第三章升级属性MyBank

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace ConsoleApplication1{ class User { public string _name;

2016-11-11 17:16:00 9309

原创 c#第二章上机题1-4-----------MYBNAK

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace MyBank{ /// /// 帐户类 /// public class User { #region 成员变量 ///

2016-11-08 17:19:43 3216

原创冒泡排序

package com.gd.text;import java.util.Random;public class BubbleSort { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub int[] arr=new

2016-11-05 14:50:18 295 1

qq_36074113的博客