教室管理系统的源代码.docVIP

1.创建数据库 Create datebase classManager; create table ClassInfo( 教室编号 varchar(10) primary key, 教室设备 varchar(100) not null, 教室容纳人数 int not null, 教室管理员编号 varchar(10) not null ); create table TeacherInfo ( 教师编号 varchar(10) primary key, 教师姓名 varchar(20) not null, 教授课程 varchar(50), 教师职称 varchar(20) not null ); create table ClassRoomInfo ( 教室编号 varchar(10), 上课开始时间 dateTime not null, 结束时间 dateTime not null, 教师编号 varchar(10), Foreign key (教室编号) references ClassInfo(教室编号), Foreign key (教师编号) references TeacherInfo(教师编号) ); create table manager( username varchar(10) not null, userpsw varchar(10) not null ); 向其中插入数据。 insert ClassInfo values(4101,投影仪,40,01) insert ClassInfo values(4102,电脑,50,02) insert TeacherInfo values(0A,李萍,计算机系统分,讲师) insert TeacherInfo values(0B,李明,C语言,教授) insert ClassRoomInfo values(4101,8:00,10:00,0A) insert ClassRoomInfo values(4102,10:00,12:00,0B) insert manager values(jack 2.创建登录界面 package dev.chall.otherinterface; import java.awt.Cursor; import java.awt.FlowLayout; import java.awt.Frame; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowEvent; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.swing.JButton; import javax.swing.JDialog; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JPasswordField; import javax.swing.JTextField; public class Login extends JDialog implements ActionListener{ private JLabel name; private JLabel psw; private JTextField nameV; private JPasswordField pswV; private JButton login,quit; private JPanel top; private JPanel center; private JPanel bottom; private JLabel prompt; public static String loginName; public Login(Frame owner, String title, boolean modal) { super(owner, title, modal); init(); } private void init() { name=new JLabel(登录名:); nameV=new JText