1.主配置文件
<span style="font-family:Microsoft YaHei;"><?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之前,type的值为包名点类名;typeAliases表示配置类型别名
<typeAliases>
<typeAlias type="com.test.entity.Student" alias="Student"/>
</typeAliases>-->
<!-- 为某一个包下面的所有类配置类型别名,别名就是类名首字母小写 -->
<typeAliases>
<package name="com.test.entity" />
</typeAliases>
<environments default="development">
<!-- id必须 -->
<environment id="development">
<!-- 事务管理器 type表示直接使用jdbc的事务管理能力 -->
<transactionManager type="JDBC" />
<!-- 配置数据库连接信息,驱动、url、用户名、密码 ,type="POOLED"表示使用的是连接池技术-->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://192.168.0.13:3306/mybatis" />
<property name="username" value="root" />
<property name="password" value="123456" />
</dataSource>
</environment>
</environments>
<!-- 注册映射文件 -->
<mappers>
<!-- resource的值是映射文件相对类路径 -->
<mapper resource = "mapper/StudentMapper.xml" />
</mappers>
</configuration></span>
2.增删改查配置文件
<span style="font-family:Microsoft YaHei;"><?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.StudentMapper">
<!-- useGeneratedKeys="true"表明是使用数据库自动生成的主键
keyColumn="id"表明哪一列是主键列
keyProperty="id"表明会把数据库生成的值设置到对象的id属性中
parameterType="com.test.entity.Student"用来指定参数的类型
当Java看的insert里面的参数(name,gender,major,grade)时,就从该对象利用反射,从它里面获取这些属性(参数)的值,然后传递给insert语句,作为insert语句的参数
-->
<insert id="add" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="student">
insert into student(name,gender,major,grade)
values(#{name},#{gender},#{major},#{grade})
</insert>
<delete id="delete" parameterType="int">
delete from student where id = #{id}
</delete>
<!-- 学生实体的属性与数据库列名的映射-->
<resultMap type="student" id="studentResultMap">
<id property="id" column="id" />
<result property="name" column="name"/>
<result property="gender" column="gender" />
<result property="major" column="major" />
<result property="grade" column="grade" />
</resultMap>
<select id="select" parameterType="int" resultMap="studentResultMap">
select * from student where id = #{id}
</select>
<!-- resultType="Student"把查询结果装备成一个对象,如果没有它,结果就是一个一个字段
<select id="select" parameterType="int" resultType="student">
select * from student where id = #{id}
</select>-->
<update id="update" parameterType="student">
update student set name=#{name},gender=#{gender},major=#{major},grade=#{grade} where id=#{id}
</update>
<!-- 查找所有学生 -->
<select id="selectAll" parameterType="int" resultMap="studentResultMap">
select * from student
</select>
</mapper></span>
3.增删改查接口类
<span style="font-family:Microsoft YaHei;">package com.test.mapper;
import java.util.List;
import com.test.entity.Student;
public interface StudentMapper {
public Student select(int id);//查询学生信息
public List<Student> selectAll();//查找所以学生
public int add(Student student);//添加学生
public int delete(int i);//删除学生
public int update(Student s);//修改学生信息
}</span>
4.增删改查实现类
步骤:先加载主配置文件->再读取配置文件->创建SqlSessionFactory->创建Sqlsession->加载抽象类->然后就调用相应的增删改查方法->提交事务->关闭事务
1.增加实现类:
<span style="font-family:Microsoft YaHei;">package com.test;
import java.io.IOException;
import java.io.Reader;
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 com.test.entity.Student;
import com.test.mapper.StudentMapper;
public class AddStudnetMapper {
public static void main(String[] args){
String resource = "mybatis-config.xml";
SqlSessionFactory factory = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
StudentMapper student = session.getMapper(StudentMapper.class);
Student student1 = new Student();
student1.setGender("男");
student1.setGrade("一年级");
student1.setMajor("C#");
student1.setName("赵白");
int i = student.add(student1);
session.commit();
session.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}</span>
2.删除实现类:
<span style="font-family:Microsoft YaHei;">package com.test;
import java.io.IOException;
import java.io.Reader;
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 com.test.mapper.StudentMapper;
public class DeleteStudentMapper {
public static void main(String[] args){
String resource = "mybatis-config.xml";
SqlSessionFactory factory = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
StudentMapper stu = session.getMapper(StudentMapper.class);
int i = stu.delete(22);
session.commit();
session.close();
System.out.println("删除了"+i+"行");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}</span>
3.修改实现类:
<span style="font-family:Microsoft YaHei;">package com.test;
import java.io.IOException;
import java.io.Reader;
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 com.test.entity.Student;
import com.test.mapper.StudentMapper;
public class UpdateStudentMapper {
public static void main(String[] args) {
String resource = "mybatis-config.xml";
SqlSessionFactory factory = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
StudentMapper stu = session.getMapper(StudentMapper.class);
Student s = new Student();
s = stu.select(24);
s.setGender("男");
s.setGrade("二年级");
s.setMajor("PHP");
s.setName("张苏");
int i = stu.update(s);
session.commit();
session.close();
System.out.println("修改了"+i+"行");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}</span>
4.查询实现类:
<span style="font-family:Microsoft YaHei;">package com.test;
import java.io.IOException;
import java.io.Reader;
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 com.test.entity.Student;
import com.test.mapper.StudentMapper;
public class SelectMapperTest {
public static void main(String[] args){
String resource = "mybatis-config.xml";
SqlSessionFactory factory = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
StudentMapper student = session.getMapper(StudentMapper.class);
Student s= student.select(6);
System.out.println("++++++++++++++"+s.getName());
} catch (IOException e) {
e.printStackTrace();
}
}
}
</span>