mybatis+oracle generator 配置和异常处理

最新推荐文章于 2023-10-31 10:34:10 发布

转载最新推荐文章于 2023-10-31 10:34:10 发布 · 483 阅读

oracle 专栏收录该内容

8 篇文章

订阅专栏

本文介绍如何通过MyBatis Generator自动生成持久层代码，包括配置generatorConfig.xml文件及解决常见错误的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

a、将图片中三个文件粘贴到src平级目录

这里写图片描述

b、generatorConfig.xml文件配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
<generatorConfiguration >
<!--oracle jar路径-->
  <classPathEntry location="/ojdbc14.jar" />  
  <context id="context1" targetRuntime="MyBatis3">
    <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
     connectionURL="jdbc:oracle:thin:@localhost:1521:ythtjfx"
      userId="mw_sys"
       password="sys" />
    <!--model包名-->
    <javaModelGenerator targetPackage="com.vo" targetProject="./src" />
    <!--xml包名-->
    <sqlMapGenerator targetPackage="com.dao" targetProject="./src" />
    <!--接口包名-->
    <javaClientGenerator targetPackage="com.dao" targetProject="./src" type="XMLMAPPER" />
    <!--表模式、表名、队形-->
    <table schema="mw_pos" tableName="consumerinfo" domainObjectName="ConsumerInfo" enableCountByExample="false" enableUpdateByExample="false" 
enableDeleteByExample="false"
    enableSelectByExample="false" selectByExampleQueryId="false">
    </table>
  </context>
</generatorConfiguration>1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

c、dos命令[shift+右键]->在此处打开命令窗口

java -jar mybatis-generator-core-1.3.2.jar -configfile generatorConfig.xml -overwrite1
1

如果提示

MyBatis Generator finished successfully.1
1

则代码生成

如果提示

Exception in thread "main" java.lang.RuntimeException: **Exception getting JDBC Dr
iver**
        at org.mybatis.generator.internal.db.ConnectionFactory.getDriver(Connect
ionFactory.java:85)
        at org.mybatis.generator.internal.db.ConnectionFactory.getConnection(Con
nectionFactory.java:54)
        at org.mybatis.generator.config.Context.getConnection(Context.java:526)
        at org.mybatis.generator.config.Context.introspectTables(Context.java:43
6)
        at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.
java:222)
        at org.mybatis.generator.api.ShellRunner.main(ShellRunner.java:117)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)
        at org.mybatis.generator.internal.ObjectFactory.internalClassForName(Obj
ectFactory.java:150)
        at org.mybatis.generator.internal.ObjectFactory.externalClassForName(Obj
ectFactory.java:121)
        at org.mybatis.generator.internal.db.ConnectionFactory.getDriver(Connect
ionFactory.java:82)
        ... 5 more1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

原因1：<classPathEntry location="/ojdbc14.jar" /> 路径配置错误
原因2： jdbcConnection 配置错误
原因3：ojdbc14.jar损坏 error invalid or corrupt jarfile
如何判断是否损坏，看能不能解压。