Mybatis优化

来源:互联网 发布:vb 中的structure 编辑:程序博客网 时间:2024/06/05 23:14

我们在使用mybatis的时候,需要注意mybatis的性能,怎么才能快速提高查询,在编写实体Bean 需要生成getXXX 和setXXX方法 ,在设置settings也需要注意一些选项:


  1. 需要在实体Bean里面添加getXXX 和setXXX方法:

    比如:UserInfo.java

    public class UserInfo {

    private Integer userId;

    private String userName;

    private String userSex;

    private Integer userAge;

    public Integer getUserId() {

    return userId;

    }

    public void setUserId(Integer userId) {

    this.userId = userId;

    }

    public String getUserName() {

    return userName;

    }

    public void setUserName(String userName) {

    this.userName = userName;

    }

    public String getUserSex() {

    return userSex;

    }

    public void setUserSex(String userSex) {

    this.userSex = userSex;

    }

    public Integer getUserAge() {

    return userAge;

    }

    public void setUserAge(Integer userAge) {

    this.userAge = userAge;

    }

  2. 在设置mybatis-config.xml配置文件里面settings信息:

    <configuration>

    <settings>

    <setting name="cacheModelsEnabled" value="true"/>

    <setting name="lazyLoadingEnabled" value="true"/>

    <setting name="enhancementEnabled" value="true"/>

    <setting name="errorTracingEnabled" value="true"/>

    <setting name="maxSessions" value="500"/>

    <setting name="maxTransactions" value="200"/>

    <setting name="maxRequests" value="1024"/>

    <setting name="useStatementNamespaces" value="true"/>

    </settings>

    <environments default="developments">

    <environment id="mysql">

    <transactionManager type="JDBC"></transactionManager>

    <dataSource type="POOLED">

    <property name="driver" value="com.mysql.jdbc.Driver" />

    <property name="url" value="jdbc:mysql://127.0.0.1:3306/test" />

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

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

    </dataSource>

    </environment>

    </environments>

    <mappers>

    <mapper resource="com/test/domain/userinfo.xml" />

    </mappers>

    </configuration>



mybatis(ibatis)优化