1. Java / Говнокод #9657

    +74

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    13. 13
    14. 14
    15. 15
    16. 16
    17. 17
    18. 18
    19. 19
    20. 20
    21. 21
    22. 22
    23. 23
    24. 24
    25. 25
    26. 26
    27. 27
    28. 28
    29. 29
    30. 30
    31. 31
    32. 32
    33. 33
    34. 34
    35. 35
    36. 36
    37. 37
    38. 38
    39. 39
    40. 40
    41. 41
    42. 42
    43. 43
    44. 44
    45. 45
    46. 46
    47. 47
    48. 48
    49. 49
    50. 50
    51. 51
    52. 52
    53. 53
    54. 54
    55. 55
    56. 56
    57. 57
    58. 58
    59. 59
    60. 60
    61. 61
    62. 62
    63. 63
    64. 64
    65. 65
    66. 66
    67. 67
    68. 68
    69. 69
    70. 70
    71. 71
    72. 72
    73. 73
    74. 74
    75. 75
    76. 76
    77. 77
    78. 78
    79. 79
    80. 80
    81. 81
    82. 82
    83. 83
    84. 84
    85. 85
    86. 86
    87. 87
    88. 88
    89. 89
    90. 90
    91. 91
    92. 92
    93. 93
    94. 94
    95. 95
    for (Tm_RecipientConstructor recipient: m_Recipients) {
	
	Tm_PHB_Contact m_Contact = recipient.getContact();
	
	if ( m_Contact != null) {					
		if(m_Contact.getMobile()!=null) {						
			st.setLong(1,recipient.getEntry().getID());//nWebEntryID
			st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
			st.setString(3,"mobile");//STRNAME
			st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
			st.setString(5,m_Contact.getMobile());//STRVALUE
			st.addBatch();
    		index++;
    		if (index % 5000 == 0){		    				
    			st.executeBatch();
    			st.clearBatch();				            
    			st = conn.prepareStatement(sql);
    		}
		}
		if(m_Contact.getName()!=null) {						
			st.setLong(1,recipient.getEntry().getID());//nWebEntryID
			st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
			st.setString(3,"first_name");//STRNAME
			st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
			st.setString(5,m_Contact.getName());//STRVALUE
			st.addBatch();
    		index++;
    		if (index % 5000 == 0){		    				
    			st.executeBatch();
    			st.clearBatch();				            
    			st = conn.prepareStatement(sql);
    		}
		}
		if(m_Contact.getSurName()!=null) {
			
			st.setLong(1,recipient.getEntry().getID());//nWebEntryID
			st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
			st.setString(3,"last_name");//STRNAME
			st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
			st.setString(5,m_Contact.getSurName());//STRVALUE
			st.addBatch();
    		index++;
    		if (index % 5000 == 0){		    				
    			st.executeBatch();
    			st.clearBatch();				            
    			st = conn.prepareStatement(sql);
    		}
		}					
		if(m_Contact.getPatrName()!=null) {
			
			st.setLong(1,recipient.getEntry().getID());//nWebEntryID
			st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
			st.setString(3,"second_name");//STRNAME
			st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
			st.setString(5,m_Contact.getPatrName());//STRVALUE
			st.addBatch();
    		index++;
    		if (index % 5000 == 0){		    				
    			st.executeBatch();
    			st.clearBatch();				            
    			st = conn.prepareStatement(sql);
    		}
		}					
		if(m_Contact.getCompanyName()!=null) {
			
			st.setLong(1,recipient.getEntry().getID());//nWebEntryID
			st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
			st.setString(3,"company");//STRNAME
			st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
			st.setString(5,m_Contact.getCompanyName());//STRVALUE
			st.addBatch();
    		index++;
    		if (index % 5000 == 0){		    				
    			st.executeBatch();
    			st.clearBatch();				            
    			st = conn.prepareStatement(sql);
    		}
		}
		if(m_Contact.getComment()!=null) {
			
			st.setLong(1,recipient.getEntry().getID());//nWebEntryID
			st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
			st.setString(3,"comments");//STRNAME
			st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
			st.setString(5,m_Contact.getComment());//STRVALUE
			st.addBatch();
    		index++;
    		if (index % 5000 == 0){		    				
    			st.executeBatch();
    			st.clearBatch();				            
    			st = conn.prepareStatement(sql);
    		}
		}	
	}
}

    Функции? Не, не слышал.

    Запостил: SadKo, 12 Марта 2012

    Комментарии (6) RSS

    Добавить комментарий