| | |
| | | import com.walker.jdbc.sqlgen.InsertBuilder; |
| | | import com.walker.jdbc.sqlgen.SelectBuilder; |
| | | import com.walker.jdbc.sqlgen.UpdateBuilder; |
| | | import com.walker.jdbc.util.StringUtils; |
| | | |
| | | import org.springframework.jdbc.core.RowMapper; |
| | | |
| | | import java.sql.ResultSet; |
| | |
| | | public String getTableName_() { |
| | | String tableName = "dep_form_scrapped_model"; |
| | | /** |
| | | if (StringUtils.isNotEmpty(this.getDatabaseName_())) { |
| | | return this.getDatabaseName_() + "." + tableName; |
| | | } else { |
| | | return tableName; |
| | | } |
| | | */ |
| | | if (StringUtils.isNotEmpty(this.getDatabaseName_())) { |
| | | return this.getDatabaseName_() + "." + tableName; |
| | | } else { |
| | | return tableName; |
| | | } |
| | | */ |
| | | return tableName; |
| | | } |
| | | |
| | |
| | | @Override |
| | | public DepFormScrappedModel mapRow(ResultSet rs, int i) throws SQLException { |
| | | ResultSetUtils resultSetUtils = new ResultSetUtils(); |
| | | DepFormScrappedModel dep_form_scrapped_model = new DepFormScrappedModel(); |
| | | DepFormScrappedModel dep_form_scrapped_model = new DepFormScrappedModel(); |
| | | Integer columnIndex; |
| | | //主键 |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Id); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setId(rs.getLong(columnIndex)); |
| | | dep_form_scrapped_model.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.DepFormScrappedId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setDepFormScrappedId(null); |
| | | dep_form_scrapped_model.setDepFormScrappedId(null); |
| | | } else { |
| | | dep_form_scrapped_model.setDepFormScrappedId(rs.getLong(columnIndex)); |
| | | dep_form_scrapped_model.setDepFormScrappedId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.DepFormScrappedGoodsId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setDepFormScrappedGoodsId(null); |
| | | dep_form_scrapped_model.setDepFormScrappedGoodsId(null); |
| | | } else { |
| | | dep_form_scrapped_model.setDepFormScrappedGoodsId(rs.getLong(columnIndex)); |
| | | dep_form_scrapped_model.setDepFormScrappedGoodsId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.ScrappedCode); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setScrappedCode(rs.getString(columnIndex)); |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setScrappedCode(null); |
| | | } else { |
| | | dep_form_scrapped_model.setScrappedCode(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.ScrappedName); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setScrappedName(rs.getString(columnIndex)); |
| | | dep_form_scrapped_model.setScrappedName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsTemplateId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setBaseGoodsTemplateId(null); |
| | | dep_form_scrapped_model.setBaseGoodsTemplateId(null); |
| | | } else { |
| | | dep_form_scrapped_model.setBaseGoodsTemplateId(rs.getLong(columnIndex)); |
| | | dep_form_scrapped_model.setBaseGoodsTemplateId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsTemplateName); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setBaseGoodsTemplateName(rs.getString(columnIndex)); |
| | | dep_form_scrapped_model.setBaseGoodsTemplateName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Classification); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setClassification(rs.getString(columnIndex)); |
| | | dep_form_scrapped_model.setClassification(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Unit); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setUnit(rs.getString(columnIndex)); |
| | | dep_form_scrapped_model.setUnit(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsModelsId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setBaseGoodsModelsId(null); |
| | | dep_form_scrapped_model.setBaseGoodsModelsId(null); |
| | | } else { |
| | | dep_form_scrapped_model.setBaseGoodsModelsId(rs.getLong(columnIndex)); |
| | | dep_form_scrapped_model.setBaseGoodsModelsId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsModelsName); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setBaseGoodsModelsName(rs.getString(columnIndex)); |
| | | dep_form_scrapped_model.setBaseGoodsModelsName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.ProcureModelUserId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setProcureModelUserId(null); |
| | | dep_form_scrapped_model.setProcureModelUserId(null); |
| | | } else { |
| | | dep_form_scrapped_model.setProcureModelUserId(rs.getLong(columnIndex)); |
| | | dep_form_scrapped_model.setProcureModelUserId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.InitialCount); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setInitialCount(null); |
| | | dep_form_scrapped_model.setInitialCount(null); |
| | | } else { |
| | | dep_form_scrapped_model.setInitialCount(rs.getInt(columnIndex)); |
| | | dep_form_scrapped_model.setInitialCount(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.UseCount); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setUseCount(null); |
| | | dep_form_scrapped_model.setUseCount(null); |
| | | } else { |
| | | dep_form_scrapped_model.setUseCount(rs.getInt(columnIndex)); |
| | | dep_form_scrapped_model.setUseCount(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Counts); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setCounts(null); |
| | | dep_form_scrapped_model.setCounts(null); |
| | | } else { |
| | | dep_form_scrapped_model.setCounts(rs.getInt(columnIndex)); |
| | | dep_form_scrapped_model.setCounts(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.GoodsUserName); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setGoodsUserName(rs.getString(columnIndex)); |
| | | dep_form_scrapped_model.setGoodsUserName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Beiz); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setBeiz(rs.getString(columnIndex)); |
| | | dep_form_scrapped_model.setBeiz(rs.getString(columnIndex)); |
| | | } |
| | | return dep_form_scrapped_model; |
| | | } |