webexam.java

一个手机上的考试系统的有服务器源码

	     	//释放资源
	     	rs.close();
	     }
	     catch(Exception e)
	     {
	     	throw new ServletException( e.getMessage() );
	     }
	     //指明所有发送了的数据的字节数
	     response.setContentLength( dos.size() );
	     dos.close();
	     os.close();
	    	return;
	 }

	private void Deal_SubjectBooK(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
	 {
	 	//按照二进制方式进行传输
	 	response.setContentType("application/octet-stream");
	 	OutputStream os = response.getOutputStream();
	 	DataOutputStream dos = new DataOutputStream(os);
	 	try
	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from SubjectBooK");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from SubjectBooK";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetSubjectBooK  info = new SetSubjectBooK();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setSubjectBook_Id( rs.getInt("SubjectBook_Id") );
			info.setSubject_Id( rs.getInt("Subject_Id") );
			info.setSubjectBook_name( rs.getString("SubjectBook_name") );
			info.setClerk_ID( rs.getInt("Clerk_ID") );
			info.setSubjectBool_Learn( rs.getInt("SubjectBool_Learn") );
			info.setSubjectBook_Train( rs.getInt("SubjectBook_Train") );
			info.setSubjectBook_TK_ID( rs.getInt("SubjectBook_TK_ID") );
			info.setCreateTime( rs.getDate("CreateTime").getTime() );
			info.setCreateName( rs.getString("CreateName") );

	 		//序列化为二进制数据
	     		byte[] data = info.serialize();
	     		//一条记录的长度
	     		dos.writeInt( data.length );
	     		dos.write(data);
	     	}
	     	//释放资源
	     	rs.close();
	     }
	     catch(Exception e)
	     {
	     	throw new ServletException( e.getMessage() );
	     }
	     //指明所有发送了的数据的字节数
	     response.setContentLength( dos.size() );
	     dos.close();
	     os.close();
	    	return;
	 }

	private void Deal_SysConfig(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
	 {
	 	//按照二进制方式进行传输
	 	response.setContentType("application/octet-stream");
	 	OutputStream os = response.getOutputStream();
	 	DataOutputStream dos = new DataOutputStream(os);
	 	try
	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from SysConfig");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from SysConfig";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetSysConfig  info = new SetSysConfig();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setAuto_Id( rs.getInt("Auto_Id") );
			info.setKeyType( rs.getString("KeyType") );
			info.setKeyName( rs.getString("KeyName") );
			info.setKeyValue( rs.getString("KeyValue") );
			info.setKeyDescribe( rs.getString("KeyDescribe") );

	 		//序列化为二进制数据
	     		byte[] data = info.serialize();
	     		//一条记录的长度
	     		dos.writeInt( data.length );
	     		dos.write(data);
	     	}
	     	//释放资源
	     	rs.close();
	     }
	     catch(Exception e)
	     {
	     	throw new ServletException( e.getMessage() );
	     }
	     //指明所有发送了的数据的字节数
	     response.setContentLength( dos.size() );
	     dos.close();
	     os.close();
	    	return;
	 }

	private void Deal_SysLog(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
	 {
	 	//按照二进制方式进行传输
	 	response.setContentType("application/octet-stream");
	 	OutputStream os = response.getOutputStream();
	 	DataOutputStream dos = new DataOutputStream(os);
	 	try
	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from SysLog");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from SysLog";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetSysLog  info = new SetSysLog();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setLogId( rs.getInt("LogId") );
			info.setLogClass( rs.getInt("LogClass") );
			info.setLogDescribe( rs.getString("LogDescribe") );
			info.setUserName( rs.getString("UserName") );
			info.setLogDate( rs.getDate("LogDate").getTime() );
			info.setOtherC1( rs.getString("OtherC1") );
			info.setOtherI1( rs.getInt("OtherI1") );

	 		//序列化为二进制数据
	     		byte[] data = info.serialize();
	     		//一条记录的长度
	     		dos.writeInt( data.length );
	     		dos.write(data);
	     	}
	     	//释放资源
	     	rs.close();
	     }
	     catch(Exception e)
	     {
	     	throw new ServletException( e.getMessage() );
	     }
	     //指明所有发送了的数据的字节数
	     response.setContentLength( dos.size() );
	     dos.close();
	     os.close();
	    	return;
	 }

	private void Deal_SysVersion(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
	 {
	 	//按照二进制方式进行传输
	 	response.setContentType("application/octet-stream");
	 	OutputStream os = response.getOutputStream();
	 	DataOutputStream dos = new DataOutputStream(os);
	 	try
	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from SysVersion");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from SysVersion";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetSysVersion  info = new SetSysVersion();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setAuto_Id( rs.getInt("Auto_Id") );
			info.setKeyName( rs.getString("KeyName") );
			info.setKeyValue( rs.getString("KeyValue") );
			info.setMemo( rs.getString("Memo") );

	 		//序列化为二进制数据
	     		byte[] data = info.serialize();
	     		//一条记录的长度
	     		dos.writeInt( data.length );
	     		dos.write(data);
	     	}
	     	//释放资源
	     	rs.close();
	     }
	     catch(Exception e)
	     {
	     	throw new ServletException( e.getMessage() );
	     }
	     //指明所有发送了的数据的字节数
	     response.setContentLength( dos.size() );
	     dos.close();
	     os.close();
	    	return;
	 }

	private void Deal_TrainBook_File(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
	 {
	 	//按照二进制方式进行传输
	 	response.setContentType("application/octet-stream");
	 	OutputStream os = response.getOutputStream();
	 	DataOutputStream dos = new DataOutputStream(os);
	 	try
	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from TrainBook_File");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from TrainBook_File";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetTrainBook_File  info = new SetTrainBook_File();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setFileID( rs.getInt("FileID") );
			info.setFKID( rs.getInt("FKID") );
			info.setFileType( rs.getInt("FileType") );
			info.setFileSite( rs.getInt("FileSite") );
			info.setFileName( rs.getString("FileName") );
			info.setFileExt( rs.getString("FileExt") );
			info.setFileSize( rs.getInt("FileSize") );

			info.setFileMemo( rs.getString("FileMemo") );
			info.setCreateTime( rs.getDate("CreateTime").getTime() );
			info.setCreateName( rs.getString("CreateName") );

	 		//序列化为二进制数据
	     		byte[] data = info.serialize();
	     		//一条记录的长度
	     		dos.writeInt( data.length );
	     		dos.write(data);
	     	}
	     	//释放资源
	     	rs.close();
	     }
	     catch(Exception e)
	     {
	     	throw new ServletException( e.getMessage() );
	     }
	     //指明所有发送了的数据的字节数
	     response.setContentLength( dos.size() );
	     dos.close();
	     os.close();
	    	return;
	 }

	private void Deal_Train_Clerk(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
	 {
	 	//按照二进制方式进行传输
	 	response.setContentType("application/octet-stream");
	 	OutputStream os = response.getOutputStream();
	 	DataOutputStream dos = new DataOutputStream(os);
	 	try
	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from Train_Clerk");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from Train_Clerk";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetTrain_Clerk  info = new SetTrain_Clerk();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setTrainClerkID( rs.getInt("TrainClerkID") );
			info.setTrainID( rs.getInt("TrainID") );
			info.setClerkID( rs.getInt("ClerkID") );
			info.setTrainClerkType( rs.getInt("TrainClerkType") );

	 		//序列化为二进制数据
	     		byte[] data = info.serialize();
	     		//一条记录的长度
	     		dos.writeInt( data.length );
	     		dos.write(data);
	     	}
	     	//释放资源
	     	rs.close();
	     }
	     catch(Exception e)
	     {
	     	throw new ServletException( e.getMessage() );
	     }
	     //指明所有发送了的数据的字节数
	     response.setContentLength( dos.size() );
	     dos.close();
	     os.close();
	    	return;
	 }

	private void Deal_Train_Log(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
	 {
	 	//按照二进制方式进行传输
	 	response.setContentType("application/octet-stream");
	 	OutputStream os = response.getOutputStream();
	 	DataOutputStream dos = new DataOutputStream(os);
	 	try
	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from Train_Log");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from Train_Log";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetTrain_Log  info = new SetTrain_Log();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setTrainLogID( rs.getInt("TrainLogID") );
			info.setTrainID( rs.getInt("TrainID") );
			info.setClerkID( rs.getInt("ClerkID") );
			info.setLogBeginTime( rs.getDate("LogBeginTime").getTime() );
			info.setLogEndTime( rs.getDate("LogEndTime").getTime() );
			info.setTrainTime( rs.getInt("TrainTime") );

	 		//序列化为二进制数据
	     		byte[] data = info.serialize();
	     		//一条记录的长度
	     		dos.writeInt( data.length );
	     		dos.write(data);
	     	}
	     	//释放资源
	     	rs.close();
	     }