第一步:
引入Mybatis的jar包:两种方式,一种创建Maven项目,一种直接下载Myabtis jar包
第一种:pom.xml配置
配置说明:这个配置是mybatis整合spring的。毫无疑问,mysql驱动包是必要,其次将myabtis核心包引入项目中,另外还要将myabtis-spring整合包引入,这是因为mybatis需要整合mybatis,然后引入spring的核心包。
第二种配置:纯学习mybatis的配置:
只需要配置mybatis的包就行。
步骤如下
新建一个纯java项目,在idea下。
第一步,将jar包引入项目。
ant-1.9.6.jar
ant-launcher-1.9.6.jar
asm-5.2.jar
cglib-3.2.5.jar
commons-logging-1.2.jar
javassist-3.22.0-GA.jar
log4j-1.2.17.jar
log4j-api-2.3.jar
log4j-core-2.3.jar
ognl-3.1.16.jar
slf4j-api-1.7.25.jar
slf4j-log4j12-1.7.25.jar
mybatis-3.4.6.jar
主要配置,mybatis-config.xml,usermapper.xml
mybatis-config.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="com/mybatis/res/jdbc.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/mybatis/mapper/usermapper.xml"></mapper> </mappers> </configuration> |
<?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.mybatis.dao.UserDao"> <select id="select" parameterType="string" resultType="com.mybatis.pojo.User"> select * from user where username=#{name} </select> <select id="selectAll" resultType="com.mybatis.pojo.User"> select * from user </select> </mapper> |
main函数测试
import com.mybatis.dao.UserDao; import com.mybatis.pojo.User; import org.apache.ibatis.annotations.Mapper; 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.apache.log4j.Logger; import java.io.IOException; import java.io.InputStream; import java.util.List; public class Main { public static void main(String[] args) { Logger logger = Logger.getLogger(Main.class); SqlSessionFactory sqlSessionFactory = null; String res = "com/mybatis/res/mybatis-config.xml"; InputStream inputStream; try { inputStream = Resources.getResourceAsStream(res); sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession sqlSession = sqlSessionFactory.openSession(); UserDao userDao = sqlSession.getMapper(UserDao.class); /*List<User> list = userDao.selectAll(); logger.debug(list); */ User user = userDao.select("root"); logger.debug(user); } catch (IOException e) { e.printStackTrace(); } } } |