Mybatis不管在什么工程中都可以使用,只要倒入所需要的jira,并進行簡單的配置即可。
1.倒入jira包:mybatis-3.1.1.jar和ojdbc6.jar。
2.建立實體類,用于映射數據表。
public class Person {PRivate Integer id;private String name;private Integer age;//必須保證該類有個默認的構造器,不然在映射數據的時候將無法創建該類對象public Person() {// TODO Auto-generated constructor stub}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}}3.建立Dao接口映射,即創建一個操作數據表的接口,里面是操作數據表的方法聲明,這面的方法名要和之后創建的mapper配置文件中的id對于
public interface PersonMapper {void insertPerson(Person person);}4.建立mybatis主配置文件
<?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><settings><setting name="lazyLoadingEnabled" value="false" /></settings><typeAliases><typeAlias alias="person" type="com.lxw.domain.Person"/></typeAliases><environments default="development"><environment id="development"><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="oracle.jdbc.driver.OracleDriver"/><property name="url" value="jdbc:oracle:thin:@localhost:1521:Sudy"/><property name="username" value="JGCWDEV"/><property name="passWord" value="11111111"/></dataSource></environment></environments><mappers> <!--這里的路徑一定要對--><mapper resource="com/lxw/service/dao/PersonMapper.xml"/></mappers></configuration>
5.建立映射文件
<?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="com.lxw.service.dao.PersonMapper"><!--表名--><sql id='TABLE_NAME'>person</sql> <!--取序列的值--><sql id='TABLE_SEQUENCE'>person_seq.nextval</sql> <!--sql語句后面不能有封號--><insert id="insertPerson" parameterType="person">insert into <include refid="TABLE_NAME" /> (id,name,age) values (<include refid="TABLE_SEQUENCE" />,#{name},#{age})</insert></mapper>6.測試
public class TestMyBaties extends TestCase {//指定MyBatis配置文件private static final String RESOURCE = "mybatis-config.xml";public void testBaties() throws IOException{//1、指定MyBatis配置文件Reader reader = Resources.getResourceAsReader(RESOURCE);//2、創建SqlsessionFactory()SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);SqlSession session = null;try {//3、獲取SqlSessionsession = sessionFactory.openSession();//4、獲取DAO接口對象PersonMapper mapper = session.getMapper(PersonMapper.class);Person person = new Person();person.setName("demo");person.setAge(11);mapper.insertPerson(person);session.commit();//添加、修改、刪除操作最后需要提交事務} catch (Exception e) {e.printStackTrace();}finally{//6、關閉SqlSessionif(session != null){session.close();}}}}新聞熱點
疑難解答