private   static   void  readingAndRewriting()  throws  IOException, SQLException{
		Connection conn = getConnection();
		 try  {
			Statement stat = conn.createStatement();
			
			POIFSFileSystem fs =  new  POIFSFileSystem( new  FileInputStream("KRD.xls"));
			HSSFWorkbook wb =  new  HSSFWorkbook(fs);
			HSSFSheet sheet = wb.getSheetAt( 0 );
			 for  ( int  i =  2 ; i <  3048 ; i++) {
				HSSFRow row = sheet.getRow(i);
				HSSFCell getCell = row.getCell(( short ) 2 );
				String valString = getCell.toString();
				ResultSet result = stat.executeQuery("SELECT SEGM FROM www..CLNVRM WHERE CLN_IDC ='"+valString+"'");
				String strRslt = result.getString( 1 );
				HSSFCell setCell = row.getCell(( short ) 8 );
				 if  (setCell ==  null )
			        setCell = row.createCell(( short ) 3 );
				setCell.setCellType(HSSFCell.CELL_TYPE_STRING);
				setCell.setCellValue(strRslt);
				FileOutputStream fileOut =  new  FileOutputStream("KRD.xls");
				 try {
					wb.write(fileOut);
				} finally {
					fileOut.close();
				}
			}
		} finally {
			conn.close();
		}
	}

				String strRslt = result.getString( 1 );