<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[moonlight616的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/moonlight616</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; moonlight616]]></copyright><item><title><![CDATA[Python中操作mysql的pymysql模块]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80841344</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80841344</guid><author>moonlight616</author><pubDate>Thu, 28 Jun 2018 12:18:07 +0800</pubDate><description><![CDATA[一、安装     cmd命令窗口1pip3 install pymysqlpymsql中调用123456789101112131415#! /usr/bin/env python# -*- coding:utf-8 -*-# __author__ = &quot;TKQ&quot;import pymysql conn = pymysql.connect(host='127.0.0.1', port=3306, us...]]></description><category></category></item><item><title><![CDATA[Mysql第四章  事物、视图、备份和恢复]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80841281</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80841281</guid><author>moonlight616</author><pubDate>Thu, 28 Jun 2018 12:07:27 +0800</pubDate><description><![CDATA[CREATE DATABASE mybank;USE mybank;CREATE TABLE `bank`(          `customerName` CHAR(10),            `currentMoney` DECIMAL(10,2))#模拟实现转账     从张三的账户转账500元到李四的账户INSERT INTO `bank`(`customerName`,`curren...]]></description><category></category></item><item><title><![CDATA[第三章  高级查询]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80732311</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80732311</guid><author>moonlight616</author><pubDate>Tue, 19 Jun 2018 12:27:15 +0800</pubDate><description><![CDATA[/*检查“Logic Java”课程最近一次考试成绩如果有 80分以上的成绩，显示分数排在前5名的学员学号和分数*/SELECT studentNO,studentResultFROM resultWHERE EXISTS(             SELECT * FROM result             WHERE studentResult&amp;gt;80             AND ...]]></description><category></category></item><item><title><![CDATA[MySQL第二章2--2]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80712356</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80712356</guid><author>moonlight616</author><pubDate>Sat, 16 Jun 2018 12:44:38 +0800</pubDate><description><![CDATA[CREATE TABLE result(     studentNo INT(6) PRIMARY KEY COMMENT'学号',     subjectNo VARCHAR(50) COMMENT'科目',     examDate DATETIME COMMENT'考试日期',     studentResult INT COMMENT'结果') COMMENT='成绩表'INSERT IN...]]></description><category></category></item><item><title><![CDATA[MySQL第二章]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80712344</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80712344</guid><author>moonlight616</author><pubDate>Sat, 16 Jun 2018 12:42:25 +0800</pubDate><description><![CDATA[CREATE TABLE student1(   studentNo INT(4) PRIMARY KEY COMMENT'学号',   loginPwd VARCHAR(20) NOT NULL COMMENT'密码',   studentName VARCHAR(50) NOT NULL COMMENT'姓名',   sex CHAR(2) NOT NULL DEFAULT '男' COMME...]]></description><category></category></item><item><title><![CDATA[MySQL第一章]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80684125</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80684125</guid><author>moonlight616</author><pubDate>Wed, 13 Jun 2018 19:35:02 +0800</pubDate><description><![CDATA[CREATE TABLE student1(   studentNo INT(4) PRIMARY KEY COMMENT'学号',   loginPwd VARCHAR(20) NOT NULL COMMENT'密码',   studentName VARCHAR(50) NOT NULL COMMENT'姓名',   sex CHAR(2) NOT NULL DEFAULT '男' COMME...]]></description><category></category></item><item><title><![CDATA[MySQL的基本概念]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80662392</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80662392</guid><author>moonlight616</author><pubDate>Tue, 12 Jun 2018 10:54:36 +0800</pubDate><description><![CDATA[数据库的优点:存储大量数据,方便检索和访问             保持数据信息的完整、一致             共享和安全             通过组合分析,产生新的有用的信息应用程序的作用:响应操作并显示结果、向数据库请求数据数据库的作用:存储数据、检索数据、产生新的数据时下流行的数据库:Oracle、SQL Server、MySQL数据库的基本概念:数据库就是数据的仓库       ...]]></description><category></category></item><item><title><![CDATA[任意树]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80626732</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80626732</guid><author>moonlight616</author><pubDate>Fri, 08 Jun 2018 18:23:58 +0800</pubDate><description><![CDATA['''
          学校
        商学院   法学院  电子学院     计算机学院
                                 软件      网络     数据
                                       网1 网2 网3

'''
# 任意树
# 根据当前节点获取父节点
# 根据当前节点获取所有子节点
# 根据当前节点获...]]></description><category></category></item><item><title><![CDATA[练习题]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80607306</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80607306</guid><author>moonlight616</author><pubDate>Thu, 07 Jun 2018 12:04:40 +0800</pubDate><description><![CDATA[class BTree:
    root=None
    class Node:
        data=None
        left=None
        right=None
        def zhongxu(self):
            if self.left is not None:
                self.left.zhongxu()
 ...]]></description><category></category></item><item><title><![CDATA[复习]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80579538</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80579538</guid><author>moonlight616</author><pubDate>Tue, 05 Jun 2018 12:06:26 +0800</pubDate><description><![CDATA[date = []
for i in range(1, 21):
    date.append(i)
print(date)
print(date[14:8:-1])
date = [i for i in range(1, 21)]
date[7:12] = [9, 99, 999]
print(date)
d1 = (1, 2, 3, 4, 5, 6, 7)
d2 = (2, 4, 7, 8,...]]></description><category></category></item><item><title><![CDATA[网络编程之群聊]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80546732</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80546732</guid><author>moonlight616</author><pubDate>Sat, 02 Jun 2018 11:54:02 +0800</pubDate><description><![CDATA[ 群聊客户端
import socket,threading
# 创建个服务端
server=socket.socket(socket.AF_INET,socket.SOCK_STREAM)
# 绑定服务器的IP和端口
server.bind(('192.168.0.1',8000))
# 设置最大挂起连接数5
server.listen(5)
print('服务端  启动等待客户端连接...')...]]></description><category></category></item><item><title><![CDATA[网络编程]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80546715</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80546715</guid><author>moonlight616</author><pubDate>Sat, 02 Jun 2018 11:52:28 +0800</pubDate><description><![CDATA[import socket
# 1.创建个服务端
server=socket.socket(socket.AF_INET,socket.SOCK_STREAM)
# 2.绑定IP和端口
server.bind(('192.168.43.129',8888))
# 设置最大挂起连接数5
server.listen(5)
print('服务端启动   等待客户端连接...')
# 3.等待客户端链接 ...]]></description><category></category></item><item><title><![CDATA[蒸馒头的线程]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80546707</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80546707</guid><author>moonlight616</author><pubDate>Sat, 02 Jun 2018 11:51:05 +0800</pubDate><description><![CDATA[蒸馒头
import threading,time
zhenglong=[] 共享数据  蒸笼
创建俩把锁 一把蒸馒头的锁 由伙夫掌管  一把吃馒头的锁  由吃货掌管
zheng_lock=threading.Lock()
zheng_Cond=threading.Condition(lock=zheng_lock)
chi_lock=threading.Lock()
chi_Cond=threa...]]></description><category></category></item><item><title><![CDATA[多线程]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80522272</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80522272</guid><author>moonlight616</author><pubDate>Thu, 31 May 2018 12:13:38 +0800</pubDate><description><![CDATA[多线程
进程  应用程序的执行实例   有独立电脑内存空间和系统资源  独立  进程之间很难共享数据
线程  CPU调度和分派的基本单位   进程当中的子任务 不能单独存在   CPU执行的最小单位  线程不安全
import threading

print([x for x in range(9)])
thread=threading.current_thread()
thread.setNa...]]></description><category></category></item><item><title><![CDATA[DVD中的OS]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80522246</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80522246</guid><author>moonlight616</author><pubDate>Thu, 31 May 2018 12:11:56 +0800</pubDate><description><![CDATA[&amp;lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; ?&amp;gt;
&amp;lt;dvds&amp;gt;
    &amp;lt;dvd&amp;gt;
        &amp;lt;name&amp;gt;简爱&amp;lt;/name&amp;gt;
        &amp;lt;price&amp;gt;300&amp;lt;/price&amp;gt;
        &amp;lt;state&amp;gt;1]]></description><category></category></item><item><title><![CDATA[OS文件2]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80494549</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80494549</guid><author>moonlight616</author><pubDate>Tue, 29 May 2018 12:01:41 +0800</pubDate><description><![CDATA[&amp;lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; ?&amp;gt;
&amp;lt;collection shelf = &quot;New Arrivals&quot;&amp;gt;
&amp;lt;movie title = &quot;Enemy Behind&quot;&amp;gt;
   &amp;lt;type&amp;gt;War, Thriller&amp;lt;/type&amp;gt;
   &amp;l]]></description><category></category></item><item><title><![CDATA[OS文件]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80494522</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80494522</guid><author>moonlight616</author><pubDate>Tue, 29 May 2018 11:57:48 +0800</pubDate><description><![CDATA[&amp;lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; ?&amp;gt;
&amp;lt;data&amp;gt;
    &amp;lt;country name=&quot;Liechtenstein&quot;&amp;gt;
        &amp;lt;rank&amp;gt;1&amp;lt;/rank&amp;gt;
        &amp;lt;year&amp;gt;2008&amp;lt;/year&amp;g]]></description><category></category></item><item><title><![CDATA[文件流]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80460684</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80460684</guid><author>moonlight616</author><pubDate>Sat, 26 May 2018 12:06:26 +0800</pubDate><description><![CDATA[r      以只读方式打开文件。文件的指针将会放在文件的开头。这是默认模式。
rb     以二进制格式打开一个文件用于只读。文件指针将会放在文件的开头。这是默认模式。
r+     打开一个文件用于读写。文件指针将会放在文件的开头。
rb+    以二进制格式打开一个文件用于读写。文件指针将会放在文件的开头。
w      打开一个文件只用于写入。如果该文件已存在则将其覆盖。如果该文件不存在，...]]></description><category></category></item><item><title><![CDATA[文件流和OS]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80460656</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80460656</guid><author>moonlight616</author><pubDate>Sat, 26 May 2018 12:03:08 +0800</pubDate><description><![CDATA[r      以只读方式打开文件。文件的指针将会放在文件的开头。这是默认模式。
rb     以二进制格式打开一个文件用于只读。文件指针将会放在文件的开头。这是默认模式。
r+     打开一个文件用于读写。文件指针将会放在文件的开头。
rb+    以二进制格式打开一个文件用于读写。文件指针将会放在文件的开头。
w      打开一个文件只用于写入。如果该文件已存在则将其覆盖。如果该文件不存在，...]]></description><category></category></item><item><title><![CDATA[部分推导和枚举]]></title><link>https://blog.youkuaiyun.com/moonlight616/article/details/80460652</link><guid>https://blog.youkuaiyun.com/moonlight616/article/details/80460652</guid><author>moonlight616</author><pubDate>Sat, 26 May 2018 12:00:17 +0800</pubDate><description><![CDATA[求m,n中各个元素的乘积  矩阵
m=[[1,2,3],[4,5,6],[7,8,9]]
n=[[2,2,2],[3,3,3],[4,4,4]]
其中i,j对应的是相应下标   i是m最外头的中括号对应的下标  j是里面三个中括号对应的下标
通过元素下标  获取各个数据
for i in range(len(m)):
    for j in range(len(m[i])):
        p...]]></description><category></category></item></channel></rss>