<?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="context1">

<commentGenerator>

<!-- 指定是否自动生成注释 true：不生成, false：生成 -->

<property name="suppressAllComments" value="true"/>

<!-- 是否用表和列的注释生成实体类和字段的注释。注：如果suppressAllComments设置为true，则忽略此配置选项 -->

<property name="addRemarkComments" value="true"/>

</commentGenerator>

<jdbcConnection connectionURL="jdbc:mysql://192.168.56.102:19816/ucgc_monit?useUnicode=true&amp;characterEncoding=UTF8"

driverClass="com.mysql.jdbc.Driver"

userId="uzone"

password="uzone">

</jdbcConnection>

<!-- 存放实体类的package -->

<javaModelGenerator targetPackage="cn.aofeng.demo.mybatis.entity"

targetProject="JavaTutorial/src" />

<!-- 存放SQL语句和结构映射配置文件的package -->

<sqlMapGenerator targetPackage="cn.aofeng.demo.mybatis.mapper"

targetProject="JavaTutorial/src" />

<!-- 存放DAO类的package -->

<javaClientGenerator targetPackage="cn.aofeng.demo.mybatis.dao"

targetProject="JavaTutorial/src" type="XMLMAPPER" />

<table schema="ucgc_monit" tableName="monit_contact"

modelType="flat"

enableCountByExample="false"

enableDeleteByExample="false"

enableSelectByExample="false"

enableUpdateByExample="false"></table>

<table schema="ucgc_monit" tableName="monit_item"

modelType="flat"

enableCountByExample="false"

enableDeleteByExample="false"

enableSelectByExample="false"

enableUpdateByExample="false"></table>

<table schema="ucgc_monit" tableName="monit_notify_history"

modelType="flat"

enableCountByExample="false"

enableDeleteByExample="false"

enableSelectByExample="false"

enableUpdateByExample="false"></table>

<table schema="ucgc_monit" tableName="monit_notify_item"

modelType="flat"

enableCountByExample="false"

enableDeleteByExample="false"

enableSelectByExample="false"

enableUpdateByExample="false"></table>

<table schema="ucgc_monit" tableName="monit_stat"

modelType="flat"

enableCountByExample="false"

enableDeleteByExample="false"

enableSelectByExample="false"

enableUpdateByExample="false"></table>

<table schema="ucgc_monit" tableName="monit_threshold"

modelType="flat"

enableCountByExample="false"

enableDeleteByExample="false"

enableSelectByExample="false"

enableUpdateByExample="false"></table>

</context>

</generatorConfiguration>

log4j.logger.org.jboss.netty.handler.logging=INFO, console

log4j.logger.org.apache.ibatis=INFO, console

log4j.additivity.org.apache.ibatis=false

log4j.appender.console.layout.ConversionPattern=[%d{yyyy-MM-dd HH:mm:ss}] %p %m%n

<?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://192.168.56.102:19816/ucgc_monit?useUnicode=true&amp;characterEncoding=UTF8"/>

<property name="username" value="uzone"/>

<property name="password" value="uzone"/>

</dataSource>

</environment>

</environments>

<mappers>

<mapper resource="cn/aofeng/demo/mybatis/mapper/MonitNotifyHistoryMapper.xml"/>

</mappers>

</configuration>

package cn.aofeng.demo.mybatis;

import java.io.IOException;

import java.io.InputStream;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import cn.aofeng.demo.mybatis.dao.MonitNotifyHistoryDao;

import cn.aofeng.demo.mybatis.entity.MonitNotifyHistory;

public class MyBatisClient {

private static Logger _logger = LoggerFactory.getLogger(MyBatisClient.class);

public static void main(String[] args) throws IOException {

String resource = "mybatis-config.xml";

InputStream ins = Resources.getResourceAsStream(resource);

SqlSessionFactory ssFactory = new SqlSessionFactoryBuilder().build(ins);

MonitNotifyHistoryDao dao = new MonitNotifyHistoryDao(ssFactory);

// 插入一条记录

long recordId = 999;

MonitNotifyHistory record = new MonitNotifyHistory();

record.setRecordId(recordId);

record.setMonitId(9999);

record.setAppId(99);

record.setNotifyTarget(1);

record.setNotifyType(1);

record.setNotifyContent("通知内容测试");

record.setStatus(0);

record.setCreateTime(1492061400000L);

int count = dao.insert(record);

_logger.info("insert complete, effects {} rows", count);

// 查询记录

MonitNotifyHistory entity = dao.selectByPrimaryKey(recordId);

_logger.info("query record id {}, result: {}", recordId, entity);

// 更新一个字段再执行查询

entity.setRetryTimes(99);

count = dao.updateByPrimaryKeySelective(entity);

_logger.info("update complete, record id:{}, effects {} rows", recordId, count);

entity = dao.selectByPrimaryKey(recordId);

_logger.info("query record id {}, result: {}", recordId, entity);

// 删除记录后再执行查询

count = dao.deleteByPrimaryKey(recordId);

_logger.info("delete complete, record id {}, effects {} rows", recordId, count);

entity = dao.selectByPrimaryKey(recordId);

_logger.info("query record id {}, result: {}", recordId, entity);

}

}