📄 xuanke.java
字号:
card22.add(p221);
Panel p222=new Panel();
p222.add(new Label("输入课程名"));
p222.add(Cname_Grade);
card22.add(p222);
Panel p223=new Panel();
display22=new TextArea(20,45);
p223.add(display22);
card22.add(p223);
Panel p224=new Panel();
ok22=new Button("确定");
back22=new Button("返回");
p224.add(ok22);
p224.add(back22);
card22.add(p224);
add("c22",card22);
ok22.addActionListener(this);
back22.addActionListener(this);
Panel card23=new Panel(); //第23张卡片显示所有学生的成绩
card23.setLayout(new GridLayout(4,1));
card23.setBackground(Color.pink);
Panel p231=new Panel();
Label tip3=new Label("***所有学生的选课成绩如下***");
tip3.setFont(new Font("Alias",Font.BOLD,15));
p231.add(tip3);
card23.add(p231);
Panel p232=new Panel();
display23=new TextArea(30,45);
p232.add(display23);
card23.add(p232);
Panel p233=new Panel();
back23=new Button("返回");
p233.add(back23);
card23.add(p233);
add("c23",card23);
back23.addActionListener(this);
setSize(400,400);
setVisible(true);
}
public String AddRegedit(String use,String word){
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url,"Administrator","woaini");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ps=con.prepareStatement("INSERT INTO Regedit VALUES(?,?)");
ps.setString(1,use);
ps.setString(2,word);
ps.executeUpdate();
rs=stmt.executeQuery("select * from Regedit");
while(rs.next()){
s+="user:"+rs.getString("user_no")+"word:"+rs.getString("password")+"\n";
}
con.close();
stmt.close();
return s;
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Delete_Course(String name){ //删除课程(管理员权限)
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url,"Administrator","woaini");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ps=con.prepareStatement("delete from Course where Cname=?");
ps.setString(1,name);
ps.executeUpdate();
rs=stmt.executeQuery("select * from Course ");
s+="课程号"+"\t"+"课程名"+"\t"+"学分"+"\t"+"地点"+"\t"+"时间"+"\t"+"老师"+"\n";
while(rs.next()){
s+=rs.getString("Cno")+"\t"+rs.getString("Cname")+"\t"+rs.getString("Credit")
+"\t"+rs.getString("Caddress")+"\t"+rs.getString("Cbegintime")+"\t"+rs.getString("Cteacher")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Query_All(String sql){ //管理员查询全部课程
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url,"Administrator","woaini");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
rs.beforeFirst();
s+="课程号"+"\t"+"课程名"+"\t"+"学分"+"\t"+"地点"+"\t"+"时间"+"\t"+"老师"+"\n";
while(rs.next()){
String s1=rs.getString("Cno");
String s2=rs.getString("Cname");
String s3=rs.getString("Credit");
String s4=rs.getString("Caddress");
String s5=rs.getString("Cbegintime");
String s6=rs.getString("Cteacher");
s+=s1+"\t"+s2+"\t"+s3+"\t"+s4+"\t"+s5+"\t"+s6+"\n";
}
return s;
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Query_Part(String name){ //管理员查询单个课程
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from Course where Cname like '"+(name +"%")+"' order by Cname DESC");
while(rs.next()){
s+="Cno:"+rs.getString("Cno")+"\n"+"Cname:"+rs.getString("Cname")+"\n"+"Credit:"+rs.getString("Credit")
+"\n"+"Caddress:"+rs.getString("Caddress")+"\n"+"Cbegintime:"+rs.getString("Cbegintime")+"\n"+"Cteacher:"+rs.getString("Cteacher")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Display_SC(String sql_displaysc){ //显示个人选课以后的信息(学生)
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql_displaysc);
s+="课程号"+"\t"+"课程名"+"\t"+"地点"+"\t"+"时间"+"\t"+"老师"+"\n";
while(rs.next()){
s+=rs.getString("Cno")+"\t"+rs.getString("Cname")+"\t"+
rs.getString("Caddress")+"\t"+rs.getString("Cbegintime")+"\t"+rs.getString("Cteacher")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Quit_Sc(String quitno){ //学生退选课程
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url,"Administrator","woaini");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ps=con.prepareStatement("delete from SC where Cno=?");
ps.setString(1,quitno);
ps.executeUpdate();
rs=stmt.executeQuery("select * from SC ");
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Lookfor_All(String sql_displayallsc){ //学生查看所有课程被选修的情况
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql_displayallsc);
s+="课程名"+"\t"+"选课人数"+"\n";
while(rs.next()){
s+=rs.getString("Cname")+"\t"+rs.getString("number")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Display_SC_sq(String sql_sq){ //管理员查看所有学生的选修情况
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql_sq);
s+="姓名"+"\t"+"课程名"+"\t"+"所属系别"+"\n";
while(rs.next()){
s+=rs.getString("Sname")+"\t"+rs.getString("Cname")+"\t"+rs.getString("Sdept")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Query_c(String sql15){ //查询选单个课程的所有学生
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql15);
s+="选该课程的所有学生如下:"+"\n";
while(rs.next()){
s+=rs.getString("Sname")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Query_s(String sql16){ //查询单个学生选修的所有课程
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql16);
s+="该同学选修的所有课程如下:"+"\n";
while(rs.next()){
s+=rs.getString("Cname")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String TeacherName(String sql_TN){ //获取教师的名字
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql_TN);
while(rs.next()){
s+=rs.getString("Tname")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String D_Grade(String sql19){ //查询单个学生选修的所有课程
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql19);
s+="课程名"+"\t"+"分数"+"\n";
while(rs.next()){
s+=rs.getString("Cname")+"\t"+rs.getString("Grade")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Query_qc(String sql22){ //按输入的课程的名字显示学生的成绩
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql22);
s+="姓名"+"\t"+"分数"+"\n";
while(rs.next()){
s+=rs.getString("Sname")+"\t"+rs.getString("Grade")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public String Query_qa(String sql23){ //显示所有学生所有课程的成绩
String s="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){System.out.print(e.getMessage());}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql23);
s+="姓名"+"\t"+"课程名"+"\t"+"分数"+"\n";
while(rs.next()){
s+=rs.getString("Sname")+"\t"+rs.getString("Cname")+"\t"+rs.getString("Grade")+"\n";
}
con.close();
stmt.close();
}catch(SQLException e){System.out.println(e.getMessage());}
return s;
}
public void actionPerformed(ActionEvent e)
{
String a;
int num=0;
CardLayout lay=(CardLayout)this.getLayout();
if(e.getSource()==ad_loading) //教师登陆
{
T_userField.setText("");
T_passwordField.setText("");
lay.show(this,"c17");
}
else if(e.getSource()==a_back)
lay.show(this,"ca");
else if(e.getSource()==loading17) //教师输入用户名登陆
{
String Input_Tuser=T_userField.getText();
String Input_Tpassword=T_passwordField.getText();
String sql17="select user_no_T,password_T from Regedit_T where user_no_T='"+Input_Tuser+"' and password_T='"+Input_Tpassword+"'";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e1){System.out.println("not found!");}
try
{
Connection con=DriverManager.getConnection(url,"",null);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery(sql17);
rs.last();
num=rs.getRow();
rs.beforeFirst();
stmt.close();
con.close();
}catch(SQLException ex){}
if(num!=0)
lay.show(this,"cb");
else
{
final Frame frmFrame = new Frame();
JOptionPane.showMessageDialog(frmFrame,"教师的用户名或密码错!");
return;
}
}
else if(e.getSource()==T_regedit)
{
R_TuserField.setText("");
R_TpasswordField.setText("");
R_TrealnameField.setText("");
R_TdeptField.setText("");
lay.show(this,"c18");
}
else if(e.getSource()==ok18) //教师注册
{
String use=R_TuserField.getText();
String word=R_TpasswordField.getText();
String no=R_TuserField.getText();
String name=R_TrealnameField.getText();
String dept=R_TdeptField.getText();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e1){System.out.println("not found!");}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql2="INSERT INTO Regedit_T"+" VALUES('"+use+"','"+word+"')";
stmt.executeUpdate(sql2);
stmt.close();
con.close();
}catch(SQLException ex){System.out.print(ex.getMessage());}
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e1){System.out.println("not found!");}
try{
con=DriverManager.getConnection(url," ",null);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sq18="INSERT INTO Teacher"+" VALUES('"+no+"','"+name+"','"+dept+"')";
stmt.executeUpdate(sq18);
stmt.close();
con.close();
}catch(SQLException ex){System.out.print(ex.getMessage());}
final Frame frmFrame = new Frame();
JOptionPane.showMessageDialog(frmFrame, "注册成功!");
return;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -