daocountryjdbcmysql.java

Java/J2EE application framework based on [Expert One-on-One J2EE Design and Development] by Rod John

package org.springframework.samples.countries.dao;

/**
 * MySql Subclass for <code>CountryDaoJdbC</code>.
 * 
 * @author Jean-Pierre Pawlak
 */
public class DaoCountryJdbcMySql extends DaoCountryJdbc {

	// MySql specific examples
	protected String DROP_SQL = "DROP TABLE IF EXISTS countries";
	protected String CREATE_SQL = "CREATE TABLE countries (lang CHAR(2), code CHAR(2), name VARCHAR(50), PRIMARY KEY (lang,code) ) Type InnoDB";
	// We don't include indexes due to the small size of this table.

	/**
	 * @see org.springframework.samples.countries.dao.IDaoCountry#initBase()
	 */
	public void initBase() {
		this.setDropSql(DROP_SQL);
		this.setCreateSql(CREATE_SQL);
		super.initBase();
	}

}