ibatis之入门使用

清疚 2022-01-05 08:19 258阅读 0赞

下载ibatis包 以ibatis-2.3.4.726为例

导入ibatis-2.3.4.726.jar和mysql驱动包

新建Student类

package com.zns.domain;
    
    public class Student {
        private int id;
        private String name;
        
        public int getId() {
            return id;
        }
        public void setId(int id) {
            this.id = id;
        }
        public String getName() {
            return name;
        }
        public void setName(String name) {
            this.name = name;
        }
    }

新建Student.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE sqlMap      
        PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
        "http://ibatis.apache.org/dtd/sql-map-2.dtd">
    
    <sqlMap>
    
        <insert id="addStudent" parameterClass="com.zns.domain.Student">
            insert into student(name) values (#name#)
            <selectKey resultClass="int" keyProperty="id">
                select @@identity as inserted
                
                
                
                
                
            </selectKey>
        </insert>
    
        <delete id="deleteStudentById" parameterClass="int">
            delete from
            student where id=#id#
        </delete>
    
        <update id="updateStudent" parameterClass="com.zns.domain.Student">
            update student set
            name=#name# where id=#id#
        </update>
    
        <select id="selectAllStudent" resultClass="com.zns.domain.Student">
            select * from student
        </select>
    
        <select id="selectStudentById" parameterClass="int"
            resultClass="com.zns.domain.Student">
            select * from student where id=#id#
        </select>
    
        <select id="selectStudentByName" parameterClass="String"
            resultClass="com.zns.domain.Student">
            select id,name from student where name like
            '%$name$%'
        </select>
    
    </sqlMap>

在src下新建ibatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
    
    <sqlMapConfig>
    
    <transactionManager type="JDBC">
    
    <dataSource type="SIMPLE">
    <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
    <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/mydb1"/>
    <property name="JDBC.Username" value="root"/>
    <property name="JDBC.Password" value="123456"/>
    </dataSource>
    </transactionManager>
    
    <sqlMap resource="com/zns/domain/Student.xml"/>
    
    </sqlMapConfig>

简单测试

Reader reader = Resources.getResourceAsReader("ibatis-config.xml");
            SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
            reader.close();
    
            // //增加
            // Student model=new Student();
            // model.setName("张三");
            // Object object = sqlMapClient.insert("addStudent", model);
            // System.out.println("添加学生信息的返回id是：" + object);
    
            // // 删除
            // Object object = sqlMapClient.delete("deleteStudentById", 1);
            // System.out.println("受影响的行数：" + object);
    
            // // 修改
            // Student model = new Student();
            // model.setId(6);
            // model.setName("张三");
            // Object object = sqlMapClient.update("updateStudent", model);
            // System.out.println("受影响的行数：" + object);
    
            // 查询
            // List<Student> list1 = sqlMapClient.queryForList("selectAllStudent");
            // List<Student> list2 = sqlMapClient.queryForList("selectStudentByName", "李");
            //Student student = (Student) sqlMapClient.queryForObject("selectStudentById", 10);

转载于:https://www.cnblogs.com/zengnansheng/p/10386008.html