teacherlogin.java

用Java与MySQL开发的小型学生成绩管理系统

		rs=null;
	}
	}
		return a;
}
	
	public String chaxun7(String x)
	{  
		ResultSet rs=null,b=null;
		String a=new String();
	try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("select  kechenghao from ke where ke.kecheng=?");
	    checkUser.setString(1,x);
	    rs = checkUser.executeQuery();
	  if(rs.next()) 
		  {
		  a=rs.getString(1);
		 }
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	finally
	{if(rs!=null)
	{try
		{ rs.close();
			}
		catch(SQLException e){}
		rs=null;
	}
	}
		return a;
	}
	public String chaxun9(String x)
	{  
		ResultSet rs=null,b=null;
		String a=new String();
		
	try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("SELECT bianhao FROM jiaoshi WHERE jiaoshiming=?");
	   checkUser.setString(1,x);
	  rs = checkUser.executeQuery();
	  if(rs.next()) 
		  {a=rs.getString(1);
		  }
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	finally
	{if(rs!=null)
	{try
		{ rs.close();
			}
		catch(SQLException e){}
		rs=null;
	}
	}
		return a;
	}
	/*public String[][] chaxun10(String x)
	{  
		ResultSet rs=null,b=null;
		String[][] a=new String[1][2];
		int n=0;
	try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("select xingming,banji from jiben where xuehao=?");
	    checkUser.setString(1,x);
	    rs = checkUser.executeQuery();
	  if(rs.next())
		  {
		  a[0][0]=rs.getString(1);
		  a[0][1]=rs.getString(2);
		
		  }
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	finally
	{if(rs!=null)
	{try
		{ rs.close();
			}
		catch(SQLException e){}
		rs=null;
	}
	}
		return a;
}*/
	
	public String[][] chaxun11(String x,String y,String z)
	{  
		ResultSet rs=null,b=null;
		String[][] a=new String[1][2];
		int n=0;
	try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("select xingming,banji from jiben where xuehao=? and banji in (select distinct banji from jiaoban where bianhao=? and kechenghao=?)");
	    checkUser.setString(1,x);
	   checkUser.setString(2, y);
	   checkUser.setString(3, z);
	    rs = checkUser.executeQuery();
	  if(rs.next())
		  {
		  a[0][0]=rs.getString(1);
		  a[0][1]=rs.getString(2);
		
		  }
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	finally
	{if(rs!=null)
	{try
		{ rs.close();
			}
		catch(SQLException e){}
		rs=null;
	}
	}
		return a;
}
		public String[][] chaxun12(String x,String y)
	{  
		ResultSet rs=null,b=null;
		String[][] a=new String[1][3];
		int n=0;
	try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("select xingming,banji,chengji from jiben,fen,ke where jiben.xuehao=? and kecheng=? and jiben.xuehao=fen.xuehao and ke.kechenghao=fen.kechenghao");
	    checkUser.setString(1,x);
	   checkUser.setString(2, y);
	    rs = checkUser.executeQuery();
	  if(rs.next()) 
		  {a[0][0]=rs.getString(1);
		   a[0][1]=rs.getString(2);
		   a[0][2]=rs.getString(3);
		  }
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	finally
	{if(rs!=null)
	{try
		{ rs.close();
			}
		catch(SQLException e){}
		rs=null;
	}
	}
		return a;
}
		public String chaxun13(String x,String y)
		{  
			ResultSet rs=null,b=null;
			String a=new String();
			int n=0;
		try
			{DBConnection dbConn = new DBConnection();
			Connection conn = DBConnection.getConncetion();
			PreparedStatement checkUser = conn.prepareStatement("select chengji from fen where xuehao=? and kechenghao=?");
		    checkUser.setString(1,x);
		   checkUser.setString(2, y);
		    rs = checkUser.executeQuery();
		  if(rs.next())
			  a=rs.getString(1);
			}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{if(rs!=null)
		{try
			{ rs.close();
				}
			catch(SQLException e){}
			rs=null;
		}
		}
			return a;
	}
		
	public int charu1(String x,String y,String z)
	{  
		int i=0;
		try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("insert into fen values(?,?,?)");
	   checkUser.setString(1,x);
	   checkUser.setString(2, y);
	   checkUser.setString(3, z);
	  i = checkUser.executeUpdate();
	  conn.close();
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	
		return i;
	}
	public int shanchu1(String x,String y)
	{  
		int i=0;
		try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("delete from fen where xuehao=? and kechenghao=(select kechenghao from ke where kecheng=?)");
	   checkUser.setString(1,x);
	   checkUser.setString(2, y);
	  i = checkUser.executeUpdate();
	  conn.close();
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	
		return i;
	}

	public int xiugai1(String x,String y,String z)
	{  
		int i=0;
		try
		{DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("update fen set chengji=? where xuehao=? and kechenghao=(select kechenghao from ke where kecheng=?)");
	   checkUser.setString(1,x);
	   checkUser.setString(2, y);
	   checkUser.setString(3, z);
	  i = checkUser.executeUpdate();
	  conn.close();
		}
	catch(Exception e)
	{
		e.printStackTrace();
	}
		return i;
	}
	class change extends JFrame {
	private JLabel a=new JLabel("旧密码：");
	private JLabel b=new JLabel("新密码：");
	private JLabel c=new JLabel("确认新密码：");
	private JTextField a1=new JTextField("",6);
	private JTextField b1=new JTextField("",6);
	private JTextField c1=new JTextField("",6);
	JButton d=new JButton("确定");
	JButton e=new JButton("取消");
	public change()
	{
	
	JPanel f=new JPanel(new FlowLayout());
	JPanel g=new JPanel(new FlowLayout());
	JPanel h=new JPanel(new FlowLayout());
	JPanel i=new JPanel(new FlowLayout());
	setLayout(new GridLayout(4,2));
	f.add(a);
    f.add(a1);
    g.add(b);
    g.add(b1);
    h.add(c);
    h.add(c1);
    i.add(d);
    i.add(e);
    add(f);
    add(g);
    add(h);
    add(i);
    d.addActionListener(new ActionListener()
    {
    	public void actionPerformed(ActionEvent e)
    	{
    		String a2=a1.getText();
    		String b2=b1.getText();
    		String c2=c1.getText();
    		String a3=password;
    		Connection conn=null;
    		PreparedStatement checkUser=null;
    		String sql="UPDATE jiaoshi SET mima=? WHERE mima=? and bianhao=?";
    		Statement stmt = null;
    		bianhao=chaxun9(text1.getText());
    		if(!(a2.equals(a3)))
    		{
    		JOptionPane.showMessageDialog(null, "原密码输入错误\n请确认后重新输入!","提示",JOptionPane.INFORMATION_MESSAGE);
    		a1.setText("");
    		b1.setText("");
    		c1.setText("");
    		}
    		else if(!(b2.equals(c2)))
    		{
    			JOptionPane.showMessageDialog(null, "新旧密码输入不一致\n请确认后重新输入!","提示",JOptionPane.INFORMATION_MESSAGE);
    		b1.setText("");
    		c1.setText("");
    		}
    	 
    		else
    		{
    			try
    			{DBConnection dbConn = new DBConnection();
    			 conn = DBConnection.getConncetion();	
    		     checkUser = conn.prepareStatement(sql);
    		     checkUser.setString(1, b2);
    		     checkUser.setString(2,a3);
    		     checkUser.setString(3, bianhao);
    		     int i=checkUser.executeUpdate();
       		   if(i!=0)
    			{
    				JOptionPane.showMessageDialog(null, "密码设置成功！","提示",JOptionPane.INFORMATION_MESSAGE);
    				}
    			}
    			catch(Exception m)
    			{
    				m.printStackTrace();
    			   }
    			finally
    			{
    			try
    			{
    				conn.close();
    			    checkUser.close();
    			}
    			catch(SQLException h)
    			{
    				h.printStackTrace();
    			}
 }
    				
    	}
               }
}
);
    e.addActionListener(new ActionListener()
    {
    	public void actionPerformed(ActionEvent e)
    	{
    		a1.setText("");
    		b1.setText("");
    		c1.setText("");
    	}
    });
	}
}
}