<b>(a) </b> 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>(b) </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.