POP实训报告.doc

poppoppop-poppoppoppoppoppoppop poppoppoppoppoppoppoppoppoppoppop pop1(1)(2)2(1)(2)23poppoppop(1)(2)pop. poppoppoppoppop080806051472010.12.19 pop poppop poppoint of purchasepoppoppoppop 76 1. pop 2.3. pop 1 1. 2. 3. 1 1 2 31. 2. 3. 12. 3. ; 4 5 61. 2.3. 1. 2. 3. 4. 5. . 2 . 2 . 4 . 5 . 6 . 7 . 7 . 7 . 8 . 9 . 9 . 10 . 11 . 12 . 14 . 16 . 16 . 23 . 2412 53pdcapdca4s56 7, , ,1 ()23(place channel) 41(1)sql serversql serverwindows (2)windowswindowswinlogin(3)sql servernewlogin123456(4)sql serversqllogin123 (5)sa, 2(1)studentnewloginnewuser(2)studentsqlloginsqluser(3)studentsqllogintestuser(4)testuserwin (5)win3(1)ssmsnewloginsysadmin2newloginserveradminsysadminnewlogin4(1)db_ownersqluserdb_owner (2)db_datawriternewuser (3)db_myusersqluser 5(1)ssmssqlusergoodsgoods (2)sqluserordersorders (3)stud_user1 (4)liustud_infolesson_info(select)update(insert)sql servertud_infolesson_info(5)12student3studenttable1table2table1table2 41studentstud_info 2teacher selectlesson.course_name,,classroom.room_name,schedule.course_week,schedule.course_time,schedule.course_id fromclassroom_infoclassroom,tracher_infoteacher,lesson_infolesson,teach_schedule schedulewhere classroom.roomroom_id=schedule.room_id and teacher.teacher_id=schedule.teacher_idand lesson.course_id=schedule.course_id3ssisstudentlesson_infoexcel dnsdnswindows server 2003dns webftpdnsdnswebftp1dns2dns3dns4 5dns 1dns 212ippingwindows 2003tcp/iptcp/ipdnsdnsip 3dns1. /internettcp/ip/2. /windows3. dns/dnsdns%systemroot%system32dnsdns 4dnswindows 2003dns 1 2 35dnsipdnsdns 1/5dnsdnsd