studentcontrol.java

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

/*
 *StudentControl.java
 *author:liuhaijing
 */
 
 package mydesign;
 
 import mydesign.*;
 import java.sql.*;
 import java.io.*;
 import java.util.*;
 import mydesign.*;
 public class StudentControl
 {
 	
 	ResultSet rs=null;
 	String sql=null;  //用于操作学生信息表的字符串
 	String sql1=null;  //用于操作入住信息表的字符串
    DBConnect dbconnect=new DBConnect();   //JDBC连接Bean
 	
 	public StudentControl() //构造函数
 	{
 	}
	
	//添加学生信息	
 	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;
 	}
	
	//添加入住信息	
 	public String addStudentHouse(Student student)
 	{
 		sql="insert into studenthouse (studentid,donghao,houseid,intime) values ('"+student.getStudentid()+"','"+student.getDonghao()+"','"+student.getHouseid()+"','"+student.getIntime()+"');";
 		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;
 	}
 			
 	//得到查询结果		
 	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")));
 				if(rs.getString("name")!=null) 
 				     student.setName(new String(rs.getString("name").getBytes("iso-8859-1")));
 				if(rs.getString("sex")!=null) 
 				     student.setSex(new String(rs.getString("sex").getBytes("iso-8859-1")));
 				if(rs.getString("home")!=null) 
 				     student.setHome(new String(rs.getString("home").getBytes("iso-8859-1")));
 				if(rs.getString("years")!=null) 
 				     student.setYears(new String(rs.getString("years").getBytes("iso-8859-1")));
 				if(rs.getString("nianzhi")!=null) 
 				     student.setNianzhi(new String(rs.getString("nianzhi").getBytes("iso-8859-1")));
 				if(rs.getString("xueyuan")!=null) 
 				     student.setXueyuan(new String(rs.getString("xueyuan").getBytes("iso-8859-1")));
 				if(rs.getString("classid")!=null) 
 				     student.setClassid(new String(rs.getString("classid").getBytes("iso-8859-1")));
 				if(rs.getString("donghao")!=null) 
 				     student.setDonghao(new String(rs.getString("donghao").getBytes("iso-8859-1")));
 				if(rs.getString("houseid")!=null)
 				     student.setHouseid(new String(rs.getString("houseid").getBytes("iso-8859-1")));
 				if(rs.getString("extra")!=null)
 				     student.setExtra(new String(rs.getString("extra").getBytes("iso-8859-1")));
 				if(rs.getDate("Intime")!=null)
 				     student.setIntime(rs.getDate("intime"));
 				a.add(student);
 			}
 			 	rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's getStudentInfo error:"+ex.getMessage());
 		}
 		return a;
 	}
 	
 	//得到查询结果		
 	public Student getStudentInfo(int a,String studentid)
 	{
 			
 		Student student=new Student();
 		try
 		{
 			sql="select * from view_student where studentid='"+studentid+"';";
 			rs=dbconnect.executeQuery(sql);
 			if(rs.next())
 			{
 				student.setStudentid(new String(rs.getString("studentid").getBytes("iso-8859-1")));
 				if(rs.getString("name")!=null) 
 				     student.setName(new String(rs.getString("name").getBytes("iso-8859-1")));
 				if(rs.getString("sex")!=null) 
 				     student.setSex(new String(rs.getString("sex").getBytes("iso-8859-1")));
 				if(rs.getString("home")!=null) 
 				     student.setHome(new String(rs.getString("home").getBytes("iso-8859-1")));
 				if(rs.getString("years")!=null) 
 				     student.setYears(new String(rs.getString("years").getBytes("iso-8859-1")));
 				if(rs.getString("nianzhi")!=null) 
 				     student.setNianzhi(new String(rs.getString("nianzhi").getBytes("iso-8859-1")));
 				if(rs.getString("xueyuan")!=null) 
 				     student.setXueyuan(new String(rs.getString("xueyuan").getBytes("iso-8859-1")));
 				if(rs.getString("classid")!=null) 
 				     student.setClassid(new String(rs.getString("classid").getBytes("iso-8859-1")));
 				if(rs.getString("donghao")!=null) 
 				     student.setDonghao(new String(rs.getString("donghao").getBytes("iso-8859-1")));
 				if(rs.getString("houseid")!=null)
 				     student.setHouseid(new String(rs.getString("houseid").getBytes("iso-8859-1")));
 				if(rs.getString("extra")!=null)
 				     student.setExtra(new String(rs.getString("extra").getBytes("iso-8859-1")));
 				if(rs.getDate("Intime")!=null)
 				     student.setIntime(rs.getDate("intime"));
 			}
 			 	rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's getStudentInfo error:"+ex.getMessage());
 		}
 		return 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;
 	}

 	//是否存在该入住信息
 	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;
 	}

 	//是否存在该入住信息
 	public boolean isExistStudentHouse(Student student) throws Exception
 	{
 		boolean a=false;
 		try
 		{
 			sql="select * from studenthouse where studentid='"+student.getStudentid()+"' and donghao='"+student.getDonghao()+"' and houseid='"+student.getHouseid()+"';";
 			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;
 	}

 	///删除学生信息	
 	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());
 		}
 	}
 	
 	//删除入住信息	
 	public void DelStudentHouse(Student student) throws Exception
 	{
 		sql="delete from studenthouse where studentid='"+student.getStudentid()+"';";
 		try
 		{
 			dbconnect.executeUpdate(sql);	
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's DelStudentHouse Error:"+ex.getMessage());
 		}
 	}

 	//修改学生信息
 	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());
 		}
 	}
 	
 	//修改入住信息
 	public void UpdateStudentHouse(Student student) throws Exception
 	{
 		sql="update studenthouse set donghao='"+student.getDonghao()+"',houseid='"+student.getHouseid()+"',intime='"+student.getIntime()+"' 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();
 	}
 }