data.java

一个学籍管理系统。

/*
 * Created on 2004-5-30
 */
/**
 * @author Zhou Qi
 * @use 
 */
import java.util.*;
import java.sql.*;
import java.io.*;

public class Data
{
	private AbstractStudent _student;
	private int _studentType;
	private int _studentNumber;
	private String _studentPassword;	
	private String _sql;
	private SeConvert convert=new SeConvert();
	
	public boolean newStudent(AbstractStudent student,String password)
	{
		
		String _studentPassword=password;
		int _studentNumber=student.getStudentID();
		String _studentName=student.getName();
		String _studentYear=student.getYear();
		int _studentAge=student.getAge();
		String _studentDepartment=null;
		String _studentTeacher=null;
		if(student instanceof GraStudent)
		{
			_studentType=0;
			_studentDepartment=((GraStudent)student).getDepartment();
		}
		else
		{
			_studentType=1;
			_studentTeacher=((BachlorStudent)student).getTeacher();
		}
		_sql="INSERT INTO student(studentNumber,studentPassword,studentType,studentYear"
		    +",studentTeacher,studentDepartment,studentAge,studentName)"
	   	    +"VALUES('"+_studentNumber+"','"+_studentPassword+"','"+_studentType+"','"+_studentYear+"',"
	   	    +"'"+_studentTeacher+"','"+_studentDepartment+"','"+_studentAge+"','"+_studentName+"')";
	   	Access myaccess=Access.getAccess();
		try
		{
			myaccess.execUpdate(_sql);
		}
		catch(Exception ex)
		{
			System.out.println(ex);
			return false;
		}
		finally
		{
			myaccess.closeConnection();
		}
		return true;
    }
    
    public ResultSet getAllStudent()
    {
    	ResultSet rs=null;
    	_sql="SELECT * FROM student";
    	Access myaccess=Access.getAccess();
    	try
    	{
    		rs=myaccess.execQuery(_sql);
		}
    	catch(Exception ex)
    	{
    		//System.out.println(ex);
    		
    	}
    	finally
    	{
    		//myaccess.closeConnection();
    	}
    	return rs;
     }
    public static List convertStudent(ResultSet rs)
    {
    	List mylist=new ArrayList();
    	AbstractStudent student=null;
    	BachlorStudent bachlorstudent=new BachlorStudent();
    	GraStudent grastudent=new GraStudent();
    	try
    	{
    		while(rs.next())
    		{
    			if(rs.getInt("studentType")==0)
    			{
    				grastudent.setAge(rs.getInt("studentAge"));
    				grastudent.setName(rs.getString("studentName"));
    				grastudent.setStudentID(rs.getInt("studentNumber"));
    				grastudent.setYear(rs.getString("studentYear"));
    				grastudent.setDepartment(rs.getString("studentDepartment"));
    				student=(AbstractStudent)grastudent;
    				mylist.add(student);  			
    			}
    			else
    			{
    				bachlorstudent.setYear(rs.getString("studentYear"));
    				bachlorstudent.setName(rs.getString("studentName"));
    				bachlorstudent.setAge(rs.getInt("studentAge"));
    				bachlorstudent.setStudentID(rs.getInt("studentNumber"));
    				bachlorstudent.setTeacher(rs.getString("studentTeacher"));
    				student=(AbstractStudent)bachlorstudent;
    				mylist.add(student);
    			}
    			    			
    		}
    		
		}catch(Exception ex){System.out.println(ex);}
    	return mylist;
    }
    
    public AbstractStudent searchStudent(int id)
    {
    	Access myaccess=Access.getAccess();
    	ResultSet rs=null;
    	GraStudent student=new GraStudent();
    	BachlorStudent student2=new BachlorStudent();
    	String _sql="SELECT * FROM student WHERE studentNumber="+id;
    	try
    	{    		
    	rs=myaccess.execQuery(_sql);    		
    	if(rs.next())
    	{
    		
      	if(rs.getType()==0)
    	{
    		student.setDepartment(rs.getString("studentDepartment"));
			student.setAge(rs.getInt("studentAge"));
			student.setName(rs.getString("studentName"));
			student.setYear(rs.getString("studentYear"));
			student.setStudentID(rs.getInt("studentNumber"));
    	    return (AbstractStudent)student;
    	
    	}
    	else
    	{
    		student2.setTeacher(rs.getString("studentTeacher"));
			student2.setAge(rs.getInt("studentAge"));
			student2.setName(rs.getString("studentName"));
			student2.setYear(rs.getString("studentYear"));
			student2.setStudentID(rs.getInt("studentNumber"));
			return (AbstractStudent)student2;
    	}
    	}
    	}
    	catch(Exception ex)
    	{
    		System.out.println(_sql);
    		System.out.println(ex);
    	}
    	finally{myaccess.closeConnection();}
    	return student;
    }
    /*
    public List getList(ResultSet rs)
    {
    	
    
    	List list=new ArrayList();
       	byte[] mybyte=null;
    	try
    	{
    		while(rs.next())
    	    {
    	    	    	
    	    	String str=null;
    	    	str=rs.getString("studentData");
    	    	mybyte=str.getBytes();
    	    	System.out.println(mybyte);
    	    	list.add(convert.convertToStudent(mybyte));
		    }
	   	}
        catch(Exception ex)
        {
           	System.out.println(ex);
        }
        finally{}
       
    	return list;
     }*/
    public boolean updataStudent(AbstractStudent student)
    {
		//String _studentPassword=password;
		int _studentNumber=student.getStudentID();
	    String _studentYear=student.getYear();
	    String _studentName=student.getName();
		int _studentAge=student.getAge();
		String _studentDepartment=null;
		String _studentTeacher=null;
		if(student instanceof GraStudent)
		{
			_studentType=0;
			_studentDepartment=((GraStudent)student).getDepartment();
		}
		else
		{
			_studentType=1;
			_studentTeacher=((BachlorStudent)student).getTeacher();
		}
    	
    	_studentNumber=student.getStudentID();
    	_sql="UPDATE student SET studentYear='"+_studentYear+"',studentName='"+_studentName+"',studentTeacher='"+_studentTeacher+"'"
    	+",studentDepartment='"+_studentDepartment+"',studentAge="+_studentAge+" WHERE studentNumber="+_studentNumber;
    	Access myaccess=Access.getAccess();
    	try
    	{
    		myaccess.execUpdate(_sql);
    	}
    	catch(Exception ex)
    	{
    		System.out.println(_sql);
    		System.out.println(ex);
    	}
    	finally
    	{
    		myaccess.closeConnection();
    	}
    	return true;
    }
    public static void main(String args[])
    {
    	/*
    	GraStudent student=new GraStudent("Jackson4");
    	Data mydata=new Data();
    	mydata.newStudent((AbstractStudent)student,"Jackson");
    	
    	
    	Data mydata=new Data();
    
    	ResultSet rs=mydata.getAllStudent();
		
	    List list=mydata.getList(rs);
		for(int i=0;i<list.size();i++)
		{			
			System.out.println((AbstractStudent)list.get(i));
		}*/
		
		/*GraStudent student=new GraStudent("Good Main");
		student.setStudentID(5);*/
		Data mydata=new Data();
		//mydata.newStudent((AbstractStudent)student,"shit");
		//mydata.updataStudent((AbstractStudent)student);
		AbstractStudent _student=mydata.searchStudent(6);
		System.out.println(_student);
    }
    	
 }
class SeConvert
{
	
	public byte[] convertToByte(AbstractStudent student)
	{
		ByteArrayOutputStream btstream=new ByteArrayOutputStream();
		ObjectOutputStream btwrite=null;
		try
		{
			btwrite=new ObjectOutputStream(btstream);
			btwrite.writeObject((Object)student);
			
		}
		catch(Exception ex){}
		return btstream.toByteArray();
	}
	public AbstractStudent convertToStudent(byte[] mybyte)
	{
		AbstractStudent student=null;
		try
		{
			ByteArrayInputStream btstream=new ByteArrayInputStream(mybyte);
		    ObjectInputStream btread=new ObjectInputStream(btstream);
		    //student=(AbstractStudent)btread.readObject();
		}
		catch(Exception ex){System.out.println(ex);}
		return student;
	}
}