| commit | author | age | ||
| 9bcb19 | 1 | /* |
| I | 2 | Copyright [2020] [https://www.xiaonuo.vip] |
| 3 | ||
| 4 | Licensed under the Apache License, Version 2.0 (the "License"); | |
| 5 | you may not use this file except in compliance with the License. | |
| 6 | You may obtain a copy of the License at | |
| 7 | ||
| 8 | http://www.apache.org/licenses/LICENSE-2.0 | |
| 9 | ||
| 10 | Unless required by applicable law or agreed to in writing, software | |
| 11 | distributed under the License is distributed on an "AS IS" BASIS, | |
| 12 | WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. | |
| 13 | See the License for the specific language governing permissions and | |
| 14 | limitations under the License. | |
| 15 | ||
| 16 | Snowy采用APACHE LICENSE 2.0开源协议，您在使用过程中，需要注意以下几点： | |
| 17 | ||
| 18 | 1.请不要删除和修改根目录下的LICENSE文件。 | |
| 19 | 2.请不要删除和修改Snowy源码头部的版权声明。 | |
| 20 | 3.请保留源码和相关描述文件的项目出处，作者声明等。 | |
| 21 | 4.分发源码时候，请注明软件出处 https://gitee.com/xiaonuobase/snowy | |
| 22 | 5.在修改包名，模块名称，项目代码等时，请注明软件出处 https://gitee.com/xiaonuobase/snowy | |
| 23 | 6.若您的项目无法满足以上几点，可申请商业授权，获取Snowy商业授权许可，请在官网购买授权，地址为 https://www.xiaonuo.vip | |
| 24 | */ | |
| 25 | package vip.xiaonuo.generate.core.tool; | |
| 26 | ||
| 27 | /** | |
| 28 | * java与sql工具类 | |
| 29 | * | |
| 30 | * @author yubaoshan | |
| 31 | * @date 2020-12-17 23:42 | |
| 32 | */ | |
| 33 | public class JavaSqlTool { | |
| 34 | ||
| 35 | /** | |
| 36 | * 数据类型转化JAVA | |
| 37 | * | |
| 38 | * @author yubaoshan | |
| 39 | * @date 2020-12-17 23:42 | |
| 40 | */ | |
| 41 | public static String sqlToJava (String sqlType) { | |
| 42 | if( sqlType == null || sqlType.trim().length() == 0 ) return sqlType; | |
| 43 | sqlType = sqlType.toLowerCase(); | |
| 44 | if(sqlType.startsWith("int")) { | |
| 45 | //如果以int开头，则直接返回int，兼容pgsql中int2 int8等 | |
| 46 | return "Integer"; | |
| 47 | } | |
| 48 | switch(sqlType){ | |
| 49 | case "nvarchar":return "String"; | |
| 50 | case "nvarchar2":return "String"; | |
| 51 | case "char":return "String"; | |
| 52 | case "varchar":return "String"; | |
| 53 | case "enum":return "String"; | |
| 54 | case "set":return "String"; | |
| 55 | case "text":return "String"; | |
| 56 | case "nchar":return "String"; | |
| 57 | case "blob":return "byte[]"; | |
| 58 | case "integer":return "Long"; | |
| 59 | case "int":return "Integer"; | |
| 60 | case "tinyint":return "Integer"; | |
| 61 | case "smallint":return "Integer"; | |
| 62 | case "mediumint":return "Integer"; | |
| 63 | case "bit":return "Boolean"; | |
| 64 | case "bigint":return "Long"; | |
| 65 | case "number":return "Long"; | |
| 66 | case "float":return "Float"; | |
| 67 | case "double":return "Double"; | |
| 68 | case "decimal":return "BigDecimal"; | |
| 69 | case "boolean":return "Boolean"; | |
| 70 | case "id":return "Long"; | |
| 71 | case "date":return "Date"; | |
| 72 | case "datetime":return "Date"; | |
| 73 | case "year":return "Date"; | |
| 74 | case "time":return "Time"; | |
| 75 | case "timestamp":return "Timestamp"; | |
| 76 | case "numeric":return "BigDecimal"; | |
| 77 | case "real":return "BigDecimal"; | |
| 78 | case "money":return "Double"; | |
| 79 | case "smallmoney":return "Double"; | |
| 80 | case "image":return "byte[]"; | |
| 81 | default: | |
| 82 | System.out.println(">>> 转化失败：未发现的类型" + sqlType); | |
| 83 | break; | |
| 84 | } | |
| 85 | return sqlType; | |
| 86 | } | |
| 87 | } | |
