visitorcontrol.java

利用java编写的一个学生宿舍管理系统

/*
 *VisitorControl.java
 *author:liuhaijing
 */
 
 package mydesign;
 
 import mydesign.*;
 import java.sql.*;
 import java.io.*;
 import java.util.*;//Vector在这个包里
 import mydesign.*;
 
 public class VisitorControl
 {
 	
 	ResultSet rs=null;
 	String sql=null;
    DBConnect dbconnect=new DBConnect();
 	
 	public VisitorControl()
 	{
 	}
 	
 	
 	//添加来访信息
 	public void addVisitor(Visitor visitor)
 	{
 		try
 		{
 			sql="insert into visitor (visitornm,studentid,guanxi,zhengjian,zjnm,visittime,inturn) values ('"+visitor.getVisitornm()+"','"+visitor.getStudentid()+"','"+visitor.getGuanxi()+"','"+visitor.getZhengjian()+"','"+visitor.getZjnm()+"','"+visitor.getVisittime().toString()+"','"+visitor.getInturn()+"');";
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("AddVisitor Bean error:"+ex.getMessage());
 		}
 	}
	
	//计算查询结果的行数			
 	public int getVisitorCount(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 getVisitorInfo(String strsql)
 	{
 			
 		ArrayList a=new ArrayList();
 		try
 		{
 			rs=dbconnect.executeQuery(strsql);
 			while(rs.next())
 			{
 				Visitor visitor=new Visitor();
 				visitor.setID(rs.getInt("id"));
 				visitor.setDonghao(new String(rs.getString("donghao").getBytes("iso-8859-1")));
 				visitor.setHouseid(new String(rs.getString("houseid").getBytes("iso-8859-1")));
 				if(rs.getString("visitornm")!=null) 
 				     visitor.setVisitornm(new String(rs.getString("visitornm").getBytes("iso-8859-1")));
 				if(rs.getString("name")!=null) 
 				     visitor.setVisitednm(new String(rs.getString("name").getBytes("iso-8859-1")));
 				if(rs.getString("guanxi")!=null) 
 				     visitor.setGuanxi(new String(rs.getString("guanxi").getBytes("iso-8859-1")));
 				if(rs.getString("zhengjian")!=null) 
 				     visitor.setZhengjian(new String(rs.getString("zhengjian").getBytes("iso-8859-1")));
 				if(rs.getString("zjnm")!=null) 
 				     visitor.setZjnm(new String(rs.getString("zjnm").getBytes("iso-8859-1")));
 				if(rs.getString("visittime")!=null) 
 				     visitor.setVisittime(rs.getDate("visittime").toString());
 				if(rs.getString("inturn")!=null) 
 				     visitor.setInturn(new String(rs.getString("inturn").getBytes("iso-8859-1")));
 				a.add(visitor);
 			}
 			 	rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("VisitorControl's getStudentInfo error:"+ex.getMessage());
 		}
 		return a;
 	}
	
 	//被访者的房间是否正确
 	public String isExistStudent(Visitor visitor) throws Exception
 	{
 		String a=null;
 		try
 		{
 			sql="select * from view_student where name='"+visitor.getVisitednm()+"' and donghao='"+visitor.getDonghao()+"' and houseid='"+visitor.getHouseid()+"';";
 			rs=dbconnect.executeQuery(sql);
 			if(rs.next())
 			{
 				a=rs.getString("studentid");
 			}
 			rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("VisiotorControl's isExistStudent error:"+ex.getMessage());
 		}
 		return a;
 	}

 	///删除来访信息	
 	public void DelVisitor(Visitor visitor) throws Exception
 	{
 		try
 		{
 			sql="delete from Visitor where id='"+visitor.getID()+"';";
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("VisitorControl's DelVisitor Error:"+ex.getMessage());
 		}
 	}
 	
 	//修改来访信息
 	public String UpdateVisitor(Visitor visitor) throws Exception
 	{
 		sql="update visitor set visitornm='"+visitor.getVisitornm()+"',zjnm='"+visitor.getZjnm()+"',guanxi='"+visitor.getGuanxi()+"',zhengjian='"+visitor.getZhengjian()+"',visittime='"+visitor.getVisittime().toString()+"',inturn='"+visitor.getInturn()+"' where id='"+visitor.getID()+"';";
 		try
 		{
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("StudentControl's UpdateStudent Error:"+ex.getMessage());
 		}
 		return sql;
 	}
	
	//得到分页显示数据	
 	public PageBean listData(int page,SearchVisitor searchvisitor) throws Exception 	//获得指定页面，并且封装在PageBean中返回
 	{
 		try
 		{
			int count=getVisitorCount(searchvisitor.strSQL1);
 			ArrayList result=getVisitorInfo(searchvisitor.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();
 	}
 }