springboot +mybatis+oracle 配置多个数据源,配置两个数据库信息

package cn.witsky.quota.base.createsource; import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.util.List; /** * * <p>ClassName:CreateSource</p> * <p>Description:生成代码神器 * 开发文件生成工具 * 使用方法：文件夹自己建 为了防止覆盖已有的文件,如果文件已存在程序终止该程序。</p> * 该模块数据库连接在类里面配。完全独立于系统工程 * @author wangxiaobo * @date 2015-11-11 */ public class CreateSource { //表名(必须小写) 如果大写出现问题后果自找 private static String tableName = "t_smb_msisdn".toLowerCase(); private static String url="jdbc:oracle:thin:@192.168.150.233:1521/ddcx"; private static String user="ddcx"; private static String password="czty_ddcx"; ///////////////////////////////////////////////////// //方法 private static String constant_insert = "insert"; private static String constant_delete = "delete"; private static String constant_update = "update"; private static String constant_getById = "getById"; private static String constant_findAll= "findAll"; //生成文件存放的位置，该文件夹要选建好后才能进行。 private static String objectPath = "main.java.cn.witsky.quota.base.createsource.temp"; public static void main(String[] args) throws Exception { //Oracle数据库链接拿到相关字段信息 GetSqlFileds getSqlFileds = new GetSqlFileds(); //生成实体xml配置文件 String sqlFileds = getSqlFileds.getSqlWithFileds(url,user,password,tableName); generateXml(tableName,sqlFileds); //生成实体类 List<String> sqlFiledsComList = getSqlFileds.getSqlWithFiledsCom(url,user,password,tableName); generateObj(tableName,sqlFiledsComList); //生成dao文件 generateDao(); //生成service文件 //generateService(); //生成Controller文件 //generateController(); //生成配置文件 //generateConfig(); } /** * 生成配置文件 * @throws IOException */ public static void generateConfig() throws IOException { //实体xml配置文件路径为 String fileName = getFilePath()+ "\\" +getObjectName() + "Config.xml"; System.out.println("配置文件路径为：" + fileName); File file = new File(fileName); if (!file.exists()) { if (file.createNewFile()) { System.out.println("配置文件创建成功！"); } else { System.out.println("配置文件创建失败！"); return; } } else { System.out.println("程序终止，配置文件已经存在"); return; } FileOutputStream out = new FileOutputStream(file, true); StringBuffer sb = new StringBuffer(); sb.append("<!-- sqlmap.xml -->"); sb.append("\n"); sb.append(" <sqlMap resource=\""+objectPath.replace(".", "/")+"/entity/"+getObjectName()+".xml\" />"); sb.append("\n"); sb.append("\n"); sb.append("<!-- applicationContext.xml -->"); sb.append("\n"); sb.append(" <bean id=\""+toBartoUpperCase(tableName)+"Dao\" class=\""+objectPath+".dao."+getObjectName()+"Dao\"/>"); out.write(sb.toString().getBytes("utf-8")); out.close(); System.out.println("配置文件生成结束！"); } /** * 生成Controller文件 * @throws IOException */ public static void generateController() throws IOException { //实体xml配置文件路径为 String fileName = getFilePath()+ "\\" +getObjectName() + "Controller.java"; System.out.println("Controller文件路径为：" + fileName); File file = new File(fileName); if (!file.exists()) { if (file.createNewFile()) { System.out.println("Controller文件创建成功！"); } else { System.out.println("Controller文件创建失败！"); return; } } else { System.out.println("程序终止，Controller文件已经存在"); return; } FileOutputStream out = new FileOutputStream(file, true); StringBuffer sb = new StringBuffer(); sb.append("package "+objectPath+".controller;"); sb.append("\n"); sb.append("\n"); sb.append("@Controller"); sb.append("\n"); sb.append("@RequestMapping(\"不要这么懒自己改一下吧/"+toLowerCaseFirstOne(getObjectName())+"/\")"); sb.append("\n"); sb.append("public class "+getObjectName()+"Controller extends BaseController{"); sb.append("\n"); sb.append(" @Autowired"); sb.append("\n"); sb.append(" private "+getObjectName()+"Service "+toLowerCaseFirstOne(getObjectName())+"Service;"); sb.append("\n"); sb.append("\n"); sb.append("}"); out.write(sb.toString().getBytes("utf-8")); out.close(); System.out.println("Dao文件生成结束！"); } /** * 生成Service文件 * @throws IOException */ public static void generateService() throws IOException { //实体xml配置文件路径为 String fileName = getFilePath()+ "\\" +getObjectName() + "Service.java"; System.out.println("Service文件路径为：" + fileName); File file = new File(fileName); if (!file.exists()) { if (file.createNewFile()) { System.out.println("Service文件创建成功！"); } else { System.out.println("Service文件创建失败！"); return; } } else { System.out.println("程序终止，Service文件已经存在"); return; } FileOutputStream out = new FileOutputStream(file, true); StringBuffer sb = new StringBuffer(); sb.append("package "+objectPath+".service;"); sb.append("\n"); sb.append("\n"); sb.append("@Service"); sb.append("\n"); sb.append("public class "+getObjectName()+"Service extends BaseService<"+getObjectName()+">{"); sb.append("\n"); sb.append("\n"); sb.append("}"); out.write(sb.toString().getBytes("utf-8")); out.close(); System.out.println("Dao文件生成结束！"); } /** * 生成Dao文件 * @throws IOException */ public static void generateDao() throws IOException { //实体xml配置文件路径为 String fileName = getFilePath()+ "\\" +getObjectName() + "Dao.java"; System.out.println("Dao文件路径为：" + fileName); File file = new File(fileName); if (!file.exists()) { if (file.createNewFile()) { System.out.println("Dao文件创建成功！"); } else { System.out.println("Dao文件创建失败！"); return; } } else { System.out.println("程序终止，Dao文件已经存在"); return; } FileOutputStream out = new FileOutputStream(file, true); StringBuffer sb = new StringBuffer(); sb.append("package "+objectPath+".dao;"); sb.append("\n"); sb.append("\n"); sb.append("@Repository"); sb.append("\n"); sb.append("public class "+getObjectName()+"Dao extends BaseDao<"+getObjectName()+">{"); sb.append("\n"); sb.append("\n"); sb.append("}"); out.write(sb.toString().getBytes("utf-8")); out.close(); System.out.println("Dao文件生成结束！"); } /** * 生成实体对象文件 * @throws IOException */ public static void generateObj(String tableName,List<String> sqlFiledsComList) throws IOException { //实体xml配置文件路径为 String fileName = getFilePath()+ "\\" +getObjectName() + ".java"; System.out.println("实体对象文件路径为：" + fileName); File file = new File(fileName); if (!file.exists()) { if (file.createNewFile()) { System.out.println("实体对象文件创建成功！"); } else { System.out.println("实体对象文件创建失败！"); return; } } else { System.out.println("程序终止，实体对象已经存在"); return; } FileOutputStream out = new FileOutputStream(file, true); StringBuffer sb = new StringBuffer(); sb.append("package "+objectPath+".entity;"); sb.append("\n"); sb.append("\n"); sb.append("public class "+getObjectName()+" extends BaseEntity implements java.io.Serializable {"); sb.append("\n"); for(String sqlFi