增刪改查代碼由工具生成，生成后再做調整即可 ``` package com.asiainfo.walk.webdemo.tools; import org.walkframework.base.system.common.Common; import org.walkframework.base.tools.dbtocrud.CrudFactory; import org.walkframework.batis.tools.dbtobean.CreateBeanConfig; import org.walkframework.data.util.IData; /** * 根據數據庫表生成增刪改查代碼及實體類 * * @author shf675 * */ public abstract class DbToCrud { /** * 執行main方法生成增刪改查代碼及實體類代碼 * * generate(表名，模塊目錄(英文)，模塊名(英文)，功能名(中文)) * * @param args */ public static void main(String[] args) { //根包和輸出路徑設置 String basePackage = "com.asiainfo.walk.webdemo"; String outBasePath = "E:/codegen"; CrudFactory crudFactory = new CrudFactory(createBeanConfig(), basePackage, outBasePath); //開始生成 crudFactory.generate("TD_M_STAFF", "staff", "Staff", "工號管理"); crudFactory.generate("TD_M_USER", "user", "User", "用戶管理"); } /** * 數據源設置 * * @return */ @SuppressWarnings("rawtypes") private static CreateBeanConfig createBeanConfig() throws IOException { String dbName = "ds_1";//設置數據庫 Properties props = PropertiesLoaderUtils.loadAllProperties("application.properties"); String dbAddr = props.getProperty(String.format("ds.%s.addr", dbName)); String dbUrl = props.getProperty(String.format("ds.%s.url", dbName)); CreateBeanConfig appConfig = new CreateBeanConfig(); appConfig.setDriverClassName(props.getProperty(String.format("ds.%s.driverClassName", dbName))); appConfig.setDburl(dbUrl.replaceAll(String.format("\\$\\{ds.%s.addr\\}", dbName), dbAddr)); appConfig.setDbusername(props.getProperty(String.format("ds.%s.username", dbName))); appConfig.setDbpassword(props.getProperty(String.format("ds.%s.password", dbName))); return appConfig; } } ```