代码Word文档下载推荐.docx
- 文档编号:21238589
- 上传时间:2023-01-28
- 格式:DOCX
- 页数:44
- 大小:27.97KB
代码Word文档下载推荐.docx
《代码Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《代码Word文档下载推荐.docx(44页珍藏版)》请在冰豆网上搜索。
登录密码
STUDENT
SNOCHAR(20)√√学号
SNAMECHAR(10)
学生姓名
SEXCHAR
(2)
性别
CLASSCHAR(5)
班级
DEPARTMENTCHAR(20)
学生所属院系
SCHOOLCHAR(20)
学生所属学校
COURSE
CNOCHAR(20)√√课程代码
CNAMECHAR(10)
课程名称
XUEFENint
学分,取值大于0小于10
HOURint
学时,大于等于0
YEARCHAR(5)
学年
TERMCHAR
(1)
学分
TEACH
TNOCHAR(20)√
教师代码
CNOCHAR(20)√
课程代码
STUDY
SNOCHAR(20)√
学号
SCOREDOUBLE
分数,0--100
3).建表语句
TEACHER建表语句:
createtableTEACHER
(
TNOchar(20)notnull,
TNAMEchar(10)notnull,
SEXchar
(1)notnull,
TITLEchar(10)notnull,
PASSWORDchar(20)notnull,
primarykey(TNO),
check(SEXin('
男'
'
女'
))
);
STUDENT建表语句:
createtableSTUDENT
SNOchar(20)notnull,
SNAMEchar(10)notnull,
SEXchar
(2)notnull,
CLASSchar(5)notnull,
DEPARTMENTchar(20)notnull,
SCHOOLchar(20)notnull,
primarykey(SNO),
COURSE建表语句:
createtableCOURSE
CNOchar(20)notnull,
CNAMEchar(10)notnull,
XUEFENintnotnull,
HOURintnotnull,
YEARchar(5)notnull,
TERMchar
(1)notnull,
primarykey(CNO),
check(XUEFEN>
0andXUEFEN<
10andHOUR>
=0)
TEACH建表语句:
createtableTEACH
primarykey(TNO,CNO)
foreignkey(TNO,CNO)REFERENCESTEACHERCOURSE,
foreignkey(CNO)REFERENCESCOURSE
altertableTEACH
addconstraintFK_TEACH_REFERENCE_TEACHERforeignkey(TNO)
referencesTEACHER(TNO)
onupdaterestrict
ondeleterestrict;
addconstraintFK_TEACH_REFERENCE_COURSEforeignkey(CNO)
referencesCOURSE(CNO)
2009-04-1218:
41
STUDY建表语句:
createtableSTUDY
SCOREdouble,
primarykey(SNO,CNO),
check(SCORE>
=0andSCORE<
=100)
altertableSTUDY
addconstraintFK_STUDY_REFERENCE_COURSEforeignkey(CNO)
addconstraintFK_STUDY_REFERENCE_STUDENTforeignkey(SNO)
referencesSTUDENT(SNO)
42
四。
系统实现代码
.system.dbconnection包
/*
*@author
*/
packagecom.system.dbconnection;
importjava.io.UnsupportedEncodingException;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclassDBConn{
protectedstaticStringdriverName="
com.mysql.jdbc.Driver"
;
//连接数据库的驱动名
protectedstaticStringdbName="
jdbc:
mysql:
//localhost/score_manage_system"
//数据库映射路径
protectedstaticStringdbUser="
root"
//数据库的登录名
protectedstaticStringdbPwd="
123456"
//数据库的登录密码
privatestaticConnectionconn=null;
//申明一个数据库连接
publicDBConn(){
//装载时建立数据库链接
try{
if(conn==null){
Class.forName(driverName).newInstance();
//System.out.println("
SuccessloadingMysqlDriver!
"
conn=DriverManager.getConnection(dbName,dbUser,dbPwd);
}
else
return;
}catch(Exceptione){
e.printStackTrace();
}
publicstaticResultSetexecuteQuery(Stringsql){
//静态方法executeQuery,执行查询操作,返回结果集ResultSet
newDBConn();
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSetrs=stmt.executeQuery(sql);
returnrs;
}catch(SQLExceptione){
returnnull;
}finally{
publicstaticbooleanexecuteUpdate(Stringsql){
//静态方法executeUpdate,执行更新操作,返回结果集布尔值,true表示更新成功,否则更新失败
stmt.executeUpdate(sql);
returntrue;
returnfalse;
publicstaticStringgetNewString(Stringstring){
//为解决数据库显示中文问题而写的方法
try{
return(newString(string.getBytes("
ISO-8859-1"
),"
gb2312"
));
}catch(UnsupportedEncodingExceptione){
//TODO自动生成catch块
publicstaticbooleanstudentChangePassword(Stringid,Stringpassword){
//学生修改密码的方法具体的逻辑判断推至上层处理
Stringsql="
updateSTUDENTsetPASSWORD='
+password+"
'
whereSNO='
+id+"
returnDBConn.executeUpdate(sql);
publicstaticbooleanteacherChangePassword(Stringid,Stringpassword){
//教师修改密码的方法
updateTEACHERsetPASSWORD='
whereTNO='
publicstaticbooleanteacherSetScoreOfStudent(Stringstudentid,Stringcourseid,doublescore){
//老师输入分数的方法
updateSTUDYsetSCORE='
+score+"
whereSNO='
+studentid+"
andCNO='
+courseid+"
publicstaticvoidclose(){
//关闭数据库连接的方法
conn.close();
conn=null;
43
2com.system.model包
//Student.java
/*
*@authorougaoyan,date:
2008-9-26
packagecom.system.model;
importjava.awt.Color;
importjava.util.ArrayList;
importjava.util.Iterator;
importjava.util.List;
importjavax.swing.JTable;
importcom.system.dbconnection.DBConn;
publicclassStudent{
publicstaticStringid;
publicstaticStringname;
publicstaticStringsex;
publicstaticStringpassword;
publicstaticStringsclass;
publicstaticStringdepartment;
publicstaticStringschool;
publicstaticListcourseList=newArrayList();
publicStudent(Stringid){
Stringsql1="
select*fromSTUDENTwhereSNO='
ResultSetrs1=DBConn.executeQuery(sql1);
while(rs1.next()){
//从数据库获得学生信息并初始化相关属性
setId(rs1.getString("
SNO"
setName(DBConn.getNewString(rs1.getString("
SNAME"
)));
setSex(DBConn.getNewString(rs1.getString("
SEX"
setPassword(rs1.getString("
PASSWORD"
setClass(rs1.getString("
CLASS"
setDepartment(DBConn.getNewString(rs1.getString("
DEPARTMENT"
setSchool(DBConn.getNewString(rs1.getString("
SCHOOL"
DBConn.close();
//关闭数据库连接
Stringsql2="
select*fromSTUDENT,STUDYwhereSTUDENT.SNO=STUDY.SNOandSTUDY.SNO='
try{
ResultSetrs2=DBConn.executeQuery(sql2);
while(rs2.next()){
courseList.add(rs2.getString("
CNO"
).trim());
publicstaticListgetScoreList(){
//返回学生各门课程的成绩信息
Listlist=newArrayList();
Iteratori=Student.courseList.iterator();
while(i.hasNext()){
StudentCoursescourse=newStudentCourse(Student.id,(String)i.next());
list.add(scourse);
returnlist;
publicstaticListgetYearScoreList(Stringyear){
Listlist=getScoreList();
ListyearList=newArrayList();
StudentCoursecourse=null;
for(inti=0;
i<
list.size();
i++){
course=(StudentCourse)list.get(i);
if(course.year.equals(year)){
yearList.add(course);
returnyearList;
publicstaticListgetTermScoreLiat(Stringyear,Stringterm){
ListtermList=newArrayList();
if(course.year.equals(year)&
&
course.term.equals(term)){
termList.add(course);
returntermList;
publicstaticvoidsetId(Stringsid){
//设置学号的方法
id=sid;
publicstaticvoidsetName(Stringsname){
//设置密码的方法
name=sname;
publicstaticvoidsetSex(Stringsex){
//设置性别的方法
Student.sex=sex;
publicstaticvoidsetPassword(Stringspassword){
password=spassword;
publicstaticvoidsetClass(Stringsclass){
Student.sclass=sclass;
publicstaticvoidsetDepartment(Stringdep){
department=dep;
publicstaticvoidsetSchool(Stringsch){
school=sch;
publicstaticbooleanchangePassword(Stringnewpassword){
//学生用户修改密码的方法
returnDBConn.studentChangePassword(Student.id,newpassword);
//Course.java
impo
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 代码