如何使用myBatis访问数据库
426次<?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="dev"> <environment id="dev"> <transactionManager type="JDBC"></transactionManager> <dataSource type="POOLED"> <property name="driver" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@192.168.1.20:1521:oa" /> <property name="username" value="zhangsan" /> <property name="password" value="123" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/cissst/oa/data/UserMapper.xml" /> <mapper resource="com/cissst/oa/data/DepartmentMapper.xml" /> </mappers> </configuration> ??
2，使用myBatis提供的工具类中的方法,从类路径或Configuration.xml文档所在位置加载资源文件。
SqlSessionFactoryBuilder?builder?=?new?SqlSessionFactoryBuilder();??
SqlSessionFactory?factory?=?null;??
?
//?获取SqlSessionFactory对象 ??
try?{??
???Reader?reader?=?Resources??
????????????.getResourceAsReader("com/cissst/oa/data/Configuration.xml");??
????factory?=?builder.build(reader);??
}?catch?(Exception?e)?{??
????e.printStackTrace();??
}??
?
3，使用工厂对象获取SqlSession 对象
SqlSession?session=factory?.openSession(false);??
?
参数如果为true，表示该会话具有自动提交事务的功能，否则需程序员手动提交事务。
4，使用进行数据库访问
SqlSession?session?=?super.getSqlSession();??
//?构造返回值集合 ??
List<UserEntity>?result?=?new?ArrayList<UserEntity>();??
try?{??
????//?获取映射接口??
?
????UserMapper?userMapper?=?session.getMapper(UserMapper.class);??
????//?调用接口中的方法 ??
????List<UserEntity>?list?=?userMapper.getUserList(userEntity);??
????//?提交事务 ??
????session.commit();??
}?catch?(Exception?e)?{??
????//?回滚事务 ??
????session.rollback();??
}?finally?{??
????//?关闭会话 ??
????session.close();??
}??
