mybatis学习之路----简单的入门程序，实现增删改查

最近在自学mybatis，在这里分享一下我的入门程序。

进行mybatis开发的基本步骤：

1.创建工程，导入相关的jar包，这里有相关jar包的下载点击打开链接

2.搭建开发的基本架构

3.在classpath路径下编写mybatis的配置文件。

名字随意，在这里我叫configuration.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"></properties>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
      </dataSource>
    </environment>
  </environments>
   <mappers>
    <mapper resource="com/test/mapper/UserMapper.xml"/>
  </mappers>
</configuration>

数据库的基本配置db.properties文件，里面保存连接数据库的基本信息

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/navigation_db
jdbc.username=root
jdbc.password=root

4.为了更好的调试我们需要创建一个日志文件log4j.properties

log4j.rootLogger=DEBUG, stdout 

log4j.appender.stdout=org.apache.log4j.ConsoleAppender    


log4j.appender.stdout.layout=org.apache.log4j.PatternLayout      


log4j.appender.stdout.layout.ConversionPattern=%d [%t] %-5p[%c] - %m%n   

log4j.org.logger.apach=info 

5.我们这里使用的mapper代理的方式所以

UserMapper.java，相当于dao

package com.test.mapper;

import java.util.List;

import com.test.pojo.User;

public interface UserMapper {
	public User findUserById(int user_id);
	public void insertInto(User user);
	public void deleteUserById(int id);
	public List<User> findAllUser();
}

UserMapper.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="com.test.mapper.UserMapper">
  <select id="findUserById" parameterType="int" resultType="com.test.pojo.User">
    select * from user_tb where user_id = #{user_id}
  </select>
  
  <insert id="insertInto" parameterType="com.test.pojo.User">
  	insert into user_tb(username,password) values(#{username},#{password})
  </insert>
  
  <delete id="deleteUserById" parameterType="int">
  	delete from user_tb where user_id=#{id}
  </delete>
  
  <select id="findAllUser" resultType="com.test.pojo.User">
  	select * from user_tb
  </select>
  
</mapper>

6.需要一个实体类User.java

7.测试方法

package com.test.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import com.test.mapper.UserMapper;
import com.test.pojo.User;

public class Testa {
	
	public SqlSessionFactory sqlSessionFactory;
	@Before
	public void SteUp() throws IOException{
		String resource = "configuration.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
	}

	@Test
	public void testfindUserById() throws IOException {
		
		
		SqlSession sqlSession=sqlSessionFactory.openSession();
		
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		User user = mapper.findUserById(1);
		System.out.println(user);

	}
	@Test
	public void testInsertUser() throws IOException {
		
		
		SqlSession sqlSession=sqlSessionFactory.openSession();
		
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		
		User user=new User();
		user.setUsername("sss");
		user.setPassword("111");
		
		mapper.insertInto(user);
		
		sqlSession.commit();
		

	}
	
	@Test
	public void testDeleteUser() throws IOException {
		
		
		SqlSession sqlSession=sqlSessionFactory.openSession();
		
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		
		mapper.deleteUserById(9);
		
		sqlSession.commit();
		

	}
	@Test
	public void testFindAllUser() throws IOException {
		
		
		SqlSession sqlSession=sqlSessionFactory.openSession();
		
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		
		List<User> users = mapper.findAllUser();
		
		System.out.println(users);
	
		

	}


}

这只是一个小小的入门，需要进一步学习就要在网上查找相关的书籍或者资料了。