• 原始DAO开发


    1,pojo

    package com.songyan.dao;
    
    import com.songyan.pojo.Student;
    
    public interface StudentDao {
        public void insertStudent(Student student);
        public void deleteStudent(String id);
        public void updateStudent(Student student);
        public Student selectStudent(Integer id);
    }
    package com.songyan.dao;
    
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    
    import com.songyan.pojo.Student;
    
    public class StudentDaoImpl implements StudentDao{
        private SqlSessionFactory sqlSessionFactory;
        
        
    
        public StudentDaoImpl(SqlSessionFactory sqlSessionFactory) {
            super();
            this.sqlSessionFactory = sqlSessionFactory;
        }
    
        public void insertStudent(Student student) {
            
        }
    
        public void deleteStudent(String id) {
            
        }
    
        public void updateStudent(Student student) {
            
        }
    
        public Student selectStudent(Integer id) {
            SqlSession session=sqlSessionFactory.openSession();
            Student student=session.selectOne("test.findStudentById",10);
            return student;
        }
        
    
    }

    2,mapper

    <?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="test">
        <select id="findStudentById" parameterType="Integer"
            resultType="com.songyan.pojo.Student">
            select * from student where STU_ID= #{value}
        </select>
    </mapper>

    3,核心配置

    <?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>
    
        <!--配置环境,默认的环境id为oracle -->
        <environments default="oracle">
            <!-- 配置环境为oracle的环境 -->
            <environment id="oracle">
                <!--使用JDBC的事务处理 -->
                <transactionManager type="JDBC" />
                <!--数据库连接池 -->
                <dataSource type="POOLED">
                    <property name="driver" value="oracle.jdbc.driver.OracleDriver"></property>
                    <property name="url" value="jdbc:oracle:thin:@localhost:1521:inspur"></property>
                    <property name="username" value="scott"></property>
                    <property name="password" value="tiger"></property>
                </dataSource>
            </environment>
        </environments>
        <!--配置mapper的位置 -->
        <mappers>
            <mapper resource="com/songyan/dao/test.xml" />
            
        </mappers>
    </configuration>

    4,测试

    package com.songyan.client;
    
    import java.io.IOException;
    import java.io.InputStream;
    
    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 com.songyan.dao.StudentDao;
    import com.songyan.dao.StudentDaoImpl;
    import com.songyan.pojo.Student;
    
    public class Test1 {
        SqlSessionFactory sqlSessionFactory;
        
        @Before
        public void test1() throws IOException
        {
            String resource="applicationContext.xml";
            InputStream in=Resources.getResourceAsStream(resource);
            sqlSessionFactory=new SqlSessionFactoryBuilder().build(in);
        }
        
        @Test
        public void test()
        {
            StudentDao studentDao=new StudentDaoImpl(sqlSessionFactory);
            Student student=studentDao.selectStudent(1);
            System.out.println(student);
        }
    }

     

  • 相关阅读:
    HashMap(HashSet)的实现
    C/C++ 安全编码 —— 指针与内存
    AlexNet神经网络结构
    查看,修改动态组成员/通讯组
    刷新已禁用用户邮箱状态
    监控DAG状态
    AD诊断命令
    PowerShell管理Exchange
    TCP连接(Time_Wait、Close_Wait)说明
    IIS配置(安装IIS、.Net、更改IIS Log目录位置)
  • 原文地址:https://www.cnblogs.com/excellencesy/p/9138999.html
Copyright © 2020-2023  润新知