一:簡介
MyBatis是一個優(yōu)秀的持久層框架,它對jdbc的操作數(shù)據(jù)庫的過程進(jìn)行封裝,使開發(fā)者只需要關(guān)注 SQL 本身,而不需要花費(fèi)精力去處理例如注冊驅(qū)動、創(chuàng)建connection、創(chuàng)建statement、手動設(shè)置參數(shù)、結(jié)果集檢索等jdbc繁雜的過程代碼。Mybatis通過xml或注解的方式將要執(zhí)行的各種statement(statement、PReparedStatemnt、CallableStatement)配置起來,并通過java對象和statement中的sql進(jìn)行映射生成最終執(zhí)行的sql語句,最后由mybatis框架執(zhí)行sql并將結(jié)果映射成java對象并返回。
二:原理
三:環(huán)境搭建
1:開發(fā)jar包:
2.因為用到了sql數(shù)據(jù)庫,所以導(dǎo)入sql jbr包
3.配置文件mybatisConfig.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="db.properties"/> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="passWord" value="${password}"/> </dataSource> </environment> </environments> <mappers> <mapper resource="org/mybatis/example/dao/DeptMapper.xml"/> </mappers> </configuration>因為采用的是外部文件 方式,所以,需要建立db.properties文件,文件內(nèi)容如下:driver=com.microsoft.sqlserver.jdbc.SQLServerDriverurl=jdbc:sqlserver://localhost:1433;DatabaseName=mydbusername=sapassword=14.Dept實體類package org.mybatis.example.dao;public class Dept { private int deptno; private String dname; private String ioc; public Dept() { } public int getDeptno() { return deptno; } public void setDeptno(int deptno) { this.deptno = deptno; } public String getDname() { return dname; } public void setDname(String dname) { this.dname = dname; } public String getIoc() { return ioc; } public void setIoc(String ioc) { this.ioc = ioc; } }5.創(chuàng)建Dept的映射文件DeptMapper.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"> <mapper namespace="org.mybatis.example.dao.DeptMapper"> <select id="selectOne" parameterType="int" resultType="org.mybatis.example.dao.Dept"> select * from dept where deptno=#{id} </select> </mapper>6.測試類Test.javapublic class Test { public static void main(String[] args) throws IOException { String resource="mybatisConfig.xml"; Reader reader=Resources.getResourceAsReader(resource); SqlsessionFactory sqlMapper=new SqlSessionFactoryBuilder().build(reader); SqlSession session=sqlMapper.openSession(); try { Dept dept=session.selectOne("org.mybatis.example.dao.DeptMapper.selectOne",2); System.out.println(dept.getDname()); } catch (Exception e) { e.printStackTrace(); }finally{ session.close(); } }}總體文件結(jié)構(gòu)
|
新聞熱點(diǎn)
疑難解答