mybatis1

最新推荐文章于 2022-05-21 14:01:49 发布

miaoao611

最新推荐文章于 2022-05-21 14:01:49 发布

阅读量210

点赞数

分类专栏： mybatis

本文链接：https://blog.csdn.net/miaoao611/article/details/51767061

版权

mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

擦刚写了半天。。。

MyBatis是一个支持普通SQL查询，存储过程和高级映射的优秀持久层框架。MyBatis消除了几乎所有的JDBC代码和参数的手工设置以及对结果集的检索封装。MyBatis可以使用简单的XML或注解用于配置和原始映射，将接口和Java的POJO（Plain Old Java Objects，普通的Java对象）映射成数据库中的记录。

MyBatis和 hibernate区别

MyBatis介于dbutils和mybatis之间优点是比较灵活，适合处理比较复杂的业务逻辑，要自己写sql语句。

hibernate基于面向对象的思想，优点是提供一级缓存以及二级缓存,配置较为复杂，然后基本什么都可以自动生成，但是就这样所以处理太复杂会很头疼，总之小项目用hibernate是很爽的

另外表示我是菜鸟一只，hibernate很多东西都没搞清楚，mybatis学起来就容易很多。

贴个基于mybatis的小例子

1 lib包里面的内容

= =我用的SqlServer，MySQL卸载以后就装不上了，想用其他数据库的换包就可以了

mybatis-3.1.1.jar
sqljdbc.jar

sqljdbc.jar是SqlServer的支持包，mybatis-3.1.1.jar是mybatis的支持包，这边说下spring，把万能spring.jar分开后菜鸟表示懵逼加心塞。

1 user类

窝这个是从做过的东西里面随copy来的= =有人想抄下可以把后面有的没的的属性全去咯

package edu.homework.bean;

import java.io.Serializable;
/**
*
* @author mdd39
*/
public class User implements Serializable{
private Integer userId;
private String uname;
private String password;
private Integer userGrant;
private Integer isEdit;
private String userDeptCode;
private String userGroupCode;
private String userDeptName;
private String userGroupName;

public Integer getUserId() {
return userId;
}

public void setUserId(Integer userId) {
this.userId = userId;
}

public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public Integer getUserGrant() {
return userGrant;
}

public void setUserGrant(Integer userGrant) {
this.userGrant = userGrant;
}

public Integer getIsEdit() {
return isEdit;
}

public void setIsEdit(Integer isEdit) {
this.isEdit = isEdit;
}

public String getUserDeptCode() {
return userDeptCode;
}

public void setUserDeptCode(String userDeptCode) {
this.userDeptCode = userDeptCode;
}

public String getUserGroupCode() {
return userGroupCode;
}

public void setUserGroupCode(String userGroupCode) {
this.userGroupCode = userGroupCode;
}

public String getUserDeptName() {
return userDeptName;
}

public void setUserDeptName(String userDeptName) {
this.userDeptName = userDeptName;
}

public String getUserGroupName() {
return userGroupName;
}

public void setUserGroupName(String userGroupName) {
this.userGroupName = userGroupName;
}

@Override
public String toString() {
return "User [userId=" + userId + ", uname=" + uname + ", password=" + password + ", userGrant=" + userGrant
+ ", isEdit=" + isEdit + ", userDeptCode=" + userDeptCode + ", userGroupCode=" + userGroupCode
+ ", userDeptName=" + userDeptName + ", userGroupName=" + userGroupName + "]";
}

}

2 userMapper.xml

这边说下userMapper请保证namespace的唯一性，且每写个mapper请在conf.xml里面注册下

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="edu.homework.bean.userMapper">
<select id="getUser" parameterType="int" resultType="edu.homework.bean.User">
select * from hx_user where userId=#{userId}

</select>
</mapper>

3 conf.xml

<?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"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="url" value="jdbc:sqlserver://127.0.0.1:1433;databaseName=hw39"/>
<property name="username" value="sa"/>
<property name="password" value="123456"/>
</dataSource>

</environment>
</environments>

<mappers>
<mapper resource="edu/homework/bean/userMapper.xml"/>
<mapper resource="edu/homework/bean1/userMapper.xml"/>
</mappers>
</configuration>

4 Test.java

package edu.homework.bean;

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;

public class Test {
public static void main(String[] args) {
String resource="conf.xml";
try {
//加载mybatis配置文件
Reader reader=Resources.getResourceAsReader(resource);
//构建sqlsession工厂
SqlSessionFactory sessionFactory=
new SqlSessionFactoryBuilder().build(reader);
SqlSession session=sessionFactory.openSession();
String statement="edu.homework.bean.userMapper"+".getUser";
User user=session.selectOne(statement, 1);
System.out.println(user.toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
}