Eclipselink or Hibernate might help if you want less ugly code.
Dne 20.7.2011 23:38 "Tomcat Programmer" <tcprogram...@yahoo.com> napsal(a):
>
>
>>
>> You must explicitly set value to null:
>>
>> if (cobj.getPartNo()==null) pstmt.setNull(1, java.sql.Types.VARCHAR);
>> else pstmt.setString(1,cobj.getPartNo());
>>
>
> Hi Peter, thanks for responding but I am aware of this as I indicated in
my post. You realize how tedious this will be with any significant number of
fields? What I am asking about is if there is an alternate solution.
>
> Thanks in advance,
> TC
