1创建数据库
CreatedatebaseclassMa
agercreatetableClassI
fo
教室编号varchar10primarykey教室设备varchar100
ot
ull教室容纳人数i
t
ot
ull教室管理员编号varchar10
ot
ullcreatetableTeacherI
fo教师编号varchar10primarykey教师姓名varchar20
ot
ull教授课程varchar50教师职称varchar20
ot
ullcreatetableClassRoomI
fo教室编号varchar10上课开始时间dateTime
ot
ull结束时间dateTime
ot
ull教师编号varchar10Foreig
key教室编号refere
cesClassI
fo教室编号Foreig
key教师编号refere
cesTeacherI
fo教师编号createtablema
ageruser
amevarchar10
ot
ulluserpswvarchar10
ot
ull向其中插入数据。
2创建登录界面
packagedevchallotheri
terfaceimportjavaawtCursorimportjavaawtFlowLayoutimportjavaawtFrame
fimportjavaawtGridLayoutimportjavaawteve
tActio
Eve
timportjavaawteve
tActio
Liste
erimportjavaawteve
tWi
dowEve
timportjavasqlCo
ectio
importjavasqlDriverMa
agerimportjavasqlPreparedStateme
timportjavasqlResultSetimportjavasqlSQLExceptio
importjavaxswi
gJButto
importjavaxswi
gJDialogimportjavaxswi
gJLabelimportjavaxswi
gJPa
elimportjavaxswi
gJPasswordFieldimportjavaxswi
gJTextFieldpublicclassLogi
exte
dsJDialogimpleme
tsActio
Liste
er
privateJLabel
ameprivateJLabelpswprivateJTextField
ameVprivateJPasswordFieldpswVprivateJButto
logi
quitprivateJPa
eltopprivateJPa
elce
terprivateJPa
elbottomprivateJLabelpromptpublicstaticStri
glogi
NamepublicLogi
Frameow
erStri
gtitleboolea
modal
superow
ertitlemodali
itprivatevoidi
it
ame
ewJLabel