1. 链接数据库
view -> Tool Windows -> Database
![](https://i-blog.csdnimg.cn/blog_migrate/700e6f80e83e10a3ce94d18ae170025e.png)
2.在右侧弹出的Database选项里
点击+ -> DataSource -> 数据库类型
![](https://i-blog.csdnimg.cn/blog_migrate/19bd40d7dfee680e517657a7eb695c9a.png)
3.链接数据库
如果缺少jar,点击就会自动下载,然后测试连接.
![](https://i-blog.csdnimg.cn/blog_migrate/9701f6676b1d6285151abc666dbec27c.png)
4.配置生成策略
右键 数据库名 -> Scripted Extensions -> Go to Scripts Directory
![](https://i-blog.csdnimg.cn/blog_migrate/a8c939b62ce1b5db7888a3f2d1716bfa.png)
编辑如下文件
![](https://i-blog.csdnimg.cn/blog_migrate/0664cce4beeecb888f34ccee05656132.png)
内容如下:
import com.intellij.database.model.DasTable
import com.intellij.database.model.ObjectKind
import com.intellij.database.util.Case
import com.intellij.database.util.DasUtil
import javax.swing.text.html.parser.Entity
import java.text.SimpleDateFormat
packageName = ""
typeMapping = [
(~/(?i)tinyint|smallint|mediumint/) : "Integer",
(~/(?i)bigint/) : "Long",
(~/(?i)int/) : "Integer",
(~/(?i)bool|bit/) : "Boolean",
(~/(?i)float|real/) : "Float",
(~/(?i)double/) : "Double",
(~/(?i)decimal/) : "BigDecimal",
(~/(?i)datetime|timestamp|date|time/) : "Date",
(~/(?i)blob|binary|bfile|clob|raw|image/): "InputStream",
(~/(?i)/) : "String"
]
FILES.chooseDirectoryAndSave("Choose directory", "Choose where to store generated files") { d