webexam.java

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

	     {
	 		//获得行数
	 		PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from GuestBook");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from GuestBook";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetGuestBook  info = new SetGuestBook();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setnumber( rs.getInt("number") );
			info.setTrainID( rs.getInt("TrainID") );
			info.setCool( rs.getByte("Cool") );
			info.setRe( rs.getInt("Re") );
			info.setName( rs.getString("Name") );
			info.setData( rs.getString("Data") );
			info.setIP( rs.getString("IP") );
			info.setAddDate( rs.getDate("AddDate").getTime() );

	 		//序列化为二进制数据
	     		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_NetExamine(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 NetExamine");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from NetExamine";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetNetExamine  info = new SetNetExamine();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setNet_Id( rs.getInt("Net_Id") );
			info.settk_cl_name( rs.getString("tk_cl_name") );
			info.settk_cl_time( rs.getFloat("tk_cl_time") );
			info.setvalid_btime( rs.getDate("valid_btime").getTime() );
			info.setvalid_etime( rs.getDate("valid_etime").getTime() );
			info.setCreateTime( rs.getDate("CreateTime").getTime() );
			info.setIsShowHomePage( rs.getInt("IsShowHomePage") );
			info.setExam_Content( rs.getString("Exam_Content") );
			info.setExamOption( rs.getString("ExamOption") );
			info.setRepeatExam( rs.getInt("RepeatExam") );
			info.setTk_cl_UserAlias( rs.getString("Tk_cl_UserAlias") );
			info.setTk_cl_gly( rs.getString("Tk_cl_gly") );
			info.setother1( rs.getString("other1") );
			info.setotherInt( rs.getInt("otherInt") );

	 		//序列化为二进制数据
	     		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_NetOption(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 NetOption");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from NetOption";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetNetOption  info = new SetNetOption();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setAutoId( rs.getInt("AutoId") );
			info.setNet_Id( rs.getInt("Net_Id") );
			info.setClerk_Id( rs.getInt("Clerk_Id") );
			info.setNetEndTime( rs.getDate("NetEndTime").getTime() );
			info.setNetOption( rs.getInt("NetOption") );

	 		//序列化为二进制数据
	     		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_Notice(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 Notice");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from Notice";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetNotice  info = new SetNotice();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setNoticeID( rs.getInt("NoticeID") );
			info.setNoticeTitle( rs.getString("NoticeTitle") );
			info.setNoticeDetail( rs.getString("NoticeDetail") );
			info.setNoticePosition( rs.getInt("NoticePosition") );
			info.setNoticeEndtime( rs.getDate("NoticeEndtime").getTime() );
			info.setNoticeType( rs.getInt("NoticeType") );
			info.setCreateTime( rs.getDate("CreateTime").getTime() );
			info.setCreateName( rs.getString("CreateName") );
			info.setNoticeMemo( rs.getString("NoticeMemo") );
			info.setTrainID( rs.getInt("TrainID") );
			info.setReserveTxt( rs.getString("ReserveTxt") );
			info.setReserveTime( rs.getDate("ReserveTime").getTime() );

	 		//序列化为二进制数据
	     		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_Notice_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 Notice_File");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from Notice_File";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetNotice_File  info = new SetNotice_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_Organ(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 Organ");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from Organ";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetOrgan  info = new SetOrgan();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setOrganID( rs.getInt("OrganID") );
			info.setOrganName( rs.getString("OrganName") );
			info.setOrganBrief( rs.getString("OrganBrief") );
			info.setOrganTrain( rs.getString("OrganTrain") );
			info.setMasterID( rs.getInt("MasterID") );
			info.setOrganLevel( rs.getInt("OrganLevel") );
			info.setOrganFatherID( rs.getInt("OrganFatherID") );
			info.setCreateTime( rs.getDate("CreateTime").getTime() );
			info.setCreateName( rs.getString("CreateName") );
			info.setOrganMemo( rs.getString("OrganMemo") );
			info.setReserveTxt( rs.getString("ReserveTxt") );
			info.setreserveTime( rs.getDate("reserveTime").getTime() );

	 		//序列化为二进制数据
	     		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_Subject(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 Subject");
	 		//执行查询语句
	 		ResultSet rs1 = ps1.executeQuery();
	 		rs1.next();//获得第一项数据
	 		int num = rs1.getInt("raw_count");//获得行数
	 		rs1.close();
	 		ps1.close();
	 		
	 		sql = "select * from Subject";
	 		
	 		//执行SQL语句
	     	rs = stmt.executeQuery(sql);
	     	
	     	//发送数目
	     	dos.writeInt(num);
	     	
	     	SetSubject  info = new SetSubject();
	     	//发送信息
	     	while( rs.next() )
	     	{
			info.setSubject_Id( rs.getInt("Subject_Id") );
			info.setSubject_name( rs.getString("Subject_name") );
			info.setClerk_ID( rs.getInt("Clerk_ID") );
			info.setSubject_Share( rs.getInt("Subject_Share") );
			info.setSubject_Learn( rs.getInt("Subject_Learn") );
			info.setSubject_TKJ_ID( rs.getInt("Subject_TKJ_ID") );
			info.setCreateTime( rs.getDate("CreateTime").getTime() );
			info.setCreateName( rs.getString("CreateName") );

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