outthingscontrol.java

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

/*
 *OutthingsControl.java
 *author:liuhaijing
 */
 
 package mydesign;
 
 import mydesign.*;
 import java.sql.*;
 import java.io.*;
 import java.util.*;//Vector在这个包里
 import mydesign.*;
 
 public class OutthingsControl
 {
 	
 	ResultSet rs=null;
 	String sql=null;
    DBConnect dbconnect=new DBConnect();
 	
 	public OutthingsControl()
 	{
 	}
 	
 	
 	//添加来访信息
 	public String addOutthings(Outthings outthings)
 	{
 		try
 		{
 			sql="insert into outthings (studentid,thing,outtime,inturn) values ('"+outthings.getStudentid()+"','"+outthings.getThing()+"','"+outthings.getOuttime().toString()+"','"+outthings.getInturn()+"');";
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("AddOutthings Bean error:"+ex.getMessage());
 		}
 		return sql;
 	}
	
	//计算查询结果的行数			
 	public int getOutthingsCount(String strsql)
 	{
 		int i=0;
 		try
 		{
 			rs=dbconnect.executeQuery(strsql);
 			while(rs.next())
 			{
 				i=rs.getInt(1);
 			}
 		}
 		catch(Exception ex)
 		{
 			System.out.print("OutthingsControl's getOutthingsCount error:"+ex.getMessage());
 		}
 		return i;
 	}
 			
 	//得到查询结果		
 	public ArrayList getOutthingsInfo(String strsql)
 	{
 			
 		ArrayList a=new ArrayList();
 		try
 		{
 			rs=dbconnect.executeQuery(strsql);
 			while(rs.next())
 			{
 				Outthings outthings=new Outthings();
 				outthings.setID(rs.getInt("id"));
 				if(rs.getString("studentid")!=null) 
 				     outthings.setStudentid(new String(rs.getString("studentid").getBytes("iso-8859-1")));
 				if(rs.getString("thing")!=null) 
 				     outthings.setThing(new String(rs.getString("thing").getBytes("iso-8859-1")));
 				if(rs.getString("outtime")!=null) 
 				     outthings.setOuttime(rs.getDate("outtime").toString());
 				if(rs.getString("inturn")!=null) 
 				     outthings.setInturn(new String(rs.getString("inturn").getBytes("iso-8859-1")));
 				a.add(outthings);
 			}
 			 	rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("VisitorControl's getStudentInfo error:"+ex.getMessage());
 		}
 		return a;
 	}
	
 	//是否存在该学生信息
 	public boolean isExistStudent(Outthings outthings) throws Exception
 	{
 		boolean a=false;
 		try
 		{
 			sql="select * from view_student where studentid='"+outthings.getStudentid()+"' and donghao='"+outthings.getDonghao()+"' and houseid='"+outthings.getHouseid()+"';";
 			rs=dbconnect.executeQuery(sql);
 			if(rs.next())
 			{
 				a=true;
 			}
 			rs.close();
 		}
 		catch(Exception ex)
 		{
 			System.out.print("OutthingsControl's isExistStudent error:"+ex.getMessage());
 		}
 		return a;
 	}

 	///删除学生信息	
 	public void DelOutthings(Outthings outthings) throws Exception
 	{
 		try
 		{
 			sql="delete from outthings where id='"+outthings.getID()+"';";
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("OutthingsControl's DelOutthings Error:"+ex.getMessage());
 		}
 	}
 	
 	//修改学生信息
 	public void UpdateOutthings(Outthings outthings) throws Exception
 	{
 		sql="update outthings set thing='"+outthings.getThing()+"',outtime='"+outthings.getOuttime().toString()+"',inturn='"+outthings.getInturn()+"' where id='"+outthings.getID()+"';";
 		try
 		{
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("OutthingsControl's UpdateOutthings Error:"+ex.getMessage());
 		}
 	}
	
	//得到分页显示数据	
 	public PageBean listData(int page,SearchOutthings searchoutthings) throws Exception 	//获得指定页面，并且封装在PageBean中返回
 	{
 		try
 		{
			int count=getOutthingsCount(searchoutthings.strSQL1);
 			ArrayList result=getOutthingsInfo(searchoutthings.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();
 	}
 }