1、项目说明
基于python+Flask+mysql的学生信息管理系统项目实战
项目需要安装pycharm专业版,mysql数据库以及项目所需的所有模块
创建数据库名称db_online_notes,然后执行sql文件生成数据表和数据
项目需要安装 flask,pymysql以及其他的一些模块
安装命令如下:
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple 模块名称
如安装flask:pip install -i https://pypi.tuna.tsinghua.edu.cn/simple flask
2、项目主要技术
python编程技术
flask框架技术
mysql数据库技术
html编程
css编程
js编程
3、项目结构
static 项目静态文件存储文件夹(images,css,js)
templates 项目模板文件文件夹(html)
log.txt 错误日志存放文件
forms.py 表单验证对象
mysql_util.py 数据库链接操作
manage.py 项目功能业务逻辑实现(项目入口)
4、项目主要功能
用户登录注册
文章信息的增删改查
5、部分源码
from flask import Flask, render_template, request, redirect, session, jsonify, url_for
from flask_sqlalchemy import SQLAlchemy
from werkzeug.utils import secure_filename
import os,shutil
import random
import json
import pymysql
import logging
import math
from operator import or_
from exts.QueryPaginate import QueryPaginate
app = Flask(__name__,static_folder='')
app.config['DEBUG']=True
#配置session key
app.config['SECRET_KEY'] = '2cf0fa7e-48d9-11e6-93fb-c03fd53413ef'
#SQLAlchemy相关配置
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:root@localhost:3306/student'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SQLALCHEMY_ECHO'] = False
# 创建组件对象
db = SQLAlchemy(app)
#**********配置初始系统变量**********
data = {}
data['SYSNAME']='毕业设计 - 学生信息管理系统'
data['DEVURL']='http://www.wwww.com/'
data['DEVNAME']='上海交大'
#**********数据库配置**********
#学生表
class TStudent(db.Model):
__tablename__ = 't_student'
id = db.Column(db.Integer, primary_key=True)
student_no = db.Column(db.String(20))
student_name = db.Column(db.String(100))
department_no = db.Column(db.String(20))
#课程表
class TCourse(db.Model):
__tablename__ = 't_course'
id = db.Column(db.Integer, primary_key=True)
course_no = db.Column(db.String(20))
course_name = db.Column(db.String(100))
#成绩表
class TGrade(db.Model):
__tablename__ = 't_grade'
id = db.Column(db.Integer, primary_key=True)
student_no = db.Column(db.String(20))
course_no = db.Column(db.String(20))
grade = db.Column(db.String(10))
#用户表
class TUser(db.Model):
__tablename__ = 't_user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20))
password = db.Column(db.String(20))
realname = db.Column(db.String(20))
#学院表
class TDepartment(db.Model):
__tablename__ = 't_department'
id = db.Column(db.Integer, primary_key=True)
department_no = db.Column(db.String(20))
department_name = db.Column(db.String(20))
#**********路由部分**********
#首页
@app.route('/')
@app.route('/index')
def index():
if(checkSignIn()==False):
return redirect('/signin')
studentCount = db.session.query(TStudent).count()
courseCount = db.session.query(TCourse).count()
userCount = db.session.query(TUser).count()
gradeCount = db.session.query(TGrade).count()
data['studentCount']= studentCount
data['courseCount']= courseCount
data['userCount']= studentCount
data['gradeCount']= gradeCount
studentData = db.session.query(TStudent,TDepartment).outerjoin(TDepartment, TStudent.department_no==TDepartment.department_no).order_by(TStudent.id.desc()).limit(10).all()
print(studentData)
data['studentData']=studentData
userData = db.session.query(TUser).order_by(TUser.id.desc()).limit(10).all()
data['userData']=userData
return render_template('index.html', **data)
'''
#首页
@app.route('/index')
def index2():
if(checkSignIn()==False):
return redirect('/signin')
return render_template('index.html', **data)
'''
#用户登录模块
@app.route('/signin',methods=['GET','POST'])
def signin():
return render_template('sign-in.html',form=data)
#用户退出模块
@app.route('/signout',methods=['GET','POST'])
def signout():
session.clear()
#return redirect('/signin')
return redirect(url_for('signin'))
#用户登录验证
@app.route('/dosignin',methods=['GET','POST'])
def dosignin():
userName = request.values.get('userName')
userPass = request.values.get('userPass')
logging.info(request.remote_addr)#记录日志
print(request.headers)#头文件
print(request.remote_addr)#远程IP地址
user = db.session.query(TUser).filter(TUser.username == userName,
TUser.password == userPass
).first()
if(user is not None):
session['userName']=userName
print(session)
return redirect('/')
else:
data['errorMessage']='用户名或密码不正确!'
return render_template('signin.html',form=data)
#用户注册模块
@app.route('/signup',methods=['GET','POST'])
def signup():
return render_template('sign-up.html',form=data)
#学生信息部分开始************************************
#查看列表带分页
@app.route('/students/',methods=['GET','POST'])
def students():
studentNo = request.form.get('studentNo') if request.form.get('studentNo') is not None else ''
studentName = request.form.get('studentName') if request.form.get('studentName') is not None else ''
data['studentNo']=studentNo
data['studentName']=studentName
page = int(request.form.get('search_page')) if request.form.get('search_page') is not None and request.form.get('search_page') != '0' else 1
query = db.session.query(TStudent).filter(or_(TStudent.student_no == studentNo, studentNo == ''),
or_(TStudent.student_name.like('%{0}%'.format(studentName)),studentName == '')
)
queryPaginate = QueryPaginate(query,10,page)
data['currdata']=queryPaginate.items
data['pagelist']=queryPaginate.iter_pages()
data['pages']=queryPaginate.pages
data['page']=queryPaginate.page
data['per_page']=queryPaginate.per_page
data['prev_num']=queryPaginate.prev_num
data['next_num']=queryPaginate.next_num
return render_template('students.html',**data)
#查看单个信息
@app.route('/student/<int:studentid>',methods=['GET','POST'])
def student(studentid):
data['studentid']=studentid
currdata = db.session.query(TStudent).filter(TStudent.id==studentid).first()
data['currdata'] = currdata
return render_template('student.html',**data)
#编辑单个信息
@app.route('/student/edit/<int:studentid>',methods=['GET'])
def student_edit(studentid):
currdata = db.session.query(TStudent).filter(TStudent.id==studentid).first()
print(currdata)
data['currdata'] = currdata
return render_template('student_edit.html',**data)
#编辑保存单个信息
@app.route('/student/doedit/',methods=['POST'])
def student_doedit():
studentid = request.form.get('studentid')
studentNo = request.form.get('studentNo')
studentName = request.form.get('studentName')
update_dict = {}
if(studentNo is not None):
update_dict['student_no']=studentNo
if(studentName is not None):
update_dict['student_name']=studentName
db.session.query(TStudent).filter_by(id=studentid).update(update_dict)
db.session.commit()
print(data)
return redirect(url_for('students'))
#删除单个信息
@app.route('/student/del/<int:studentid>',methods=['GET'])
def student_del(studentid):
db.session.query(TStudent).filter_by(id=studentid).delete()
db.session.commit()
return redirect(url_for('students'))
#删除单个信息
@app.route('/student/dodel/',methods=['POST'])
def student_dodel(studentid):
db.session.query(TStudent).filter_by(id=studentid).delete()
db.session.commit()
return redirect(url_for('students'))
#保存单个信息
@app.route('/student/add',methods=['GET'])
def student_add():
return render_template('student_add.html',form=data)
#保存单个信息
@app.route('/student/doAdd',methods=['POST'])
def student_doadd():
studentNo = request.form.get('studentNo')
studentName = request.form.get('studentName')
print(request.form)
student = TStudent(student_no=studentNo,student_name=studentName)
db.session.add(student)
db.session.commit()
return redirect(url_for('students'))
#学生信息部分结束************************************
#课程信息部分开始************************************
#查看列表带分页
@app.route('/courses/',methods=['GET','POST'])
def courses():
courseNo = request.form.get('courseNo') if request.form.get('courseNo') is not None else ''
courseName = request.form.get('courseName') if request.form.get('courseName') is not None else ''
data['courseNo']=courseNo
data['courseName']=courseName
page = int(request.form.get('search_page')) if request.form.get('search_page') is not None and request.form.get('search_page') != '0' else 1
query = db.session.query(TCourse).filter(or_(TCourse.course_no == courseNo, courseNo == ''),
or_(TCourse.course_name.like('%{0}%'.format(courseName)),courseName == '')
)
queryPaginate = QueryPaginate(query,10,page)
data['currdata']=queryPaginate.items
data['pagelist']=queryPaginate.iter_pages()
data['pages']=queryPaginate.pages
data['page']=queryPaginate.page
data['per_page']=queryPaginate.per_page
data['prev_num']=queryPaginate.prev_num
data['next_num']=queryPaginate.next_num
return render_template('courses.html',**data)
#查看单个信息
@app.route('/course/<int:courseid>',methods=['GET','POST'])
def course(courseid):
data['courseid']=courseid
currdata = db.session.query(TCourse).filter(TCourse.id==courseid).first()
data['currdata'] = currdata
return render_template('course.html',**data)
#编辑单个信息
@app.route('/course/edit/<int:courseid>',methods=['GET'])
def course_edit(courseid):
currdata = db.session.query(TCourse).filter(TCourse.id==courseid).first()
print(currdata)
data['currdata'] = currdata
return render_template('course_edit.html',**data)
#编辑保存单个信息
@app.route('/course/doedit/',methods=['POST'])
def course_doedit():
courseid = request.form.get('courseid')
courseNo = request.form.get('courseNo')
courseName = request.form.get('courseName')
update_dict = {}
if(courseNo is not None):
update_dict['course_no']=courseNo
if(courseName is not None):
update_dict['course_name']=courseName
db.session.query(TCourse).filter_by(id=courseid).update(update_dict)
db.session.commit()
print(data)
return redirect(url_for('courses'))
#删除单个信息
@app.route('/course/del/<int:courseid>',methods=['GET'])
def course_del(courseid):
db.session.query(TCourse).filter_by(id=courseid).delete()
db.session.commit()
return redirect(url_for('courses'))
#删除单个信息
@app.route('/course/dodel/',methods=['POST'])
def course_dodel(courseid):
db.session.query(TCourse).filter_by(id=courseid).delete()
db.session.commit()
return redirect(url_for('courses'))
#保存单个信息
@app.route('/course/add',methods=['GET'])
def course_add():
return render_template('course_add.html',form=data)
#保存单个信息
@app.route('/course/doAdd',methods=['POST'])
def course_doadd():
courseNo = request.form.get('courseNo')
courseName = request.form.get('courseName')
print(request.form)
course = TCourse(course_no=courseNo,course_name=courseName)
db.session.add(course)
db.session.commit()
return redirect(url_for('courses'))
#课程信息部分结束************************************
#成绩信息部分开始************************************
@app.route('/grades/',methods=['GET','POST'])
def grades():
studentNo = request.form.get('studentNo') if request.form.get('studentNo') is not None else ''
studentName = request.form.get('studentName') if request.form.get('studentName') is not None else ''
courseNo = request.form.get('courseNo') if request.form.get('courseNo') is not None else ''
courseName = request.form.get('courseName') if request.form.get('courseName') is not None else ''
data['studentNo']=studentNo
data['studentName']=studentName
data['courseNo']=courseNo
data['courseName']=courseName
page = int(request.form.get('search_page')) if request.form.get('search_page') is not None and request.form.get('search_page') != '0' else 1
query = db.session.query(TGrade,TStudent,TCourse).outerjoin(TStudent, TStudent.student_no==TGrade.student_no).outerjoin(TCourse,TCourse.course_no==TGrade.course_no).filter(or_(TCourse.course_no == courseNo, courseNo == ''),
or_(TCourse.course_name.like('%{0}%'.format(courseName)),courseName == ''),
or_(TStudent.student_no == studentNo, studentNo == ''),
or_(TStudent.student_name.like('%{0}%'.format(studentName)),studentName == '')
)
#print(query)
queryPaginate = QueryPaginate(query,10,page)
#print(queryPaginate.items)
data['currdata']=queryPaginate.items
data['pagelist']=queryPaginate.iter_pages()
data['pages']=queryPaginate.pages
data['page']=queryPaginate.page
data['per_page']=queryPaginate.per_page
data['prev_num']=queryPaginate.prev_num
data['next_num']=queryPaginate.next_num
return render_template('grades.html',**data)
#保存单个信息
@app.route('/grade/add',methods=['GET'])
def grade_add():
studentdata = db.session.query(TStudent).all()
data['studentdata']=studentdata
coursedata = db.session.query(TCourse).all()
data['coursedata']=coursedata
return render_template('grade_add.html',**data)
#保存单个信息
@app.route('/grade/doAdd',methods=['POST'])
def grade_doadd():
courseNo = request.form.get('courseNo')
studentNo = request.form.get('studentNo')
grade = request.form.get('grade')
grade = TGrade(course_no=courseNo,student_no=studentNo,grade=grade)
db.session.add(grade)
db.session.commit()
return redirect(url_for('grades'))
#删除单个信息
@app.route('/grade/del/<int:gradeid>',methods=['GET'])
def grade_del(gradeid):
db.session.query(TGrade).filter_by(id=gradeid).delete()
db.session.commit()
return redirect(url_for('grades'))
#成绩信息部分结束************************************
#用户信息部分开始************************************
#查看列表
@app.route('/users',methods=['GET','POST'])
def users():
userName = request.form.get('userName') if request.form.get('userName') is not None else ''
realName = request.form.get('realName') if request.form.get('realName') is not None else ''
data['userName']=userName
data['realName']=realName
page = int(request.form.get('search_page')) if request.form.get('search_page') is not None and request.form.get('search_page') != '0' else 1
query = db.session.query(TUser).filter(or_(TUser.username == userName, userName == ''),
or_(TUser.realname.like('%{0}%'.format(realName)),realName == '')
)
print(query)
queryPaginate = QueryPaginate(query,10,page)
#print(queryPaginate.items)
data['currdata']=queryPaginate.items
data['pagelist']=queryPaginate.iter_pages()
data['pages']=queryPaginate.pages
data['page']=queryPaginate.page
data['per_page']=queryPaginate.per_page
data['prev_num']=queryPaginate.prev_num
data['next_num']=queryPaginate.next_num
return render_template('users.html',**data)
#查看单个信息
@app.route('/user/<int:userid>',methods=['GET','POST'])
def user(userid):
data['userid']=userid
print(data)
return render_template('user.html',form=data)
#保存单个信息
@app.route('/user/add',methods=['GET'])
def user_add():
return render_template('user_add.html',**data)
#保存单个信息
@app.route('/user/doAdd',methods=['POST'])
def user_doadd():
username = request.form.get('username')
password = request.form.get('password')
realname = request.form.get('realname')
user = TUser(username=username,password=password,realname=realname)
db.session.add(user)
db.session.commit()
return redirect(url_for('users'))
#编辑单个信息
@app.route('/user/edit/<int:userid>',methods=['GET'])
def user_edit(userid):
currdata = db.session.query(TUser).filter(TUser.id==userid).first()
print(currdata)
data['currdata'] = currdata
return render_template('user_edit.html',**data)
#编辑保存单个信息
@app.route('/user/doedit/',methods=['POST'])
def user_doedit():
userid = request.form.get('userid')
username = request.form.get('username')
password = request.form.get('password')
realname = request.form.get('realname')
update_dict = {}
if(username is not None):
update_dict['username']=username
if(password is not None):
update_dict['password']=password
if(realname is not None):
update_dict['realname']=realname
db.session.query(TUser).filter_by(id=userid).update(update_dict)
db.session.commit()
print(data)
return redirect(url_for('users'))
#删除单个信息
@app.route('/user/del/<int:userid>',methods=['GET'])
def user_del(userid):
db.session.query(TUser).filter_by(id=userid).delete()
db.session.commit()
return redirect(url_for('users'))
#用户信息部分结束************************************
#用户设置部分结束************************************
#编辑单个信息
@app.route('/user/set/<username>',methods=['GET'])
def user_set(username):
currdata = db.session.query(TUser).filter(TUser.username==username).first()
print(currdata)
data['currdata'] = currdata
return render_template('user_set.html',**data)
#编辑保存单个信息
@app.route('/user/doset/',methods=['POST'])
def user_doset():
userid = request.form.get('userid')
username = request.form.get('username')
password = request.form.get('password')
realname = request.form.get('realname')
update_dict = {}
if(username is not None):
update_dict['username']=username
if(password is not None):
update_dict['password']=password
if(realname is not None):
update_dict['realname']=realname
db.session.query(TUser).filter_by(id=userid).update(update_dict)
db.session.commit()
print(data)
return redirect(url_for('users'))
#用户设置部分结束************************************
@app.route('/faq',methods=['GET','POST'])
def faq():
return render_template('faq.html',**data)
@app.route('/help',methods=['GET','POST'])
def help():
return render_template('help.html',**data)
@app.route('/calendar',methods=['GET','POST'])
def calendar():
return render_template('calendar.html',form=data)
@app.route('/media',methods=['GET','POST'])
def media():
return render_template('media.html',**data)
@app.route('/theory',methods=['GET','POST'])
def theory():
return render_template('theory.html',**data)
@app.route('/privacy-policy',methods=['GET','POST'])
def privacypolicy():
return render_template('privacy-policy.html',**data)
@app.route('/terms-and-conditions',methods=['GET','POST'])
def termsandconditions():
return render_template('terms-and-conditions.html',**data)
#系统级报警路由
@app.errorhandler(403)
def error403():
return render_template('403.html',form=data)
@app.errorhandler(404)
def error404(error):
return render_template('404.html',form=data)
@app.errorhandler(500)
def error500():
return render_template('500.html',form=data)
@app.errorhandler(503)
def error503():
return render_template('503.html',form=data)
#**********测试用路由**********
@app.route('/jsontest')
def jsonTest():
jsonStr = '{"name":"张三","age":"33"}'
jsonData = json.loads(jsonStr)
print(jsonData['name'])
data={"name":"张三","age":"33"}
print (json.dumps(data,ensure_ascii=False))
#return jsonify(data)
return jsonify(name="张三",age=34)
@app.route('/mysqltest')
def mysqlTest():
cursor = db.cursor()
try:
mySql = "select * from kelly limit 10"
cursor.execute(mySql)
data = cursor.fetchall()
except Exception as e:
print("Error: ",e)
return jsonify(data)
#**********方法部分**********
#检测登录状态
def checkSignIn():
#if(session.get('userName') is None or session.get('userName')==''):
if('userName' not in session):
return False
else:
return True
#**********通用方法部分**********
if __name__ == "__main__":
app.run(host='0.0.0.0',debug=False,port=8088)
#app.run(host='127.0.0.1',debug=False,port=8082)
6、运行截图








7、项目总结
本项目是一个非常适合练手的项目,对我们的python编程和对flask框架的了解和提升都有很大的帮助,推荐大家学习研究这个项目,搞懂其中的原理流程以及知识点非常关键。
资料获取地址:https://item.taobao.com/item.htm?spm=a21dvs.23580594.0.0.4fee3d0dmeAXHu&ft=t&id=713204492149
B站视频讲解地址:
注:其他问题请参看视频讲解,都有介绍,一定要认真看完哦!
代码编写、视频录制不易,感谢您的支持,祝您学习愉快!
关闭。这个问题是opinion-based.它目前不接受答案。想要改进这个问题?更新问题,以便editingthispost可以用事实和引用来回答它.关闭4年前。Improvethisquestion我想在固定时间创建一系列低音和高音调的哔哔声。例如:在150毫秒时发出高音调的蜂鸣声在151毫秒时发出低音调的蜂鸣声200毫秒时发出低音调的蜂鸣声250毫秒的高音调蜂鸣声有没有办法在Ruby或Python中做到这一点?我真的不在乎输出编码是什么(.wav、.mp3、.ogg等等),但我确实想创建一个输出文件。
大约一年前,我决定确保每个包含非唯一文本的Flash通知都将从模块中的方法中获取文本。我这样做的最初原因是为了避免一遍又一遍地输入相同的字符串。如果我想更改措辞,我可以在一个地方轻松完成,而且一遍又一遍地重复同一件事而出现拼写错误的可能性也会降低。我最终得到的是这样的:moduleMessagesdefformat_error_messages(errors)errors.map{|attribute,message|"Error:#{attribute.to_s.titleize}#{message}."}enddeferror_message_could_not_find(obje
我主要使用Ruby来执行此操作,但到目前为止我的攻击计划如下:使用gemsrdf、rdf-rdfa和rdf-microdata或mida来解析给定任何URI的数据。我认为最好映射到像schema.org这样的统一模式,例如使用这个yaml文件,它试图描述数据词汇表和opengraph到schema.org之间的转换:#SchemaXtoschema.orgconversion#data-vocabularyDV:name:namestreet-address:streetAddressregion:addressRegionlocality:addressLocalityphoto:i
这个问题在这里已经有了答案:关闭10年前。PossibleDuplicate:Pythonconditionalassignmentoperator对于这样一个简单的问题表示歉意,但是谷歌搜索||=并不是很有帮助;)Python中是否有与Ruby和Perl中的||=语句等效的语句?例如:foo="hey"foo||="what"#assignfooifit'sundefined#fooisstill"hey"bar||="yeah"#baris"yeah"另外,类似这样的东西的通用术语是什么?条件分配是我的第一个猜测,但Wikipediapage跟我想的不太一样。
什么是ruby的rack或python的Java的wsgi?还有一个路由库。 最佳答案 来自Python标准PEP333:Bycontrast,althoughJavahasjustasmanywebapplicationframeworksavailable,Java's"servlet"APImakesitpossibleforapplicationswrittenwithanyJavawebapplicationframeworktoruninanywebserverthatsupportstheservletAPI.ht
导读:随着叮咚买菜业务的发展,不同的业务场景对数据分析提出了不同的需求,他们希望引入一款实时OLAP数据库,构建一个灵活的多维实时查询和分析的平台,统一数据的接入和查询方案,解决各业务线对数据高效实时查询和精细化运营的需求。经过调研选型,最终引入ApacheDoris作为最终的OLAP分析引擎,Doris作为核心的OLAP引擎支持复杂地分析操作、提供多维的数据视图,在叮咚买菜数十个业务场景中广泛应用。作者|叮咚买菜资深数据工程师韩青叮咚买菜创立于2017年5月,是一家专注美好食物的创业公司。叮咚买菜专注吃的事业,为满足更多人“想吃什么”而努力,通过美好食材的供应、美好滋味的开发以及美食品牌的孵
华为OD机试题本篇题目:明明的随机数题目输入描述输出描述:示例1输入输出说明代码编写思路最近更新的博客华为od2023|什么是华为od,od薪资待遇,od机试题清单华为OD机试真题大全,用Python解华为机试题|机试宝典【华为OD机试】全流程解析+经验分享,题型分享,防作弊指南华为o
在应用开发中,有时候我们需要获取系统的设备信息,用于数据上报和行为分析。那在鸿蒙系统中,我们应该怎么去获取设备的系统信息呢,比如说获取手机的系统版本号、手机的制造商、手机型号等数据。1、获取方式这里分为两种情况,一种是设备信息的获取,一种是系统信息的获取。1.1、获取设备信息获取设备信息,鸿蒙的SDK包为我们提供了DeviceInfo类,通过该类的一些静态方法,可以获取设备信息,DeviceInfo类的包路径为:ohos.system.DeviceInfo.具体的方法如下:ModifierandTypeMethodDescriptionstatic StringgetAbiList()Obt
文章目录一、概述简介原理模块二、配置Mysql使用版本环境要求1.操作系统2.mysql要求三、配置canal-server离线下载在线下载上传解压修改配置单机配置集群配置分库分表配置1.修改全局配置2.实例配置垂直分库水平分库3.修改group-instance.xml4.启动监听四、配置canal-adapter1修改启动配置2配置映射文件3启动ES数据同步查询所有订阅同步数据同步开关启动4.验证五、配置canal-admin一、概述简介canal是Alibaba旗下的一款开源项目,Java开发。基于数据库增量日志解析,提供增量数据订阅&消费。Git地址:https://github.co
我想解析一个已经存在的.mid文件,改变它的乐器,例如从“acousticgrandpiano”到“violin”,然后将它保存回去或作为另一个.mid文件。根据我在文档中看到的内容,该乐器通过program_change或patch_change指令进行了更改,但我找不到任何在已经存在的MIDI文件中执行此操作的库.他们似乎都只支持从头开始创建的MIDI文件。 最佳答案 MIDIpackage会为您完成此操作,但具体方法取决于midi文件的原始内容。一个MIDI文件由一个或多个音轨组成,每个音轨是十六个channel中任何一个上的