String sql = "select * from template_type";
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while(rs.next())
{
TemplateType templateType = new TemplateTypeImpl();
templateType.setId(DataAccessFactory.getInstance().createUUID(Integer.toString(rs.getInt("id"))));
templateType.setName(rs.getString("name"));
templateType.setDisplayIndex(rs.getInt("displayIndex"));
templateTypeList.add(templateType);
}
}catch(Exception e)
{
e.printStackTrace();