01. Mybatis使用

1.配置mybatis配置文件

<?xml version="1.0" encoding="UTF-8"?>

<settings>
    <setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
   <environments default="mysql">
    <environment id="mysql">

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

        <dataSource type="POOLED">
            <property name="driver" value="${driver}"></property>
            <property name="url" value="jdbc:mysql://127.0.0.1:3306/smbms"></property>
            <property name="username" value="root"></property>
            <property name="password" value="newpwd"></property>
        </dataSource>
    </environment>
</environments>
<mappers>
    <mapper resource="com/hua/dao/StudentMapper.xml"></mapper>
</mappers>

db.properties

url=jdbc:mysql://localhost:3306/smbms
user=root
pwd=newpwd
driver=com.mysql.jdbc.Driver

2.连接类

package com.hua.util;

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 java.io.IOException;
import java.io.InputStream;

public class MybatisUtil {
private static SqlSessionFactory sqlSessionFactory;
static {
String resource=“mybatis.xml”;
try {
//获取sqlsession
InputStream inputStream= Resources.getResourceAsStream(resource);
sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}

public static SqlSession getSqlsession(){
    return  sqlSessionFactory.openSession(true);


}

}

3.接口查询配置文件

<?xml version="1.0" encoding="UTF-8"?> select * from smbms_user

<select id="getuserbyId" parameterType="int" resultType="com.hua.pojo.User">
    select * from smbms_user where id= #{id}
</select>

<delete id="deleteuser" parameterType="int" >
  delete *from smbms_user where id=#{id}

<select id="userlimit" parameterType="map" resultType="com.hua.pojo.User">
    select *from smbms_user limit #{start},#{end}
</select>

4.测试类

public void test3(){
SqlSession sqlsession = MybatisUtil.getSqlsession();
UserDao mapper = sqlsession.getMapper(UserDao.class);
int deleteuser = mapper.deleteuser(10);
sqlsession.commit();//增删改提交事物保存
sqlsession.close();

}

5易见问题

xml文件未获取到，添加pom配置

src/main/resources **/*.properties **/*.xml true

    <resource>
        <directory>src/main/java</directory>
        <includes>
            <include>**/*.properties</include>
            <include>**/*.xml</include>
        </includes>
        <filtering>true</filtering>
    </resource>
</resources>