(a) 
try
{
   StringBuffer SQL = new StringBuffer();
   SQL.append("Insert into Member (MemberID, FirstName, ");
   SQL.append("LastName, Email, EmailBouncing, Password, ");
   SQL.append("RegistrationDate) ");
   SQL.append("Values (?, ?, ?, ?, ?, ?, ?)");
   Statement = dbConnection.prepareStatement( SQL.toString() );


(b) 
if ( m_MemberID == null )
  Statement.setNull( 1, java.sql.Types.NUMERIC );
else
  Statement.setLong( 1, m_MemberID.longValue() );

Example 3: (a) Constructing the prepared statement; (b) setting a long.