studentcontrol1.java

学生宿舍管理系统(含源代码) 使用SQL Server 2000的企业管理器

/*
 *StudentControl.java
 *author:liuhaijing
 */
 
 package mydesign;
 
 import mydesign.*;
 import java.sql.*;
 import java.io.*;
 import java.util.*;//Vector在这个包里
 import mydesign.*;
 
 public class StudentControl
 {
 	
 	ResultSet rs=null;
 	String sql=null;
 	String sql1=null;
 	DBConnect dbconnect=new DBConnect();
    	
 	public StudentControl()
 	{
 	}
 		
 	//add the Student
 	public String addStudent(Student student)
 	{
 		sql="insert into student(studentid,name,sex,home,years,nianzhi,xueyuan,classid,extra) values ('"+student.getStudentid()+"','"+student.getName()+"','"+student.getSex()+"','"+student.getHome()+"','"+student.getYears()+"','"+student.getNianzhi()+"','"+student.getXueyuan()+"','"+student.getClassid()+"','"+student.getExtra()+"');";
 		try
 		{
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's addStudent error:"+ex.getMessage());
 		}
 		return sql1;
 	}

 		
 	//add the StudentHouse
 	public String addStudentHouse(Student student)
 	{
 		sql="insert into studenthouse(studentid,donghao,houseid) values ('"+student.getStudentid()+"','"+student.getDonghao()+"','"+student.getHouseid()+"');";
 		try
 		{
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's addStudentHouse error:"+ex.getMessage());
 		}
 		return sql1;
 	} 	
 			
 	public int getStudentCount(String strsql)  //计算查询结果的行数
 	{
 		int i=0;
 		try
 		{
 			rs=dbconnect.executeQuery(strsql);
 			while(rs.next())
 			{
 				i=rs.getInt(1);
 			}
 		}
 		catch(Exception ex)
 		{
 			System.out.print("HouseControl's getHouseInfo error:"+ex.getMessage());
 		}
 		return i;
 	}
 			
 	//getStudentInfo		
 	public ArrayList getStudentInfo(String strsql)
 	{
 			
 		ArrayList a=new ArrayList();
 		try
 		{
 			rs=dbconnect.executeQuery(strsql);
 			while(rs.next())
 			{
 				Student student=new Student();
 				student.setStudentid(new String(rs.getString("studentid").getBytes("iso-8859-1")));
 				student.setName(new String(rs.getString("name").getBytes("iso-8859-1")));
 				student.setSex(new String(rs.getString("sex").getBytes("iso-8859-1")));
 				student.setHome(new String(rs.getString("home").getBytes("iso-8859-1")));
 				student.setYears(new String(rs.getString("years").getBytes("iso-8859-1")));
 				student.setNianzhi(new String(rs.getString("nianzhi").getBytes("iso-8859-1")));
 				student.setXueyuan(new String(rs.getString("xueyuan").getBytes("iso-8859-1")));
 				student.setClassid(new String(rs.getString("classid").getBytes("iso-8859-1")));
 				student.setDonghao(new String(rs.getString("donghao").getBytes("iso-8859-1")));
 				student.setHouseid(new String(rs.getString("houseid").getBytes("iso-8859-1")));
 				student.setExtra(new String(rs.getString("extra")));
 				a.add(student);
 			}
 			 	rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's getStudentInfo error:"+ex.getMessage());
 		}
 		return a;
 	}
 		
 	//isExist Student
 	public boolean isExistStudent(String studentid) throws Exception
 	{
 		boolean a=false;
 		try
 		{
 			sql="select * from student where studentid='"+studentid+"';";
 			rs=dbconnect.executeQuery(sql);
 			if(rs.next())
 			{
 				a=true;
 			}
 			rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's isExistStudent error:"+ex.getMessage());
 		}
 		return a;
 	}
 		
 	//isExist StudentHouse
 	public boolean isExistStudentHouse(String studentid) throws Exception
 	{
 		boolean a=false;
 		try
 		{
 			sql="select * from studenthouse where studentid='"+studentid+"';";
 			rs=dbconnect.executeQuery(sql);
 			if(rs.next())
 			{
 				a=true;
 			}
 			rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's isExistStudentHouse error:"+ex.getMessage());
 		}
 		return a;
 	}
 		
 	///DelStudent	
 	public void DelStudent(Student student) throws Exception
 	{
 		sql="delete from student where studentid='"+student.getStudentid()+"';";
 		sql1="delete from studenthouse where studentid='"+student.getStudentid()+"';";
 		try
 		{
 			dbconnect.executeUpdate(sql);
 			dbconnect.executeUpdate(sql1);
 			
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's DelStudent Error:"+ex.getMessage());
 		}
 	}
 	
 	///DelStudentHouse	
 	public void DelStudentHouse(Student student) throws Exception
 	{
 		sql="delete from student_house where studentid='"+student.getStudentid()+"';";
 		try
 		{
 			dbconnect.executeUpdate(sql);	
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's DelStudentHouse Error:"+ex.getMessage());
 		}
 	}
 		
 			
 	//UpdateStudent
 	public void UpdateStudent(Student student) throws Exception
 	{
 		sql="update student set name='"+student.getName()+"',sex='"+student.getSex()+"',home='"+student.getHome()+"',years='"+student.getYears()+"',nianzhi='"+student.getNianzhi()+"',xueyuan='"+student.getXueyuan()+"',classid='"+student.getClassid()+"',extra='"+student.getExtra()+"' where studentid='"+student.getStudentid()+"';";
 		try
 		{
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's UpdateStudent Error:"+ex.getMessage());
 		}
 	}
 	
 	//UpdateStudentHouse
 	public void UpdateStudentHouse(Student student) throws Exception
 	{
 		sql="update studenthouse set donghao='"+student.getDonghao()+"',houseid='"+student.getHouseid()+"' where studentid='"+student.getStudentid()+"';";
 		try
 		{
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's UpdateStudentHouse Error:"+ex.getMessage());
 		}
 	}
 	
 	public PageBean listData(int page,SearchStudent searchstudent) throws Exception 	//获得指定页面，并且封装在PageBean中返回
 	{
 		try
 		{
			int count=getStudentCount(searchstudent.strSQL1);
 			ArrayList result=getStudentInfo(searchstudent.strSQL);
			PageBean pagebean=new PageBean(count,result);
 			ArrayList v=new ArrayList();
 			int x=(pagebean.maxRowCount<page*pagebean.rowsPerPage?pagebean.maxRowCount:page*pagebean.rowsPerPage);
 			for(int i=pagebean.rowsPerPage*(page-1);i<x;i++)
 			{
 				v.add(result.get(i));
 			}
 			pagebean.curPage=page;
 			pagebean.data=v;
 			return pagebean;
 		}
 		catch(Exception ex)
 		{
 			ex.printStackTrace();
 			throw ex;
 		}
 	}
 	
 	//close
 	public void close()
 	{
 		dbconnect.close();
 	}
 }