xueshengbean.java

JSP开发的学生信息管理系统

package xuesheng;
import conn.DataBaseConnection;
import java.sql.Date;
import java.sql.*;
import java.util.*;
import java.io.*;
public class XueshengBean
{
	private Connection con=null;
	public XueshengBean()
	{
		this.con=DataBaseConnection.getConnection();
	}
	
	//学生是否存在
	public boolean existXuesheng(Xuesheng xuesheng) {
        try {
            String studentId = xuesheng.getStudentId();
            PreparedStatement pstmt = con.prepareStatement(
                    "select studentId from xuesheng where studentId='" +
                    studentId + "'");
            ResultSet rst = pstmt.executeQuery();
            if (rst.next()) {
                return true;
            }
        } catch (Exception ex) {
            return false;
        }
        return false;
    }
    public boolean existXuesheng(String studentId) {
        try {
            PreparedStatement pstmt = con.prepareStatement(
                    "select studentId from xuesheng where studentId='" +
                    studentId + "'");
            ResultSet rst = pstmt.executeQuery();
            if (rst.next()) {
                return true;
            }
        } catch (Exception ex) {
            return false;
        }
        return false;
    }
    //添加学生
	public String addXuesheng(Xuesheng xuesheng)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			if (existXuesheng(xuesheng)) {
                return "exist"; //存在此学生
            }
            
			pstmt=con.prepareStatement("insert into xuesheng values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
			pstmt.setString(1,xuesheng.getSpeciality());
			pstmt.setString(2,xuesheng.getStuClass());
			pstmt.setString(3,xuesheng.getStudentId());
			pstmt.setString(4,xuesheng.getStuName());
			pstmt.setString(5,xuesheng.getStuSex());
			pstmt.setString(6,xuesheng.getBirthDate());
			pstmt.setString(7,xuesheng.getJiguan());
			pstmt.setString(8,xuesheng.getShenfenId());
			pstmt.setString(9,xuesheng.getJiatingTelphone());
			pstmt.setString(10,xuesheng.getStuNation());
			pstmt.setString(11,xuesheng.getXueLi());
			pstmt.setString(12,xuesheng.getPhoto());
			pstmt.setString(13,xuesheng.getImage());
			pstmt.setString(14,xuesheng.getDormId());
			pstmt.setString(15,xuesheng.getStuSource());
			pstmt.setString(16,xuesheng.getZhenzmmao());
			pstmt.setString(17,xuesheng.getJiatingAddress());
			pstmt.setString(18,xuesheng.getStuTelphone());
			pstmt.setString(19,xuesheng.getPostID());
			pstmt.setString(20,xuesheng.getBeizu());
			pstmt.setString(21,"666666");
			pstmt.setString(22,"1");
			pstmt.execute();
			str="sucess";
		}catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{	
  	    		 if(pstmt!=null){
  	    		 	pstmt.close();
  	    		 }
  	    		 if(con!=null){
  	    		 	con.close();
  	    		 }
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	}
  	    return str;		
	}
	//更新
	public String updateXuesheng(Xuesheng xuesheng)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("update xuesheng set speciality=?,stuClass=?,stuName=?,stuSex=?,birthDate=?,jiguan=?,shenfenId=?,JiatingTelphone=?,stuNation=?,xueLi=?,dormId=?,stuSource=?,zhenzmmao=?,jiatingAddress=?,stuTelphone=?,postID=?,beizu=? where studentId=?");
			
			pstmt.setString(1,xuesheng.getSpeciality());
			pstmt.setString(2,xuesheng.getStuClass());
			pstmt.setString(3,xuesheng.getStuName());
			pstmt.setString(4,xuesheng.getStuSex());
			pstmt.setString(5,xuesheng.getBirthDate());
			pstmt.setString(6,xuesheng.getJiguan());
			pstmt.setString(7,xuesheng.getShenfenId());
			pstmt.setString(8,xuesheng.getJiatingTelphone());
			pstmt.setString(9,xuesheng.getStuNation());
			pstmt.setString(10,xuesheng.getXueLi());
			pstmt.setString(11,xuesheng.getDormId());
			pstmt.setString(12,xuesheng.getStuSource());
			pstmt.setString(13,xuesheng.getZhenzmmao());
			pstmt.setString(14,xuesheng.getJiatingAddress());
			pstmt.setString(15,xuesheng.getStuTelphone());
			pstmt.setString(16,xuesheng.getPostID());
			pstmt.setString(17,xuesheng.getBeizu());
			pstmt.setString(18,xuesheng.getStudentId());
			pstmt.execute();
			str="sucess";
		}
		catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{
  	    			if(pstmt!=null){
  	    				pstmt.close();
  	    			}	
	  	    		 if(con!=null){
	  	    		 	con.close();
	  	    		 }
  	    		 
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	
  	    	}
  	    return str;	
	}
	
	//更新我的信息
	public String updateMyInfo(Xuesheng xuesheng)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("update xuesheng set birthDate=?,jiguan=?,shenfenId=?,JiatingTelphone=?,stuNation=?,dormId=?,stuSource=?,zhenzmmao=?,jiatingAddress=?,stuTelphone=?,beizu=? where studentId=?");	
			pstmt.setString(1,xuesheng.getBirthDate());
			pstmt.setString(2,xuesheng.getJiguan());
			pstmt.setString(3,xuesheng.getShenfenId());
			pstmt.setString(4,xuesheng.getJiatingTelphone());
			pstmt.setString(5,xuesheng.getStuNation());
			pstmt.setString(6,xuesheng.getDormId());
			pstmt.setString(7,xuesheng.getStuSource());
			pstmt.setString(8,xuesheng.getZhenzmmao());
			pstmt.setString(9,xuesheng.getJiatingAddress());
			pstmt.setString(10,xuesheng.getStuTelphone());
			pstmt.setString(11,xuesheng.getBeizu());
			pstmt.setString(12,xuesheng.getStudentId());
			pstmt.execute();
			str="sucess";
		}
		catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{
  	    			if(pstmt!=null){
  	    				pstmt.close();
  	    			}	
	  	    		 if(con!=null){
	  	    		 	con.close();
	  	    		 }
  	    		 
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	
  	    	}
  	    return str;	
	}
	//删除
	public String deleteXuesheng(String studentId)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("delete from xuesheng where studentId=?"); 
			pstmt.setString(1,studentId);
			pstmt.execute();
			str="sucess";
		}
		catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{	
  	    		 if(pstmt!=null){
  	    				pstmt.close();
  	    			}	
	  	    		 if(con!=null){
	  	    		 	con.close();
	  	    		 }
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	
  	    	}
  	    return str;	
	}
	//退学
	public String exitXuesheng(String studentId)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("update xuesheng set flag=? where studentId=?"); 
			pstmt.setString(1,"3");
			pstmt.setString(2,studentId);
			pstmt.execute();
			str="sucess";
		}
		catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{	
  	    		 if(pstmt!=null){
  	    				pstmt.close();
  	    			}	
	  	    		 if(con!=null){
	  	    		 	con.close();
	  	    		 }
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	
  	    	}
  	   return str; 	
	}
	
	//休学
	public String restXuesheng(String studentId)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("update xuesheng set flag=? where studentId=?"); 
			pstmt.setString(1,"2");
			pstmt.setString(2,studentId);
			pstmt.execute();
			str="sucess";
		}
		catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{	
  	    		 if(pstmt!=null){
  	    				pstmt.close();
  	    			}	
	  	    		 if(con!=null){
	  	    		 	con.close();
	  	    		 }
  	    		}catch(Exception e)
  	    		{
  	    			e.printStackTrace();
  	    		}
  	    	
  	    	}
  	    return str; 	
	}
	//复学
	public String backXuesheng(String studentId)
	{
		PreparedStatement pstmt=null;
		String str="";
		try
		{
			pstmt=con.prepareStatement("update xuesheng set flag=? where studentId=?"); 
			pstmt.setString(1,"1");
			pstmt.setString(2,studentId);
			pstmt.execute();
			str="sucess";
		}
		catch(SQLException ex)
  	    	{
  	    		System.err.println(ex.getMessage());
  	    		str="failer";
  	    	}
  	    	finally
  	    	{
  	    		try{	
  	    		 if(pstmt!=null){
  	    				pstmt.close();
  	    			}	
	  	    		 if(con!=null){
	  	    		 	con.close();
	  	    		 }
  	    		}catch(Exception e)