先说一下实现基本的mybatis框架步骤:
1.首先导入依赖(jar包):我这里连接的是mysql,所以把mysql的依赖也导入进来:
<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.43</version> </dependency>
2.配置文件名: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> <!--设置别名--> <typeAliases> <!--<typeAlias type="com.desert.Dto.MyPerson" alias="a"></typeAlias>--> 这里是设置单个方法 <package name="com.desert"></package> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/test"/> <property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> </environments> <mappers>
<!--加载映射文件--> <mapper resource="com/desert/entity/person.xml"/> </mappers> </configuration>3.再看一下我的实体类和我的dao层接口和映射文件:
我Person表的属性:
private String pname; private int pid; private int page;
我的dao层接口:
我这里写了几个方法:
public List<Person> getallPerson(); public Person getPersonById(int pid); public void delperson(int pid); public void addperson(Person person); public void updateperson(Person person);
我person.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">
<!--这个namespace配置的就是我刚刚所写dao层的接口-->
<mapper namespace="com.desert.Dao.IPersonDao">
<!--注意,之前在我的mybatis-config配置了一个设置别名,然后这里resultType就可以直接返回Person,如果没有配置设置别名,那就得写 这种全限名com.desert.entity.Person--> <select id="getPersonById" parameterType="int" resultType="com.desert.entity.Person"> select * from person where pid=#{pid} </select> <select id="getallPerson" resultType="com.desert.entity.Person"> select * from person </select> <select id="delperson" parameterType="int"> delete from person where pid=#{pid} </select> <select id="addperson" parameterType="com.desert.entity.Person"> insert into person(pname,page) values(#{pname},#{page}) </select> <select id="updateperson" parameterType="com.desert.entity.Person"> update person set pname =#{pname}, page =#{page} where pid=#{pid} </select> </mapper>
4.这里,还得在pom.xml配置一些东西,因为当你一运行项目的时候,它不会加在你java这个文件夹下面的xml格式的文件,所以你得在pom.xml里面写一些配置信息:
<build> <finalName>g160828_mybatis01</finalName> <resources> <resource>
<!--这里就写你的文件夹目录下面的就行--> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> </resource> </resources> </build>
5.然后就可以直接去测试了:
@Test public void testSelect(){ //读取配置文件: //获取SqlsessionFactory try { SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config")); //通过sessionFactory获得SqlSession SqlSession sqlSession=sqlSessionFactory.openSession();IPersonDao iPersonDao=sqlSession.getMapper(IPersonDao.class); //查找 Person person=iPersonDao.getPersonById(1); System.out.println(person);//删除iPersonDao.delperson(1);
//提交事物:sqlSession.close();sqlSession.close(); } catch (IOException e) { e.printStackTrace(); } }
然后就简单的实现用mybatis连接mysql并实现简单的增删改查了。