standardcontrol.java

学生宿舍管理系统旨在使用计算机管理系统简化学校传统的管理模式

/*
 *StandardControl.java
 *author:liuhaijing
 */
 
 package mydesign;
 
 import mydesign.*;
 import java.sql.*;
 import java.io.*;
 import java.util.*;
 import mydesign.*;
 public class StandardControl
 {
 	
 	ResultSet rs=null;
 	String sql=null;

    DBConnect dbconnect=new DBConnect();   //JDBC连接Bean
 	
 	public StandardControl() //构造函数
 	{
 	}
 	
	
 	public Standard getStandardInfo()  //得到查询结果
 	{	
 		Standard standard=new Standard();
 		try
 		{
 			sql="select * from standard where id=1;";
 			rs=dbconnect.executeQuery(sql);
 			if(rs.next())
 			{
 				standard.setWstd(rs.getString("wstd"));
 				standard.setEstd(rs.getString("estd"));
 			}
 		}
 		catch(Exception ex)
 		{
 			System.out.print("HouseControl's getHouseInfo error:"+ex.getMessage());
 		}
 		return standard;
 	}
	
 	public void UpdateStandard(String wstd,String estd) throws Exception   //修改房间信息
 	{
 		try
 		{
 			sql="update standard set wstd='"+wstd+"',estd='"+estd+"' where id=1;";
 			dbconnect.executeUpdate(sql);
 		}
 		catch(Exception ex)
 		{
 			System.out.print("HouseControl's UpdateHouse Error:"+ex.getMessage());
 		}
 	}
 	
 	 	
 	//close
 	public void close()
 	{
 		dbconnect.close();
 	}
 }