用mybatis原因很简单,易用,性能。是介于jdbc和hibernate之间的一个完美方案。
很简单:
1:配置pom
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.test.database</groupId> <artifactId>dao-core</artifactId> <version>0.0.1-SNAPSHOT</version> <dependencies> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.1.1</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.30</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.7</version> <type>jar</type> <scope>test</scope> </dependency> </dependencies> <build> <plugins> <!-- mybits dao层 自动生成代码 插件 --> <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.2</version> <configuration> <verbose>true</verbose> <overwrite>true</overwrite> </configuration> </plugin> </plugins> </build> </project>
2: src/main/resources 下新建 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> <!--classPathEntry:数据库的JDBC驱动 --> <classPathEntry location="D:\soft_源程序\DB\mysql\mysql-connector-java-5.1.19-bin.jar" /> <context id="MysqlTables" targetRuntime="MyBatis3"> <!-- 注意这里面的顺序确定的,不能随变更改 --> <!-- 自定义的分页插件 <plugin type="com.deppon.foss.module.helloworld.shared.PaginationPlugin"/> --> <!-- 可选的(0 or 1) --> <!-- 注释生成器 --> <commentGenerator> <!-- 是否去除自动生成的注释 true:是 : false:否 --> <property name="suppressAllComments" value="true" /> </commentGenerator> <!-- 必须的(1 required) --> <!--数据库连接的信息:驱动类、连接地址、用户名、密码 --> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/data?useUnicode=true&characterEncoding=UTF-8" userId="root" password="123654"> </jdbcConnection> <!-- 可选的(0 or 1) --> <!-- 类型转换器或者加类型解析器 --> <!-- 默认false,把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer true,把JDBC DECIMAL 和 NUMERIC 类型解析为java.math.BigDecimal --> <javaTypeResolver> <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!-- 必须的(1 required) --> <!-- java模型生成器 --> <!-- targetProject:自动生成代码的位置 --> <javaModelGenerator targetPackage="com.test.model" targetProject="F:\Workspaces\workspace_eclipse\dao-core\src\main\java"> <!-- TODO enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="true" /> <!-- 从数据库返回的值被清理前后的空格 --> <property name="trimStrings" value="true" /> </javaModelGenerator> <!-- 必须的(1 required) --> <!-- map xml 生成器 --> <sqlMapGenerator targetPackage="com.test.persistence" targetProject="F:\Workspaces\workspace_eclipse\dao-core\src\main\resources"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator> <!-- 可选的(0 or 1) --> <!-- mapper 或者就是dao接口生成器 --> <javaClientGenerator targetPackage="com.test.dao" targetProject="F:\Workspaces\workspace_eclipse\dao-core\src\main\java" type="XMLMAPPER"> <property name="enableSubPackages" value="true" /> </javaClientGenerator> <!-- 必须的(1...N) --> <!-- pojo 实体生成器 --> <!-- tableName:用于自动生成代码的数据库表;domainObjectName:对应于数据库表的javaBean类名 --> <!-- schema即为数据库名 可不写 --> <table schema="data" tableName="tab_city" domainObjectName="CityModel" enableInsert="true"> <!-- 忽略字段 可选的(0 or 1) --> <!-- <ignoreColumn column="is_use" /> --> <!--//无论字段是什么类型,生成的类属性都是varchar。 可选的(0 or 1) 测试无效 --> <!-- <columnOverride column="city_code" jdbcType="VARCHAR" /> --> </table> </context> </generatorConfiguration>
3: 点击pom,run as maven bulid : mybatis-generator:generate 红色字最好自己手敲或者copy.
构建完后:
4:项目中使用的话,需要建立 mybatis-config.xml 在 src/main/resources 下
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/data" /> <property name="username" value="root" /> <property name="password" value="123654" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/test/persistence/CityModelMapper.xml" /> </mappers> <!-- <typeAliases> <typeAlias type="com.hoo.entity.Account" alias="account"/> </typeAliases> --> </configuration>
5: 建立测试
5.1 java传统测试
TestDao.java
package com.test.dao; import java.io.IOException; import java.io.Reader; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import com.test.model.CityModel; public class TestDao { public static void main(String[] args) { SqlSession session = null; String resource = "mybatis-config.xml"; Reader reader = null; try { reader = Resources.getResourceAsReader(resource); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder() .build(reader); session = sessionFactory.openSession(); CityModelMapper cityModelMapper = session .getMapper(CityModelMapper.class); // CityModel cityModel = new CityModel(); // cityModel.setId(7); // cityModel.setCityName("test7"); // cityModel.setCityCode(2); // cityModelMapper.insert(cityModel); // session.commit(); // System.out.println("插入一个city name" + cityModel.getCityName()); CityModel cityModel = cityModelMapper.selectByPrimaryKey(4); session.commit(); System.out.println(cityModel.getCityName()); cityModel.setCityName("testchange"); ; cityModelMapper.updateByPrimaryKey(cityModel); session.commit(); System.out.println("update"); } catch (IOException e) { e.printStackTrace(); } finally { if (null != session) session.close(); } } }
5.2 单元测试:
CityModelMapperTest.java
package com.test.dao; import static org.junit.Assert.fail; import java.io.Reader; import java.util.List; import junit.framework.Assert; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.After; import org.junit.Before; import org.junit.Test; import com.test.model.CityModel; import com.test.model.CityModelExample; public class CityModelMapperTest { SqlSession session = null; CityModelMapper cityModelMapper = null; @Before public void setUp() throws Exception { String resource = "mybatis-config.xml"; Reader reader = null; reader = Resources.getResourceAsReader(resource); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder() .build(reader); session = sessionFactory.openSession(); cityModelMapper = session.getMapper(CityModelMapper.class); } @Test public void testCountByExample() { fail("Not yet implemented"); } @Test public void testDeleteByExample() { fail("Not yet implemented"); } @Test public void testDeleteByPrimaryKey() { int flag = cityModelMapper.deleteByPrimaryKey(10); session.commit(); System.out.println("返回值:" + flag); System.out.println("删除一个city id " + 10); Assert.assertTrue(flag > 0); } @Test public void testInsert() { CityModel cityModel = new CityModel(); int i = 10; cityModel.setId(i); cityModel.setCityName("test" + i); cityModel.setCityCode(i); cityModelMapper.insert(cityModel); session.commit(); System.out.println("插入一个city name" + cityModel.getCityName()); } @Test public void testInsertSelective() { fail("Not yet implemented"); } @Test public void testSelectByExample() { CityModelExample example = new CityModelExample(); example.setDistinct(false); example.setOrderByClause("id"); example.createCriteria().andIdBetween(1, 3); List<CityModel> cityList = cityModelMapper.selectByExample(example); for (CityModel cityModel : cityList) { System.out.println("id:" + cityModel.getId() + "\n" + "name:" + cityModel.getCityName() + "\n"); } fail("Not yet implemented"); } @Test public void testSelectByPrimaryKey() { CityModel cityModel = cityModelMapper.selectByPrimaryKey(8); System.out.println("查询到一个city" + cityModel.getCityName()); Assert.assertTrue(null != cityModel); } @Test public void testUpdateByExampleSelective() { fail("Not yet implemented"); } @Test public void testUpdateByExample() { fail("Not yet implemented"); } @Test public void testUpdateByPrimaryKeySelective() { fail("Not yet implemented"); } @Test public void testUpdateByPrimaryKey() { CityModel cityModel = new CityModel(); int i = 8; cityModel.setId(i); cityModel.setCityName("updaet" + i); cityModel.setCityCode(i); int flag = cityModelMapper.updateByPrimaryKey(cityModel); session.commit(); System.out.println("返回值:" + flag); System.out.println("update一个city id " + i); Assert.assertTrue(flag > 0); } @After public void tearDown() throws Exception { } }
6: 用到的sql
1
2
3
4
5
6
7
8
|
DROP
TABLE IF EXISTS `tab_city`;
CREATE
TABLE `tab_city` (
`id` int (11) NOT
NULL AUTO_INCREMENT COMMENT ‘ID‘ ,
`city_name` varchar (255) DEFAULT
NULL COMMENT ‘城市名称‘ ,
`city_code` int (11) NOT
NULL COMMENT ‘用三位数字表示 例如 001 代表朝阳‘ ,
`is_use` int (11) DEFAULT
NULL COMMENT ‘是否有效‘ ,
PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT
CHARSET=utf8 COMMENT= ‘城市代码表‘ ;
|
完。
java_model_dao_自动生成_generator-mybatis-generator-1.3.2 基于maven插件,布布扣,bubuko.com
java_model_dao_自动生成_generator-mybatis-generator-1.3.2 基于maven插件