<?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>
<!--指向目标数据库-->
<context id="DB2Tables" targetRuntime="MyBatis3">
<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
connectionURL="jdbc:mysql:// localhost:3306/user_db ?serverTimezone=Asia/Shanghai"
userId="root"
password="kkk123123">
</jdbcConnection>
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!--指定java ben的生成策略-->
<javaModelGenerator targetPackage="com.mybatis.ben"
targetProject=".\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- sql映射生成策略的定义-->
<sqlMapGenerator targetPackage="conf"
targetProject=".\conf">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!--指定mapper接口所在的位置-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.mybatis.dao"
targetProject=".\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!--指向要逆向分析哪些表:根据表要创建Java Bean-->
<table tableName="tbl_employee" domainObjectName="Department"></table>
<table tableName="tbl_dept" domainObjectName="Employee"></table>
</context>
</generatorConfiguration>
public class myTest {
public SqlSessionFactory getsqlsessionfactory() throws IOException {
String resource = "mybatis.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
return new SqlSessionFactoryBuilder().build(inputStream);
}
@Test
public void testMbg() throws Exception {
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
File configFile = new File("mbg.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
}
@Test
public void testSimple() throws IOException {
SqlSessionFactory sqlSessionFactory = getsqlsessionfactory();
SqlSession openSession = sqlSessionFactory.openSession();
try {
EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
List<Employee> example = mapper.selectByExample(null);
for (Employee employee:example
) {
System.out.println(employee);
}
}finally {
openSession.close();
}
}
}
代码生成不会报错 测试就报下面的错误
Error building SqlSession.
### The error may exist in SQL Mapper Configuration
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource dbconfig.properties
测试配置的dbconfig.properties读取路径不对吧