• mybatis


        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 是数据库名,
  • 相关阅读:
    SQL数据转移
    怎么将控制台的打印输出到文本文件中
    用来控制 XML 序列化的属性
    excel内容转成xml
    HTTP状态码
    char、varchar、nchar、nvarchar的区别
    C# Cookie编程
    android的原理--为什么我们不需要手动关闭程序
    HTTP协议及HTTP包
    HTTP 方法:GET 对比 POST
  • 原文地址:https://www.cnblogs.com/z360519549/p/10716077.html
Copyright © 2020-2023  润新知