首页 > 其他 > 详细

mybatis

时间:2019-04-16 12:42:09      阅读:111      评论:0      收藏:0      [点我收藏+]
    String resource = "mybatis-config.xml";
        InputStream inputStream  = getResourceAsStream(resource);

        SqlSessionFactory sqlSessionFactory =   new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Map<String,String> map = new HashMap<String,String>();
        map.put("id", "029c987e4a9745b38aa65e46d8c77a01");
        User user = sqlSession.selectOne("com.mytest.UserMapper.UserMapper.selectUser", map);


  User userinsert = new User("11101", "222", "333");
  int a = sqlSession.insert("com.mytest.UserMapper.UserMapper.insertUser", userinsert);

 sqlSession.commit();
 sqlSession.close();

  技术分享图片把mybatis 的配置文件放到  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://192.168.1.193:3306/test?characterEncoding=utf8"/>
                <property name="username" value="root"/>
                <property name="password" value="111"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/mytest/UserMapper/UserMapper.xml"/>
    </mappers>
</configuration>

  

test 是数据库名,

 

mybatis

原文:https://www.cnblogs.com/z360519549/p/10716077.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!