MyBatis

1.首先要准备：

 

 

---

 2.实体类与小配置

//实体类
public class Dept {
	private Integer deptNo;
	private String deptName;
	public Integer getDeptNo() {
		return deptNo;
	}
	public void setDeptNo(Integer deptNo) {
		this.deptNo = deptNo;
	}
	public String getDeptName() {
		return deptName;
	}
	public void setDeptName(String deptName) {
		this.deptName = deptName;
	}
	
}
//小配置  XXX.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="my.entity.Dept">
<!-- 查询部门所有信息 -->
<select id="selectAllDept" resultType="Dept">
select * from MyDept
</select>
<!--条件查询 -->
<select id="selectAllDeptById" parameterType="Dept" resultType="Dept">
select * from MyDept where deptNo=#{deptNo}
</select>
<!-- 删除 -->
<delete id="deleteAllDeptById" parameterType="Dept" >
delete from dept where deptNo=#{deptNo}
</delete>
<!-- 修改 -->
<update id="updateAllDeptById" parameterType="Dept" >
update dept set deptName=#{deptName} where deptNo=#{deptNo}
</update>
<!-- 增加 -->
<insert id="insertAllDeptById" parameterType="Dept" >
insert into dept values(#{deptNo},#{deptName},#{deptCity})
</insert>
</mapper>

　　

 

---

 

 3.大配置(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>
<!--  别名的配置      Dept-->
	<typeAliases>
		<typeAlias type="my.entity.Dept" alias="Dept"/>
	</typeAliases>
	
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
			    <property name="driver" value="oracle.jdbc.OracleDriver" />
				<property name="url" value="jdbc:oracle:thin:@localhost:1521:LIYANG" />
				<property name="username" value="LiYang" />
				<property name="password" value="orcl" />
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
		<mapper resource="my/entity/Dept.xml" />
	</mappers>
	

</configuration>

　

---

4.　测试类

SqlSession session;
@Before
public void initData() throws IOException{
Reader reader=Resources.getResourceAsReader("mybatis-config.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
session= factory.openSession();
}
@Test
public void testselectAllDept() throws IOException{
//在xml配置中的一个锁定唯一SQL的id
List<Dept> selectList = session.selectList("selectAllDept");
for (Dept dept : selectList) {
System.out.println(dept);
}
}
//模糊查詢
@Test
public void likeTest(){
Dept dept = new Dept();
dept.setDeptName("市场");
List<Dept> list = session.selectList("mybatis.entity.Dept.likeDept",dept);
for (Dept item : list) {
System.out.println(item);
}
session.close();
}
//修改
@Test
public void updateTest(){
Dept dept = new Dept();
dept.setDeptNo(5);
dept.setDeptName("开发部");
int count = session.update("mybatis.entity.Dept.updateDept",dept);
session.commit();
System.out.println(count+"修改成功");
session.close();
}
//删除
@Test
public void testdeleteDept() throws IOException{
Dept dept = new Dept();
dept.setDeptNo(5);
int count = session.delete("mybatis.entity.Dept.deleteDept",dept);
session.commit();
System.out.println(count+"删除成功!");
}
//增加
@Test
public void testinsertDept() throws IOException{
Dept dept = new Dept();
dept.setDeptNo(8);
dept.setDeptName("财务部");
dept.setDeptCity("上海");
int count = session.insert("mybatis.entity.Dept.insertDept",dept);
session.commit();
System.out.println(count+"增加成功");
}
}

---