studentdatafromdb.java

学生选课系统-java做的学生选课系统

package com.window.student;

import java.sql.ResultSet;
import java.util.Vector;

import javax.swing.JOptionPane;

import com.hotdon.men.dataDAO;

public class StudentDatafromDB {
	
    public StudentDatafromDB()
    {
    	
    }
    //获得可选的课程
   public Vector readdCourse(String coursetype)
	{        
	         String coursetyp="";
             coursetyp=coursetype;
		     dataDAO dao=null;
		     dao=(com.hotdon.men.dataDAO) new com.hotdon.men.dataDAOImpl();
		     String QueryString;
		     Vector CheckBoxItem = new Vector();
		     try
		     {    if(coursetyp.trim().equals("全部"))
		          {
		    	     QueryString="select * from 选课课程表";
				     ResultSet rsl=dao.getData(QueryString);
				      while(rsl.next())
			        {  
					  CheckBoxItem.insertElementAt(
							 rsl.getString("课程编号")+"     "
							 + "名称:" +rsl.getString("课程名")+"        "
							 +"类型：" +rsl.getString("课程分类")+"    "
							  +"上课时间："+rsl.getString("上课时间")+"        "
							  +"授课老师："+rsl.getString("教师")+"       "
							  +"学分："+rsl.getString("学分")
							  ,CheckBoxItem.size() );
			        }
		          }else
		          {
		    	    QueryString="select * from 选课课程表 '"+"'where 课程分类='"+coursetyp.trim()+"'";
				    ResultSet rsl=dao.getData(QueryString);
				    while(rsl.next())
   			        {  
				    	CheckBoxItem.insertElementAt(
								 rsl.getString("课程编号")+"     "
								 + "名称:" +rsl.getString("课程名")+"        "
								 +"类型：" +rsl.getString("课程分类")+"    "
								  +"上课时间："+rsl.getString("上课时间")+"        "
								  +"授课老师："+rsl.getString("教师")+"       "
								  +"学分："+rsl.getString("学分")
								  ,CheckBoxItem.size() );
   			        }
		          }
		     }
		     catch(Exception e)
			 {
			    e.printStackTrace();
			 }
		     return CheckBoxItem;
	}
   //获得学生成绩
   public Vector getChengji(String studentNo)
   {  
	  Vector  chengji= new Vector();
	  dataDAO dao=null;
      dao=(com.hotdon.men.dataDAO) new com.hotdon.men.dataDAOImpl();
      String QueryString;
      try
	     {
	    	
	    	 QueryString="select *  from 学生选课表,选课课程表  where 学生选课表.课程编号=选课课程表.课程编号 ";
	    	 ResultSet rsl=dao.getData(QueryString);
	    	 while(rsl.next())
			      {         if(rsl.getString("学号").trim().equals(studentNo.trim())&&!rsl.getString("状态").trim().equals("待批"))
			               {  
			    	         chengji.insertElementAt(
				             rsl.getString("课程编号")+"          " 
				             +"课程名:"+rsl.getString("课程名")+"            " 
				             +"类型:"+rsl.getString("课程分类")+"            " 
				    		 +"成绩:"+rsl.getString("成绩")
				    		 ,chengji.size());
			               }
			      }
			
	     }
	     catch(Exception e)
		 {
		    e.printStackTrace();
		 }
      
      System.out.println(chengji);
      
	  return chengji;
   }
   
   //获得已选课程
	public Vector getOkChoiceCourse(String studentNo)
	{   
		//System.out.println(studentNo);
		 Vector  ChoiceCourse= new Vector();
		 dataDAO dao=null;
	     dao=(com.hotdon.men.dataDAO) new com.hotdon.men.dataDAOImpl();
	     String QueryString;
	     try
	     {
	    	
	    	 QueryString="select *  from 学生选课表,选课课程表  where 学生选课表.课程编号=选课课程表.课程编号 ";
	    	 ResultSet rsl=dao.getData(QueryString);
	    	 while(rsl.next())
			      {        if(rsl.getString("学号").trim().equals(studentNo.trim()))
			               {
				             ChoiceCourse.insertElementAt(
				             rsl.getString("课程编号")+"          " 
				             +"课程名:"+rsl.getString("课程名")+"            " 
				             +"类型:"+rsl.getString("课程分类")+"            " 
				    		 +"自愿号:"+rsl.getString("自愿号")+"            " 
				    		 +"状态:"+rsl.getString("状态")
				    		,ChoiceCourse.size());
			               }
			      }
			
	     }
	     catch(Exception e)
		 {
		    e.printStackTrace();
		 }
	     return ChoiceCourse;
		
		
		
	}
	//添加数据
	public void insertData(String student,String course,String will)
	{
		
		 String studentNo=student;
		 String courseNo=course;
		 String willNo=will;
		 boolean isOK=true;
		 dataDAO dao=null;
	     dao=(com.hotdon.men.dataDAO) new com.hotdon.men.dataDAOImpl();
	     String QueryString;
	     try
	     {   
	    	 
	    	 QueryString="select * from 学生选课表 ";
			 ResultSet rsl=dao.getData(QueryString);
	    	 while(rsl.next())
		     { 
	    		 
	    	     String  stNo=rsl.getString("学号");
	    		 if(rsl.getString("课程编号").equals(courseNo.trim())&stNo.equals(studentNo.trim()))
	    		 {
	    		   JOptionPane.showMessageDialog(null,"添加失败！！！\n你不能选该选课程\n你已选修过！！","提示",JOptionPane.INFORMATION_MESSAGE);
	    		   isOK=false;
	    		   break ;
	    		 }
	    		 if(rsl.getString("自愿号").equals(willNo.trim())&stNo.equals(studentNo.trim()))
	    		 {
	    			   JOptionPane.showMessageDialog(null,"添加失败！！！\n这一自愿号你已选过不能有重复的志愿号！！","提示",JOptionPane.INFORMATION_MESSAGE);
		    		   isOK=false;
		    		   break ;
	    		 }
	    	 }
	    	
	    	 if(isOK)
	    	 {
	    	   QueryString="insert into 学生选课表"+"(学号,课程编号,自愿号)"+"values('"+studentNo+"','"+courseNo+"','"+willNo+"')";
	    	   dao.updateData(QueryString);
	    	   JOptionPane.showMessageDialog(null,"添加成功！！！","提示",JOptionPane.INFORMATION_MESSAGE);
	    	 }
	     }catch(Exception e)
	     {
	    	
	    	 e.printStackTrace();
	     }
	}
	//删除数据
    public void deleteData(String studentNo,String courseNo)
    {
    	
    	 dataDAO dao=null;
	     dao=(com.hotdon.men.dataDAO) new com.hotdon.men.dataDAOImpl();
	     String QueryString;
	     QueryString="delete 学生选课表 from 学生选课表  where 学号='"+studentNo.trim()+"'"+"  and  课程编号='"+courseNo.trim()+"'";
    	try
    	{
	     dao.updateData(QueryString);
	     JOptionPane.showMessageDialog(null,"删除成功！！！","提示",JOptionPane.INFORMATION_MESSAGE);
    	}catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
    //删除数据
	public void updataPassword(String studentNo,String newpassword)
	{
		 dataDAO dao=null;
	     dao=(com.hotdon.men.dataDAO) new com.hotdon.men.dataDAOImpl();
	     String QueryString;
	     QueryString="update  学生表  set 选课登陆密码='"+newpassword.trim()+"'"+"  where 学号='"+studentNo.trim()+"'";
	     try
	    	{
		     dao.updateData(QueryString);
		     JOptionPane.showMessageDialog(null,"更改成功！！！","提示",JOptionPane.INFORMATION_MESSAGE);
	    	}catch(Exception e)
	    	{
	    		e.printStackTrace();
	    	}
		
	}

}