Mybatis快速入门

Mybatis下载地址

将jar包导入到项目中

在src中新建一个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>
	<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/databasename"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="com/ly/stUdentMapper.xml" />
	</mappers>
</configuration>

在配置url，username，password。

新建一个类，此类要与数据表相对应

新建与此类对应的Mapper.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.ly.StudentMapper">
	<select id="selectOne" resultType="com.ly.Student" parameterType="int">
		select * from student where id = #{id}
	</select>
	<select id="selectAll" resultType="com.ly.Student" parameterType="int">
		select * from student
	</select>
	<insert id="insertOne" parameterType="com.ly.Student">
		insert into student values(#{id},#{name},#{age})
	</insert>
	<update id="updateOne" parameterType="com.ly.Student">
		update student set name=#{name} where id=#{id}
	</update>
	<delete id="deleteOne" parameterType="int">
		delete from student where id=#{id}
	</delete>
</mapper>

新建此Mapper对应的接口

public interface StudentMapper {
	Student selectOne(int id);
	List<Student> selectAll();
	int insertOne(Student student);
	int updateOne(Student student);
	int deleteOne(int id);
}

新建测试类

public class MybatisTest {
	public static void main(String[] args) throws IOException {

		String resource = "mybatis-conf.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

		SqlSession session = sqlSessionFactory.openSession();

		StudentMapper studentMapper = session.getMapper(StudentMapper.class);

		List<Student> stus = studentMapper.selectAll();
		for(Student stu:stus) {
			System.out.println(stu);
		}