原始Dao开发

我不是女神ヾ 2021-11-23 10:50 321阅读 0赞

> 具体配置看Mybities入门  
> [https://blog.csdn.net/qq\_39205129/article/details/97278242][https_blog.csdn.net_qq_39205129_article_details_97278242]  
> Mybaties框架入门

## 原始Dao开发Mybaties ##

dao

package com.baidu.dao;
    
    import com.baidu.pojo.User;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    
    //原始Dao 开发
    public class UserDao {
    
    
        private SqlSessionFactory sqlSessionFactory;
        public  UserDao(SqlSessionFactory sqlSessionFactory){
            this.sqlSessionFactory=sqlSessionFactory;
    
    
        }
    
    
        public  void add(){
            SqlSession session = sqlSessionFactory.openSession();
    
            User user = new User();
            user.setName("slisisisqqq");
    
            session.insert("test.insertUser4", user);
            System.out.println(user.getId());
            session.commit();
    
            session.close();
    
        }
    
    }

pojo

package com.baidu.pojo;
    
    public class User {
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        @Override
        public String toString() {
            return "User{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    '}';
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        private Integer id;
        private  String name;
    }

SqlMapConfig.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>
    
        <properties resource="jdbc.properties"></properties>
    
        <environments default="development">
            <environment id="development">
                <transactionManager type="JDBC"/>
                <dataSource type="POOLED">
                    <property name="driver" value="${jdbc.driver}"/>
                    <property name="url" value="${jdbc.url}"/>
                    <property name="username" value="${jdbc.username}"/>
                    <property name="password" value="${jdbc.password}"/>
                </dataSource>
            </environment>
        </environments>
    
    
        <mappers>
            <mapper resource="sqlMap/UserMapper.xml"/>
            
        </mappers>
    </configuration>

UserMapper.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">
    
        <insert id="insertUser4" parameterType="com.baidu.pojo.User" keyProperty="id">
    
            insert  into  t_user set  name =#{name };
        </insert>
    
    </mapper>

test

package com.baidu.test;
    
    import com.baidu.dao.UserDao;
    import com.baidu.pojo.User;
    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 org.junit.Before;
    import org.junit.Test;
    import java.io.IOException;
    import java.io.InputStream;
    import java.util.List;
    
    public class TesyMybaties {
    
        public static void main(String[] args) throws IOException {
    
            String resource = "SqlMapConfig.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession session = sqlSessionFactory.openSession();
            List<Object> list = session.selectList("test.selectUser");
            System.out.println(list.size());
            session.close();
        }
        SqlSessionFactory sqlSessionFactory;
    
        @Before//执行之前干这事
        public void before() throws IOException {
    
            String resource = "SqlMapConfig.xml";
    
            InputStream inputStream = Resources.getResourceAsStream(resource);
            this.sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        }
        @Test
        public  void  test(){
            UserDao userDao = new UserDao(sqlSessionFactory);
            userDao.add();
        }
    }

结果

DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - Opening JDBC Connection
    DEBUG [main] - Created connection 2042495840.
    DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
    DEBUG [main] - ==>  Preparing: insert into t_user set name =?; 
    DEBUG [main] - ==> Parameters: slisisisqqq(String)
    DEBUG [main] - <==    Updates: 1
    null
    DEBUG [main] - Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
    DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
    DEBUG [main] - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
    DEBUG [main] - Returned connection 2042495840 to pool.
    
    Process finished with exit code 0

[https_blog.csdn.net_qq_39205129_article_details_97278242]: https://blog.csdn.net/qq_39205129/article/details/97278242