chengjicaxun.java

学生成绩管理系统可以查询修改成绩 修改密码 删除填加成绩

										}
									} 
									catch (SQLException e) 
									{
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
								
							}
						//System.out.println(x);	
						}
							
					}
					else if(jrb2.isSelected())
					{
						if((t2==null||t2.getText().equals("")))
						{
							JOptionPane.showMessageDialog(null,"对不起，您没有没有输入姓名，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
								
						}
						else
						{
							if(jcb.getSelectedItem().equals("第一学期"))
							{
								String sql1="select * from term1 where sname='" + b + "'";
								ResultSet rs1=db.executeQuery(sql1);
								try {
										while(rs1.next())
										{
										
											sno=rs1.getString(1);
											sname=rs1.getString(2);
											smath=rs1.getString(3);
											senglish=rs1.getString(4);
											schinese=rs1.getString(5);
											String[] row={sno,sname,smath,senglish,schinese};
											md.addRow(row);
											return;

										}
										if(!rs1.next())
										{
											JOptionPane.showMessageDialog(null,"对不起，您输入的姓名没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
										}
									} 
									catch (SQLException e) 
									{
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
									
									
							}
							else if(jcb.getSelectedItem().equals("第二学期"))
							{
								String sql1="select * from term2 where sname='" + b + "'";
								ResultSet rs1=db.executeQuery(sql1);
								try {
										while(rs1.next())
										{
										
											sno=rs1.getString(1);
											sname=rs1.getString(2);
											smath=rs1.getString(3);
											senglish=rs1.getString(4);
											schinese=rs1.getString(5);
											String[] row={sno,sname,smath,senglish,schinese};
											md.addRow(row);
											return;

										}
										if(!rs1.next())
										{
											JOptionPane.showMessageDialog(null,"对不起，您输入的姓名没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
										}
									} 
									catch (SQLException e) 
									{
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
							}
						}
							
					}
					
					else if(jrb4.isSelected()) //下拉列表项的选择，置第一项为已选
					{
						if(jcb.getSelectedItem().equals("第一学期"))
						{	
							if(jcb1.getSelectedItem().equals("数学"))
							{
								String sql4="select * from term1";
								ResultSet rs4=db.executeQuery(sql4);
								try {
										while(rs4.next())
										{
										
											sno=rs4.getString(1);
											sname=rs4.getString(2);
											smath=rs4.getString(3);
											//senglish=rs4.getString(4);
											//schinese=rs4.getString(5);
											String[] row={sno,sname,smath,null,null};
											md.addRow(row);
										
										}
										
									} 
									catch (SQLException e) 
									{
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
							}
							
							else if(jcb1.getSelectedItem().equals("英语"))
							{
								String sql７="select * from term1";
								ResultSet rs７=db.executeQuery(sql７);
								try {
										while(rs７.next())
										{
										
											sno=rs７.getString(1);
											sname=rs７.getString(2);
											smath=rs７.getString(3);
											senglish=rs７.getString(4);
											schinese=rs７.getString(5);
											String[] row={sno,sname,null,senglish,null};
											md.addRow(row);
											
										}
										
									} 
									catch (SQLException e) 
									{
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
							}
							else if(jcb1.getSelectedItem().equals("语文"))
							{
								String sql8="select * from term1";
								ResultSet rs8=db.executeQuery(sql8);
								try {
										while(rs8.next())
										{
										
											sno=rs8.getString(1);
											sname=rs8.getString(2);
											smath=rs8.getString(3);
											senglish=rs8.getString(4);
											schinese=rs8.getString(5);
											String[] row={sno,sname,null,null,schinese};
											md.addRow(row);
										
										}
										
									} 
									catch (SQLException e) 
									{
										// TODO Auto-generated catch block
										e.printStackTrace();
									}
							}
							
						}
						if(jcb.getSelectedItem().equals("第二学期"))
						{	
							
								
								if(jcb1.getSelectedItem().equals("数学"))
								{
									String sql9="select * from term2";
									ResultSet rs9=db.executeQuery(sql9);
									try {
											while(rs9.next())
											{
											
												sno=rs9.getString(1);
												sname=rs9.getString(2);
												smath=rs9.getString(3);
												senglish=rs9.getString(4);
												schinese=rs9.getString(5);
												String[] row={sno,sname,smath,null,null};
												md.addRow(row);
												
											}
											
										} 
										catch (SQLException e) 
										{
											// TODO Auto-generated catch block
											e.printStackTrace();
										}
								}
								
								else if(jcb1.getSelectedItem().equals("英语"))
								{
									String sql10="select * from term2";
									ResultSet rs10=db.executeQuery(sql10);
									try {
											while(rs10.next())
											{
											
												sno=rs10.getString(1);
												sname=rs10.getString(2);
												smath=rs10.getString(3);
												senglish=rs10.getString(4);
												schinese=rs10.getString(5);
												String[] row={sno,sname,null,senglish,null};
												md.addRow(row);
											
											}
											
										} 
										catch (SQLException e) 
										{
											// TODO Auto-generated catch block
											e.printStackTrace();
										}
								}
								else if(jcb1.getSelectedItem().equals("语文"))
								{
									String sql11="select * from term2";
									ResultSet rs11=db.executeQuery(sql11);
									try {
											while(rs11.next())
											{
											
												sno=rs11.getString(1);
												sname=rs11.getString(2);
												smath=rs11.getString(3);
												senglish=rs11.getString(4);
												schinese=rs11.getString(5);
												String[] row={sno,sname,null,null,schinese};
												md.addRow(row);
												
											}
											
										} 
										catch (SQLException e) 
										{
											// TODO Auto-generated catch block
											e.printStackTrace();
										}
								}
						}
						
					}
						
				}
			
				else
				{
				//JOptionPane.showMessageDialog(null,"对不起，您没有选择查询方式，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);

					if(jcb.getSelectedItem().equals("第一学期"))
					{
						String sql5="select * from term1";
						ResultSet rs5=db.executeQuery(sql5);
						try {
								while(rs5.next())
								{
								
									sno=rs5.getString(1);
									sname=rs5.getString(2);
									smath=rs5.getString(3);
									senglish=rs5.getString(4);
									schinese=rs5.getString(5);
									String[] row={sno,sname,smath,senglish,schinese};
									md.addRow(row);
								}
							} 
							catch (SQLException e) 
							{
								// TODO Auto-generated catch block
								e.printStackTrace();
							}
							
					}
					else if(jcb.getSelectedItem().equals("第二学期"))
					{
						String sql6="select * from term2";
						ResultSet rs6=db.executeQuery(sql6);
						try {
								while(rs6.next())
								{
								
									sno=rs6.getString(1);
									sname=rs6.getString(2);
									smath=rs6.getString(3);
									senglish=rs6.getString(4);
									schinese=rs6.getString(5);
									String[] row={sno,sname,smath,senglish,schinese};
									md.addRow(row);
								}
							} 
							catch (SQLException e) 
							{
								// TODO Auto-generated catch block
								e.printStackTrace();
							}
							
						}
					}
				}
		
			}
		}

		
	public static void main(final String[] args)
	{
		new Chengjicaxun().setVisible(true);

	}

}